Excel Power User Bundle

Upon completion of this course, you will be able to:

• Identify business questions that can be answered using data analysis
• Translate business challenges into structured, data-driven inquiries
• Clean and prepare datasets using Excel tools
• Use basic Power Query transformations to automate data cleaning and consolidation
• Apply intermediate Excel functions to summarise and analyse data
• Create and interpret PivotTables to identify patterns and trends
• Detect and correct issues related to data bias, quality and structure
• Utilise Excel’s AI tools to generate insights more efficiently
• Communicate data insights using structured storytelling techniques that support decision-making

> See the full 1-day agenda for Excel for Business: Data Analysis in our expanded Course Guide

Upon completion of this course, you will be able to:

• Apply advanced Excel workflow techniques to improve efficiency and accuracy
• Create and manage named ranges to simplify and organise complex formulas
• Use auditing tools to trace, evaluate and troubleshoot calculations
• Build structured references in Tables and apply logical and lookup functions for sophisticated analysis
• Apply Goal Seek and Data Tables to perform forecasting and scenario planning
• Streamline analysis with dynamic arrays, LET and LAMBDA to create reusable solutions

> See the full 1-day agenda for Excel for Business: Advanced Formulas and Functions in our expanded Course Guide