Excel - Functionality, Power Query is a lot Faster

If you've been frustrated by other limitations of pivot tables then Power Pivot is for you. Simply put, Power Pivot takes pivot tables and data analysis to the next level. If you're a fan of pivot tables, you'll love Power Pivot.

Areas Covered in the Session:

Importing data into Excel from external sources
Creating pivot tables from multiple sources
Creating relationships and data models
Introduction to DAX formulas
Cleaning and transforming data using Power Query
Combining data from Multiple Tables

Who Will Benefit:

Excel users who are familiar with PivotTable concepts, but need expanded techniques to analyze lists of data

Anyone needing to know how to create PivotTables from multiple sources, use Slicers, Timelines, Calculated Fields, and Conditional Formatting will benefit from this course

Speaker and Presenter Information

Mike Thomas has worked in the IT training business since 1989. He is a subject matter expert in a range of technologies including Microsoft Office and Apple Mac. In 2012 Mike founded theexceltrainer.co.uk where he has produced nearly 200 written and video-based Excel tutorials. He has recorded several Excel training courses for pluralsight.com and in his career delivered hundreds of courses and webinars on a wide variety of technology-related topics.