Excel Solver & Goal Seek: MUST-KNOW for Business & Finance Professionals

[@KenjiExplains]

👉 Get Krisp for Free: krisp.ai/?ref=kenjiexplains

[@gvinodnair]

Solver is a life saver when it comes to solving real life complex calculations. It helps us take lots of stress away. Happy that such a tool is existing for our disposal. 👍👍 Thanks Kenji for explaining.

[@KenjiExplains]

thanks for watching!

[@0ldFashioned85]

This is basically a channel about my former career. Very nice. Subscribed.

[@jenoyestewart1516]

Thank you for simplifying these for me!

[@addylai8793]

Love the content Kenji, thank you for taking the time to explain everything in detail. For example, I was wondering why there is a need for a minimum country production and you answered it right after I was thinking about reasons as to why!

[@KenjiExplains]

Thank you! Really appreciate the nice comment :)

[@michaelquach7046]

Awesome, that last solver exercise seems like a great way to optimize many business scenarios!

[@KenjiExplains]

I think so too!

[@JeffreyJeffersonUK]

Thank you so much for your content. Very very useful. Keep up the great work.

[@lebakusainaveen4504]

Super..! Nicely explained It remembered me of my costing class. Keep posting such more incite-full videos..

[@KenjiExplains]

thank you for supporting :)

[@Soritaaa]

Nice, clear as always! also.... the Krisp software is amazing! Will be using it in the future!

[@KenjiExplains]

Glad you like it!

[@timmagaling]

Kenji, Thank you for this!

[@KenjiExplains]

Thanks for watching Tim!

[@mstipich1]

Thanks Kenji for your video. Please help. How to find MAXy for ax1+bx2+cx3+dx4=y ?

[@andreugiro2807]

Thanks for the information! Very useful!!

[@KenjiExplains]

My pleasure!

[@sparkofjoy3191]

Great content thank you! Could you please make a video if there is a way to get a specific number but in a case where the initial formula is already linked to something dynamic like eg to another sheet like in complex financial models? I suppose the formula would have to be able change the whole calculation in a sheet where it is linked to in the first place… I hope I managed to explain this somewhat complex issue ☺️

[@limitless003]

Thanks a lot

[@willzinner8813]

didnt know solver existed..thank you sir

[@KenjiExplains]

cool tool right? :)

[@christiancoronado]

Nice video, thank you Kenji!

[@KenjiExplains]

Glad you enjoyed it!

[@andymarci6766]

Great content and I will apply it for sure!

[@KenjiExplains]

Best of luck!

[@othmanbensouda8109]

Great video Kenji!

[@KenjiExplains]

Othman! What's up bro good to hear from you...hope all is good out in the states!

[@aaronchiao1990]

Kenji, do u know have any tips about consulting interview ?

[@MrAndromedean]

Copy paste at 11:55 didn't work for me despite multiple trials. Definitely need to work on the subtlety of F4 usage in my learning here. 2x on first sum but 3x on second sum.

[@camlex6310]

Really helpful...will solve a lot of my problems haha!

[@KenjiExplains]

Glad it helped!

[@priaabrio5993]

Thank you

[@lmp2024]

Hi Kenji, can you do one tutorial to filter out invalid phone number from raw data? Some come with invalid length of number and some invalid country code.

[@KenjiExplains]

Thanks for the suggestion, will keep it noted. Meanwhile, in the last part of this video I address a similar problem: kzbin.info/www/bejne/a2G7Y3d6hbyLpbs

[@jeraldtorres1258]

Love the content Kenji. Btw, you look cute hehe

[@gurharkrishanbureau187]

Nice video.. v well explained

[@KenjiExplains]

Glad you liked it! Thanks for commenting :)

[@jasonfoos]

When I run the second iphone example, I put C6 >= 359, just like the video, and solver changes C6 to solver_lhs4. Clicking Solve gives me an error. anyone know why this is? Thanks,

[@jeraldtorres1258]

Love the content Kenji. Btw, you look cute hehehw

[@aaronchiao1990]

Excel solver function has been used by many operation research people/supply chain management

[@KenjiExplains]

indeed great point!

[@phantrungai8585]

at the last exercise, when i highlight the table it says something "solver_adj" and this messes up with my function, and only after the error that i can highlight the table and it shows cells number (at this time i was able to correctly use the function). Any idea how to fix this ?

[@alainnjocke732]

thanks

[@KenjiExplains]

You're welcome!

[@kutlimuroduralboev3954]

are these actually real world problems ? like I've done this stuff in my cost accounting classes, but I feel like stuff like won't even show up in my job, it has to be more advanced than that right ?

[@garvit1359]

Please make some finance careers related videos.

[@KenjiExplains]

Felt like I did most of the important ones...anything you would like to see in particular?

[@garvit1359]

I am a high school kid and I want to make a career in the finance industry and I am often confused. You can make a video on different international courses like cfa etc.

[@sohaibkhan7148]

France got replaced by Taiwan in the 2nd table :P