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
Template Design © VibeThemes. All rights reserved.

Setup Menus in Admin Panel