Training Course Outlines:

Course content includes:

• Model Tools
• Choosing between Excel and Access
• General Functions
• Financial Functions
• Other Useful Tools
• Modelling Techniques
• Rebuilding an inherited model
• Bullet-proofing your model
• Making a model user-friendly
• Final Model Results
• Scenarios and Sensitivity Analysis
• Presentation of Model Output
• The Fine Print

Training Course Outcomes:

• Build a financial model from scratch, or modify and improve an inherited model
• Mitigate errors by building in error checks
• Prevent incorrect use of your model by protecting worksheets
• Validate data entry by setting data entry parameters
• Create a navigation page to help users find their way around your model
• Create drop-down boxes which enable a model to produce a series of results depending on scenario variable selected
• Mitigate liability by providing assumptions
• Write instructions for use
• Present findings in a concise and meaningful way

Course Accreditations:

Course Prerequisites:

Related Courses:

People Visited:

324 people visited