MS Excel training courses
Instructor-led MS Excel 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...
-
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...
-
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 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 ...
-
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.