Excel for Insight: Data Storytelling, Dashboards, and Advanced Functions

Learn to turn raw data into clear stories and visuals. Discover advanced Excel tools-Pivot Tables, Dashboards, XLOOKUP, FILTER, and UNIQUE-to analyse, automate, and present data with impact.
Duration: 1 Day
Hours: 1 Hour
Training Level: All Levels
Batch One
Friday, January 30, 2026
12:00 PM - 01:00 PM (Eastern Time)
Batch Two
Friday, February 20, 2026
12:00 PM - 01:00 PM (Eastern Time)
Batch Three
Friday, March 20, 2026
12:00 PM - 01:00 PM (Eastern Time)
Live Session
Single Attendee
$149.00 $249.00
Live Session
Recorded
Single Attendee
$199.00 $332.00
6 month Access for Recorded
Live+Recorded
Single Attendee
$249.00 $416.00
6 month Access for Recorded

About the Course:

This hands-on webinar helps you move beyond spreadsheets and into storytelling. You’ll learn how to connect data, apply advanced functions, build dashboards, and visualise insights that influence decisions. Using practical examples, we’ll cover the newest Excel capabilities-dynamic arrays, slicers, and conditional formatting-to simplify analysis and make your reports shine.

Course Objectives:

  • Apply modern Excel functions for smarter data analysis.
  • Build pivot tables and dashboards that reveal trends and insights.
  • Use storytelling techniques to communicate data effectively.
  • Automate repetitive reporting tasks with dynamic arrays and filters.
  • Create professional visuals for presentations and stakeholders.

Who is the Target Audience?

  • Business professionals, analysts, trainers, and anyone who uses Excel to analyse or present data. Suitable for users from intermediate to advanced levels.

Basic Knowledge:

  • Participants should be comfortable with basic Excel functions (SUM, IF, VLOOKUP) and simple charting.

Curriculum
Total Duration: 1 Hour
Data Storytelling Principles - Clarity, Simplicity, Impact
Advanced Excel functions: XLOOKUP, FILTER, UNIQUE, SORT
Pivot Tables and Pivot Charts - Designing for Insight
Dashboard Creation with Slicers and Interactivity
Conditional Formatting and Data Visualisation Best Practices
Automation and Efficiency Tips for Everyday Reporting