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.
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!
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.
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.
Thanks for the suggestion, will keep it noted. Meanwhile, in the last part of this video I address a similar problem: ua-cam.com/video/50X2DDPWXoY/v-deo.html
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 ☺️
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.
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 ?
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 ?
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,
👉 Get Krisp for Free: krisp.ai/?ref=kenjiexplains
This is basically a channel about my former career. Very nice. Subscribed.
Thank you for simplifying these for me!
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.
thanks for watching!
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!
Thank you! Really appreciate the nice comment :)
Thank you so much for your content. Very very useful. Keep up the great work.
Awesome, that last solver exercise seems like a great way to optimize many business scenarios!
I think so too!
Nice, clear as always! also.... the Krisp software is amazing! Will be using it in the future!
Glad you like it!
Kenji, Thank you for this!
Thanks for watching Tim!
Super..! Nicely explained
It remembered me of my costing class.
Keep posting such more incite-full videos..
thank you for supporting :)
Great video Kenji!
Othman! What's up bro good to hear from you...hope all is good out in the states!
Thanks for the information! Very useful!!
My pleasure!
Nice video, thank you Kenji!
Glad you enjoyed it!
Great content and I will apply it for sure!
Best of luck!
Nice video.. v well explained
Glad you liked it! Thanks for commenting :)
Thanks a lot
Love the content Kenji. Btw, you look cute hehe
Thank you
didnt know solver existed..thank you sir
cool tool right? :)
Really helpful...will solve a lot of my problems haha!
Glad it helped!
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.
Kenji, do u know have any tips about consulting interview ?
Love the content Kenji. Btw, you look cute hehehw
Thanks Kenji for your video. Please help. How to find MAXy for ax1+bx2+cx3+dx4=y ?
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.
Thanks for the suggestion, will keep it noted. Meanwhile, in the last part of this video I address a similar problem: ua-cam.com/video/50X2DDPWXoY/v-deo.html
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 ☺️
thanks
You're welcome!
Please make some finance careers related videos.
Felt like I did most of the important ones...anything you would like to see in particular?
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.
Excel solver function has been used by many operation research people/supply chain management
indeed great point!
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 ?
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 ?
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,
France got replaced by Taiwan in the 2nd table :P