Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Present Your Data Online Course Package
Introduction
Getting Started (7:32)
Course Introduction (0:59)
Data Visualization Example (0:54)
Data Visualization Meaning (0:59)
Data Visualization Story Example (2:50)
Dashboard Example (1:13)
Return On Investment (2:28)
Join Our Closed Facebook Group
Visualization Concepts
The 5 Key Elements (1:01)
Tell Your Story (2:19)
Story Structure (4:49)
Craft Your Story in a Speech (10:12)
Keep it simple (4:27)
Chart Types (3:30)
Superstore - Dataset
Chart Types in Excel (17:30)
Using Colors (5:12)
Color Schemes (11:31)
Counting Colors in Dashboards (2:21)
Drive the Focus 1 (7:18)
Drive the Focus 2 (2:59)
Say it with Pictures (3:09)
Test The 5 Key Elements (5:48)
Data Analysis (Insights)
Create Pivot Table (5:06)
Formatting Numbers (6:30)
Formatting Chart (3:54)
Using Slicer in Excel (5:14)
Root Cause Analysis Using Pivot Table 1 (10:02)
Root Cause Analysis using Pivot Table 2 (7:56)
Analysis Using Scatter Plot 1 (8:19)
Analysis Using Scatter Plot 2 (11:49)
Dashboard Creation
Create Summary Dashboard 1 (11:19)
Create Summary Dashboard 2 (11:17)
Create Summary Dashboard 3 (7:33)
Create Detailed Dashboard (17:17)
Validate Our Dashboard (4:54)
Course Summary
Course Summary (2:44)
Course Feedback
Extra Content
Add Total to Stacked Column Chart (5:49)
Custom Sorting in Pivot Table (5:42)
Line Chart (7:23)
Negative Values on Chart (1:29)
How to Choose The Right Chart Type (2:05)
Table Vs. Chart (4:30)
Resources
Present Your Data - Presentation
Sales Dashboard
Excel Dashboard Online Course
Excel Dashboard Online Course Link
Superstore - Dataset
Download
Superstore - Dataset.xlsx
Complete and Continue
Discussion
328
comments
Load more
328 comments