Excel Basics 16: Mixed Cell References #1 Trick to Creating Formulas Quickly!!!

[@coolbreeze476]

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.

[@excelisfun]

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 : )

[@nurhutomo6186]

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.

[@excelisfun]

You are welcome for the fun!!!!

[@appletreegfx806]

Michael G is my Excel Hero!! I am literally enjoying your videos! Please do not stop uploading!

[@excelisfun]

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.

[@hashtube4697]

The best excel tutor.

[@excelisfun]

Glad I can help!!!

[@shubhampawar8506]

I often confuse in mixed cell reference , but today you make it crystal clear for me ,many thanks to you ..luv ur teaching ❤️

[@excelisfun]

Crystal clear is good when it comes to mixed cell references!!!!

[@PieterSteens]

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.

[@excelisfun]

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]

In the same boat myself, hopefully this will help me get that job my degree should’ve secured for me.

[@PieterSteens]

@@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.

[@jacktickle5723]

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!

[@anderson40th60]

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!

[@excelisfun]

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 : )

[@jiwoncha9734]

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!

[@excelisfun]

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 : )

[@MonirulIslam-zj3ve]

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.

[@excelisfun]

Thank you, Md. Monirul Islam!!!! Thanks for the support with your comments, Thumbs Up and Sub : )

[@Linux4Ever2011]

I thought I am good at mixed cell references, but I learned a lot from this video. Thanks a lot for such beautiful channel ^_^.

[@excelisfun]

You are welcome for the beauty!!!!

[@ismailismaili0071]

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

[@excelisfun]

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!!!!!!!!!!!!!

[@ismailismaili0071]

Always

[@khashyplus3]

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

[@excelisfun]

Glad that the lessons help!!!

[@stephanieclancy254]

Wow! I had to wake up my brain for this one! Thank you.

[@excelisfun]

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!!!

[@paolap.7369]

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 :)

[@excelisfun]

I am glad you like what I post! Thanks for the support with your comments, thumbs ups and of course your Sub, Paola!!!

[@MsPrettierthanpink]

thank you very much and God Bless you and your family Sir, I learn and hoping I get a job that uses excel

[@excelisfun]

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!!!

[@SK-bv6yd]

Big thank you and standing ovation to the greatest teacher!!

[@manrajabogu2452]

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

[@excelisfun]

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 : )

[@meghnagautam5577]

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.

[@mostafaahmedzein450]

LOL That loud music part was really epic and fun XD :D , Thank you very much for being the best Excel teacher ever!

[@excelisfun]

It was fun to make too!!! Sometimes you have to use music to make the learning fun and effective!

[@mr.chinmayajoshi2688]

Love it man! So awesome! Every video is truly an eye-opener 😂❤️

[@excelisfun]

Yes!!! How'd you like the slow way with music?

[@mr.chinmayajoshi2688]

@@excelisfun awesome!👌 the music was fitting the fast-forward segment. Keep up the great videos Sir. ❤️

[@lingc9195]

You are an amazing teacher!!! Never thought I would love Excel so much:) Thank you so much Sir!

[@lalitsharma9417]

Thx. Very helpful to understand basic concept through examples 👍

[@excelisfun]

You are welcome!

[@Nyuklehead]

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.

[@excelisfun]

You are right about a whole new level. The efficiency fun NEVER stops as you keep learning more Excel : )

[@dylankiehart1865]

You make Excel so seem cool. And you know what? The more I learn from you, the more it ACTUALLY IS!

[@excelisfun]

EXCELlent!!! The more you learn, the cooler Excel is, Dylan!!!

[@akhtaruzzamanjoy8524]

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]

You will achieve your goal!!! The reason that you will achieve your goal is because you are working hard! What is your native language?

[@akhtaruzzamanjoy8524]

@@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.

[@excelisfun]

@@akhtaruzzamanjoy8524 Glad to help! Been teacher here at KZbin since 2008 : )

[@victorgarzao]

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.

[@excelisfun]

That has been my specialty for 12 yeasr here at KZbin. i am glad to help you, and thank you for your support on each video, Victor!!

[@tennispie1]

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.

[@excelisfun]

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 KZbin for the past 14 years.

[@shrek8722]

Hey Sir, I really liked the pension example as it involved absolute as well as mixed refrence..nthanks a lot.

[@excelisfun]

Glad you like it, SherK!!!

[@zonawu1627]

Excel taught by Mike is not only fun but also cool~thanks a million :)

[@excelisfun]

You are welcome a million!!!! Thanks for the support with your comment, Thumbs Up and Sub : )

[@hazemali382]

not only great tutorial but also fantastic workbook also

[@johnborg6005]

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 :) :)

[@excelisfun]

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" : )

[@johnborg6005]

Couldn't have said it better!!!!

[@excelisfun]

I will have to make a video about Excelitis some day ... : )

[@simoiyahector-morales9521]

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

[@jasonlee3349]

