Seminarkatalog

1-day training

"I use Pivot - but I want to understand what Copilot makes of it."
"I don't want to automate blindly - I want to decide."
"Can Copilot also compare multiple tables - or do I have to do it myself?"

This course is for anyone who is comfortable with Excel - but now wants to analyse, visualise and make decisions more intelligently with Copilot.
You will not learn what Copilot can do - but how to use it in a conscious and controlled way.
This course does not show you what Copilot ‘can do’ - but how you can use it in a targeted way to make faster and more informed decisions.

You will learn:

• how to formulate complex questions with linguistic precision
• how to categorise and refine Copilot results
• how to decide for yourself what should be automated and what should not.

Whether it's a variance analysis, monthly comparison or dashboard:
You stay in control - Copilot provides speed, suggestions and structure.

Topic

Without Copilot

What Copilot Adds

Pivot & Dashboards

Structure, combine, analyze data

Auto-generated top lists, visuals

Scenarios & Goal Seek

Goal Seek, What-If Analysis

Parameter simulations, recommendations

KPI Analysis

Calculate & filter KPIs

Grouping, pattern detection, categorization

Consolidation

Compare and validate tables manually

Merging, differences, overlaps

Final Project

Mini case study from participants’ own work

Prompting, combining, critical evaluation

Prerequisites

• Solid Excel knowledge (e.g. tables, formulas, pivot tables)
• Course language: german

• Team leads, project managers, operations staff
• Professionals with solid Excel skills who want to use Copilot effectively
• Employees in procurement, sales, controlling, or administration
• Users looking to write strong prompts