Courses / Excel Tools for Business Modelling
Excel Tools for Business Modelling
- Provider
- Desktop Training & Development Ltd
- Summary
- This course will provide you with the best Excel tools for improving your own business modelling skills.
About the Course
- Target
- Delegates with a good working knowledge of Microsoft Excel who can produce multi-sheet workbooks and work with a range of Excel functions.
- Entry requirements
- Delegates should have attended the Intermediate course or gained similar knowledge in the workplace
- Outcome
- Content
- 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. - Cost
- Contact Desktop Training for details
- Enrolment
- Telephone, fax or write to Desktop.
- Website
- www.desktoptraining.co.uk
Availability
- Starts
- Please contact provider for further dates
- Duration
- 1 Day
- Timetable
- 9.30am - 4.30pm
- Provider
- Desktop Training & Development Ltd
Venues/Contact
Main (View map)
11 Beta Terrace
Masterlord Office Village
Ransomes Europark
Ipswich, Suffolk
IP3 9FE
UNITED KINGDOM
Telephone 0845 1188150
Email info@desktoptraining.co.uk
Website http://www.desktopcourses.co.uk
Venue Notes 0
Courses
Syndicate
