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?
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
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