Get in Touch
 Duration 7 hours

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

Number of participants


Price per participant

Testimonials (3)

Upcoming Courses

Related Categories