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
If you need to quickly and accurately make sense of your company's raw data, this Excel - KPI Dashboards course is for you. It introduces you to KPIs and dashboard design processes and will help you build an interactive KPI Dashboard.
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.
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.
Level - Advanced
This course introduces additional skills to develop your knowledge of Microsoft Excel by focusing on advanced functions and productivity tools.