Can I run a linear regression in Excel?

Anyone survived a statistics course at uni without running a linear regression in SPSS? Come forward, please Joke aside, linear regression is such a basic and fundamental forecasting tool that it is being taught across a range of bachelor and master programmes. Yet, all too often, very little is explained how you could use it … Continue reading Can I run a linear regression in Excel?

6 Major Differences between Excel 2016 for Windows and Excel 2016 for MAC

1.Excel for MAC does not support PowerPivot. Consequently, any pivot table based on the Excel Data Model will be unfilterable if the spreadsheet is opened by a MAC user. So will be any pivot table, that was created via the "Import from Microsoft Access Database" option as Excel for MAC does not support OLEDB connections, either. It … Continue reading 6 Major Differences between Excel 2016 for Windows and Excel 2016 for MAC

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

Tracking progress against goals

Remember doughnut charts? Yes, next to neatly visualizing shares of totals, they can also make decent progress trackers! You'll need to create a couple of additional calculations to help you create a progress doughnut chart, however: A parameter where you can dynamically input your Sales Target 2. Sales Remaining = Sales Target - Sales 3. … Continue reading Tracking progress against goals