Analysis, Using Appropriate Statistical Methodology

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

Event Cost & Details:

One Dial-in One Attendee Price: US$150.00

Contact Detail:

Compliance4All DBA NetZealous,

Phone: +1-800-447-9407

Email: support@compliance4All.com

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.