Course Content
Topic 1: Mastering Power Query for Excel 2016 or later versions
Describing Power Query
0/3
Topic#1: Mastering Power Query for Excel 2016 or later versions
00:00
Assignments#1: Mastering Power Query for Excel 2016 or later versions
Mastering Power Query for Excel 2016 or later versions
15:00
Topic 2: Introduction to Power Pivot
0/4
Lesson#1: Video and Workbook – Introducing PowerPivot
00:00
Lesson#2: Notes – Introducing PowerPivot
00:00
Assignments#2: Introduction to Power Pivot
Introduction to Power Pivot
05:00
Topic 3: Creating Measures with DAX (or Calculated Fields)
0/4
Lesson#2: Notes – Creating Measures with DAX (or Calculated Fields)
00:00
Lesson#1: Video and Workbook – Creating Measures with DAX (or Calculated Fields)
00:00
Assignments#3: Creating Measures with DAX (or Calculated Fields)
Creating Measures with DAX (or Calculated Fields)
05:00
Data & Analytics using Ms. Excel PowerSuite For Healthcare Professionals
About Lesson

In this lesson you are going to cover:

  • Exploring Power Query Editor & Data Loading Options (Various Data
    Sources)
  • Powerful Data Table Transformations (Cleaning, Flattening, Unpivoting
    etc)
  • Grouping, Aggregating and inserting Calculated Columns
  • Append, Duplicate, Merge and Refresh Queries

Please download the reference notes and follow them in line with the video tutorial and the class workbook.

Exercise Files
Excel Power Query Tutorial.pdf
Size: 1.29 MB
Previous
Next
0% Complete