10 differences between a PowerPivot Pivot Table and a Standard one

1) PowerPivot Pivot Tables allow you to mix and match data from different tables (provided relationships between them have been created in the data model) 2) Summary Functions: PowerPivot Pivot Tables lack the "Product" and "Count Numbers" summary functions that standard pivot tables offer. But they do have the handy "Distinct Count" 🙂 3) Subtotals: Switching … Continue reading 10 differences between a PowerPivot Pivot Table and a Standard one

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

Top 3 Excel functions you can use to forecast sales

Well, I didn't need to predict sales but segment sizes for the upcoming 3 periods of the Markstrat simulation game we were playing as part of the Strategic Marketing class I was taking.  Still, it works pretty much the same way - you use the numerical historic data you have in order to make a prediction … Continue reading Top 3 Excel functions you can use to forecast sales