Advanced Excel training courses
Instructor-led Advanced Excel courses in Dublin, Cork, Limerick and live online.
-
AI in Excel using ChatGPT and Copilot
The potential opportunities offered by AI are enormous, but how do you apply them to reap their benefits in Microsoft Excel? This course will help to unveil the power of artificial intelligence, exploring key conce...
-
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...
-
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...
-
Supercharge your Excel skills with Python and OpenPyXl
This course is for people who are proficient at Excel and want to add in the power of Python, the world's best programming language for data analytics.
It assumes no experience with programming and will start by demo...
-
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.
-
AI+ Programme for ENTIRE EDIH - AI-Powered Productivity with Excel, Data & Presentations - Day 1
Artificial Intelligence is transforming the way professionals analyse data, build reports and deliver presentations. This practical course shows you how to harness AI to work smarter in Excel and PowerPoint. You’ll st...