Mastering Data Visualization in Excel: Unveiling Insights with Dashboards
Created by Team Mammoth
01
Skill level
All levels
02
Sections
9
03
Lectures
55
04
Instructor
Team Mammoth
What's inside
This course includes.
✓
9
Sections
✓
55
Lectures
✓
55
Resources
✓
Certificate of completion
Included
✓
Mobile and desktop access
Included
✓
AI learning assistance
Included
Unlock all courses with our Subscription Bundle! Get unlimited access to entire course library, books and assets. Learn more and subscribe today!
Course content
Curriculum & lectures.
+ Introduction to the Course 5 lectures
1.1 Introduction To The Course
Locked
1.2 Introduction Of The Instructor
Locked
1.3 Course Requirements
Locked
1.4 How To Get Excel
Locked
Source files
Locked
+ Dashboards Introduction 7 lectures
2.1 What Will We Learn In This Section
Locked
2.2 What Are Dashboards
Locked
2.3 Answers You Need Before You Start A Dashboard
Locked
2.4 Best Practices For Dashboard Layout
Locked
2.5 Best Practices For Dashboard Colors
Locked
2.6 Section Summary
Locked
Source Code
Locked
+ Build a Dashboard Project 6 lectures
3.1 What Will We Learn In This Section
Locked
3.2 Build A Wireframe In Excel
Locked
3.3 Prepare Raw Data For Dashboard
Locked
3.4 Prepare Calculation Sheet
Locked
3.5 Section Summary
Locked
Source Code
Locked
+ Scrolling Data Table 8 lectures
4.1 What Will We Learn In This Section
Locked
4.2 Build A Combo Box
Locked
4.3 Complex Lookup
Locked
4.4 Build A Scrolling Data Table
Locked
4.5 Conditionally Format Actual Values VS Budgeted Values
Locked
4.6 Conditional Headers
Locked
4.7 Section Summary
Locked
Source Code
Locked
+ Show Top Indicators 6 lectures
5.1 What Will We Learn In This Section
Locked
5.2 Show Top Matches Over And Under Budget
Locked
5.3 List Box To Select Indicators
Locked
5.4 Toggle Between Top Over Or Under
Locked
5.5 Section Summary
Locked
Source Code
Locked
+ Scrollable Line Chart 8 lectures
6.1 What Will We Learn In This Section
Locked
6.2 Prepare Data For Scrolling Chart
Locked
6.3 Scrollable Line Chart
Locked
6.4 Remove Crashing Lines
Locked
6.5 Toggle Visibility Of Line Series
Locked
6.6 Finetune The Line Series
Locked
6.7 Section Summary
Locked
Source Code
Locked
+ Interactivity 8 lectures
7.1 What Will We Learn In This Section
Locked
7.2 Add Interactivity To Reports With Pivot Slicers
Locked
7.3 Column Chart Controlled By Slicer
Locked
7.4 Pivot Slicer Sorting
Locked
7.5 Select Only 1 Slicer
Locked
7.6 Dynamic Comments With Slicers
Locked
7.7 Section Summary
Locked
Source Code
Locked
+ Finetune the Dashboard 6 lectures
8.1 What Will We Learn In This Section
Locked
8.2 Add Calculations For Variances In Pivot Tables
Locked
8.3 Conditional Formatting In Pivot Tables
Locked
8.4 Refresh Pivot Table With Easy VBA
Locked
8.5 Section Summary
Locked
Source Code
Locked
+ Course Summary 1 lecture
9.1 Course Summary And Next Steps
Locked
Instructors
Taught by people who ship.
Team Mammoth
Instructor
Produced by a team of Mammoth Club industry experts. Over 14 years, Mammoth Club has built a global student community in 190+ countries with 9+ million courses sold, releasing over 1,000+ courses and 5,000+ hours of video content.
Ready to start building?
Join Mammoth Club and move through the course with structured lessons, previews, and certificates.