Digital SkillsProductivityAIEM 100% HRDF claimable

Microsoft Excel: AI-Powered Excel Mastery

Equip yourself with essential Excel skills enhanced by AI tools. Learn Excel functions, clean and analyse data, build PivotTables, create visualisations, and responsibly apply AI tools like ChatGPT, Copilot, or Gemini to assist with formulas, interpretation, and automation.

2 DaysPEOPLElogy

What you'll learn

Apply essential Excel functions and formulas for data analysis
Use AI tools to understand, write, and debug Excel formulas
Clean and prepare data using Excel features and AI assistance
Analyse data using PivotTables and interactive filters
Automate Excel tasks using basic macros and AI guidance

Course modules (8)

01Excel data analytics & AI fundamentals

02Functions and formulas (SUMIFS, VLOOKUP, INDEX/MATCH)

03Using AI to write, explain, and debug Excel formulas

04Data cleaning and preparation with AI assistance

05Structuring data for analysis

06PivotTables and interactive filters

07Visualization with AI-supported chart suggestions

08Automation with macros and AI guidance