Microsoft Advanced Excel Dashboard : Zero To Hero (Complete)

Course Curriculum

Chapter 1: Introduction to the Course

Lecture 1: Introduction to Dashboard Course

Lecture 2: Download the Excel Dashboard Practice Files + Shortcuts

Chapter 2: Learn to make Excel dashboard using Pivot tables

Lecture 1: Introduction to 1st Dashboard

Lecture 2: Understanding the data in Excel

Lecture 3: Text Function in Excel

Lecture 4: Dynamic Data to Create Table

Lecture 5: Naming the dynamic data and the using it in function

Lecture 6: Preparing 1st Pivot and updating data

Lecture 7: Classic view and Filling blank with zero in Pivot

Lecture 8: Create Chart for comparison from the Pivot Table

Lecture 9: Create Trend line from the Pivot table

Lecture 10: Creating Pie Chart from Slab Report from Pivot

Lecture 11: Preparing Framework for Dashboard

Lecture 12: Inserting Slicer using Chart

Lecture 13: Customize Slicer Setting

Chapter 3: Learn to create Excel Dashboard using Functions

Lecture 1: Brief on 2nd Dashboards

Lecture 2: Importing Data from the Internet

Lecture 3: Converting Line Item into a Currency Table

Lecture 4: Calculation of Currency using INDEX and MATCH

Lecture 5: Creating Slabs using Vlookup True Parameter

Lecture 6: Creating Quarters based on Financial or Calendar Selection

Lecture 7: Preparing the base by removing duplicate for Dashboard

Lecture 8: AverageIF for calculating Country Wise Salary

Lecture 9: Substituting ERROR with zero using IFERROR

Lecture 10: Introduction to Function INDIRECT Part 1 and 2

Lecture 11: Using Function INDIRECT to Retrieve AverageIF from relevant sheet

Lecture 12: Using Function CountIf with INDIRECT to calculate Number of Employees

Lecture 13: Calculating Contribution Country wise Number of Employees

Lecture 14: Using NameRange to simplify calculation

Lecture 15: Using NameRange with formula in 2nd Dashboard

Lecture 16: Introduction to Offset Function

Lecture 17: Offset Function in Excel

Lecture 18: Using Offset Function in Dashboard

Lecture 19: Use of MINIF in Dashboard

Lecture 20: Use of MAXIF in Dashboard

Lecture 21: Using Average to get Designation Wise Experience result

Lecture 22: Using MAXIF with multiple conditions

Lecture 23: Using MINIF with multiple conditions

Lecture 24: Dynamic Dropdown List

Lecture 25: Longitude and Latitude with plotting data on Dashboard

Lecture 26: Using REPT Function based on the percentage calculation

Lecture 27: Activation of Developer Tab and creating Scroll Bar

Lecture 28: Inserting Trend chart based on data

Lecture 29: Advance INDEX and MATCH with multiple references

Lecture 30: Inserting Spark Line

Lecture 31: Insert World Map into the chart

Lecture 32: Plotting Data on Map Chart

Lecture 33: Controlling Map Preview from Dropdown

Lecture 34: Summarizing 2nd Dashboard

Chapter 4: Learn to create Excel Dashboard using Macros and Functions

Lecture 1: Brief on 3rd Dashboards

Lecture 2: Implementation of OFFSET for Dynamic Data

Lecture 3: Creating Trend Chart from Two Pivot Tables

Lecture 4: Modifying the Chart Settings for Better View

Lecture 5: Using Macro recording for Trend Chart

Lecture 6: Using macro to update pivot based on the Job Type

Lecture 7: Triggering macros with any change in Spreadsheets

Lecture 8: Creating Name Range using Shortcut

Lecture 9: Use of MAXIF and MINIF with Single and Multiple Parameters

Lecture 10: Create chart to represent multiple parameters effectively – Part 01

Lecture 11: Create chart to represent multiple parameters effectively – Part 02

Lecture 12: Preparing data for Spiderweb chart and change the graph setting

Lecture 13: Using macro to Hide and Unhide working sheets

Lecture 14: Inserting Trendline and formatting for better view

Chapter 5: Conclusion

Lecture 1: Conclusion of all 3 Excel dashboards