Hello Mike, I can't thank you enough for your videos! I have been using excel for over 10 years in my personal trading strategy for my investments. I have been mostly self taught, but I have finally decided to educate myself by watching videos about Excel on YT. I came across your channel because someone on Twitter mentioned how helpful your videos are. Having been through 16 videos now I couldn't agree more!!! I have learned so much in terms of keyboard shortcuts, terminology, and so much more. I actually look forward to watching the next video to learn even more! Thank you for all that you do and many blessings to you.
You are welcome, Rob H!!!! I am glad that the resources that I post can help you to become more efficient and have more fun with Excel! Thanks for your support with comments, thumbs ups and of course your Sub : )
7 years later and the noob me learned so much from your video, no matter what excel version I'm currently using. You made me fall in love with excel and I can't thank you enough for how clear, easy and fun your videos explain all the details and frameworks of excel. You are such a good teacher and may the universe return all the favors to you.
I'm fresh out of university applying for jobs which means I have a lot of free time on my hands when i'm not writing cover letters and have decided to plough through your basic (and after this the advanced) excel playlists. Just excellent (and entertaining) all around! I will try to leave a comment here and there and thumbs up all your videos to support as I cannot thank you enough with words. In fact I would never ever have guessed it but the channel name is totally correct. I'm having fun learning excel and cannot wait to apply this during my career as I feel this will be very useful! Thank you, thank you, thank you Mr Girvin.
You are welcome, Pieter! Why have I posted for 11 years? Because most graduates are not trained with the skill they need: Excel. So I post for free to help you and all our other Excel Teammates!!!!
@@jamesbaxter5147 Hi James, good luck on your journey. So fun to see this old comment. This might as well be years ago. I am currently working as a data engineer :) graduated from Excel to Power BI to SQL to Python because I loved it so much. But yeah this is a great great series and excel is super useful. Good luck mate.
Rad! Another lesson plus homework completed! Great video as always. Thanks for calling out keys ("Control Enter!, F2, etc"), briefly explaining what each item in a function means. Putting little bits of review material like this really helps. Rock on!
Sir, Your every video is more than excellent. I am so confident that there is no other advanced tutorial and trainer like you. I am not interested to follow any other trainer's tutorial if you have tutorial in which I am interested to learn. If it is possible, I will give a lot of Thumbs Up in every of your videos. We need trainer like you to make the world more better. I usually suggest to download and follow your videos whoever want to learn excel meeting with me. You are the best sir. Thanks a lot to keep love and patience in your teaching field.
Best Excel tutorial video series I've ever seen! I'm so thankful I found your videos. Downloadable files and homework tasks are extremely helpful! I rarely comment on videos, but this time I had to. Thank you so much!
Glad you like the videos!! I will not stop uploading. In fact, starting next week, I will be creating a new class all about the latest version of Excel: Microsoft 365 Excel. I will be releasing a new video every few days for next few months.
Great mate thank you. A small note though. I think saying that the dollar sign is 'before' the letter or number would be better than saying 'in front of. This' would be far less confusing for other viewers and myself. Cheers for the free stuff. The UK government recently released online learning platforms on their website under the OnlineToolKit program. You sir are saving lives since so many people including myself are shockingly under skilled and under qualified for the structural shifts taking place in the economy. Thank you, you are helping the world!
also i want to tell you something i have a friend that he got work in USA with a company and he was in payroll dept i really make an excel sheet for him that let his work so easy and faster by 85% and he thanks me so much while i thank you so much as i told you since 2013 i started watching your videos you and Mr. Bill have changed my life i swear when i first come no one of the co-workers was in need to me but after they got that i know about excel so much because of you for sure everybody started asking for help and this was my first increment of my salary as my boss knows that i'm doing great for his company thank you so much Mr. Mike, Mr. Bill and Ms. Leila
You are welcome! I have had the very same experience myself, where in my job, Excel gets me hired, noticed quickly and promoted : ) Thank you for your continued support!!!!!!!!!!!!!
I love your videos, since I watched the first one, I became 'addicted' and watched more ! I Never found someone who could teach excel in such clear way. You are truly amazing ! Thanks a lot for sharing your knowledge and keep these videos coming please :)
Hello mr. Mark just wanted to thank you you've made my this year's Christmas break the most productive. I used to find other excel tutorials boring and. quit but now i can't get enough. happy new year to you
You are welcome! Yes, Mixed Cell References are hard to learn, but they are the dividing line between people who are good with Excel and people who are great with Excel!!!
Thanks for the amazing lesson! I already thought I was saving a ton of time with what you've taught us before and mixed cell references brought it to a whole new level.
Hello Mike, My whole life I hated calculations & always thought Excel is just digital version of the big formulas I did in school. So many books I referred even took up a paid course but no one has explained things so well like you have in your video. I am able to understand every small thing, able to do them myself & don't have excel phobia as well , in fact because of you I am loving the fact that how beautifully excel has automated everything. I seriously cannot thank you enough. Only regret wish I found this channel sooner. I would have definitely gotten some promotion. :) hhehe. Hope my speed & efficiency of applying these learning in my day to day work increases as well. Thank you so much once again.
Hello Mr. Mike, I can proudly say you're the best excel teacher have seen, very simplified and unambiguous to understand. I don't have much to say but you're a MOGUL in Excel I wish I could meet you someday
I am glad that you like the materials that I post, Manrajab!!! You can show appreciation by leaving a comment and thumbs up on each video that you learn from. I hope to meet you one day too : )
Thanks Mike. I guess every time you see my comments, you would say that I always start with a Thanks :) Well, surely not enough said :) Over at my work place, I have been Diagnosed with Excelitis....thanks to you :) :)
Yes, and the great thing about Excelitis, is that it is the #1 cause of "Getting Hired For a New Job", "Getting Noticed at Your New Job", "Getting Promoted at Your Job", "Not Getting Laid Off at Your Job", and "Having Most Fun at Your Job" : )
I am taking a break at this video and re-visit lesson 1 to lesson 15 for this next 6 days, two videos each day and practice all of the HW and practice lessons. I need to understand excel before the end of this year and your videos will help me to reach that goal. I also ordered a excel related book in my native language. Wish me luck!!
@@excelisfun Bangla! Just revisit the first video. What I have noticed that, by revisiting old video I understand the concept more clearly this time. Excel is vast and your videos are detail ordinated. I found your channel from Reddit and I also recommend your channel to someone who is learning from zero. Hands down the best excel channel.
Not much to say to you Excel guru Mike, keep on keeping on.. These tutorials have given me a desire to explore excel more. I find my self speaking your language and all "double click and send it down" lol
Glad you like the teaching and video! Thanks for the support, Sanyukta, with your comment, Thumbs Up and Sub : ) It is with the support from viewers like you that I can keep posting this free education : )
0:39 says "relative and mixed cell references". Should say ABSOLUTE. Don't mean to be petty...but Excelisfun rarely makes even the smallest mistake! Thanks for all your videos, you truly know how to break things down and get straight to the point. (just remember 1.5 playback speed:)) Have not found another source that's even close to these classes with the combination of simplicity, yet great depth and efficiency.
You are an angel sent from heaven LOL. Seriously though, you're doing god's work. Thank you for providing amazing knowledge for those of us who are less fortunate. Seriously, this is helping your country's economy in so many indirect ways. We are forever indebted to you.
That is not a bad thing because learning Excel well is the key to getting and keeping and getting promoted in most jobs : ) And this is free, except that I do charge you a comment and thumbs up on each video : )
@@excelisfun I was waorking in book center and sell books. My work needed to be an expert in excel. The most important thing is to know how to use Vlookup. It took me a lot of time to look for book price. Now I know vlookup it takes only some seconds to know. Thanks a lot for all your efforts.
Mike, I am planning to start my job as an accountant. Of course, I will watch all 26 video for basics Excel. What would you recommend to watch after these series of 26 video for acccountants/auditors?
i have question mike, how do i get my cell indicators to be as obvious and colorful like in your videos? in full edit mode its a bit hard to see the references somtimes.. thanks in advance!
I find that clicking on the "show formulas" button gives a more comprehensive verification rather than just f2 on the single cell. Am I missing something?
Yes, indeed - Mixed cell References can save so much time. Also, Mixed Cell References are the dividing line between people who think they are good with Excel and people who are good with Excel.
I have a back log of about a year of class videos to make - so it will be a long time until i can do it - but I have it on the list to do both FIFO and LIFO...
100000% NO!!!!! You must not have watch the earlier class videos about Number Foramting. Number Format changes the display of the video, but not the underlying number. Round changes the number. I would sugget going back and studying the number formatting and ROUND video in this class where I give detailed examples and show the terrible troubl if you do not understand this distinction clearly
It was hard for me back in the 1990s to learn this. I used the sledge hammer method of learning, just try all options until the formula worked. Eventually I just had to invent a memorization trick to try and remember it.
I watched a second video from another person and made use of the word ALWAYS MOVE on the COLUMN and ROW and I tested it with your work and I completely got it… You are really great.. EXCEL IS INDEED FUN❤️❤️❤️
Hello Mr. Mike, I can proudly say you're the best excel teacher have seen, very simplified and unambiguous to understand. I don't have much to say but you're a MOGUL in Excel I wish I could meet you someday
I am glad that you like the materials that I post, Manrajab!!! You can show appreciation by leaving a comment and thumbs up on each video that you learn from. I hope to meet you one day too : )
Hello Mike,
I can't thank you enough for your videos! I have been using excel for over 10 years in my personal trading strategy for my investments. I have been mostly self taught, but I have finally decided to educate myself by watching videos about Excel on YT. I came across your channel because someone on Twitter mentioned how helpful your videos are. Having been through 16 videos now I couldn't agree more!!! I have learned so much in terms of keyboard shortcuts, terminology, and so much more. I actually look forward to watching the next video to learn even more! Thank you for all that you do and many blessings to you.
You are welcome, Rob H!!!! I am glad that the resources that I post can help you to become more efficient and have more fun with Excel! Thanks for your support with comments, thumbs ups and of course your Sub : )
7 years later and the noob me learned so much from your video, no matter what excel version I'm currently using. You made me fall in love with excel and I can't thank you enough for how clear, easy and fun your videos explain all the details and frameworks of excel. You are such a good teacher and may the universe return all the favors to you.
You are welcome for the fun!!!!
I'm fresh out of university applying for jobs which means I have a lot of free time on my hands when i'm not writing cover letters and have decided to plough through your basic (and after this the advanced) excel playlists. Just excellent (and entertaining) all around! I will try to leave a comment here and there and thumbs up all your videos to support as I cannot thank you enough with words. In fact I would never ever have guessed it but the channel name is totally correct. I'm having fun learning excel and cannot wait to apply this during my career as I feel this will be very useful! Thank you, thank you, thank you Mr Girvin.
You are welcome, Pieter! Why have I posted for 11 years? Because most graduates are not trained with the skill they need: Excel. So I post for free to help you and all our other Excel Teammates!!!!
In the same boat myself, hopefully this will help me get that job my degree should’ve secured for me.
@@jamesbaxter5147 Hi James, good luck on your journey. So fun to see this old comment. This might as well be years ago. I am currently working as a data engineer :) graduated from Excel to Power BI to SQL to Python because I loved it so much. But yeah this is a great great series and excel is super useful. Good luck mate.
Rad! Another lesson plus homework completed! Great video as always. Thanks for calling out keys ("Control Enter!, F2, etc"), briefly explaining what each item in a function means. Putting little bits of review material like this really helps. Rock on!
Yes indeed, I will try to rock on radly, but only because it is fun and it is cool when people like you enjoy, learn and support : )
Sir,
Your every video is more than excellent. I am so confident that there is no other advanced tutorial and trainer like you. I am not interested to follow any other trainer's tutorial if you have tutorial in which I am interested to learn. If it is possible, I will give a lot of Thumbs Up in every of your videos. We need trainer like you to make the world more better. I usually suggest to download and follow your videos whoever want to learn excel meeting with me. You are the best sir. Thanks a lot to keep love and patience in your teaching field.
Thank you, Md. Monirul Islam!!!!
Thanks for the support with your comments, Thumbs Up and Sub : )
Best Excel tutorial video series I've ever seen! I'm so thankful I found your videos. Downloadable files and homework tasks are extremely helpful! I rarely comment on videos, but this time I had to. Thank you so much!
Glad you like it! Be sure to click Thumbs Up and leave a small comment on each vid that you watch to give back and say Thanks : )
I often confuse in mixed cell reference , but today you make it crystal clear for me ,many thanks to you ..luv ur teaching ❤️
Crystal clear is good when it comes to mixed cell references!!!!
Michael G is my Excel Hero!! I am literally enjoying your videos! Please do not stop uploading!
Glad you like the videos!! I will not stop uploading. In fact, starting next week, I will be creating a new class all about the latest version of Excel: Microsoft 365 Excel. I will be releasing a new video every few days for next few months.
Great mate thank you. A small note though. I think saying that the dollar sign is 'before' the letter or number would be better than saying 'in front of. This' would be far less confusing for other viewers and myself. Cheers for the free stuff. The UK government recently released online learning platforms on their website under the OnlineToolKit program. You sir are saving lives since so many people including myself are shockingly under skilled and under qualified for the structural shifts taking place in the economy. Thank you, you are helping the world!
also i want to tell you something i have a friend that he got work in USA with a company and he was in payroll dept i really make an excel sheet for him that let his work so easy and faster by 85% and he thanks me so much while i thank you so much as i told you since 2013 i started watching your videos you and Mr. Bill have changed my life i swear when i first come no one of the co-workers was in need to me but after they got that i know about excel so much because of you for sure everybody started asking for help and this was my first increment of my salary as my boss knows that i'm doing great for his company thank you so much Mr. Mike, Mr. Bill and Ms. Leila
You are welcome! I have had the very same experience myself, where in my job, Excel gets me hired, noticed quickly and promoted : ) Thank you for your continued support!!!!!!!!!!!!!
Always
I love your videos, since I watched the first one, I became 'addicted' and watched more ! I Never found someone who could teach excel in such clear way. You are truly amazing ! Thanks a lot for sharing your knowledge and keep these videos coming please :)
I am glad you like what I post! Thanks for the support with your comments, thumbs ups and of course your Sub, Paola!!!
Hello mr. Mark just wanted to thank you you've made my this year's Christmas break the most productive. I used to find other excel tutorials boring and. quit but now i can't get enough. happy new year to you
Glad that the lessons help!!!
thank you very much and God Bless you and your family Sir, I learn and hoping I get a job that uses excel
You are welcome! I hope you get a job that uses Excel also!!! Many jobs do require Excel, so you have a good chance! Thanks for the support, En A!!!
Wow! I had to wake up my brain for this one! Thank you.
You are welcome! Yes, Mixed Cell References are hard to learn, but they are the dividing line between people who are good with Excel and people who are great with Excel!!!
LOL That loud music part was really epic and fun XD :D , Thank you very much for being the best Excel teacher ever!
It was fun to make too!!! Sometimes you have to use music to make the learning fun and effective!
I thought I am good at mixed cell references, but I learned a lot from this video. Thanks a lot for such beautiful channel ^_^.
You are welcome for the beauty!!!!
You are an amazing teacher!!! Never thought I would love Excel so much:) Thank you so much Sir!
Thanks for the amazing lesson! I already thought I was saving a ton of time with what you've taught us before and mixed cell references brought it to a whole new level.
You are right about a whole new level. The efficiency fun NEVER stops as you keep learning more Excel : )
Hello Mike,
My whole life I hated calculations & always thought Excel is just digital version of the big formulas I did in school. So many books I referred even took up a paid course but no one has explained things so well like you have in your video. I am able to understand every small thing, able to do them myself & don't have excel phobia as well , in fact because of you I am loving the fact that how beautifully excel has automated everything. I seriously cannot thank you enough. Only regret wish I found this channel sooner. I would have definitely gotten some promotion. :) hhehe. Hope my speed & efficiency of applying these learning in my day to day work increases as well. Thank you so much once again.
Thank you Mike. ! As always amazing and fun your videos, every class on video You are teach us the easy and powerful way to use Excel.
That has been my specialty for 12 yeasr here at RUclips. i am glad to help you, and thank you for your support on each video, Victor!!
Hello Mr. Mike,
I can proudly say you're the best excel teacher have seen, very simplified and unambiguous to understand. I don't have much to say but you're a MOGUL in Excel
I wish I could meet you someday
I am glad that you like the materials that I post, Manrajab!!! You can show appreciation by leaving a comment and thumbs up on each video that you learn from. I hope to meet you one day too : )
Thanks Mike. I guess every time you see my comments, you would say that I always start with a Thanks :) Well, surely not enough said :) Over at my work place, I have been Diagnosed with Excelitis....thanks to you :) :)
Yes, and the great thing about Excelitis, is that it is the #1 cause of "Getting Hired For a New Job", "Getting Noticed at Your New Job", "Getting Promoted at Your Job", "Not Getting Laid Off at Your Job", and "Having Most Fun at Your Job" : )
Couldn't have said it better!!!!
I will have to make a video about Excelitis some day ... : )
Big thank you and standing ovation to the greatest teacher!!
I am taking a break at this video and re-visit lesson 1 to lesson 15 for this next 6 days, two videos each day and practice all of the HW and practice lessons. I need to understand excel before the end of this year and your videos will help me to reach that goal. I also ordered a excel related book in my native language. Wish me luck!!
You will achieve your goal!!! The reason that you will achieve your goal is because you are working hard! What is your native language?
@@excelisfun Bangla! Just revisit the first video. What I have noticed that, by revisiting old video I understand the concept more clearly this time. Excel is vast and your videos are detail ordinated. I found your channel from Reddit and I also recommend your channel to someone who is learning from zero. Hands down the best excel channel.
@@akhtaruzzamanjoy8524 Glad to help! Been teacher here at RUclips since 2008 : )
Excel taught by Mike is not only fun but also cool~thanks a million :)
You are welcome a million!!!! Thanks for the support with your comment, Thumbs Up and Sub : )
Chapeau (Hats off to you, sir)
Thank you for the kind hat words : )
You really deserve it, teammate
:-)
Love it man! So awesome! Every video is truly an eye-opener 😂❤️
Yes!!! How'd you like the slow way with music?
@@excelisfun awesome!👌 the music was fitting the fast-forward segment. Keep up the great videos Sir. ❤️
Thx. Very helpful to understand basic concept through examples 👍
You are welcome!
Hi Mike, thank you sooo much for the series of excel courses. I really learnt a lot from these courses. thank you so much!
another artwork mike.. thank one more.. and many more to come!
Not much to say to you Excel guru Mike, keep
on keeping on.. These tutorials have given me a desire to explore excel more. I find my self speaking your language and all "double click and send it down" lol
Thank you again, I had forgotten about the FV, you can always relearn
not only great tutorial but also fantastic workbook also
I want to say thank you so much every time I see your video!!!!
Hey Sir,
I really liked the pension example as it involved absolute as well as mixed refrence..nthanks a lot.
Glad you like it, SherK!!!
And, as usual: thank you so much! You make learning so easy and fun!! =) =) =)
Mike the KING of EXCEL
Just a guy having fun with Excel : ) Thank you for your continued support!
WOW! You're going serious long-form, brother! 👍👍👍
I do not know what you are trying to communicate. Can you re-state?
How do you like the song? I am trying to keep up with your artistic enhancements : )
Dude, what are you trying to communicate? I do not understand?
What are you talking about? You new here?
Mike has plenty of long-ass videos - best show on RUclips. ;-)
You make Excel so seem cool. And you know what? The more I learn from you, the more it ACTUALLY IS!
EXCELlent!!! The more you learn, the cooler Excel is, Dylan!!!
thank you so much again you make me so happy to watch your video i'm so excited to the next one.
I am glad that the videos are exciting!!!
Such a Amazing Teacher :D
Glad you like the teaching and video! Thanks for the support, Sanyukta, with your comment, Thumbs Up and Sub : ) It is with the support from viewers like you that I can keep posting this free education : )
ExcelIsFun Welcome Sir
So beautiful and amazing work... Cheers
ExcelIsFun drive me crazy Fantastic channel uhh I hope to open My PC 24 hours
Thank You Teacher.
You are welcome!!!!!
simply amazing!
Yes!!!!
Thank you for all your videos.
You are welcome!
Thank you for the lesson
You are welcome!!!
0:39 says "relative and mixed cell references". Should say ABSOLUTE. Don't mean to be petty...but Excelisfun rarely makes even the smallest mistake! Thanks for all your videos, you truly know how to break things down and get straight to the point. (just remember 1.5 playback speed:)) Have not found another source that's even close to these classes with the combination of simplicity, yet great depth and efficiency.
Yes, thanks for that correction! Glad you like the combination of simplicity, yet great depth and efficiency, S Palley!
You are an angel sent from heaven LOL. Seriously though, you're doing god's work. Thank you for providing amazing knowledge for those of us who are less fortunate. Seriously, this is helping your country's economy in so many indirect ways. We are forever indebted to you.
You are welcome, Abhay!!!! It is my duty to try and make the world a better place, so this is what I try to do here at RUclips for the past 14 years.
It took a while to totally grasp it, but I got there. Thank you.
You are welcome! Thanks for your support with the comment, Thumbs Up and Sub : )
Love your videos, keep up the good work!
You git it, Zach : )
thank you for today's lesson
You are welcome for today's lesson : )
Found this one very useful thanks
I am being addicted to your lessons 🌺❤
That is not a bad thing because learning Excel well is the key to getting and keeping and getting promoted in most jobs : ) And this is free, except that I do charge you a comment and thumbs up on each video : )
@@excelisfun I was waorking in book center and sell books. My work needed to be an expert in excel. The most important thing is to know how to use Vlookup. It took me a lot of time to look for book price. Now I know vlookup it takes only some seconds to know. Thanks a lot for all your efforts.
@@lameessy2302 I love to hear great stories like yours, Lamees!!!! That is awesome : )
Thanks, another great video! :)
You are welcome!!!
Thanks Mike!!! Still loving these videos!!
Awesome! I am glad that the videos help!!! I am still loving the support : )
Brilliant stuff Mike! Happy New Year partner.
Glad you like it, Daniel! Happy Holidays!!!
@@excelisfun Likewise. Stay healthy and be well.
43:00 Office Space Superman 3 story! 🤣
The awesome background score was by Alt rock, "Half Pipe" by Huma Huma and what a cool party trick at 15:52!
Yes, fun music at 04:28 : )
Glad you like the party trick at 15:52: Ctrl + Enter : )
How did you know it was "Half Pipe" by Huma Huma? Had you heard it before?
Thank you!
You are welcome!!!
Great as usual!
Thanks, Teammate!!!
Thanks!
You are welcome, Yew!!
today i am not feeling attend the class , but here is me winning against my self ;)
Mike, I am planning to start my job as an accountant. Of course, I will watch all 26 video for basics Excel. What would you recommend to watch after these series of 26 video for acccountants/auditors?
I have a whole playlist with Accounting related videos: ruclips.net/p/PLrRPvpgDmw0ndqetqYG0ocKrr-3FvouJ-
thanks a lot mike! again!
No worries!
Great video thanks mike
You are welcome, Jack!!!
You are absolutly amezing.. Thanks
Glad it is amazing for you, Lawrence!!! Thanks for your support of the excelisfun channel with your comments, thumbs ups and of course your Sub : )
Tanq Sooooo much for One more Great Video. :)
: ) Bharat!!!!
Hello Mike sir
Please make a video on Ms outlook
Mike, do you know of any resources for learning SQL? Any help would be appreciated! Love your videos!
i have question mike, how do i get my cell indicators to be as obvious and colorful like in your videos? in full edit mode its a bit hard to see the references somtimes.. thanks in advance!
I find that clicking on the "show formulas" button gives a more comprehensive verification rather than just f2 on the single cell. Am I missing something?
Very much thank you
You are welcome very much : )
Thanks again.
You are welcome!
I believe this topic could not have been explained any better. However, this is the most difficult one for me to grasp.
100% TRUE. Without a doubt, after teaching for more than 20 years, this is THE hardest for people to learn. You are not alone : )
Great
Glad you like it!!!
@@excelisfun Honestly it is absolute amazing, thank you a lot for the videos, all the best! :D
Awesome!
Glad you like it!
Thanks Mike
You are welcome!
Freakishly amazing
Yes, indeed - Mixed cell References can save so much time. Also, Mixed Cell References are the dividing line between people who think they are good with Excel and people who are good with Excel.
Thanks for your consistent support, Yashvardhan, with your comments, Thumbs Ups and Sub : )
THAK YOU THANK YOU
You are welcome, You are welcome !!
please make a video regarding all formula related to use FIFO method... if u can... plz
I have a back log of about a year of class videos to make - so it will be a long time until i can do it - but I have it on the list to do both FIFO and LIFO...
Sledge Hammer Method: Trust me. I know what I’m doing.
Either Method means you know what you are doing : ) Thanks for your support, XLarium : )
It was also a reference to the TV character Sledge Hammer played by David Rasche.
So cool!!!! But I did not get that reference, because I had not seen it, or was it because I was not using Mixed Cell References!?!?!?
Good job Mike go on :-)
Glad you like it! I keep going on : )
i guess all the files have been converted to highline something. I am unable to access this one
Same @excelisfun pls help😊
@@The-sp5df It is working now!
There was a world wide Microsoft error today that shut down my school server computers. They are working on fixing it.
@@The-sp5df There was a world wide Microsoft error today that shut down my school server computers. They are working on fixing it.
@@excelisfun ok sir btw your vids explanation are the best
Hi Mike, does it work the same if you use number format to 2 decimal places rather than the round() function?
100000% NO!!!!! You must not have watch the earlier class videos about Number Foramting. Number Format changes the display of the video, but not the underlying number. Round changes the number. I would sugget going back and studying the number formatting and ROUND video in this class where I give detailed examples and show the terrible troubl if you do not understand this distinction clearly
@@excelisfun Thank you. I came across this video in my RUclips feed, not watching them in order. Will fins your other video.
@@kimyenchu Here is the playlist: ruclips.net/p/PLrRPvpgDmw0n34OMHeS94epMaX_Y8Tu1k
I hope..Kanban in the next video..
I do not know what Kanban is. What is Kanban?
Sir i want to learn excel from very basics.
Can u plz help me from which video i should start
Thank u
Anuj
India
I would recommend that you look at Mike's playlists and select the ones that are at your level.
How about starting at #1 in this series?
Here is the full play list: ruclips.net/p/PLrRPvpgDmw0n34OMHeS94epMaX_Y8Tu1k
Am I the only one finding the Mixed Reference a bit confusing? Am new to excel
Absolutely not!!!! It is 100% proven over many decades to be the #1 hardest things learn. You are like the 99%, not the 1% that find it easy ; )
It was hard for me back in the 1990s to learn this. I used the sledge hammer method of learning, just try all options until the formula worked. Eventually I just had to invent a memorization trick to try and remember it.
I watched a second video from another person and made use of the word ALWAYS MOVE on the COLUMN and ROW and I tested it with your work and I completely got it…
You are really great.. EXCEL IS INDEED FUN❤️❤️❤️
Yes the ALWAYS works and reference to column and row…
@@ericassan This is fabulous: ALWAYS MOVE on the COLUMN and ROW!!!! I am glad that you have got it now : )
OK I must admit I was surprised by the hardrock music lol
Punk Rock! It was fun : )
4:27 Insane Thrash Metal Data Scientist ..
Best part of the whole video!!!! But I think it is Punk Rock Data Scientist ; )
How $0 cells auto fills when you type formula and control enter please reply. I am bored of trying
Hi
Thanks for the Support Rad Racer!!!
Hello Mr. Mike,
I can proudly say you're the best excel teacher have seen, very simplified and unambiguous to understand. I don't have much to say but you're a MOGUL in Excel
I wish I could meet you someday
I am glad that you like the materials that I post, Manrajab!!! You can show appreciation by leaving a comment and thumbs up on each video that you learn from. I hope to meet you one day too : )
Thanks!
You are welcome S & P P!!!!!! Thanks for your continued support. It means a lot : ) : ) : ) : )