Excel - Functionality, Power Query is a lot Faster

Overview:
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 Profile:
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.

Others Details

For more details and updates please visit conference website