Excel – Advanced Reporting with Power Pivot and Power Query


March 29, 2017


Mike Thomas

  1:00 PM ET | 12:00 PM CT | 10:00 AM PT 60 min


If you often need to work with large datasheets, you must be well aware of the limitations of Microsoft Excel. However, Power Pivot and Power Query, which are two free add-ins by Microsoft, will help you overcome this hurdle and make your work a lot simpler. Find out how.

Power Pivot helps you overcome Excel’s limitations when it comes to working with massive datasets. Using the add-in you can import over 1 million row datasets, from virtually any source. However, that’s not all. Power Pivot is also really handy for creating pivot tables from multiple datasets. You’ll not have to bother with vlookup, and you can forget about multiple consolidation ranges. Working with Power Pivot is a breeze.

Power Query (which is built in and named ‘Get and Transform’ on Excel 2016) can save you a lot of time when working with imported data. Often, when data is imported from external sources, it needs work on it, before it can be used. Unnecessary rows and columns may need to be removed, blank spaces may need to be deleted, and data may have to be merged or split. All of this can be done on Excel, but with Power Query, things move a lot faster. It can also handle much more data, and you can save query definitions on it to increase ease of usage in the future.

Attendees should have (at least) intermediate knowledge of Excel, and they should be familiar with formulas and Pivot tables on Excel. All webinar attendees will be provided handouts, which will help them remember and make the most of the training they receive. These handouts include copies of the demo files used during the webinar.

Training Highlights:

  • Learn how to install Power Pivot to your devices
  • Learn about Data Models
  • Find out how to create relationships in Power Pivot
  • Find out how to import data into excel from external sources
  • Learn about DAX formulas
  • Learn about Power Query’s data sources
  • Learn how to clean, transform, merge and unpivot data in Excel

Who will benefit:

The following people will benefit from, and should therefore attend, this webinar:

  • Users of Microsoft Excel
  • Users of Excel who want to learn about Power Pivot and Power Query
  • People with an intermediate level of knowledge about Excel