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
Month: April 2018
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
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. … Continue reading Let’s crunch this data in Excel