Switch to the Dutch version/Switch to the English version
Specialised trainers
High rating
Flexible range
Spreadsheet with colourful data tables and charts on a computer screen, focused on project management.
Multiple dates
1 day

Excel Pivot Tables, formulas and functions

In this course you delve into advanced formulas, functions and pivot tables in Excel. You learn to set up and filter databases and to present data clearly using pivot tables and pivot charts. Optionally, you can also look at Excel with Copilot.


Startgarantie:
Multiple dates available

Show me
Man working on an Excel spreadsheet on a computer, with table data and the software interface visible on screen.
Multiple dates
2 days

Excel Expert

In this Excel Expert course you delve into advanced functions, pivot tables, macros and what-if analyses. You learn to structure, analyse and present complex data. Optionally, attention is paid to working with Copilot in Excel.


Startgarantie:
Multiple dates available

Show me
Tablet with spreadsheets on the screen and papers with table overviews on a desk.
Multiple dates
2 days

Excel Intermediate

In this course you will work with advanced Excel functions such as pivot tables, subtotals, nested formulas and macros. You will learn to present complex data clearly and to automate repetitive work. Optionally, attention is also given to Excel with Copilot.


Startgarantie:
Multiple dates available

Show me
Spreadsheet with coloured cells and numbers listed one below the other, with a few crosses in one column.
In-company
3 days

Automating Excel with Python

Do you want to use Excel more intelligently and more quickly? With Python you can automate recurring tasks in spreadsheets. You edit data, create formulas, generate charts and adjust formatting. In this course you learn to work with Python and modules such as pandas and openpyxl. You start with the basics of Python and build up step by step towards practical applications in Excel. By the end you can independently write scripts that take work in Excel off your hands. No prior programming knowledge required.

In-company

Show me
Screen with a spreadsheet, showing a pie chart, bar charts and finances in dollars.
In-company
1 day

Excel Macros and working with other programs

In this course you will learn to record, edit and understand macros in order to automate tasks in Excel. You will create links with Word, Access and PowerPoint. Optionally, you can also look at Excel with Copilot.

In-company

Show me
Glasses and pen on papers with tables and charts, probably financial or planning documents.
Multiple dates
1 day

Excel PowerPivot

In this course you will learn to work with Excel PowerPivot. You will link external data sources, build a data model and analyse data using DAX formulas in clear pivot tables. Optionally, you can also cover Excel with Copilot.


Startgarantie:
Multiple dates available

Show me
Laptop with spreadsheets and charts on screen, next to coffee, a smartphone and plants on a desk.
In-company
2 days

Excel VBA

In this Excel VBA course you learn to automate common tasks with VBA code. You work with the VBA editor, create procedures, variables and your own functions, and program Userforms. Optionally, you can spend time on Excel with Copilot.

In-company

Show me

Reviews

What others say about our courses.

“Good course, delivered by a professional organisation and highly applicable in practice.”

R. Velthuis, Heupink & Bloemen Tabak B.V. - Excel 2010
Rating 8.8
“LearnIt is the right place to follow a course. Everything is arranged down to the last detail, all kinds of questions can be raised and there is always a suitable answer. A great experience!”

W. van den Heuvel, Van Luyt taxateurs.nl - Word and Excel 2013
Rating 9.4
"K. Algra, Gemeente Nijmegen - "An excellent course with good materials and plenty of exercises that tie in with everyday practice." - Rating: 7.0"

Excel Macros and working with other programs
“The training course is focused, well structured and easy to follow and complete at your own pace within the time provided.”

J. Mols, Meulenhoff Boekerij - Excel Macro's en samenwerken met andere programma's
Rating 8.7
"Immediately applicable in practice, saves a huge amount of time and prevents new frustrations."

Excel Intermediate
“I can recommend Learnit to anyone. All participants work through the exercises independently at their own level. On top of that, an expert trainer gives clear explanations, both individually and to the group. It is handy that you get to keep the workbook for reference.”

Hilda de Vries, Gemeente Zeewolde - Excel 2003 Basis
Rating 9.7

Why choose training at Learnit?

Specialised trainers

High rating

Flexible range

Find out more about Learnit