Earn Your CS Degree, Tuition-Free, 100% Online!
Learn Excel & Financial Modeling the Way Finance Teams Actually Use Them
Overview
Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off
One annual plan covers every course and certificate on Coursera. 40% off for a limited time.
Get Full Access
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