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

YouTube

How to Create Data Visualization in Excel Using Tables, Slicers and Charts

Simon Sez IT via YouTube

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Learn how to create stunning data visualizations in Excel using tables, slicers, and charts with the help of free practice files in this 46-minute tutorial. Master the creation of column charts, pie charts, sparklines, and pivot tables while discovering how to connect them into a simple interactive dashboard. Transform raw data into clear, engaging visuals that facilitate analysis and reporting by following along with downloadable course files. The tutorial begins with an introduction before diving into column charts, then progresses through pie charts, slicers for interactive filtering, sparklines for compact data trends, pivot tables for data summarization, and concludes with building a comprehensive dashboard that brings all these elements together into a cohesive visualization system.

Syllabus

00:00:00 - Course Introduction
00:01:18 - Column Charts
00:18:05 - Pie Charts
00:21:37 - Slicers
00:28:22 - Sparklines
00:34:31 - Pivot Tables
00:37:42 - Create a Simple Dashboard

Taught by

Simon Sez IT

Reviews

Start your review of How to Create Data Visualization in Excel Using Tables, Slicers and Charts

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.