Loading...

Course Description

In this course, you will build spreadsheet-based models that evaluate solutions and decision problems, investigating a number of different methods and built-in tools to optimize decisions and assess tradeoffs. One of the most powerful ways to take an evaluation model to the next level is to build an optimization layer that automates the process of finding the best solution for a given set of input factors. Depending on the scale, scope, and mathematical complexity of the model, you will discover that different kinds of optimization approaches may work better than others.

You will explore some of the most practical ways to layer optimization on top of Excel-based evaluation models. For simpler problems, this involves efficiently listing and examining all the potential solutions; for more complex problems, it entails automating simple heuristics using VBA or by employing Excel's Solver tool. By the end of this course, you will have the skills to confidently use optimization to help improve the decisions you need to make based on your data.

You are required to have completed the following courses or have equivalent experience before taking this course:

  • Making Data Usable
  • Creating Effective Data-Driven Dashboards
  • Developing Robust Models to Evaluate Decisions

Faculty Author

Kathryn Caggiano

Benefits to the Learner

  • Optimize decisions using enumeration
  • Automate simple and sensible heuristics using VBA to execute a guided search process
  • Optimize decisions using built-in tools in Excel

Target Audience

  • Finance professionals
  • Data analysts
  • Data scientists
  • Business analysts
  • Engineers
  • Managers and executives
  • Students who need in-depth Excel knowledge

Applies Towards the Following Certificates

Loading...
Enroll Now - Select a section to enroll in
Type
2 week
Dates
Apr 24, 2024 to May 07, 2024
Total Number of Hours
16.0
Course Fee(s)
Standard Price $1,199.00
Section Notes

IMPORTANT COURSE INFORMATION

  • The courses in this certificate use Microsoft Excel 2016 for Windows. We highly recommend you use this version of Excel so you can easily replicate the tools and functions demonstrated in the course.
Type
2 week
Dates
Jun 19, 2024 to Jul 02, 2024
Total Number of Hours
16.0
Course Fee(s)
Standard Price $1,199.00
Section Notes

IMPORTANT COURSE INFORMATION

  • The courses in this certificate use Microsoft Excel 2016 for Windows. We highly recommend you use this version of Excel so you can easily replicate the tools and functions demonstrated in the course.
Type
2 week
Dates
Aug 14, 2024 to Aug 27, 2024
Total Number of Hours
16.0
Course Fee(s)
Standard Price $1,199.00
Section Notes

IMPORTANT COURSE INFORMATION

  • The courses in this certificate use Microsoft Excel 2016 for Windows. We highly recommend you use this version of Excel so you can easily replicate the tools and functions demonstrated in the course.
Type
2 week
Dates
Oct 09, 2024 to Oct 22, 2024
Total Number of Hours
16.0
Course Fee(s)
Standard Price $1,199.00
Section Notes

IMPORTANT COURSE INFORMATION

  • The courses in this certificate use Microsoft Excel 2016 for Windows. We highly recommend you use this version of Excel so you can easily replicate the tools and functions demonstrated in the course.
Type
2 week
Dates
Dec 04, 2024 to Dec 17, 2024
Total Number of Hours
16.0
Course Fee(s)
Standard Price $1,199.00
Section Notes

IMPORTANT COURSE INFORMATION

  • The courses in this certificate use Microsoft Excel 2016 for Windows. We highly recommend you use this version of Excel so you can easily replicate the tools and functions demonstrated in the course.
Required fields are indicated by .