Automating Analysis with Advanced Features of Excel


This course is intended for experienced Excel users seeking to advance their skills and find short-cuts and tips to get more from Excel. It will introduce participants to Excel's automated techniques in both forecasting and historical analysis.

Venue details:  
, , Dublin
Start date & time:  
08 October 2020 09:30
End date & time:  
08 October 2020 17:00
By registering for this course you have accepted the terms and conditions
Training ticket cost:  
CPD hours:  
Speaker details
First nameLast name
Damian O'Neill


Product type:  
CPD course
Technology and data

Who should attend

This course is for accountants, and other business professionals, with existing advanced Excel skills. It is not appropriate for anyone new to Excel, or who is not using Excel regularly, at a level comparable to the Institute's Intermediate or Advanced Excel courses.

Course overview

  • Macros - useful macros will be presented especially covering more tedious areas such as printing, graphing, filling etc.
  • Functions - A number of powerful Excel functions useful for analytical purposes will be introduced such as SUMPRODUCT, D functions, financial functions and information functions (CELL, ISERROR, TRIM etc.)
  • Time based functions
  • Toolbars and Custom toolbars
  • Graphs
  • Forecasting model
  • Data Consolidation techniques
  • Pivot Tables - Practical examples
  • Range names - advanced uses

Key learning outcomes

By the end of this course, participants will be able to:

  • Utilise Excel skills to maximise output versus time input
  • Demonstrate the power of Excel without recourse to programming in VBA i.e. using the present tools in Excel