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

Shalina Hj Mohd Salleh

Power BI, Excel, Google Workspace and AI tools trainer

At a glance

2 days

In-house at your premises or a venue you choose

HRD Corp claimable