Training course · Generative AI · Data Analysis & Excel

Generative AI for Data Analysis and Excel

Vendor-neutral, hands-on day: how language models work, where they go wrong and how to roll out AI successfully in your team.

Duration
1 day (7 hrs)
Format
Online or on-site
Language
German or English
Participants
open dates or exclusive for your team
Certificate
Certificate of attendance

Overview

“Generative AI for Data Analysis and Excel” is a hands-on course for roles such as Business users who work regularly with Excel and reports, Controllers and finance staff and Sales and marketing analysts. Rather than learning Generative AI in the abstract, you work on tasks from your daily routine – with examples, exercises and templates from Data Analysis & Excel.

Generative AI has reached most organisations, yet teams often lack a shared understanding of what language models can actually do and where their limits lie. In this vendor-neutral course you will learn how large language models generate text, why they hallucinate and how careful prompting, context and source checking lead to reliable results. Rather than relying on any provider's marketing claims, you will work with transparent criteria that help you compare tools and judge their fit for your own tasks.

The second focus is everyday implementation. You will identify concrete use cases in your area of work, weigh benefit, risk and effort, and draft a realistic roll-out plan for your team. This covers ground rules for handling confidential data, a practical prompt library and ways to build acceptance and make results measurable. Throughout the day you work with examples from your own field, so you leave with an actionable roadmap rather than a set of abstract ideas.

In almost every department, decisions are made on the basis of spreadsheets, exports and reports – and much working time goes into cleaning, combining and analysing that data. Generative AI dramatically lowers the barrier to sophisticated analysis. It explains and writes Excel formulas, builds Power Query steps and macros, suggests pivot analyses and charts, generates Python or SQL code for larger datasets and drafts commentary on KPIs. AI agents can prepare recurring reports automatically. This empowers business users to answer questions themselves that once meant waiting for IT or an analytics team. What remains essential is checking results rigorously and keeping an eye on data quality.

The course is delivered live – either online in a virtual classroom or on-site in our training rooms in Munich, Salzburg, Berlin, Augsburg, Hanover, Bremen, Stuttgart and Kaiserslautern. We can also run it exclusively for your team.

Who is this course for?

  • Business users who work regularly with Excel and reports
  • Controllers and finance staff
  • Sales and marketing analysts
  • Business analysts and reporting teams
  • Team leads responsible for KPIs

Typical challenges we address

  • Time-consuming manual data cleaning and copy-and-paste processes
  • Complex formulas and macros that only a few people understand
  • Data from different systems in inconsistent formats
  • Error-prone spreadsheets without traceable calculation logic

What you will be able to do

  • You can explain clearly how language models generate text and why hallucinations occur.
  • You can write prompts that consistently deliver useful, verifiable results.
  • You can compare AI tools against transparent criteria covering data protection, features and cost.
  • You can identify and prioritise concrete use cases for your area of work.
  • Create and understand complex Excel formulas, Power Query steps and macros with AI.
  • Clean, analyse and visualise data faster and more transparently with AI support.
  • Automate recurring reports and check AI results methodically for accuracy.

Course outline

Module 1 How large language models work
  • Tokens, context windows and probabilities: what happens when a model generates text
  • Training knowledge versus web search versus your own documents (RAG)
  • Text, images, audio and code: what multimodal models can do today
  • Realistically assessing typical strengths and weaknesses in office work
Module 2 Spotting hallucinations and getting reliable output
  • Why models produce plausible-sounding errors and when the risk increases
  • Prompting techniques: role, context, examples, output format and step-by-step instructions
  • Requesting sources, cross-checking facts and introducing a four-eyes principle
  • Scoping tasks so that AI assists rather than decides
Module 3 Choosing tools without vendor bias
  • Overview of chat assistants, AI built into office suites and specialist tools
  • Criteria: data processing, hosting location, admin features, integrations and pricing model
  • Enterprise licences, API access and locally hosted open-source models compared
  • Building a simple scoring matrix for your own tool selection
Module 4 Identifying use cases in your field
  • Systematically capturing recurring writing, research and analysis tasks
  • Rating benefit, risk and implementation effort for each use case
  • Distinguishing quick wins from strategic initiatives
  • Creating a prioritised use-case backlog for your team
Module 5 Rolling out generative AI in your team
  • Usage rules: which data may go into which tool and who signs off results
  • Building and maintaining a shared prompt library and templates
  • AI champions, training formats and peer exchanges to embed new habits
  • Measuring success: documenting time saved, quality and user satisfaction
Module 6 Practice lab: Data Analysis & Excel
  • Writing and explaining formulas
  • Cleaning and combining data
  • Analyses and charts
  • Python and SQL for large datasets
  • Commenting on KPIs
  • Automating reports
