Advanced Excel & Co-Pilot for Data Analytics
Course Overview
This intensive short course equips participants with practical skills to unlock the full potential of Excel as a modern data analytics and modelling tool. Blending traditional Excel techniques, Power Query, and AI-powered Co-Pilot capabilities, the course provides a forward-looking perspective on how professionals can streamline workflows, automate analysis, and build smarter financial and business models.
What you’ll learn
- Understand how Excel fits into the modern data analytics workflow
- Apply advanced Excel functions for effective data manipulation
- Use Power Query for data transformation and automation
- Leverage Python integration within Excel for advanced analysis
- Utilise Microsoft Co-Pilot for faster, AI-assisted insights and modelling
- Apply Excel in financial modelling scenarios with confidence
Hands-On Learning
Through real-world examples, interactive demos, and guided exercises, participants will learn how to manipulate, clean, and analyse data, integrate Python within Excel, and harness Co-Pilot to boost productivity and accuracy.
Course Schedule & Outline
Welcome / Attendance & Overview Data Manipulation using Power Query
Course objectives and expectations Financial Modelling Examples using Excel
Introduction to Data Analytics with Excel Structuring a financial model with best practices
Role of Excel in analytics workflows Integrating analytics, scenarios, AI-assisted inputs
Introduction to Python & Co-Pilot in Excel Interactive knowledge check
Data Manipulation using Advanced Excel Challenges, real-world use cases
This course is designed as structured learning and may be used to claim 3 CPD hours with your professional association. Please confirm eligibility with your professional body.
