Automating Analysis with Advanced Features of Excel

Summary

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, Professional Training, Unit 22 Westland Square, Pearse Street, Dublin
Start date & time:  
24 October 2019 09:30
End date & time:  
24 October 2019 17:00
Price: €468.75  (€375.00 Member price)
By registering for this course you have accepted the terms and conditions
Training ticket cost:  
12.00
CPD hours:  
7.00
Speaker details
First nameLast name
Damien O'Neill

Description

Product type:  
CPD course
Category:  
Information technology

Who should attend

This course is for accountants 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 CAI CPD 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.