If you are not using the latest version of Excel, you may see a compatibility warning message when importing the data, but if you simply click, close, you are able to proceed. At the time of recording this course, the features in Excel, Power Pivot, and Power Query are only available on the desktop version of Excel and on the PC version of the app, not Mac.
- [Instructor] Throughout this course, you'll notice that I'm using a desktop version of Excel. If you are too but are working with say an older version of Excel, then you may see a compatibility warning pop up when using some of the exercise files. If this happens, then simply go ahead and click on Close, and you're good to go. It's also worth mentioning that at the time of recording, the Excel add-ins that I demonstrate in this course, that is Power Pivot and Power Query, were only available in the Desktop version of Excel. Unfortunately, these features were not available on the Mac release of the software. Both Power Query and Power Pivot are available in the subscription version of Excel. That is in Office 365 or Microsoft 365. They're also both available in Excel 2019. Now the availability in previous versions of Excel varies. So I encourage you to check support.office.com for more details.
- Preparing queries
- Cleansing data with Power Query
- Enhancing queries
- Creating a data model in Power Pivot
- Building relationships
- Analyzing data with PivotTables and PivotCharts
- Using Power Query with PowerPivot