Hi Mike, thank you sooo much for the series of excel courses. I really learnt a lot from these courses. thank you so much!

[@ikebana8185]

I want to say thank you so much every time I see your video!!!!

[@idanbenruby8741]

another artwork mike.. thank one more.. and many more to come!

[@masterjack9505]

Thank You Teacher.

[@excelisfun]

You are welcome!!!!!

[@wagdyziada4503]

Mike the KING of EXCEL

[@excelisfun]

Just a guy having fun with Excel : ) Thank you for your continued support!

[@nagizadeorxan]

Thank you for the lesson

[@excelisfun]

You are welcome!!!

[@aamir_curious]

simply amazing!

[@excelisfun]

Yes!!!!

[@hazemali382]

ExcelIsFun drive me crazy Fantastic channel uhh I hope to open My PC 24 hours

[@scottdoerner1784]

Thank you again, I had forgotten about the FV, you can always relearn

[@meniporat3527]

Chapeau (Hats off to you, sir)

[@excelisfun]

Thank you for the kind hat words : )

[@meniporat3527]

You really deserve it, teammate :-)

[@ezgikocak7457]

Thanks, another great video! :)

[@excelisfun]

You are welcome!!!

[@gauravchaudhry7133]

So beautiful and amazing work... Cheers

[@DewinaBu]

And, as usual: thank you so much! You make learning so easy and fun!! =) =) =)

[@SP-to4ub]

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.

[@excelisfun]

Yes, thanks for that correction! Glad you like the combination of simplicity, yet great depth and efficiency, S Palley!

[@ismailismaili0071]

thank you so much again you make me so happy to watch your video i'm so excited to the next one.

[@excelisfun]

I am glad that the videos are exciting!!!

[@lameessy2302]

I am being addicted to your lessons 🌺❤

[@excelisfun]

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 : )

[@lameessy2302]

@@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.

[@excelisfun]

@@lameessy2302 I love to hear great stories like yours, Lamees!!!! That is awesome : )

[@kisslaci36]

It took a while to totally grasp it, but I got there. Thank you.

[@excelisfun]

You are welcome! Thanks for your support with the comment, Thumbs Up and Sub : )

[@chrisinasia1997]

Thank you for all your videos.

[@excelisfun]

You are welcome!

[@OzduSoleilDATA]

WOW! You're going serious long-form, brother! 👍👍👍

[@excelisfun]

I do not know what you are trying to communicate. Can you re-state?

[@excelisfun]

How do you like the song? I am trying to keep up with your artistic enhancements : )

[@excelisfun]

Dude, what are you trying to communicate? I do not understand?

[@GeertDelmulle]

What are you talking about? You new here? Mike has plenty of long-ass videos - best show on KZbin. ;-)

[@sanyuktasrivastava5375]

Such a Amazing Teacher :D

[@excelisfun]

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 : )

[@sanyuktasrivastava5375]

ExcelIsFun Welcome Sir

[@andreacarr3199]

Thanks Mike!!! Still loving these videos!!

[@excelisfun]

Awesome! I am glad that the videos help!!! I am still loving the support : )

[@zachoneill3897]

Love your videos, keep up the good work!

[@excelisfun]

You git it, Zach : )

[@Kizo_55]

Thank you!

[@excelisfun]

You are welcome!!!

[@febrianto984]

thank you for today's lesson

[@excelisfun]

You are welcome for today's lesson : )

[@Dentoscope10]

Found this one very useful thanks

[@sovereignruler]

Brilliant stuff Mike! Happy New Year partner.

[@excelisfun]

Glad you like it, Daniel! Happy Holidays!!!

[@sovereignruler]

@@excelisfun Likewise. Stay healthy and be well.

[@vishnu8899]

The awesome background score was by Alt rock, "Half Pipe" by Huma Huma and what a cool party trick at 15:52!

[@excelisfun]

Yes, fun music at 04:28 : )

[@excelisfun]

Glad you like the party trick at 15:52: Ctrl + Enter : )

[@excelisfun]

How did you know it was "Half Pipe" by Huma Huma? Had you heard it before?

[@AoiTodo998]

today i am not feeling attend the class , but here is me winning against my self ;)

[@zveringaable]

Thanks!

[@excelisfun]

You are welcome, Yew!!

[@lawrencelawrence592]

You are absolutly amezing.. Thanks

[@excelisfun]

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 : )

[@pmsocho]

Great as usual!

[@excelisfun]

Thanks, Teammate!!!

[@markkennedy9767]

43:00 Office Space Superman 3 story! 🤣

[@damianjez4336]

I believe this topic could not have been explained any better. However, this is the most difficult one for me to grasp.

[@excelisfun]

100% TRUE. Without a doubt, after teaching for more than 20 years, this is THE hardest for people to learn. You are not alone : )

[@str4lent]

Great video thanks mike

[@excelisfun]

You are welcome, Jack!!!

[@chandu7spark]

Tanq Sooooo much for One more Great Video. :)

