Office 365 training courses
Instructor-led Office 365 courses in Dublin, Cork, Limerick and live online.
-
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 Powe...
-
Data Visualisation with Excel and PowerPoint
This course provides essential knowledge and practical skills to create effective charts and dynamic dashboards for data visualisation. Using Microsoft Excel and PowerPoint, the course enables learners to interpret, a...
-
Building Effective Financial Models 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 ...
-
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 yo...
-
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 a...
-
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.