Microsoft Excel 2021 training courses
Instructor-led Microsoft Excel 2021 courses in Dublin, Cork, Limerick and live online.
-
Rolling Forecasts with Excel
This course is designed to equip participants with the concepts and tools from which a model can be prepared which can be changed easily and automatically as business change requirements dictate. Changing external ec...
-
Business Plan Modelling using Excel
Effective business planning is fundamental to success in business. Building the plan model is the first step in transforming ideas into tangible reality. A well-organised plan should tell you if the concepts make soun...
-
Data Analysis - Excel 365 – New Dynamic Functions, Top Pivot Table tips, Macros and more
This packed course tackles new Excel Functions like FILTER UNIQUE, SEQUENCE, SORT and SORTBY showing their effectiveness over traditional Functions. We explore writing Custom Functions (LAMBDA, BYCOL) and use import...
-
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.