Workshops: AI Automation & Agents

AI for Excel & Data Analysis: ChatGPT, Claude & Copilot

In this training your staff learn to analyse spreadsheets and data faster and more safely with AI – using Copilot in Excel, ChatGPT and Claude. The focus is on getting correct results and reliably spotting AI calculation errors.

Who is this workshop for?

  • Controlling and finance teams
  • Sales and marketing analysts
  • Procurement, logistics and production planning
  • Professionals who build reports in Excel regularly
  • Managers who want to understand KPIs faster

What you will take away

  • You have AI build and explain complex formulas, XLOOKUP and pivot structures.
  • You clean messy datasets with AI support in a traceable way.
  • You analyse data with code execution in ChatGPT and Claude and verify the calculations.
  • You use Copilot in Excel for summaries, charts and analysis suggestions.
  • You know which data may be uploaded to which tool.

Agenda

  1. Module 1

    AI and numbers: strengths and traps

    • Why language models can miscalculate
    • Code execution as the fix: AI calculates with Python
    • Verification routines for every result
  2. Module 2

    Formulas and macros with AI

    • Generating and understanding formulas from plain language
    • Debugging broken formulas
    • Having AI write simple VBA or Office Scripts
  3. Module 3

    Data cleaning

    • Duplicates, spellings, date formats
    • Assigning categories automatically
    • Exercise: tidy up a messy export
  4. Module 4

    Analysis and visualisation

    • Copilot in Excel: asking questions of your table
    • Data analysis in ChatGPT and Claude with charts
    • Gemini in Google Sheets compared
  5. Module 5

    From result to report

    • Drafting key messages and cross-checking them
    • Standardising recurring reports
    • Data protection: customer, HR and company figures

Why Excel professionals should use AI

Hours each week go into hunting for the right formula, cleaning exports and writing report commentary. This is where AI shines: it turns questions into formulas, suggests analyses and explains results in plain language.

At the same time, few areas are as error-prone as numbers. We therefore consistently train participants to recalculate results and make the AI's working visible.

A typical exercise: a messy sales export with inconsistent customer names is cleaned, analysed by region and turned into a short management commentary. Each step is documented so colleagues can follow it.

Tools at a glance

We use the tools available in your organisation and show the differences.

  • Microsoft 365 Copilot directly in Excel
  • ChatGPT with data analysis and code execution
  • Claude with its analysis tool and file handling
  • Google Gemini in Google Sheets
  • Mistral Le Chat as a European option

Protecting confidential figures

Revenue figures, salary data or customer lists do not belong in personal AI accounts. We show when business plans with contractual safeguards are needed, how to anonymise or aggregate data beforehand and which rules belong in an internal AI policy.

Frequently asked questions

Do we need Microsoft 365 Copilot for the training?

No. Copilot in Excel is one part; most exercises also work with ChatGPT or Claude. We adapt the content to your licences.

What Excel skills are required?

Solid basics are enough. Advanced users benefit most from the formulas, automation and data cleaning modules.

Can we work with our own data?

Yes, with anonymised or approved datasets. On request we provide realistic sample data from your industry.

Workshop

Get in touch

How much time could your team save on monthly reports with AI?

Tell us a little about your team – we will get back to you within 24 hours with a proposal for content, format and dates.

Prefer to talk?

We only use your details to handle this request. See our privacy policy.