This course is aimed at both intermediate and experienced staff – it is expected that all participants will have a good grasp of Excel prior to attending this course.
- Workbook set up & use of shortcuts
- Formatting data professionally, inputting base data & Style
- Basics Setting update flexibility using EDATE, EOMONTH
- Breakdown and grouping of accounting elements
- Determine drivers of the model & Assumptions for projections
- Effective use of short-keys and functions
- Applicable financial, logical functions & data transfer and links
- Professional use of Excel –protection, range names, data validation
- Maximum use of Excel applications
- Flexible and user-friendly models & sensitivities
- Model diagnostics Using existing models
- How to become comfortable with ‘new’ models
- Auditing models
- Professional showcase
- Use of graphs
- Using switches
Please Note: Each delegate will leave the course with an action plan for the workplace