KTBnet

Trainings

Mastering Excel: Basic and Intermediate

A two-day workshop that takes a team from Excel fundamentals to independent data analysis with pivot tables — enriched with hands-on Copilot work.

Ask for details

Who it's for

Who this training is for

Working with data

Teams working with data every day

  • Data analysis specialists building summaries and reports regularly.
  • Anyone for whom Excel is their main working tool for analysing and presenting data.
  • Anyone who wants to use AI deliberately and put Copilot to work as real support in the workbook.
Management and onboarding

IT managers and people being onboarded

  • IT managers overseeing the team's tools and raising Excel skills across it.
  • Anyone who is just getting up to speed with Excel or brushing up on the fundamentals.

Good to know

Format and logistics

Group size

Up to 20 people.

Prerequisites

A laptop running Windows 11 with Microsoft Excel installed.

Format

A workshop with a lecture component — working through real-world cases together, with active participation expected.

Duration

2 days, 9:00 AM–5:00 PM.

Course scope

What your team will learn

The workshop takes the team step by step — from working efficiently in a sheet, through clean and reliable data, to independent analysis with pivot tables.

After two days, participants work faster and with more confidence, also using Copilot as real support in their everyday tasks.

The course covers

  • Interface and AI in Excel — the ribbon, Backstage, keyboard shortcuts, and Copilot as everyday support.
  • Structure and data entry — laying out data correctly, editing different data types, custom series and lists.
  • Clean, reliable data — cleaning data, eliminating errors, filtering and sorting.
  • Formulas and functions — built-in functions, nesting them, and how references work.
  • Conditional formatting — fast data analysis using conditional formatting rules.
  • Pivot tables — independent data analysis, from a first summary to reports of your own.

Plan this training for your team

We'll match the date, group size, and skill level to your needs — get in touch and we'll work out the details.

Ask for details