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 … Continue reading Top 3 Handy Features of Excel 2016

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 … Continue reading 1 super handy feature of Power Query