2017 - Excel - Functionality, Power Query is a lot Faster
Date2017-09-22
Deadline2017-09-21
VenueFremont, USA - United States
KeywordsExcel functions; Power Pivot; Business Intelligence
Topics/Call fo Papers
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.
Event Cost & Details:
One Dial-in One Attendee Price: US$150.00
Contact Detail:
Compliance4All DBA NetZealous,
Phone: +1-800-447-9407
Email: support-AT-compliance4All.com
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.
Event Cost & Details:
One Dial-in One Attendee Price: US$150.00
Contact Detail:
Compliance4All DBA NetZealous,
Phone: +1-800-447-9407
Email: support-AT-compliance4All.com
Other CFPs
Last modified: 2017-07-12 19:28:28