Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Creating Interactive Excel Dashboards - From Raw Data to Dynamic Visualization

Teacher's Tech via YouTube

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Learn to create a professional, interactive Excel dashboard in this 24-minute tutorial that transforms raw data into meaningful visualizations. Master essential skills including PivotTable creation for data summarization, strategic chart selection for visual storytelling, and slicer implementation for dynamic filtering. Progress through hands-on exercises using provided practice datasets to build three distinct dashboard components, each combining PivotTables, charts, and interactive elements. Explore layout and design principles to create visually appealing dashboards, format slicers for enhanced user experience, and maintain dashboard functionality with data updates. Perfect for Excel users seeking to elevate their data presentation skills, this step-by-step guide includes downloadable practice files and links to supplementary resources for deeper learning about PivotTables, charts, and Excel basics.

Syllabus

Intro
Get practice data
Create table
Create1st Pivot Table
Create Chart
Add Slicer
Create 2nd PivotTable, Chart and Slicers
Create 3rd PivotTable, Chart and Slicers
Create dashboard sheet and move charts and slicers
Slicer formatting
Layout and design
Adding new data and refreshing dashboard

Taught by

Teacher's Tech

Reviews

Start your review of Creating Interactive Excel Dashboards - From Raw Data to Dynamic Visualization

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.