When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.
Finance Optimization with Excel Solver
Master complex optimization problems to maximize business profit and corporate return
This Course Includes
udemy
4.6 (135 reviews )
2h 2m 
english
Online - Self Paced
professional certificate
Udemy
About Finance Optimization with Excel Solver
This course brings together the worlds of computational math and finance to develop
next-level proficiency in financial business planning and decision making optimization
- all within Excel. Mathematical optimization (rather than process or engineering optimization) allows us to maximize profit under nearly any type of constraint such as budget, capital availability, production capacity, materials availability, and scheduling times. In this course, you will not only learn how optimization is applied in finance and how to
use and master optimization solvers
, but also how to
lay out a well-structured financial model
in any scenario. In each of the
hands-on practice sessions
, we spend time covering all the financial concepts used as well as laying out the right quantitative model fit. These practice examples cover capital allocation across
investments, working cash management, manufacturing input scheduling, and inventory order management
. The course comes with
7 great downloadable resources
, including
6 Excel financial models
as well as a helpful
Solver debugging PDF
. You'll use these resources while working through the examples in the course but can also
re-use and modify them for your own optimization needs.
Once you have completed this course, you will be able to manage and model any of these domains with
skill and insight
, and maximize profit or minimize cost accordingly.
What You Will Learn?
- Understand optimization problems and how they relate to financial planning and decision making .
- Use Excel Solver to define optimization and solve optimization problems .
- Learn how to maximize profit or minimize costs under constrained conditions .
- Solve hands-on problems in working capital management, capital budgeting, inventory management and product manufacturing mix optimization .
- Frameworks and financial model templates for business problem optimization Show moreShow less.