| Name | Description |
| Microsoft Office Excel Intermediate |
This Microsoft Excel course focuses on the need to produce real time reports using Charts and Pivot Tables and introduces new functions and data tools to help participants be more productive. Areas covered include If Statements, VLookup, data analysis functions, sorting and filtering data in tables, data validation and cleaning data . This is our most popular Microsoft Excel course and is a very comprehensive day for Excel users to really get to grips with the key functions they need. |
| Microsoft Office Excel Advanced |
This Microsoft Excel advanced course will extend your knowledge into some of the more specialized and advanced capabilities of Excel by using the data analysis and business intelligence features. You will learn how to use the newer functions and features including PivotTables and Power Pivots for analysis of large data sets. Using Get and Transform functions are always popular sections on the course, as well as a first look at creating Macros using the powerful point and click features available in Microsoft Excel. |
| 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. |