ONLEARN COURSE
Dynamic Dashboards: Excel Storytelling with Data
Transform raw spreadsheets into interactive, insightful dashboards. Learn to visualize key metrics, track trends, and communicate compelling data narratives without coding.
IntermediateEnglish4 sections4.5 hours894 students
What you’ll be able to do
- Design and plan effective dashboard layouts for various data storytelling needs.
- Master advanced Excel functions (e.g., INDEX/MATCH, OFFSET, CHOOSE, array formulas) for dynamic data retrieval.
- Implement interactive controls like slicers, timelines, and form controls to enable user-driven data exploration.
- Create impactful and dynamic charts and visualizations that respond to user selections.
- Utilize conditional formatting effectively to highlight key trends and outliers.
- Assemble multiple dashboard components into a cohesive, user-friendly interface.
- Optimize dashboard performance and ensure data integrity.
- Apply best practices for dashboard design and data storytelling.
Inside this course
4 sections · 22 activities · 4.5 hours total length
01Module 1: Dashboard Planning and Data Preparation
- Introduction to Dynamic Dashboards10:00
- Dashboard Design Principles15:00
- Structuring Your Data for Dashboards12:00
- Data Validation and Dropdown Lists13:00
- Exercise: Planning Your First Dashboard10:00
02Module 2: Advanced Formulas for Interactivity
- Dynamic Data Retrieval with INDEX/MATCH15:00
- Leveraging OFFSET for Dynamic Ranges15:00
- CHOOSE and INDIRECT for Flexible Reporting10:00
- Introduction to Array Formulas (CSE Formulas)15:00
- Hands-on Lab: Building Dynamic Data Tables20:00
- Quiz: Advanced Formula Concepts5:00
03Module 3: Interactive Controls and Visualizations
- Introduction to Form Controls (Spin Buttons, Option Buttons)15:00
- Using Slicers and Timelines for Filtering15:00
- Creating Dynamic Charts20:00
- Conditional Formatting for Visual Impact15:00
- Hands-on Lab: Integrating Interactive Controls25:00
- Quiz: Interactive Elements and Charting5:00
04Module 4: Dashboard Assembly and Best Practices
- Assembling the Dashboard Components15:00
- Dashboard Optimization and Performance10:00
- Protecting Your Dashboard10:00
- Storytelling with Your Dashboard10:00
- Project: Build Your Complete Dynamic Dashboard15:00
About this course
Transform static data into compelling narratives! This course empowers you to build interactive, dynamic dashboards in Excel, making your data insights clear and impactful for any audience.
Who this is for
- Analysts, managers, and business professionals who need to present data more effectively.
- Anyone looking to transform static Excel reports into interactive, user-friendly dashboards.
- Individuals who want to enhance their Excel skills for data visualization and reporting.
- Data enthusiasts eager to tell compelling stories with their data in Excel.
Before you begin
- Microsoft Excel 2016 or newer (Office 365 recommended)
- Basic to intermediate Excel skills (formulas, pivot tables, basic charts)
- A computer with Excel installed and a stable internet connection
LEARNING EXPERIENCES
455 ratingsLearner ratings
4.4 / 5 · Average learner rating
A few useful details
How will I learn?
Work through the course sections and activities in your Onlearn course player, at your own pace. Your progress is saved to your account.
Is this a subscription?
No. Each course is purchased separately with one payment.