Blog

Posted on: November 19, 2018 Posted by: admin Comments: 0

Excel essentials #1 Excel table basics

At a first glance, this may be a familiar topic, right? But I’ve been very surprised over time by how few people actually use them. You might think, as soon as we enter column data we have a table, right? Well, yes, but speaking in Excel terms, no. If you …

Posted on: November 16, 2018 Posted by: admin Comments: 0

Excel Magic Trick #1 Pivot Table Filtering

Great! You have your population data cleaned after hours of working hard (if you don’t use Power Query) and it is almost ready and set. Basic pivot table So, now you have to divide data on separate sheets for each country with its cities’ population. The task would not be …