This course aims to introduce the Excel user to the brave new world of self-service BI using the Excel BI Toolkit. The course has been created with the version of Microsoft Excel 2019 and Microsoft 365, but it's compatible with older versions of Excel. This course is a guide with simple step-by-step instructions to walk you through creating business intelligence reports and dashboards in Excel, quickly and efficiently. Power Pivot is currently not available for Mac and is only available in specific Excel versions for windows.

You can watch the 3rd lecture of the course: Versions, Compatibility and Install Power Pivot & Power Map. IMPORTANT NOTE: To make sure that your version is compatible before you go on with that course, please check the Microsoft Excel compatibility page. While anyone can put a list of values in Excel & sum them up, not everyone can do advanced analysis, create interactive charts, summarize data intelligently using Power Pivot and Power BI tools, and finally present output in stunning Dashboards. These days almost any job requires data analysis & presentation of results. Learn Power Query, Power Pivot, DAX, Power Map (3D Maps) and Power BI Desktop Business Intelligence Tools that are rarely found on Excel users, and transform to an Excel Star! COMPLETELY REDONE ON MARCH 2023 WITH NEW VIDEOS!

Power query excel 2019 mac