Premium Only Content

Excel Solver - Example and Step-By-Step Explanation
September 28, 2017 Excel Advanced Formulas & Features
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://rumble.com/v2tnkui
✉ 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
-
16:21
The Pascal Show
1 day ago $1.80 earned'THE FEDS MADE THIS UP!' Candace Owens Drops BOMBSHELL Pushing Back On Details In Charlie Kirk Case
6.44K6 -
LIVE
Lofi Girl
2 years agoSynthwave Radio 🌌 - beats to chill/game to
270 watching -
25:39
DeVory Darkins
12 hours ago $20.83 earnedMass shooting erupts in Michigan as bombshell study shows left wing political violence skyrocketed
38.5K108 -
5:55:33
MattMorseTV
11 hours ago $127.42 earned🔴Portland ANTIFA vs. ICE.🔴
168K324 -
3:13:00
Badlands Media
1 day agoThe Narrative Ep. 40: Acceleratia.
75.6K27 -
6:57:01
SpartakusLIVE
10 hours ago#1 Solo Spartan Sunday || TOXIC Comms, TACTICAL Wins, ENDLESS Content
63.5K5 -
49:45
Sarah Westall
9 hours agoComedians take Center Stage as World goes Nuts w/ Jimmy Dore
45.6K20 -
3:26:14
IsaiahLCarter
17 hours ago $12.40 earnedAntifa Gets WRECKED. || APOSTATE RADIO 030 (Guests: Joel W. Berry, Josie the Redheaded Libertarian)
53.5K1 -
4:44:18
CassaiyanGaming
8 hours agoArena Breakout: Infinite Dawg
33.5K2 -
2:24:32
vivafrei
17 hours agoEp. 284: Ostrich Crisis Continues! Kirk Updates! Fed-Surrection Confirmed? Comey Indicted! AND MORE!
144K232