Skip to main content
grasp.study
About
Explore
Pricing
Log in
Try it for free
Back to course
👋
Welcome to a Grasp lesson
Create a free account
to keep studying and create your own study path.
Excel Basics
·
Module 7
Data Visualization and Interactive Dashboards
1
Mastering Data Visualization: Creating and Customizing Charts
Create and customize various chart types (bar, line, scatter) to effectively represent data.
2
Visualize Data with PivotCharts
Create a PivotChart to visualize data from a PivotTable.
Creating Combo Charts with a Secondary Axis
Build combination charts with a secondary axis to display multiple data series.
4
Sparklines: Tiny Charts, Big Insights
Use sparklines to create compact, in-cell data visualizations.
5
Dynamic Charts with Excel Tables
Create dynamic charts that automatically update with new data using Excel Tables.
6
Interactive Dashboards with Slicers & Timelines
Add interactivity to dashboards using Slicers and Timelines.
7
Interactive Chart Controls
Incorporate form controls (e.g., drop-down lists) to create interactive chart inputs.
8
Building an Interactive Dashboard
Design and build an interactive dashboard to consolidate and display key metrics.
Previous module
Summarizing Data with PivotTables
Next module
Financial Modeling Fundamentals