Top 3 Handy Features of Excel 2016

Visualizing statistical results in Excel has just become easier as the latest version enables you to create "Histogram" and "Pareto" charts (+ a bunch others) 2.Power Pivot Add-In is integrated, which essentially means that: (a) you do not have to install it separately as it was the case with Excel 2013 and Excel 2010 (b) you will see …

1 super handy feature of Power Query

What is your favourite feature of Power Query? Mine, by all means, is the option to import data from a folder. Located under Power Query --> From File in Excel 2013 Data tab --> New Query --> From File in Excel 2016 the option is a handy way of keeping track of all your documents …

Let’s crunch this data in Excel

But how do we get it there in the first place? There are a couple of options - choosing the best one for your case will very much depend on the volume of data you need to analyse and the data infrastructure that your company provides. So far I've used: 1. Import from text (a.k.a. …