Gain a Splash of New Skills - Coursera+ Annual Just ₹7,999
35% Off Finance Skills That Get You Hired - Code CFI35
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