This course provides participants with a comprehensive and practical understanding of Microsoft Excel, from mastering core functionalities to applying advanced tools such as Pivot Tables, Power Query, Forecasting features, and AI-assisted analysis. Participants will develop the ability to organise, analyse, and present data effectively while building the productivity skills required to use Excel confidently across business, finance, and academic environments.
Everything you need to know
This course is designed for professionals across all industries who use Microsoft Excel to work with data. It is ideal for beginners with little or no prior experience who want to build a strong practical foundation. Finance, operations, administrative, and analytics professionals, as well as business leaders who handle data or reports, will benefit greatly. It is also well-suited for graduates, career changers, and anyone looking to improve productivity and data skills using Excel.
8 hours (this is run as 2 sessions of 4 hours each)
- Introduction to Excel
- Basic Data Entry & Navigation
- Basic Formatting & Conditional Formatting
- Sorting & Filtering
- Formulas & Functions
- Data Tools
- Pivot Tables
- Data Visualization
- Get Data (Power Query)
- Forecasting & What-If Analysis
- ALT Controls & Productivity
- Recording Macros
- AI in Excel