Module 7 Data protection, quality & transfer to daily work
  • Spreadsheets often contain personal data about customers or employees as well as confidential business figures, which may only be processed in approved AI environments and ideally anonymised or aggregated. Analyses relating to employees may be subject to works council rights, and responsibility for the accuracy of reports remains with the business unit.
  • Ground rules for safe AI use in your team
  • Checking results: facts, sources, tests and the four-eyes principle
  • Personal action plan for the next 30 days
  • Open questions, outlook and resources for further learning

Practical scenarios from your field

Writing and explaining formulas

AI creates formulas such as XLOOKUP, SUMIFS or dynamic arrays from a plain-language description and explains existing nested formulas step by step. Common pitfalls are pointed out as well.

Cleaning and combining data

For inconsistent exports, AI suggests cleaning steps, builds Power Query queries or scripts for merging, de-duplicating and normalising, and documents the transformations. The steps can be repeated with one click next time.

Analyses and charts

From a business question, AI derives suitable pivot tables, metrics and chart types and helps present results clearly and accurately. Misleading displays such as truncated axes are avoided.

Python and SQL for large datasets

When Excel reaches its limits, AI generates Python or SQL code for analysing larger datasets, which business users run, understand and adapt step by step.

Commenting on KPIs

Variances, trends and anomalies in reports are translated into clear written commentary for management and departments; hypotheses about causes are checked by experts. Reports become self-explanatory in meetings.

Automating reports

Recurring monthly or weekly reports are automated with macros, scripts or AI agents so that data is retrieved, prepared and distributed as a report. Manual steps and transfer errors largely disappear.

Prerequisites

No technical background is required. It helps to bring along typical tasks from your day-to-day work that you would like to support with AI. Confident everyday use of Excel; no programming skills required.

Technical requirements

You will need a laptop with an up-to-date browser and internet access. A free account with a common AI assistant is sufficient; company licences are welcome.

Data protection & compliance

Spreadsheets often contain personal data about customers or employees as well as confidential business figures, which may only be processed in approved AI environments and ideally anonymised or aggregated. Analyses relating to employees may be subject to works council rights, and responsibility for the accuracy of reports remains with the business unit.

Suggested dates

All dates are suggestions – your preferred date is always possible.

  • Wed, 25 November 2026 Online Request
  • Tue, 8 December 2026 Stuttgart Request
  • Thu, 21 January 2027 Berlin Request
  • Thu, 4 February 2027 Online Request
  • Wed, 10 February 2027 Munich Request
  • Mon, 15 February 2027 Online Request

Frequently asked questions

Is the course tied to a specific AI tool?

No. The training is deliberately vendor-neutral. You work with widely used chat assistants and learn principles that apply to all major language models. That way you can transfer your skills to whichever tool your organisation has approved and evaluate new offerings yourself using clear criteria instead of relying on marketing statements.

How is confidential company data handled during the course?

For the exercises you use anonymised or fictitious examples from your area of work. At the same time you learn which categories of data may be entered into which tools, what to look for regarding data processing agreements and use of inputs for training, and how to set out these rules clearly for your team.

Will we leave with something concrete to implement?

Yes. You leave with a prioritised use-case backlog, a scoring matrix for tool selection, tested prompt templates and a draft set of team usage rules. These materials are designed so you can take them straight into internal discussions with management, IT and your data protection officer.

Do I need programming skills for data analysis with AI?

No. Good Excel skills are enough to start. AI generates formulas, Power Query steps and, where needed, Python code that you learn to follow step by step. What matters is being able to sanity-check results. The course focuses on exactly these checking techniques alongside hands-on practice.

How reliable are AI-generated formulas and analyses?

Often very good, but not flawless: references, edge cases or wrong assumptions about the data structure lead to silent errors. That is why you verify results with spot checks, control totals and cross-calculations. The course teaches a simple checking routine to apply to every AI-assisted analysis.

How much does “Generative AI for Data Analysis and Excel” cost?

The course costs a flat €949 plus VAT per participant – whether online or on-site. This includes 1 training day(s) with a live trainer, course materials, a lab environment and a certificate of attendance.

Can I suggest my own date?

Yes. Our suggested dates are just a guide. In the request form you can always describe your preferred date or period in free text – we check availability and confirm within one working day.

Is the course online or on-site?

Both are possible: live online in a virtual classroom or on-site in Munich, Salzburg, Berlin, Augsburg, Hanover, Bremen, Stuttgart or Kaiserslautern. We can also run the course exclusively for your team.

More courses for Data Analysis and Excel

More Generative AI courses

All 45 Generative AI courses

Generative AI · MunichGenerative AI · SalzburgGenerative AI · BerlinGenerative AI · AugsburgGenerative AI · HanoverGenerative AI · BremenGenerative AI · StuttgartGenerative AI · KaiserslauternGenerative AI · Online