Excel Data Analytics with Copilot
2 days
HRD Corp claimable
Runs in-house for your team
Overview
In this programme, Microsoft Copilot in Excel works as an AI analyst. Participants describe what they need in plain language, then direct, check and refine what comes back. It is for business and data analysts, finance, HR, sales, marketing, operations and supply chain staff, and managers who need faster insight. Basic Excel is enough, with no coding or prior Copilot use required. Each participant needs a Microsoft 365 Copilot licence, and some features depend on the licence and Excel version.
Sessions follow one workflow: clean, explore, analyse, visualise and present. Day 1 covers Excel Tables, cleaning messy exports by prompt, XLOOKUP, SUMIFS and nested formulas, the =COPILOT() function, Analyze data, and PivotTables and charts by description. Day 2 moves to conditional formatting, Python in Excel for forecasting and clustering, sentiment analysis of survey comments and Agent Mode for multi-step analysis. Cases include sales trends, HR attrition and budget against actual.
Every participant builds an interactive executive dashboard from their own scenario and presents the findings. They also take home a prompt library and a "Verify Before You Trust" checklist for catching AI errors before results are shared.
Module topics
- Meet your AI analyst
- Data cleaning at speed
- Formulas and the =COPILOT() function
- Quick insights with Analyze data
- PivotTables and charts on demand
- Smart formatting and highlighting
- Python in Excel for forecasting and clustering
- Text and sentiment analytics
- Agent Mode for multi-step analysis
- Executive dashboard, storytelling and capstone
Who runs this programme
At a glance
2 days
In-house at your premises or a venue you choose
HRD Corp claimable
More in this category
Artificial Intelligence (AI) / Microsoft Copilot
1 day
Artificial Intelligence (AI) / Microsoft Copilot
2 days
Artificial Intelligence (AI) / Microsoft Copilot
2 days