Training course · Claude · Data Analysis & Excel

Claude for Data Analysis and Excel

Claude as an AI assistant for knowledge work: projects, Artifacts, long documents, analysis and precise writing for teams.

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

“Claude 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 Claude in the abstract, you work on tasks from your daily routine – with examples, exercises and templates from Data Analysis & Excel.

Anthropic's Claude has become a go-to AI assistant for demanding knowledge work: it handles very long documents, reasons transparently and writes in a measured, easily steerable style. In this practical day you learn to exploit these strengths systematically. You analyse lengthy reports, contracts or policies, compare several sources and extract key findings with references to the exact passages. With Projects you store background knowledge and working instructions permanently, so Claude knows your terminology, templates and quality standards and you no longer start from scratch with every request.

We also show how to use Artifacts to produce standalone deliverables – structured documents, tables, charts or small interactive tools – and share them with your team. You analyse files with the built-in analysis capability, use research and connectors to company data, and put Claude to work as a critical reviewer of your own writing. A dedicated session covers Team and Enterprise plans, access management and data protection. By the end you have tested project set-ups and prompt patterns that you can apply straight away in your own function.

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 write precise, structured instructions that let Claude handle complex tasks reliably.
  • You analyse long and multiple documents and obtain referenced, verifiable summaries.
  • You set up Projects with a knowledge base and style rules and share them with your team.
  • You use Artifacts and the analysis capability to produce usable documents, tables and evaluations.
  • 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 Understanding and directing Claude
  • Model family, strengths and limitations compared with other assistants
  • Clear instructions with context, examples and the desired output format
  • Structured input using sections and tags for complex tasks
  • Extended thinking and step-by-step approaches for demanding questions
Module 2 Analysing long documents
  • Uploading and querying large PDFs, reports and contract sets
  • Comparing multiple documents and surfacing contradictions
  • Summaries with references to specific passages
  • Deriving checklists and review grids from policies and guidelines
Module 3 Projects and knowledge base
  • Creating Projects with knowledge documents and persistent instructions
  • Storing style and terminology rules for consistent results
  • Sharing Projects with the team and developing them together
  • Making good use of connectors to drives and business applications
Module 4 Artifacts, analysis and writing
  • Creating Artifacts for documents, tables, charts and interactive tools
  • Analysing files and spreadsheets with the built-in analysis capability
  • Drafting, shortening, rewording and tailoring text to audiences
  • Using Claude as a critical reviewer of arguments and gaps
Module 5 Team use, data protection and quality
  • Team and Enterprise plans: administration, roles and sharing
  • Handling confidential and personal data in line with GDPR
  • Checking output: verifying facts, figures and quotations
  • Defining internal guidelines and reusable prompt patterns
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

Confident use of office applications and a web browser; prior AI experience is helpful but not required. Your own non-confidential documents are welcome as practice material. Confident everyday use of Excel; no programming skills required.

Technical requirements

A laptop with an up-to-date browser or the Claude desktop app and a Claude account; we recommend Pro, Team or Enterprise access for Projects and larger files.

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.

  • Thu, 26 November 2026 Online Request
  • Tue, 8 December 2026 Berlin Request
  • Fri, 18 December 2026 Online Request
  • Wed, 13 January 2027 Stuttgart Request
  • Thu, 28 January 2027 Online Request
  • Fri, 5 February 2027 Hanover Request

Frequently asked questions

How does Claude differ from ChatGPT in everyday work?

Both are capable general-purpose assistants. Claude particularly stands out with very long documents, careful reasoning and an easily steerable writing style, while Projects and Artifacts support structured work. Which tool fits better depends on your tasks, integrations and company policies – the course gives you criteria for an informed assessment.

What are Artifacts and why would I use them?

Artifacts are standalone deliverables that Claude creates in a separate panel next to the chat – a document, a table, a chart or a small interactive tool, for example. They can be revised in a targeted way, downloaded and shared. A conversation therefore produces ready-to-use results rather than scattered fragments of text.

Is my data used to train Claude?

On Team and Enterprise plans, business content is not used for model training as a matter of principle. For individual accounts this depends on settings you should review yourself. Regardless of the plan, GDPR and internal confidentiality rules apply. In the course we walk through the relevant settings and the questions to ask.

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 “Claude 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 Claude courses

All 45 Claude courses

Claude · MunichClaude · SalzburgClaude · BerlinClaude · AugsburgClaude · HanoverClaude · BremenClaude · StuttgartClaude · KaiserslauternClaude · Online