Word, Excel, PowerPoint, Outlook and Access: indispensable in almost every workplace. Our Microsoft Office courses bring you to whatever level you need, from basics to expert, and are always practical and immediately applicable. You will work faster, more neatly and with more enjoyment.
In this Excel course you will learn to work with formulas, functions, charts and formatting. You will create clear spreadsheets yourself and apply your knowledge directly in practice. Optionally, you can also give attention to Excel with Copilot.
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.
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.
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.
In this Access course you work with databases in a targeted way. You learn to design tables, retrieve data using filters and queries, build data entry forms and create clear reports. You also gain insight into the structure and terminology of databases in general.
In this two-day course you learn to work with VBA in Access. You automate tasks via the VBA editor, get to know the object model and work with variables, loops, Docmd objects and ADO. Debugging and error handling are also covered.
Have you already worked with Access and would you like to get more out of it? In the Access Advanced course you take a deeper look at building and managing databases. You learn to work with relationships between tables, more complex queries, advanced forms and reports. You also automate recurring tasks with macros and get to know VBA. In addition, you discover how to exchange data with Excel, Word, Outlook and an SQL server. Afterwards you will be able to design powerful databases that really work for you.
Do you want to keep your Excel lists clean and get more out of your data? In this course you will learn how to prevent input errors using data validation and how to apply advanced functions and formulas. You will work with text formulas, lookup and reference formulas, statistical and mathematical formulas and array functions. By the end, you will be able to make your Excel files more consistent and carry out more complex operations without endless intermediate steps. A practical course for experienced Excel users who really want to take the next step.
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 this one-day training course you learn how to use Microsoft 365 Copilot in Excel. You work faster with formulas, pivot tables, charts and data analysis. You practise with realistic examples and your own work file, and discover where Copilot does and does not help.
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.
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.