Live Excel Dashboard MasterClass (August 18-19, 2022 on Zoom)
Back to Dashboard

Hey there, great course, right? Do you like this course?

All of the most interesting lessons further. In order to continue you just need to purchase it

Get course

Course sections

Section 1
Introduction
1
Introduction to Excel Dashboards
2
Principles of Great Dashboard Design
Section 2
Excel Fundamentals
1
Relative & Absolute Referencing
2
Creating & Using Range Names
3
Using Conditional Formatting
4
Format Data with Excel Tables
5
Methods to Sort & Filter Data
6
Using Excel Slicers
Section 3
Data Preparation
1
Loading Data into Excel
2
Remove Duplicates
3
Split Data into Multiple Columns
4
Excel Functions to Clean Data
5
Data Validation
6
Error Handling
Section 4
Creating Mini Dashboards With Excel
1
Logical Functions
2
Lookup Functions
3
Creating a simple Excel dashboard
Section 5
Excel Dashboards With Pivot Tables & Charts
1
Introduction to Excel Pivot Tables & Charts
2
Creating Pivot Table Reports for Analysis
3
Creating a sophisticated Excel Dashboard With Pivot Tables, Charts & Slicers
Section 6
Dashboards With Advanced Controls
1
Introduction to Excel Developer Tools
2
Excel Dashboard with Buttons
3
Excel Dashboard with Dropdowns
4
Excel Dashboard with Scroll Bars
5
Excel Dashboards with Check Boxes
Section 7
Wrap Up

How to Subtract a Date From Today in Excel

Lesson is locked. Please Buy course to proceed.