How to Use Relative, Absolute, and Mixed Cell References in Microsoft Excel

This video explains and demonstrates how to use relative, absolute, and mixed cell referencing in Microsoft Excel.

[@tamilarasi6895]

Simple & clear. Gun point explanation! Thank you!

[@ashleyneiswk8384]

Thanks for sharing this video to us sir.
due to some illness i couldn't go school for few days and i couldn't go with computer bcx I'm rlly weak in it
but sir this video has encouraged me and helped me a lot to do in computer now waiting for the computer exam and results of it....i understood relative and absolute cell reference but not mixed reference but its okay thank u sir
i smashed the like button and subscribe button

[@bubbakindroad]

I Lol'd at 'Delicious Nachos' . Perfect Timing, and excellent comedic delivery ! :)

[@RUNTHROUGHDATAPE]

You had me until the mixed cell referencing part. Im still trying to get it. Overall its the best explanation I've seen thus far.

[@fribbidfribbid2169]

Yeah mixed is a bit confuzing

[@westfield90]

fribbid fribbid yeah the mixed part is a little confusing. The example here is much clearer czcams.com/video/LFIykJmL4M8/video.html

[@kimalleyne7050]

Yea he's good

[@Gabi-kv2jh]

thank you so much for youre well explained and heldpful content

[@cortneylang3881]

Great informational video. I'm taking an online class and got stuck on absolute referencing, this video helped me understand it and do it correctly!!

[@srishtidey5910]

Uhhh

[@KellyDaniel-kw6bl]

Best explanation so far🎉

[@rasinahbinteshaiksafiudeen9101]

Thank you! Now I understand mixed,absolute and mixed cell references

[@srishtidey5910]

This video helped me a lot!!!!!

[@SHAHZAIBXEDITS]

Very informative...

[@cactuserror528]

Good explanation

[@Subhash_VCU]

To folks who are a bit confused, Columns are called by letters , rows are called by numbers and now try to rewatch the video and get some better clarity without being confused

[@akankshaprajapati_51_m3s8]

Yes very helpful, theoretically it can't be understood

[@kshitizsinha3109]

Great explanation

[@fabulousangella]

Thank you for the video! I understand mixed referencing now.

[@SpringRain23]

Thank you for sharing. I need to watch this a few times and get it memorized!!

[@britneycooper2644]

Did it today in class but didn't understand it thank you so much for your help still need more practice

[@lakshmisharang1621]

Thanks a lot sir

[@navyalaukik9083]

Got it thank you .

[@RabThapa]

Thank you a lot.

[@alphaapoorv2659]

Thank you

[@kaushikisonawane2651]

Wow I got it all so easily thanks.

[@raghavendramishra2]

THANKS

[@VinayKumar-ou9gy]

I've got absolute and relative cell referencing but not the mixed ! :(

[@manojbhai634]

The mixed cell reference is not much clear

[@westfield90]

Excellent

[@hasanmjmj]

Thank you sir.

[@Shiv-br6uy]

Thanks sir you are the best

[@no-manplayer3281]

I just came cause my assignment is about this Thanks though.

[@Bandanavlogs143]

Thank u Daniel Sir

[@melisaagnes9142]

Thank you so much!

[@anumchaudhary5918]

mixed cell reference :(

[@syedasumaira4196]

When I press Enter after writing formula using absolute cell reference, the answer is #value! why I can't get correct answer? sir, Plz reply.

[@GursimranKaur-kr8di]

Put = sign

[@ateeqahmad3063]

Did not got the mixed cell referencing

[@sohaibfazal5347]

Thankd a lot i got it

[@alphaapoorv2659]

Oh

[@alphaapoorv2659]

I also

[@madelrefugiogalindodejesus5031]

I do not get it... :'( :'( :'(

[@tibryosman8621]

replay the video

[@doraymarthak.leshego8985]

EXECELLENT

[@dhaneshelectrical8739]

I want a formula for variable cell reference.
I am having a Column A of 100 number 1 to 100.
I am having a Column B of 100 numbers 0 to 100
Now in Column C, I want to average Cell value of A1 to A100 based on value on column B1 to B100
Suppose in Column C ,if Average of $A$1:A10 = 50, and at that time B10>0, now for next averaging in Cell C11 I want to use formula $A$11:A11, $A$11:A12,$A$11:A13 and so on.
Again if anytime in Column C, say $A$11:A20 = 100 and same time B20>0, I want to change average formula in Cell C21 from next cell and it will become $A$21:A21,$A$21:A22, $A$21:A23 and so on
Pls guide

[@ericerickson4876]

You might want to show the formula bar to show how each formula will change for each set of values. Your effort, although appreciated, was a waste of your time and the viewers.

[@MungusMctavish]

=FORMULATXT()

[@Mrdannyboy1462]

Lol mixed cell referencing is so useless

[@shahinmulani3998]

0

[@chasejoseph]

literally what the fuck