Excel Tools for Business Modelling Profile
- Course duration
- 1 day
- Course timings
- 9:30-16:30
- Prerequisites
- Delegates should have attended the Intermediate course or gained similar knowledge in the workplace
- Training formats
- Scheduled course · private course · tailored · 1 to 1 (all instructor led)
- Manuals
- A comprehensive course manual provides support throughout the course and upon your return to the office.
- Calendar
- Click here to see the Excel courses calendar
This course will provide you with the best Excel tools for improving your own business modelling skills.
Course Topics
Number Formatting
Conditional number formats · the four parts of a format · creating custom formats ·
formatting dates and times.
Validation and Protection
Setting cell validation · protecting cells & worksheets · using cell comments.
Range Names and Absolute References
Absolute references · fixing only the row or column · creating range names ·
labeling ranges automatically.
Multiple Worksheets
Copying · moving and renaming worksheets · the dangers of group mode ·
summing across worksheets· 3-D range names.
Building Models
Freezing windows · what makes a good formulae · separating inputs and
calculations · mastering the IF function.
Advanced Formatting
Creating and applying styles · grouping and outlining.
Reference Functions
MATCH, INDEX and OFFSET · using the INDIRECT function.
Array Formulae
Creating array formulae · editing and deleting arrays · strengths and weaknesses of
arrays.
