Level - Advanced
This course introduces Power Query to discover, connect to and import data into Microsoft Excel. It also focuses on using PowerPivot to remodel and enhance the imported data by writing queries through Power Query M language.
Half-day
The Excel - Power Query course will enable you to understand how to connect to a variety of data sources and extract data, group and summarise data and transpose and unpivot complex data. After completion of this course you will be able to understand basic Power Query formulas and the M language.
Participants should be able to:
Level - Advanced
This course concentrates on Excel’s advanced functions that will allow you to work more efficiently with business data.
Level - Advanced
This course is all about time-savers in Microsoft Word. It shows how to automate standard documents and how to create your own shortcuts for frequently used tasks which you then can add to your toolbar or ribbon. This course is for you, if you are a confident Word user.
Level - Fundamental
In this course you will learn how to add data, edit and move data and how to format and print spreadsheets. You will create charts and use formulas and functions for simple calculations.
Level - Fundamental
Using Microsoft Word efficiently will help you create good looking documents quickly. This course develops essential Word skills needed to create, edit, format and print documents.