OVERVIEW
Microsoft Copilot for Excel puts the power of AI right into your spreadsheets — and this course shows you exactly how to use it. Learn how to clean and analyse data, generate formulas, build dashboards, and create visual reports using natural language commands.
In this hands-on training, you’ll explore practical ways to streamline your Excel tasks, uncover insights, and boost productivity using Microsoft 365 Copilot. No coding required — just smarter ways to work.
By the end of the course, you’ll be able to:
- Navigate and use Copilot features in Excel
- Query data using natural language
- Clean and audit data using built-in AI tools
- Generate and troubleshoot formulas
- Build PivotTables and visualisations
- Format spreadsheets for readability and impact
- Perform advanced analytics with Python in Excel
- Summarise and present data clearly and professionally
Typically spans 1-2 Days (9am to 5pm).
Nonetheless, we can customize both the program’s duration and schedule to cater to unique client requirements (e.g., compact 1-day workshops or extended sessions beyond 2 days)
- Executives
- Managers
- Supervisors
- Team Leaders
- Professionals interested in AI literacy and smart workplace adaptation
PROGRAM OUTLINE
- Icebreaker & Trainer Introduction
- Program Objectives
- Understand course objectives and scope
- Familiarize with Copilot interface and capabilities in Excel
- Quick live demo of Copilot features
- Learner introductions and experience sharing
- Query and summarize datasets using natural language
- Identify key insights using Copilot
- Guided hands-on practice querying Copilot
- Group discussion: insights discovered from provided dataset
- Use Excel’s AI-powered Clean Data tool
- Learn common data quality and consistency issues
- Demo of Copilot cleaning workflow
- Hands-on activity: clean and audit messy dataset
- Generate basic formulas using Copilot (e.g., SUM, AVERAGE)
- Understand, verify, and correct Copilot-generated formulas
- Create calculated columns and simple summaries
- Hands-on practice generating and editing formulas
- Use Copilot to build complex formulas
- Troubleshoot errors and broken formulas using Copilot
- Work with IF, VLOOKUP, and INDEX-MATCH
- Hands-on troubleshooting practice
- Improve spreadsheet presentation with formatting via Copilot
- Apply conditional formatting to highlight important data
- Use Copilot for dynamic formatting (e.g., top 10 values, thresholds)
- Hands-on: apply and edit formatting rules
- Introduction to Python integration in Excel
- Use Copilot to perform advanced analysis without writing code
- Real-world examples: sales forecasting, correlation analysis, advanced visuals
- Group observation and discussion on analysis outputs
- Create PivotTables using Copilot
- Interpret pivot table layouts and summaries
- Generate and customize Excel charts with Copilot
- Hands-on activity:
- Pivot for sales by region/product
- Create and style a chart using Copilot
PROGRAM OUTLINE
- Interactive Lectures: Conceptual understanding of Copilot features.
- Hands-On Labs: Real-time practice with Excel and Copilot.
- Group Activities: Peer collaboration and feedback.
- Scenario-Based Learning: Real-world use cases and challenges.
- Reflection Checkpoints: Reinforce learning through guided sharing.
CONTACT US
Our Experts Are Here to Help