Office 365 Training Courses
Name | Description |
---|---|
Microsoft Excel 365 Advanced - Key Features & Business Intelligence | This MS Excel Advanced course explores some specialized capabilities of Excel using the data analysis and business intelligence features. Participants will use key functions and features including PivotTables and Power Pivots for analysis of large data sets as well as creating user defined functions, automating data imports, building table relationship and using Power Pivot advanced Data Analysis and expanding Excel's capability using Python. |
Microsoft Excel 365 Foundation | This course aims to provide a foundation for Excel knowledge and skills, which you can build upon to eventually become an expert in data manipulation. |
Data Visualisation with Excel and PowerPoint | This course is designed for people who present technical or financial information using a combination of MS Excel and MS PowerPoint. It will cover a wide range of tools and techniques such as quick features in Excel, charts, conditional formatting, pivot table/charts and dashboards. It will challenge the way we present information and seek to create new insights into how we can get our audience to understand and interpret information more effectively. |
Introduction to Financial Modelling and Analysis with Excel | The aim of the course is to provide a general introduction to spreadsheet modelling and related analysis.
The central part of the course focuses on the creation of a model from scratch. This will entail the use of relevant Excel tools (Lookups, macros, range names etc.) and the use of this model for various outputs, production of summary reports, KPIs etc. It will also involve comparison with history requiring the extensive use of advanced functions in Pivot tables and other relevant techniques. |
LAMBDA - Using the Ultimate Excel Function | Office 365 subscribers have access to LAMBDA, which Microsoft calls "The Ultimate Worksheet Function". Using LAMBDA, you can create your own user defined functions without needing to work with VBA. LAMBDA allows you to greatly simplify complex formulas by breaking them into small and simple user defined functions (Lambdas). Simplifying complex formulas will make your spreadsheets more understandable, maintainable, secure and with less potential for errors. Lambdas and the associated Lambda Helper Functions along with Dynamic Arrays and the LET function will radically improve the way complex spreadsheets are written. Understanding these innovations is vital for any Excel Power User. AI Assistants like ChatGPT and Copilot are aware of these functions and can be utilised to create user-defined functions using LAMBDA and simplify existing formulas using LET. |
Programming in VBA - Using Microsoft Excel | The skills and knowledge acquired in this course are sufficient to be able to create real life working VBA applications within Excel. The learner will be able to work with VBA within the Excel environment to program and automate worksheet operations. Users of Excel up to Office 365 can be facilitated. |
Excel Macros from A to Z using VBA | This course refreshes the skills of Advanced users of Excel on the basics of Macros, then builds on the knowledge of participants to enable them to create, vet and edit Macros effectively and accurately using VBA. |