Excel Essentials 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:

• Navigate the Excel interface, customise settings and manage multiple worksheets efficiently
• Learn best practices for inputting, editing and formatting data for clarity and readability
• Adjust, insert, delete and freeze panes to keep data structured and accessible
• Use formulas, including SUM, AVERAGE, IF, COUNT and LOOKUP functions to calculate and analyse data
• Organise data alphabetically, numerically and by multiple criteria to extract insights easily
• Create and customise bar, pie and line charts to communicate trends and patterns clearly
• Apply validation rules and implement best practices for data integrity
• Discover formatting shortcuts, templates and essential Excel functions to work smarter

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