This course is designed for those interested to learn how to make use of Pivot Tables, Power Query, and Power Pivot to get meaningful results from tons of data coming from different sources. Read more.
Tom Fragale is a computer professional w/over 30 years of experience. He is a Microsoft Certified Trainer. Available for webinars, Live Onsite Training and 1-on-1 training. He is also a published author with a book on Pivot Tables published by Wiley Publishing.
Buy this course for $199 $10
and keep lifetime access.
Access all courses in our library for only $9/month with All Access Pass
About This Course
These days, there are tons of data coming in from many sources. You are expected to import all of that data, and then get meaningful results from that data.
This course will help you do that.
Topics include:
- Normal Pivot Table formulas
- Sorting and filtering the Pivot Table
- Calculated items
- Calculated fields
- Conditional Formatting in the Pivot Table
- Consolidated Pivot Tables
- Importing data from Excel into Power Query – normal data
- Splitting and merging columns in the Power Query
- Calculate age in the Power Query
- Adding custom calculations in Power Query
- Importing data from a website into the Power Query
- Refreshing the data in Power Query
- Importing data from Excel into Power Query – formatted tables
- Importing Access, SQL Server, and text files into Power Query
- Append Queries
- GroupBy Queries
- Merge Queries
- More calculations including a conditional column in Power Query
- Activating Power Pivot
- Exploring the Power Pivot menus
- Starting the Pivot Table from Power Pivot
- Managing table relationships
- Slicers and timelines in Power Pivot
- Using sets in Power Pivot
- Importing Data directly into the Power Pivot
- Measures and KPIs in Power Pivot
Requirement:
- Basic working knowledge of Excel.
Our Promise to You
By the end of this course, you will have learned how to use Pivot Tables, Power Query, and Power Pivot.
10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.
Get started today and learn more about getting meaningful results with Excel.
Course Curriculum
| Section 1 - Pivot Tables | |||
| Student File | 00:00:00 | ||
| Normal Pivot Table Formulas | 00:00:00 | ||
| Sorting And Filtering The Pivot Table | 00:00:00 | ||
| Calculated Items In Excel Pivot Tables | 00:00:00 | ||
| Calculated Fields | 00:00:00 | ||
| Conditional Formatting In The Pivot Table | 00:00:00 | ||
| Consolidated Pivot Tables | 00:00:00 | ||
| Section 2 - Power Query | |||
| Importing Data From Excel Into Power Query – Normal Data | 00:00:00 | ||
| Splitting And Merging Columns In The Power Query | 00:00:00 | ||
| Calculate Age In The Power Query | 00:00:00 | ||
| Adding Custom Calculations In Power Query | 00:00:00 | ||
| Importing Data From A Website Into The Power Query | 00:00:00 | ||
| Refreshing The Data In Power Query | 00:00:00 | ||
| Importing Data From Excel Into Power Query – Formatted Tables | 00:00:00 | ||
| Importing Access, SQL Server, And Text Files Into Power Query | 00:00:00 | ||
| Append Queries | 00:00:00 | ||
| GroupBy Queries | 00:00:00 | ||
| Merge Queries | 00:00:00 | ||
| More Calculations Including A Conditional Column In Power Query | 00:00:00 | ||
| Section 3 - Power Pivot | |||
| Activating Power Pivot | 00:00:00 | ||
| Exploring The Power Pivot Menus | 00:00:00 | ||
| Starting The Pivot Table From Power Pivot | 00:00:00 | ||
| Managing Table Relationships | 00:00:00 | ||
| Slicers And Timelines In Power Pivot | 00:00:00 | ||
| Using Sets In Power Pivot | 00:00:00 | ||
| Importing Data Directly Into The Power Pivot | 00:00:00 | ||
| Measures And KPIs In Power Pivot | 00:00:00 | ||
About This Course
These days, there are tons of data coming in from many sources. You are expected to import all of that data, and then get meaningful results from that data.
This course will help you do that.
Topics include:
- Normal Pivot Table formulas
- Sorting and filtering the Pivot Table
- Calculated items
- Calculated fields
- Conditional Formatting in the Pivot Table
- Consolidated Pivot Tables
- Importing data from Excel into Power Query – normal data
- Splitting and merging columns in the Power Query
- Calculate age in the Power Query
- Adding custom calculations in Power Query
- Importing data from a website into the Power Query
- Refreshing the data in Power Query
- Importing data from Excel into Power Query – formatted tables
- Importing Access, SQL Server, and text files into Power Query
- Append Queries
- GroupBy Queries
- Merge Queries
- More calculations including a conditional column in Power Query
- Activating Power Pivot
- Exploring the Power Pivot menus
- Starting the Pivot Table from Power Pivot
- Managing table relationships
- Slicers and timelines in Power Pivot
- Using sets in Power Pivot
- Importing Data directly into the Power Pivot
- Measures and KPIs in Power Pivot
Requirement:
- Basic working knowledge of Excel.
Our Promise to You
By the end of this course, you will have learned how to use Pivot Tables, Power Query, and Power Pivot.
10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.
Get started today and learn more about getting meaningful results with Excel.
Course Curriculum
| Section 1 - Pivot Tables | |||
| Student File | 00:00:00 | ||
| Normal Pivot Table Formulas | 00:00:00 | ||
| Sorting And Filtering The Pivot Table | 00:00:00 | ||
| Calculated Items In Excel Pivot Tables | 00:00:00 | ||
| Calculated Fields | 00:00:00 | ||
| Conditional Formatting In The Pivot Table | 00:00:00 | ||
| Consolidated Pivot Tables | 00:00:00 | ||
| Section 2 - Power Query | |||
| Importing Data From Excel Into Power Query – Normal Data | 00:00:00 | ||
| Splitting And Merging Columns In The Power Query | 00:00:00 | ||
| Calculate Age In The Power Query | 00:00:00 | ||
| Adding Custom Calculations In Power Query | 00:00:00 | ||
| Importing Data From A Website Into The Power Query | 00:00:00 | ||
| Refreshing The Data In Power Query | 00:00:00 | ||
| Importing Data From Excel Into Power Query – Formatted Tables | 00:00:00 | ||
| Importing Access, SQL Server, And Text Files Into Power Query | 00:00:00 | ||
| Append Queries | 00:00:00 | ||
| GroupBy Queries | 00:00:00 | ||
| Merge Queries | 00:00:00 | ||
| More Calculations Including A Conditional Column In Power Query | 00:00:00 | ||
| Section 3 - Power Pivot | |||
| Activating Power Pivot | 00:00:00 | ||
| Exploring The Power Pivot Menus | 00:00:00 | ||
| Starting The Pivot Table From Power Pivot | 00:00:00 | ||
| Managing Table Relationships | 00:00:00 | ||
| Slicers And Timelines In Power Pivot | 00:00:00 | ||
| Using Sets In Power Pivot | 00:00:00 | ||
| Importing Data Directly Into The Power Pivot | 00:00:00 | ||
| Measures And KPIs In Power Pivot | 00:00:00 | ||
Course Review
5.0
1 RatingsRelated Courses
Are you interested in higher education?
All Rights Reserved
Great Course - Informative and Not a Big Time Commitment
This is a very good course to learn some new skills about Excel you probably don’t know anything about! If you need a refresher on Pivot Tables, Thomas covers it nicely in the first part of the course. He also adds things like calculated fields and calculated items if you haven’t done those in Pivot Tables yet. But on to the good stuff — Power Queries are a great way of cleaning up data, adding additional calculations, and sourcing data from other workbooks and even the web. Power Queries can also add data to a Data Model which you use in Power Pivot. Power Pivot can give you similar functions you might expect from relational databases but entirely within Excel. He then ends with showing you some features in Power Pivot that don’t show up in regular Pivot Tables. Thomas gives you a nice student file with data you can practice on.
You can get this course done in an afternoon and have useful skills you can take with you on your next Excel project. Give it a try!