Excel - Functionality, Power Query is a lot Faster
This Webinar is over| Date | Sep 22, 2017 |
| Time | 10:00 am |
| Cost | $ 150.00 |
|
Online
|
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@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@compliance4All.com
comments powered by Disqus
Create your own event
Turn your passion into a business.
Turn your passion into a business.