[@excelisfun]

: ) Bharat!!!!

[@Nikol0zi]

thanks a lot mike! again!

[@excelisfun]

No worries!

[@bigjuicefolife]

Mike, do you know of any resources for learning SQL? Any help would be appreciated! Love your videos!

[@idanbenruby8741]

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!

[@pravinadevi5005]

Very much thank you

[@excelisfun]

You are welcome very much : )

[@BK-kp6rr]

Thanks again.

[@excelisfun]

You are welcome!

[@NemanjaIvanovic-i7x]

Great

[@excelisfun]

Glad you like it!!!

[@NemanjaIvanovic-i7x]

@@excelisfun Honestly it is absolute amazing, thank you a lot for the videos, all the best! :D

[@Whyvardhann]

Freakishly amazing

[@excelisfun]

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.

[@excelisfun]

Thanks for your consistent support, Yashvardhan, with your comments, Thumbs Ups and Sub : )

[@umairahmed1809]

Hello Mike sir Please make a video on Ms outlook

[@mister7cents307]

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?

[@excelisfun]

I have a whole playlist with Accounting related videos: kzbin.info/aero/PLrRPvpgDmw0ndqetqYG0ocKrr-3FvouJ-

[@joramirez159357]

Awesome!

[@excelisfun]

Glad you like it!

[@SyedMuzammilMahasanShahi]

Thanks Mike

[@excelisfun]

You are welcome!

[@Chamchijjige]

THAK YOU THANK YOU

[@excelisfun]

You are welcome, You are welcome !!

[@Luckyca008]

please make a video regarding all formula related to use FIFO method... if u can... plz

[@excelisfun]

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...

[@XLarium]

Sledge Hammer Method: Trust me. I know what I’m doing.

[@excelisfun]

Either Method means you know what you are doing : ) Thanks for your support, XLarium : )

[@XLarium]

It was also a reference to the TV character Sledge Hammer played by David Rasche.

[@excelisfun]

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!?!?!?

[@peterwoods35]

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?

[@mohamedchakroun4973]

Good job Mike go on :-)

[@excelisfun]

Glad you like it! I keep going on : )

[@diya8869]

i guess all the files have been converted to highline something. I am unable to access this one

[@The-sp5df]

Same @excelisfun pls help😊

[@diya8869]

@@The-sp5df It is working now!

[@excelisfun]

There was a world wide Microsoft error today that shut down my school server computers. They are working on fixing it.

[@excelisfun]

@@The-sp5df There was a world wide Microsoft error today that shut down my school server computers. They are working on fixing it.

[@The-sp5df]

@@excelisfun ok sir btw your vids explanation are the best

[@kimyenchu]

Hi Mike, does it work the same if you use number format to 2 decimal places rather than the round() function?

[@excelisfun]

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

[@kimyenchu]

@@excelisfun Thank you. I came across this video in my KZbin feed, not watching them in order. Will fins your other video.

[@excelisfun]

@@kimyenchu Here is the playlist: kzbin.info/aero/PLrRPvpgDmw0n34OMHeS94epMaX_Y8Tu1k

[@ericassan]

Am I the only one finding the Mixed Reference a bit confusing? Am new to excel

[@excelisfun]

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 ; )

[@excelisfun]

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.

[@ericassan]

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❤️❤️❤️

[@ericassan]

Yes the ALWAYS works and reference to column and row…

[@excelisfun]

@@ericassan This is fabulous: ALWAYS MOVE on the COLUMN and ROW!!!! I am glad that you have got it now : )

[@carloseduardofernandez4672]

I hope..Kanban in the next video..

[@excelisfun3903]

I do not know what Kanban is. What is Kanban?

[@AnujSharma-wt8bw]

Sir i want to learn excel from very basics. Can u plz help me from which video i should start Thank u Anuj India

[@MySpreadsheetLab]

I would recommend that you look at Mike's playlists and select the ones that are at your level.

[@excelisfun]

How about starting at #1 in this series? Here is the full play list: kzbin.info/aero/PLrRPvpgDmw0n34OMHeS94epMaX_Y8Tu1k

[@ExcelStrategy]

OK I must admit I was surprised by the hardrock music lol

[@excelisfun]

Punk Rock! It was fun : )

[@ndbvlogs5501]

[@applesoranges559]

4:27 Insane Thrash Metal Data Scientist ..

[@excelisfun]

Best part of the whole video!!!! But I think it is Punk Rock Data Scientist ; )

[@kokneiy2196]

Hi

[@excelisfun]

Thanks for the Support Rad Racer!!!

[@239ubaidullahkhan7]

How $0 cells auto fills when you type formula and control enter please reply. I am bored of trying

[@manrajabogu2452]

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

[@excelisfun]

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 : )

[@TrailShake]

Thanks!

[@excelisfun]

You are welcome S & P P!!!!!! Thanks for your continued support. It means a lot : ) : ) : ) : )