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