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.
30 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 |