Course Outline
Module 1: Faster and more efficient work with Excel
The first module lays the foundation of skills that will accelerate daily work. Participants will learn keyboard shortcuts and navigation techniques that break the barrier of unnecessary actions and speed up work from the very first minutes.
Topics
-
Basic keyboard shortcuts
-
Faster navigation in the worksheet
-
Efficient selection and editing of data
-
Practical tips for daily work
-
Techniques for saving time
Practical exercises
A series of exercises for building speed in executing frequently encountered tasks.
Business Value
A small improvement in daily work leads to significant saving of time before the end of the workday.
Module 2: Professional formatting of tables
Well-structured tables are easier to read, carry less risk of errors, and facilitate the sharing of information between teams.
Topics
-
Format as Table
-
Table styles
-
Sorting and filtering
-
Conditional Formatting
-
Good practices in report design
Practical exercises
Transforming an unstructured table into a professional business report.
Business Value
Better visual presentation of data eases decision-making and improves communication between colleagues.
Module 3: Key business functions in Excel
This module builds confidence in using the functions that are most frequently used in daily work.
Instead of memorizing formulas, participants will understand when and why each function is most suitable.
Topics
-
VLOOKUP
-
XLOOKUP
-
IF
-
IFERROR
-
SUMIF
-
SUMIFS
-
Combining functions
Practical exercises
Solving real business tasks with client lists, budgets, reports, and operational data.
Business Value
Less manual work, fewer errors and faster processing of information.
Module 4: Pivot Tables – Transforming data into useful information
Pivot Tables are one of the most powerful tools in Excel for analysing large volumes of information.
Participants will learn not only how to create Pivot Tables, but also to confidently adjust, filter and use them to create management reports.
Topics
-
Creating Pivot Tables
-
Adjusting data
-
Grouping information
-
Filters and Slicers
-
Calculations in Pivot Tables
-
Creating summary reports
Practical exercises
Creating Pivot Tables from real business data and extracting practical insights.
Business Value
Instead of manually aggregating data, employees will be able to create ready management reports in just a few minutes.
Module 5: Microsoft Copilot for Excel – The next step in productivity
The final module shows how Microsoft Copilot complements modern Excel skills.
The goal is not to replace participants' knowledge, but to demonstrate how artificial intelligence can accelerate data analysis, formula creation and report preparation.
Topics
-
How Copilot for Excel works
-
How to ask effective questions to Copilot
-
Generating and explaining formulas
-
Data analysis in natural language
-
Automatic detection of trends
-
Creating charts with AI assistance
-
Summarizing spreadsheet contents
-
Checking and validating AI results
Practical demonstrations
-
Generating a formula with Copilot
-
Data analysis in natural language
-
Creating a summary of results
-
Automatically generating visualizations
Business Value
Participants will gain first-hand experience with AI tools in Excel and understand how they can save even more time in their daily work.
Working practice
Before the end of the day, participants are encouraged to ask questions and discuss real situations from their own work.
Depending on the situation, the instructor may use these examples during the exercises, which transforms the training into an individually focused working session, rather than just a standard course.
This kind of training approach guarantees that the knowledge gained can be applied immediately after connecting to the training.
Requirements
Prerequisites
-
Basic knowledge of Microsoft Excel.
-
Experience in working with spreadsheets.
-
Microsoft 365 Excel (demonstrate Copilot and check the Microsoft Copilot license, where available).
Target Audience
The course is suitable for employees who work with Excel daily and want to improve their productivity in data processing and analysis.
It is suitable for:
-
Project coordinators
-
Administrative specialists
-
Financial specialists
-
Operations teams
-
Business management
-
Anyone who uses Excel as an everyday working tool
Testimonials (3)
Everything is possible :-)
Sandra Bardewyck - Media Carrier Solutions GmbH
Course - Microsoft 365 Copilot: AI Productivity Across Word, Excel, PowerPoint, Outlook, and Teams
i already have some reports that i know, i will use some of the prompts that looked at today
Kelly Cotham
Course - Copilot for Finance and Accounting Professionals
Learning and creating of agents.