Buy Dideo Subscription
Excel’s Solver tool is an optimization package. It finds the optimal solution to a problem by changing multiple variables. It can solve for more complex “what-if-analysis” which Goal Seek can’t. Goal seek is restricted to changing one variable, whereas with solver you can have many variables. ★ My Online Excel Courses ► https://www.xelplus.com/courses/ 00:00 Define and Solve a Problem by Using Excel Solver 00:15 Solve Problems in Excel with 2 or More Variables 06:56 Solve What-If Problems with Constraints ► Download the workbook here: http://www.xelplus.com/excel-solver-example Calling Solver an “advanced goal seek” doesn’t do it any justice. Solver can handle complex data models and solve for the optimal solution. But; it can also easily solve for the more simpler problems that we might face at work. In this video, I show you two examples: 1 - How to set income to a specific value by changing prices which adding constraints for the price and also full rounded number for units sold. 2. Distribute the remaining budget dollars among your different projects based on certain cost constraints. Goal Seek Video: https://youtu.be/OhnkuBVTcg8 ✉ Subscribe & get my TOP 10 Excel formulas e-book for free https://www.xelplus.com/free-ebook/ Get Office 365: https://microsoft.msafflnk.net/15OEg Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593 GEAR Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161 Main Camera: https://amzn.to/3a5ldBs Backup Camera: https://amzn.to/2FLiFho Main Lens: https://amzn.to/39apgeD Zoom Lens: https://amzn.to/3bd5pN7 Audio Recorder: https://amzn.to/2Uo5rLm Microphone: https://amzn.to/2xYy9em Lights: http://amzn.to/2eJKg1U More resources on my Amazon page: https://www.amazon.com/shop/leilagharani Let’s connect on social: Instagram: https://www.instagram.com/lgharani Twitter: https://twitter.com/leilagharani LinkedIn: https://at.linkedin.com/in/leilagharani Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support! #MsExcel
