**MOTM 2019 Excel Power Query / Power Pivot Overview**
Excel Power Query and Power Pivot are tools built into Excel that enhance your ability to query, transform, and present data.
It's like having MS Query, Access, and Crystal Reports in one application that everybody already owns.
In this session we will go through the basics of how to use it in real life. The good, the bad, and the funny.
In this hands-on session, you will learn things like:
* Eliminating the need to ever do VLOOKUP's ever again!
* Pulling data from Sage 100.
* Automating consolidating multiple Sage 100 companies into one data set. And when you refresh, it does it all again for you.
* Pulling data from other Excel files, and linking it to the Sage 100 data.
* Creating an automated process to transform an exported report to a valid database.
* Creating Pivot Tables that show accurate GP% for the subtotals.
* Create a Pivot Table to summarize data, then convert the pivot table into a data table.
* Links to Microsoft short online training videos to learn at your own pace.
* We'll even do an example of using Excel Power query for doing an Income Statement.
This doesn't even scratch the surface. And everything you learn applies to using Microsoft Power BI, their flagship Business Intelligence app. At the end is a short demonstration of Power BI to show you what it is and how it goes beyond Excel Power query.
Requirements:
* A Laptop
* Excel 2016, or 2013 with Power Query and Power Pivot add-ins. (32bit ok, 64bit is even better).
* Sage 100 installed with ABC & XYZ demo data.