Level - Intermediate
This course focuses on expanding your knowledge of Microsoft Excel’s functions and understanding how to write well-structured formulas.
1 Day
The Excel - Formulas and Functions course will help you to create well-structured formulas using relative and absolute referencing and named ranges. It will help you to understand and use various functions in formulas, including the Insert Function feature.
Participants should be able to:
Level - Advanced
This course concentrates on creating PivotTables and PivotCharts to present business data for analysis. It also focuses on how best to manage the underpinning business data using List Management techniques.
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
Explore key project management terminology and Microsoft Project's main features, including how to set up a schedule and resource pool, assign resources to tasks and how to track projects.
Level - Advanced
This course builds on the Power BI Desktop - Level 1 course. It introduces you to more advanced DAX (Data Analysis Expressions) concepts including variable and advanced functions.