To all those who are watching this video, here is what I recommend.. While watching the video open the provided work book and practice it in real time by pausing the video. Practice the same after 1 week.. Continue this exercise two more times with a gap of 7 days.. It stays in your mind for a longer duration...
This is the only Excel Training Course that explains how to properly use Excel and explains the steps percisely at a proper speed for ANYONE to understand, without having to pause or replay the video. For months and months Ive tried to understand formulas especially and in one single View from watching the Video, Shawn explained everything in such a way, I had to laugh at myself for looking into the picture, just from the wrong Angle/View. The ONLY TUTORIAL THAT GUARANTEES YOU'LL UNDERSTAND IT! A++++++++++
this guy's tone makes the tutorial,, though long, very engaging. He explains each concept as if teaching it to a baby (i might as well be one in terms of excel skills). Many thanks and I hope this channel grows huge.
One thing you should add to the Solver and Solver2 parts is that formulas have to be contained in the Objective cells (i.e. Total Shipping Costs). It wouldn't work for me until I did that. Other than that-- FANTASTIC tutorial! This is what I've been looking for!
Excel made to excel by Sean - Yours is one of the best in Excel Learning - I have done Basic, Inter and Advanced without practising - Just to know what the Store has - and the Store has lots - Now I am going do it from the beginning slowly by pausing and practising alongside - there is one thing I didnt find - how to bring the Price automatically when item is chosen - Hope you will calrify - Thanks for the great set of Videos.
Great Video, but be careful with Scenario Summary information at 2:09:00, since it is showing INCORRECT results for "Southern Expansion". It should be $1.343M, so "New CEO" exceeds "Southern Expansion". The error is with the current values changing the "Southern Expansion" original "Standard Scenario" data to "New CEO" data with only the change of South ($C$14) returning to the increased 4%. Be careful of this for future company analysis.
I'm commenting without even opening this video. I came to know from comment section that this video tutorial is very helpful. Thanks in advance sir. I've subscribe your channel and will recommend it to my colleagues.
Great video! I realised at ~1:06:00 the function only works because you've got either "Holiday" or one other option. However, if you had more than 2 options it would be truly automated by using an IFS function and adding "values if true" as necessary
Wow, Amazing how much I learned I have been using office and excel since it's birth, I now realize I know very little about office 2016 that I own. Thank you Learn it for these videos and these instructors. Thank you Sean you did an awesome job!
Very grateful for this video. I have learnt a lot in less than 3 hours. Thanks to COVID 19 I have plenty of time to watch this video and many more learning materials
At the beginning using the function box i was not impressed until you started merging If,lookup,sum all together :D. Well i am not going to type functions the way i used to before. I am finishing the series in about 40mins. Thank you very much. I have learnt a lot. Bless you
This presentation is really simply demonstrated and very easy to understand and very helpful..... Thank you so much and look forward to more useful excel tutorials
Dear Mr. Sean Bugler I would like to thank you from my heart for this amazing video really it is valuable I learn a lot of things that make my tasks easier your style in learning is amazing God bless you wishing you the best in your whole life best whishes
at 53:04 i couldn't stop my self to comment bcoz i learnt a lot and i'm sure more to come to learn. thanks a lot to share such a valuable skill at free... thanks again./
I know right? I'm going to need to watch this 2x a week to drill this in my head because AppleONe keeps on sending me the damn IBM Kenexa test for MS Excel 2016 and they NEVER send me the tutorial on it. I used Excel in my jobs, but not advanced stuff. Don't employment agencies know that if you don't use it daily, you are not gonna know it all ? Even the owner of this video says that the Tell me function is a big help since no one know where everything is.
I work for a company where we have "wave days" and a list of stores that have dedicated ship days and built a spread sheet using named ranges. Store ABC might be a Monday but broken down by regions too.. So Store ABC might be in Region North and ships out Tuesdays So the "Named Range" would be NTUES and ABC would check to see all the various tables I named using a mix between CHOOSE, INDEX/MATCH, and and INDIRECT formulas while each "WEEKDAY" is already assigned a number by excel, it makes CHOOSE every easy to know which Table to use "Index/Match" on. Without named ranges, these formulas would be extremely long. but with named ranges, it shortens the formula quite a bit. Since I get one big Data File, I rank out each Store by the day of the week and boom. Organized information with Stores ship days All parsed out from a mass unorganized Data File. Great information here Keep up the great work.
For the Scenario Summary, the changes seem to stack on whatever the current values are. The calculation should have started with the current values equal to the standard scenario. Correct me if I'm wrong here. I got a very different result by starting out this way.
I have been searching for this kind of video for a long time. This is fantastic! Thank you. Is anyone else having a problem downloading the exercise file? I can only view the file but cannot edit.
This video is really good and precise on giving information that everybody can easily understand what to do. Well demonstrated compare to other Excell videos here in you tube. And the guy speaking articulately clear on the way that the viewers can understand and catches of what he was talking. And i just found out that his name was Sean. Its look like that you are sitting on his classroom listening on his lecture. With this regards it makes me log in on my account and subscribed to his channel. Thanks well done.
Awesome tutorial, THANKS! 💥❤ Here is my Ques. sir. 2:11:00 "Credit Card Payment Plan" While the C. Balance is $8000, IR 14.2% and Time is 48months, how did you get this value of $219.42 in C8? kindly the formula you put in that cell! I'd appreciate it sir.
Explained very well. Only had to watch once and remembered it the next day!. Some of it I knew and other bits I didn't. Only watched the named ranges and IF function so far will be watching more tonight. Thank you!
Small typo in video time line: VLOOKUP 38:42:19 instead of VLOOKUP 38:42, so it doesn't work. Excellent tutorial, by the way, congratulations and many thanks!
You know, I thought the optimization problem with Pear Company Transportation would have been difficult to calculate by hand but as it turns out, it seems like there's a pretty good algorithm that you can follow. Ultimately, you want to use the cheapest option as much as you can. Unfortunately, you can't all the time because you have to maintain the minimum specification for all shipping depots. You fill up to the max the best(most economical choice), and then you look at the second-best and so and so forth... Except for example in the 2nd quarter, you find that if you do that with Portland, you will remain with not enough units to ship from Quebec or Charlotte. In that case you just subtract from Portand and add it to the next best alternative in such a way as both Charlotte and Quebec have the minimum requirement met.
Hi, Thank you very much for reading this comment. This tutorial is very very easy to understand and extremely helpful. I have a query and here is my situation. I have an excel file of size more than thirty MB and it can be accessed using the network and it keeps growing in size, every day. More than five users are actively using the file, on most of the day. Some of my users complain that when the file is opening and saving it is slow due to the network being slow. Hence, I need a solution for this. I have two solutions in my mind. Firstly, create a local file to each remote user and let them add their data and sync with the main file in the network when they close or click a button to update the main file. Secondly, add data to excel file in the network without fully opening the file. Do you have any suggestions? Thank you in advance and have a wonderful day.
Hi Sean! Thank u for the knowledge u put in there. I just noticed that in this third video, your drop down menus are invisible. I can't figure out y. Anyway big up
does anyone know if he formatted the cell during the solver part around 1:50:00? Mine is showing it could not find a feasible solution. I believe he formatted h4 through h6 but did not show us. How are we suppose to know just out of thin air?
i apologize - did not see your exercise files under the video. I was able to obtain same result as yours. But your video has some stuffs that we can't see so that's where the confusing arise.
To all those who are watching this video, here is what I recommend.. While watching the video open the provided work book and practice it in real time by pausing the video. Practice the same after 1 week.. Continue this exercise two more times with a gap of 7 days.. It stays in your mind for a longer duration...
Practice makes perfect!
Amazing advice thanks
4
4
4
Excel 2016 beginner to advanced are by far the best of excel series that covers excel in detail
Great to hear!
@@LearnitTraining hello. My Solver tool doesnt work, it says "Objective cell contents must be a formula" what do i do? Please help.
You are a GREAT teacher. You have almost no extra words. You speak clearly and concisely. Thank you!!!!
Thank you! 😃
This is the only Excel Training Course that explains how to properly use Excel and explains the steps percisely at a proper speed for ANYONE to understand, without having to pause or replay the video. For months and months Ive tried to understand formulas especially and in one single View from watching the Video, Shawn explained everything in such a way, I had to laugh at myself for looking into the picture, just from the wrong Angle/View. The ONLY TUTORIAL THAT GUARANTEES YOU'LL UNDERSTAND IT! A++++++++++
31:38 “This leaves me time to focus on the more important nuances of my job like deciding what I’m gonna have for lunch” - That's gold, man!
the man has his priorities set straight
this guy's tone makes the tutorial,, though long, very engaging. He explains each concept as if teaching it to a baby (i might as well be one in terms of excel skills). Many thanks and I hope this channel grows huge.
Thanks for watching!
This is about the most impactful excel tutorial I have watched and used. Thank you Sean. You also teach incredibly well.
Logged in from 2 different accounts to like this video twice. Love and regards from India. 🙏💜
One of the best if not the best Excel Tutorials I ever watched attentively....Keep it up Sean!
Glad you liked it!
Starting a new job and I will highly be using all these functions, so thank you for teaching us all well.
You're very welcome!
Thanks for this wonderful presentation. I highly recommend this tutorial to anyone who wants to use Microsoft Excel productively.
Thank you for the kind words Issahaku!
One thing you should add to the Solver and Solver2 parts is that formulas have to be contained in the Objective cells (i.e. Total Shipping Costs). It wouldn't work for me until I did that. Other than that-- FANTASTIC tutorial! This is what I've been looking for!
That's a great idea!
Really wish you could pour more light on this topic because I am stuck herr
I rarely leave a comment but here I must. Thank you very much. The best explainer and lesson ever
Excel made to excel by Sean - Yours is one of the best in Excel Learning - I have done Basic, Inter and Advanced without practising - Just to know what the Store has - and the Store has lots - Now I am going do it from the beginning slowly by pausing and practising alongside - there is one thing I didnt find - how to bring the Price automatically when item is chosen - Hope you will calrify - Thanks for the great set of Videos.
Ftxctftfttxttftxtxffctfftxtxffcfftft,fcftxtxtxctf,fft ftxffftfxtxttxcffctfffctxtf,txfcctxtttxtxctttff,txtftxtx"/_/'xtcttfttxtxtfftxctxctxftxtfcttctfftftxfftfffffcffctxffffcftxftxctctfftxtxfffffctxtxt,txtfctfxtxctxffctxftxtttxcfctxtftctxfttffftxtxttttffffcftxtxttxffcfctftftxtctxtxtfttxtxcffcftxtxtfctxfftxcfxfctxftctffcttxctxtfft,txfffftxftfttff,ttxfftftxfftctfxtftftctxctxggtxtctxffffftxttxfcffctxtftxcftfftxfcfftxfftxtfftxfxftxtfxccfcfftf ftxtfffffctxffttxctf tfcftxftfxctfxftxctxtxtfcttxfttxtxvttxctxftfffftxtftxttfffftftfxftxttfffftftxctxtftxctftftftxftcttxtctxcft,txtxtttftxtftxtxtftftfctxcttxfftxtxtxtft txtxftxftxct,fcffftxctxtxctffffxtctttftxtt txft tfctxtftgtxfcttcttftftxffffctfffcftfxtctxxfffcgfctftxftxfttxfctfxtttfffctctftctffftxftfxfctxfcftxctxftfctxccfftxxctffftxftxtxtxtctxtxctfftxftftxtftfcftftxctffftctxffftxxtffffxfftfftxfftctxfffxtfcffcfctxxtfcctxtxctxftxccftffcfcfxftxffctxtfctfctfftfctxfftxfftftxctftftfftctttxftffttffctxfffxtfcffffffcfcfffttfctftxxxtfcffftxffcffctffcffftxfftxfftfxffffcffftxffcctftxctxtf,fftxctxftxcftctxtttxttxfftfggtfctctxctxtftxfftfxtxctfftxxtftxfcffftftfxfttfctxfffffctfftfxffftfftxfcftfftffftfxtftxctf,xcfxftxcffctxftxffftftfcftxttxftfxtttfttxfftxtxftxfcctffxtfxtftxcftxxtfffftxtxfftxftctfftxtxtxtfctttxctxftxtffctxftctftfctfttxtftxtfttxtctxfftftxfftff,f,ffftxfcttxtfctftxfftctctxcfttttxffccgtctxtfft,txcgtcttxftxtxftxtxctxcgctftxcttffftxftfffffftftffftftxfctfttxgfffftfffffffcftxtftftxtxftffttctxftxctcttftf,fftxfffftftxtftctxftfffffctxtxfcttftxyxtxtxtftxffttxttftftxftxftxtxctxfgtxtftfctftffffftxtfftttxftxtxfttctftxtffffcgcgtctxfftxctffftxtftxtfffftctftttffttxttxtyxfttxctfftctfxgfftxctxtfftftxftxfftftxtftfxftxtftxtctxtfftctxftftxtxtfffftxftxftxfftxftxtxtxtctxffftxtfffftxtfctftttxtxtfftxtftxcttffftxftxtfttxttxftxctxtffftxftftxcttxtxtf,txtcctxftxcgfftxtctffftfctftfftxfftgtxfffftxftfttxtffttftxftftxfxfvtxffcttftxftxttffftxctxtxftxtxtxtxftxffttftftftfftxtftxtftxfcfftxtftffffctxctxttxt,gtf,txftxgfftxffcgftctctxftxtfffftftftxffftttfctfgtxfttftxtffffftftctffftcttxtttfftffxtfffffffcgtfttffffftffttfftfxftxtftxftxtttgtfttxtfxctctftftct tfftxtfctfttxtffctxfftxtxttf,ftxfftxctftftxfffffftfcfftxtfxtftftxcgfctcttxtxftxctfffttfxftxtxtxgtxtftxtxtctxftxfftctxtctxffctxtxtxtffgctctxtxctxctxfftxffxtctttfttxtctxtfftxtxtxftffctxffttxfffgtctftxtgfcgttxgtxtfftctctctffftftxtxfftxfftxttftxftcgfftctfcttxtfffffftctxtftxtttftggtxtffctcttxgcgtftctxgtcttffftxtfftxftfftfffffctxfttfxtfftfctftxtfctxcfttctxftffftxtxffftffftxtftxxfftfftfffftxttffctxtxtxftxctcgfftxtcgtxffttxtxtxtxcgctttfctcttftxtxtfctxttftxgfftxtftxgtxtftxftxtxftxttctxtxtfttfttftfftctfttftctxtxfffcftxftxtffctxfgtxtffcftxftxtxtttxftxtfcffffctctftxtftxtfxtfttffctxtxtxtftffffftctxtxfftxcttfftxfffcfftxfctxftctfxtftxftfctftxtxtxtfftctxtxtxftxct tffcttctttctxtxtfctftxtftctffttxfgf¥8999'
I learned a lot from your video. As my way of saying thank you, I didn't skip the ads. Thank you.
I appreciate that!
Best tutorial ever. This tutorial is a must have for anyone who wants to learn excel. Thank you so much.
THANKS A TON! YOU ARE DOING A GREAT JOB AND IT IS FAR BETTER THAN VIRAL ENTERTAINMENT VIDEOS ON TH-cam.YOU ARE HELPING MANY!
Great Video, but be careful with Scenario Summary information at 2:09:00, since it is showing INCORRECT results for "Southern Expansion". It should be $1.343M, so "New CEO" exceeds "Southern Expansion". The error is with the current values changing the "Southern Expansion" original "Standard Scenario" data to "New CEO" data with only the change of South ($C$14) returning to the increased 4%. Be careful of this for future company analysis.
just found your channel and I must say - the video is incredibly incredible. Thank you for sharing your knowledge.
Thanks for watching!
Best Excel training ever. You are the best
Wow, thanks!
One of the best Trainer in excel. All Kudos
Thank you for the kind words Shivika!
Your excellent teaching and training will definitely help me to complete the database workbook that I'm working on! You have made me happy. Koodos!!
Thank you Cora! Glad you had a great time watching and learning!
One of the best tutorials I have ever come across. Many thanks!
This is a great tool for learning Excel. The lessons are very engaging and easy to comprehend. Thank you
You're very welcome!
'Pause the video to catch up"...love it, what a classic video !!!!!
Most underrated tutorial ...big thanks for such a good explanation with good examples.
This is literally the best Excel training I have seen. Great job!!!
✔✔👍👍😊😊😀
I'm commenting without even opening this video.
I came to know from comment section that this video tutorial is very helpful.
Thanks in advance sir.
I've subscribe your channel and will recommend it to my colleagues.
Thats being funny though
lmao
LOL!
Great video! I realised at ~1:06:00 the function only works because you've got either "Holiday" or one other option. However, if you had more than 2 options it would be truly automated by using an IFS function and adding "values if true" as necessary
Thank you I learned a lot from you sharing your knowledge. Time is valuable so thank you for sharing your efforts . 2 hours 38 mins of good value.
Glad it was helpful!
Thanks Sean, for teaching me and not making it boring!!
Glad we were able to make it interesting and fun!
I have been trying to learn advanced excel for years (like, over 10) and this was the best lesson I've ever had. Thank you so much!!!
i have taken all the begginer, intermediate and advanced in excel...i have to say wonderful explanation, very patient...and yet very engaging
You are welcome!
You are the perfect teacher. Thank you a million times over for sharing these tutorials.
Wow, Amazing how much I learned I have been using office and excel since it's birth, I now realize I know very little about office 2016 that I own. Thank you Learn it for these videos and these instructors. Thank you Sean you did an awesome job!
This is awesome. I always thought that I know a lot about excel until today. Thanks for this.
Ini namanya belajar dari rumah... gak usah pake kartu2an/iuran, tapi cuma modal paket data bisa belajar excel.. thank you Learnit Training 👍👍
Very grateful for this video. I have learnt a lot in less than 3 hours. Thanks to COVID 19 I have plenty of time to watch this video and many more learning materials
Thats lesson is just brilliant. I like the sense of humor which tutor is shering often. Really good work.
Glad you enjoyed it!
Really useful.
And from your videos people learn how to use these softwares & as a by-product u also learn how to teach / present topics.
Glad to hear that!
I LOVE THIS GUY. YOU ARE A REAL LIFE SAVER
Thank you Gostavis! We love you for watching!
At the beginning using the function box i was not impressed until you started merging If,lookup,sum all together :D. Well i am not going to type functions the way i used to before.
I am finishing the series in about 40mins. Thank you very much. I have learnt a lot. Bless you
This presentation is really simply demonstrated and very easy to understand and very helpful..... Thank you so much and look forward to more useful excel tutorials
Glad it was helpful!
Thanks for the effort, this is one of the very best Excel Tutorial I,ve seen so far, well done
1:01:00 inside C4 cell , use this formula =VLOOKUP(B4,$E$4:$G$10,IF($C$12="Holiday",3,2),1) , and then just copy down
Dear Mr. Sean Bugler
I would like to thank you from my heart for this amazing video really it is valuable
I learn a lot of things that make my tasks easier
your style in learning is amazing
God bless you
wishing you the best in your whole life
best whishes
at 53:04 i couldn't stop my self to comment bcoz i learnt a lot and i'm sure more to come to learn. thanks a lot to share such a valuable skill at free... thanks again./
Very well explained. I'm not finished yet but so far its very well explained. Thank you for your efforts.
Glad it was helpful!
The best ever in history. God bless you for easing my suffering while learning
I know right? I'm going to need to watch this 2x a week to drill this in my head because AppleONe keeps on sending me the damn IBM Kenexa test for MS Excel 2016 and they NEVER send me the tutorial on it. I used Excel in my jobs, but not advanced stuff. Don't employment agencies know that if you don't use it daily, you are not gonna know it all ? Even the owner of this video says that the Tell me function is a big help since no one know where everything is.
This was a very helpful video condensed into a two-hour segment. Thanks for the material!
Glad it was helpful!
I work for a company where we have "wave days" and a list of stores that have dedicated ship days and built a spread sheet using named ranges.
Store ABC might be a Monday but broken down by regions too.. So Store ABC might be in Region North and ships out Tuesdays So the "Named Range" would be NTUES and ABC would check to see all the various tables I named using a mix between CHOOSE, INDEX/MATCH, and and INDIRECT formulas while each "WEEKDAY" is already assigned a number by excel, it makes CHOOSE every easy to know which Table to use "Index/Match" on.
Without named ranges, these formulas would be extremely long. but with named ranges, it shortens the formula quite a bit.
Since I get one big Data File, I rank out each Store by the day of the week and boom. Organized information with Stores ship days All parsed out from a mass unorganized Data File.
Great information here Keep up the great work.
From Egypt, Thanks from here to infinity :)
For the Scenario Summary, the changes seem to stack on whatever the current values are. The calculation should have started with the current values equal to the standard scenario. Correct me if I'm wrong here. I got a very different result by starting out this way.
One of the BEST advanced tutorial..kudos and Thanks alot
Thank you so much Nazia! Extra big thank you for subscribing, it helps so much!
This is was very insightful. It has taught me new tricks and commands I can't wait to apply in my work! Thank-you very much!
You are very welcome Joshua!
I have been searching for this kind of video for a long time. This is fantastic! Thank you. Is anyone else having a problem downloading the exercise file? I can only view the file but cannot edit.
Hi Timmy! You can click on File in the upper left and then save as to save a local copy for yourself.
@@LearnitTraining Thank you very much
The best free Excel tutorial i've seen so far. Learned a lot from it. Thank you very much. :)
I could watch your demonstration of hours... Very clear thanks
now i am about to finish the 5day webinar sessions. Thank you very much.
i learned
you guys are an oasis!!!that simple!! thanks a lot
Happy to help!
1:54:16 for solver basic
1:48:33 for solver advanced
The only useful comment here (Y) Thanks!
excel 2016 Advance. iam thankful because I know a little only on excel. Now I am learning.
This is a very detailed video. I would watch this for full knowledge and playlist for short recall from Vanna Excel
Glad it was helpful!
Omg! this is great I needed this along time ago, all the money I've missed out on jobs.
wow this is awesome. I like the fact that I don't have to subscribe anything. The data is just on google spreadsheet
Thank you Mercantilism!
Excellent presentation. This is very helpful materials. It has broaden my knowledge in excel.
Thank you so much Prosper Accountancy and Bookeeping Services!
Thank you so much for the best Excel Advanced tutorial . well done
You are welcome!
This video is really good and precise on giving information that everybody can easily understand what to do. Well demonstrated compare to other Excell videos here in you tube. And the guy speaking articulately clear on the way that the viewers can understand and catches of what he was talking. And i just found out that his name was Sean. Its look like that you are sitting on his classroom listening on his lecture. With this regards it makes me log in on my account and subscribed to his channel. Thanks well done.
Thank you so much Carlo! We aim to have the videos mimic a live classroom experience as much as possible!
@@LearnitTraining hey how software expenses is 17215 dollars in first qiarter l shouldnot be 5875 dollars ?
Awesome tutorial, THANKS! 💥❤
Here is my Ques. sir. 2:11:00 "Credit Card Payment Plan" While the C. Balance is $8000, IR 14.2% and Time is 48months, how did you get this value of $219.42 in C8? kindly the formula you put in that cell!
I'd appreciate it sir.
Really entertaining! Also learned something about Excel I did not know. Keep it up!
Glad you liked it!
An outstanding video, clear, concise and comprehensive. thank you very much
Thanks all for your great effort!!
Our pleasure!
Explained very well. Only had to watch once and remembered it the next day!. Some of it I knew and other bits I didn't. Only watched the named ranges and IF function so far will be watching more tonight. Thank you!
Small typo in video time line: VLOOKUP 38:42:19 instead of VLOOKUP 38:42, so it doesn't work. Excellent tutorial, by the way, congratulations and many thanks!
Thanks for the tip!
the best video so far
Thank you Ice Cream!
Thanks for a great tutorial man. Tone was great!
Glad you liked it!
You are excellent!! Best excel video
Thank you for the kind words Kashish!
Very Good tutorial fully explaining all in all. I love it
I thank you so much for the 5day seminar. the speakers....hmm. very knowledgeable. Amazing for I had learned alot
Thank you for making this video! You helped us a lot in being more knowledgeable of what Excel can do. Two thumbs up to you!
Glad it was helpful!
Thank you so much... This is for what I pay Internet bill
You're welcome! Thank you for subscribing!
Amazing video , I watched all 3 and all i can say is thank youuuu so muchhhhhhh
Very clear voice and great tutor, thank you very muchh !
Now i am gonna watch all of his Excel tutorial . Thanks to Co-vid 19
your not the only one!!!
Hammad Razzaq Nice crest
BWahahahahaha
so you are in quarantine hahahahahahah
This article is great to know! How to subtract in Excel? > l.linklyhq.com/l/5rOi
Thanks a lot for such a wonderful video and information
You are most welcome
trainer is very good
Excellent training video. I learned a lot from watching and practicing the commands.
Thank You Learnit Training!
Our pleasure!
Thanks a lot for the free and brilliant lesson!
Thank you for watching !
Thank you very much for this tutorial. You explain everything so clearly that it’s very easy to understand.
You know, I thought the optimization problem with Pear Company Transportation would have been difficult to calculate by hand but as it turns out, it seems like there's a pretty good algorithm that you can follow. Ultimately, you want to use the cheapest option as much as you can. Unfortunately, you can't all the time because you have to maintain the minimum specification for all shipping depots. You fill up to the max the best(most economical choice), and then you look at the second-best and so and so forth... Except for example in the 2nd quarter, you find that if you do that with Portland, you will remain with not enough units to ship from Quebec or Charlotte. In that case you just subtract from Portand and add it to the next best alternative in such a way as both Charlotte and Quebec have the minimum requirement met.
Hi, Thank you very much for reading this comment. This tutorial is very very easy to understand and extremely helpful. I have a query and here is my situation. I have an excel file of size more than thirty MB and it can be accessed using the network and it keeps growing in size, every day. More than five users are actively using the file, on most of the day. Some of my users complain that when the file is opening and saving it is slow due to the network being slow. Hence, I need a solution for this. I have two solutions in my mind.
Firstly, create a local file to each remote user and let them add their data and sync with the main file in the network when they close or click a button to update the main file.
Secondly, add data to excel file in the network without fully opening the file.
Do you have any suggestions? Thank you in advance and have a wonderful day.
Hi Sean! Thank u for the knowledge u put in there.
I just noticed that in this third video, your drop down menus are invisible. I can't figure out y.
Anyway big up
Very helpful and very well explained. Thank you so much for making this tutorial.
Glad it was helpful!
This is a very concise tutorial. Thank you. I highly recommended this to my colleagues. Subscribed to your channel. Keep safe always sir!
Much appreciated!
Incredible. Helped a lot.
Thank you so much for your continued support F C!
Thank you so much for very nice lessons about excel. good job!!!
I Like short videos but this is going well so far
Excellent - Wonderful way to spend the lockdown days - Thanks
My only suggestion to include problems with dates before 1 January 1900
Hi Anthony! We will take your suggestion under consideration! Thank you for watching and thank you for subscribing!
does anyone know if he formatted the cell during the solver part around 1:50:00? Mine is showing it could not find a feasible solution. I believe he formatted h4 through h6 but did not show us. How are we suppose to know just out of thin air?
i apologize - did not see your exercise files under the video. I was able to obtain same result as yours. But your video has some stuffs that we can't see so that's where the confusing arise.
I keep getting that it could not find a feasible solution. I don't know what exactly I'm missing.