Lesson 1 Adjusting Data

Lesson 2 Creating Pivot Table

Lesson 3 Pivot Chart Part 1

Lesson 4 Pivot Chart Part 2

Lesson 5 Customizing Pivot Table

Lesson 6 Sorting Pivot Table

Lesson 7 Grouping Pivot Table

Lesson 8 Filtering Pivot Table

Lesson 9 Changing Calculations

Lesson 10 Adding Percentages

Lesson 11 Running Total In

Lesson 12 Refreshing Pivot Table

Lesson 13 Frequency

Lesson 14 Bie Chart

Lesson 15 Cross Tabulation

Lesson 16 Conditional Format

Lesson 17 Line Chart Part 1

Lesson 18 Line Chart Part 2

Lesson 19 Doughnut Chart

Lesson 20 Adding Slicers

Lesson 21 Text To Columns

lesson 22 Creating Dashboard Part 1

Lesson 23 Creating Dashboard Part 2

Lesson 24 Analaysing Dashboard Report

Lesson 25 Column with Text

Lesson 26 Power Query Editor

Lesson 27 Change Type Power Query Editor

Lesson 28 Insert CSV File

Lesson 29 Frequency of Pivot Table Analysis

Lesson 30 Frequency In Excel Functions Analysis

lesson 31 Extracting Excel File

Lesson 32 Relationship Creating

Lesson 33 Creating Pivot Table and Pivot Chart

Lesson 34 Add Measuring

Lesson 35 Merge And Queries

Lesson 36 Vlookup Relationship

Lesson 37 Data Modeling -Relationship

Lesson 38 Pivot Table Analysis

Lesson 39 Xlookup relationship

Lesson 40 Add Pivot Chart

Lesson 41 Creating Dashboard part1

Lesson 42 Creating Dashboard Part 2

Lesson 43 Creating Dashboard Part3

Lesson 44 Summarizing Final Dashboard