Excel 2021 training courses
Instructor-led Excel 2021 courses in Dublin, Cork, Limerick and live online.
-
Microsoft Excel 365 Intermediate
This Excel Intermediate course is designed to extend participants’ knowledge and proficiency in MS Excel by focusing on a wide range of key functions, tools and analytical techniques. The course aims to enhance learne...
-
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...
-
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...
-
Data Analysis - Excel 365 – Power Query, Power Pivot, Dashboard Production and beyond
Excel 365 has heralded an explosion in the tools available for reporting and analysis in accounting. This course will introduce two of the most powerful Excel tools - Power Query and Power Pivot and then use those t...
-
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.