Learning Objectives

After completing this course, the participants will be able to:

• Build different dashboards from scratch
• Modify and improve an inherited model
• Select the most appropriate formula to achieve the desired outcome
• Identify common errors in data analysis models
• Mitigate errors by building in error checks
• Prevent incorrect use of their model by protecting worksheets
• Validate data entry by setting data entry parameters
• Create a navigation page to help users find their way around their model
• Develop drop-down boxes which enable a model to produce a series of results depending on the selected scenario variable
• Gain an in-depth understanding of how to build a business case
• Communicate the results of their model clearly and concisely
• Make use of Excel and implement best practices, efficient formula construction, and appropriate driver selections
• Use Advanced Excel functions to present various sensitivities to projected metrics
• Fix circularity problems, iteration, and other common modeling troubleshooting