Learn Excel Goal Seek and Solver using real-life examples in company or money management.
👉 Get Krisp for Free: https://krisp.ai/?ref=kenjiexplains
🆓 DOWNLOAD Free Excel file for this video: https://view.flodesk.com/pages/6262db42ec93244248594f10
In this video you learn to use Excels optimization tools: Goal Seek (part of What-If study) and Solver (Excel Add-in).
Firstly, you learn to use goal seek, by figuring out the quantity sold to reach a break even point and a million in profit. Then, you learn the limitation of Goal Seek, and why Solver may come handy.
Secondly, you learn to use solver, and excel add in to optimize your profit given a number of constraints such as a maximum price, a capacity constraint, and a minimum variable cost.
Lastly, you learn to use solver in an advanced setting, trying to minimize the labor cost per country and item given a set of constraints. Then, we will create checks to make sure the solver matrix is working correctly,.
Throughout, you will practice using real-life scenarios you might encounter working with your manager in company or money management roles.
LEARN:
📈 The Complete money management & Valuation Course: https://www.careerprinciples.com/courses/money management-valuation-course
👉 Excel for company & money management Course: https://www.careerprinciples.com/courses/excel-for-company-money management
📊 Get 25% OFF Financial Edge Using Code KENJI25: https://bit.ly/3Ds47vS
SOCIALS:
📸 Instagram – https://www.instagram.com/kenji_explains/
🤳 TikTok – https://www.tiktok.com/@kenjiexplains?lang=en
GEAR:
📹 My Favorite Books & Gear: https://kit.co/kenjiexplains
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00 - Goal Seek
3:30 – Excel Solver
7:08 – Advanced Excel Solver
Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.
Disclaimer:
If you own the YouTube channel related to this video and do not want it to be featured here, you can contact us through our contact page. We will gladly remove it without questioning your reasons.