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

Highline College Busn 216 Class: Computer Applications taught by Michael Girvin.
Topics in this video:
1. (00:01) Introduction
2. (01:24) Example 1: Mixed Cell References in Multiplication Table
3. (04:24) Song and Excel Example in High Speed
4. (05:20) How Cell References Move Throughout Copy Action
5. (07:06) Two Questions Method for Determining Which Type of Cell Reference you need.
6. (08:58) F4 key as Merry-Go-Round
7. (13:05) Sledge Hammer Method for Determining Which Type of Cell Reference you need.
8. (15:23) Use Ctrl + Enter to Populate a Highlighted Range with a Formula
9. (16:17) Example 3: Mixed Cell References for Budget with Income Statement Accounts
10. (24:28) Use Ctrl + Enter to Populate a Highlighted Range with an Edited Formula
11. (27:26) Example 2: Mixed Cell References & Assumption Tables.
12. (31:40) Example 4: Mixed Cell References for Retirement Savings Table
13. (37:07) Example 5: Mixed Cell References & Correct Assumption Table for Dynamic Payroll Table
14. (41:22) Two Stories about ROUND Function examples in working world
15. (43:46) Summary - Conclusion

[coolbreeze]

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.

[nurhutomo]

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.

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

[shubhampawar]

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

[jacktickle]

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!

[ismailismaili]

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

[andersonth]

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!

[stephanieclancy]

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

[jiwoncha]

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!

[appletreegfx]

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

[MonirulIslam-zjve]

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.

[LinuxEver]

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

[MsPrettierthanpink]

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

[paolap.]

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

[mostafaahmedzein]

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

[khashyplus]

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

[lingc]

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

[meghnagautam]

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.

[SK-bvyd]

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

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