Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel Dashboards
Welcome
Intro and Course Navigation (2:04)
YouTube Data & Other Resources
Final Dashboard
Importing & Transforming Data with Power Query
Power Query Data Tab Overview (3:34)
Download Power Query Add-In for Excel 2010 or 2013
Import CSV Files & Power Query Editor Overview (10:38)
Edit a Power Query (3:15)
Combine Files in a Folder with Power Query (Part 1) (6:19)
Combine Files in a Folder with Power Query (Part 2) (3:45)
Joining Data with Power Query Merges (Part 1) (4:15)
Joining Data with Power Query Merges (Part 2) (2:50)
Creating a Calendar Table in Power Query (Part 1) (6:02)
Creating a Calendar Table in Power Query (Part 2) (5:52)
Calendar Table Alternative Period Method (8:33)
Dynamically List Dates in a Calendar (3:02)
Building an Excel Data Model
Load Data Into the Data Model and Define Relationships (4:06)
Add Measures to the Data Model (4:32)
Add Measures for Last Month (4:39)
Pivot Table Style and Layout Tips (4:13)
Creating Key Performance Indicator Data Cards (KPI's)
Building a Pivot Chart (4:50)
Building a Label Heading (3:43)
Adding a KPI Value (10:00)
Adding a Percent Change Value (7:03)
Useful Settings (2:36)
Copy and Paste a Data Card (5:48)
Dashboard Charts
Unpivot Data for Doughnut Chart (7:07)
Format Doughnut Chart (6:48)
Column Chart (5:23)
Line Chart (5:11)
Top 10 Countries Pivot Table (9:19)
Top 10 Videos Pivot Table (7:44)
Map Chart (12:15)
Move All Visuals to a New Sheet (1:04)
Slicers and Timelines
Add Slicers and Timelines (8:01)
Connect Slicers and Timelines to Multiple Pivot Tables (2:11)
Style a Slicer or Timeline (3:21)
Dashboard Final Touches
Aligning Dashboard Elements (5:25)
Dashboard Final Touches (3:33)
Protecting the Dashboard (4:14)
Refreshing the Dashboard (2:10)
Course Feedback
Course Feedback
Extras
More Extras Coming Soon...
Power Query Parameters (4:09)
Power Query Parameter Table (10:15)
Convert Pivot Tables to Cube Functions (5:17)
Load Data Into the Data Model and Define Relationships
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock