Business Applications of Excel: 3

Modern Excel: Power Pivot and Power Query

Whether Excel is a daily part of your business or just occasionally used for a quick spreadsheet project, users often find themselves spending hours trying to answer the question, “I know there’s a way to do this in Excel, but how?” Become a more efficient Excel user and learn the most powerful features that the program has to offer in this one-day, advanced course. Highly interactive and hands-on, you will spend the entire time using Excel while an expert trainer walks you through demonstrations and exercises. Topics Include:

• Power Pivot: PowerPivot is a free add-in for Microsoft Excel that enables you to import millions of rows of data from multiple data sources into a single Excel workbook, create relationships between heterogeneous data, create calculated columns and measures using formulas, build PivotTables and PivotCharts, and then further analyze the data so that you can make timely business decisions without requiring IT assistance.


• Power Query: Power Query is an amazing data tool for Excel! It is built by Microsoft to help you import, transform, and remember your data processes. Can import data from a variety of sources, clean the data and be ready for the analysis phase. After doing it once, this process can be automated.


• Scraping the Internet: Pulling data directly from the internet and then manipulating that data for purposes of analysis.