Level - Advanced
This course will introduce and extend VBA programming within Microsoft Excel. Participants will be able to create and manage complicated macros.
2 Days
This course will introduce and extend VBA programming within Microsoft Excel to enable participants to create and manage complicated macros.
Participants should be able to:
Level - Advanced
This course outlines analytic tools of Microsoft Excel which can be very useful for business planning and modelling.
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 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 - 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.