Training

Excel VBA, Power Query & AI for Excel Training

Practical training for individuals, analysts and business teams who want to automate Excel, improve reporting and use AI tools safely in real spreadsheet work.

Discuss training requirements

Training built around real business Excel work

We do not teach theory in isolation. Our training is focused on the spreadsheets, reporting problems, automation tasks and data-cleaning challenges that people face at work every day.

Excel VBA Training

Learn how to record, write, debug and improve macros, build custom functions, automate reports and support existing VBA workbooks.

Power Query Training

Learn repeatable data imports, cleansing, merging, transformation and reporting workflows using Power Query and M code.

AI for Excel Training

Learn how to use ChatGPT, Claude, Copilot and other AI tools to improve Excel productivity, VBA development and reporting.

AI for Excel Training

We provide practical training on how to use modern AI tools to improve Excel productivity, VBA development, Power Query solutions and business reporting.

The focus is on safe, useful adoption: where AI can help, where it needs expert checking, and how teams can avoid relying blindly on generated formulas or code.

  • AI-assisted Excel formulas and workbook analysis
  • AI-supported VBA development and debugging
  • AI-assisted Power Query and M code development
  • AI for documentation, user guides and training notes
  • Spreadsheet auditing, validation and governance
AI and Excel training illustration showing spreadsheet automation and analysis

AI tools covered in training

ChatGPT for Excel & VBA

Generate VBA code, create custom Excel functions, build formulas from plain English, generate SQL queries, produce documentation and troubleshoot workbook issues.

Claude for Excel Development

Review large VBA projects, refactor legacy VBA code, analyse complex workbooks, improve Power Query solutions and understand spreadsheet logic.

Microsoft Copilot for Excel

Create formulas using natural language, generate PivotTables and charts, analyse workbook data, identify trends and improve Microsoft 365 productivity.

GPTExcel, Numerous.ai & Elyx AI

Explore specialist tools for formulas, VBA, spreadsheet functions, Excel-specific automation and faster spreadsheet assistance.

Powerdrill, Anomaly AI & Julius AI

Use AI-assisted analysis for spreadsheet datasets, business reporting, data exploration and visualisation.

AI-Powered Excel Automation

Combine AI with Excel VBA, Power Query and reporting automation while keeping testing, governance and maintainability under control.

Training formats

  • One-to-one coaching
  • Remote team training
  • Corporate workshops
  • Workbook-specific mentoring
  • Follow-up support and documentation

Enquire about training