Excel: Relative and Absolute Cell References

Подписаться 1,1 млн

Просмотров 1,3 млн

50% 1

In this video, you’ll learn the basics of using relative and absolute cell references in Excel 2019, Excel 2016, and Office 365. Visit edu.gcfglobal.... for our text-based lesson.
This video includes information on:
• Creating and copying formulas using relative references
• Creating and copying formulas using absolute references
• Using cell references with multiple worksheets
• Referencing cells across worksheets
We hope you enjoy!

Опубликовано:

23 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 111

@ceciliapalomo6457 6 лет назад

Finally someone who knows how to communicate well!

@JustSimplyMatt 7 лет назад

This makes so much more sense than the way my class material was trying to explain it. Thank you!

@theballereli 5 лет назад

EXACTLY. Also helps when you're a visual learner

@yusufdadkhah7561 4 года назад

@@theballereli true.

@psonthebeat7614 4 года назад

nerds fam

@griffeycuprynski2995 4 года назад

my class just linked this video lmao. paying thousands of dollars for an education I could get for free

@shaktiexports4717 4 года назад

nice!! vid

@brannonchatham2143 4 года назад

Short & Simple and to the point, GREAT refresher!!!

@GCFLearnFree 4 года назад

Glad it was helpful!

@DrMcGuireWU 6 лет назад

Thank you for reviewing this distinction. And, for those interested, the shortcut key for toggling between absolute and relative references is F4 on a PC.

@bobbytrap2554 5 лет назад

the hero I was looking for, it is so tedious to have to the dollar signs for 5 values in a formula

@velona509 7 лет назад

Excellent. Very well explained.

@3sisters49 4 года назад

You explianed it very well with very easy... Thank you so much

@quinnjacobs7260 4 года назад

Thank you for the chart that explains each type of absolute value. Very helpful!

@nattyasrat2078 5 лет назад

you are a life savior. Thank You.

@alleefattah8045 5 лет назад

Very Very Beautiful explanation ever !! Thank you so much

@eveline9530 4 года назад

Simple uncomplicated example! Thank you

@Wong2k 2 года назад

Very well explained. Thanks for making things very visual.

@radu0505 3 года назад

Excellent Video - Exactly what I was looking for. Thanks !!!!!

@uraibasif8053 6 лет назад

Thx, this is gonna help me in my exam tomorrow

@ahmedferdous2433 6 лет назад

Very nice..Precise and "as a beginners want"

@hafsahsiddiquah3526 2 года назад

I honestly HATE computer but this made me really clear. Thank you so much!! *Edit*: I meant the subject computer, lol.

@sahelikayalmolykayal4907 4 года назад

Thank You so much . Such a great , brief explanation 😀

@josec439 5 лет назад

Loved the explanation, made it real easy to understand. Thank you!

@ettanoel2457 20 дней назад

Thank you this is very helpful . Very well explain.

@Son0fFalse 2 года назад

Thanks very much!

@GCFLearnFree 2 года назад

You're welcome!

@LuckyundGacki 7 лет назад

omg most helpful tutorial ever. got it. thanks.

@debjitmajumder1405 2 года назад

Brilliantly explained !!!!!!

@GCFLearnFree 2 года назад

Thank you!

@kevinpinto9082 6 лет назад

Thanks for sharing very well expalined !!

@karolinerobinson43 7 лет назад

Very helpful! Many thanks.

@vladislavbarbarii2089 6 лет назад

perfect explanation

@amirusewmin6318 5 лет назад

You are very good at explaining

@jaypandya4047 5 лет назад

Thank you so much very nice and easy explanations

@oraclesolutions8592 2 года назад

Awesome video got some clarity on cell referrences.

@GCFLearnFree 2 года назад

Glad it was helpful!

@clarissar6911 6 лет назад

Great explanation!

@mohasahal1771 Год назад

thanks for this concise explanation

@GCFLearnFree Год назад

Glad it was helpful!

@munirahkabir8082 4 года назад

Thanks, this video was really helpful! ☺️

@GCFLearnFree 4 года назад

You're so welcome!

@NikhilSharma-il1ye 2 года назад

Great Video!

@westfield90 5 лет назад

So well explained

@rakeshmehrotra8837 5 лет назад

Excellent I understood it very well pls make more videos on formulas of excel class 7

@beezhangholizadeh-anzabi7840 5 лет назад

WATCH THIS VIDEO. Very helpful and straight to the point, ty!

@keefs41 3 месяца назад

Thank you for this vid. it really helped a lot!

@kshitijsinha2029 5 лет назад

Thanks a ton. It will help in my exam surely!

@srinivasak3869 6 лет назад

Thanks a lot! It helped me so much

@faridagaber4860 2 года назад

very useful . THANK YOU

@GCFLearnFree 2 года назад

You are welcome

@TheO_siddiqui 2 года назад

Reallu helful! Keep it up!!!

@Simar09 Год назад

Really helpful 👍🖤...

@shahzaibzafar629 6 лет назад

Brilliant explanation

@bluejay8411 Год назад

THANK YOU SM! :)

@GCFLearnFree Год назад

No problem!!

@nasibrahman9 6 лет назад

Really helpful video. Keep up the good work!

@alexfeher4402 5 лет назад

Nicely explained!

@gabrielthemessenger 6 лет назад

Outstanding Tutorial, Thank you so much!

@shadishadi9410 2 года назад

Really good vedio pleas keep up on good work

@allsmiles3281 7 лет назад

Very professional and concice! Thank you

@LividLibruh 2 года назад

this was really helpful!

@GCFLearnFree 2 года назад

Glad you think so!

@bernadettedoh9445 3 года назад

Thanks so much

@RonTheGod 6 лет назад

you're a lifesaver

@floydmillar2875 4 года назад

Fantastic presentation. thanks so much

@GCFLearnFree 4 года назад

Glad you liked it!

@abhishek7417 5 лет назад

beautiful explanation . thank you so much.

@l4rjy 5 лет назад

Brilliant!

@anabel9460 4 года назад

Thank you this helped me

@GCFLearnFree 4 года назад

You're welcome!

@motakuw_2906 4 года назад

Smooth and efficient, thank you!

@Tarmedy 4 года назад

Thank you so much!

@floydmartinauman1368 6 лет назад

thanks for the explination

@shalloh3201 5 лет назад

wow how do you explainn so well thanks

@mochaticha5944 5 лет назад

Best explanation ever! Thank you

@wilcamacho5074 4 года назад

THANK YOU!

@nirmalgharti6971 4 года назад

Thank you so much

@bbossin 7 лет назад

Just what I needed!

@ezauramarule 4 года назад

Thank you so much♥️🙏🏾

@GCFLearnFree 4 года назад

No problem 😊

@marthagomez4103 2 года назад

Thank you so much for the different examples!

@GCFLearnFree 2 года назад

Glad it was helpful!

@kobeb365 5 лет назад

Thank you!!

@jonathanorellana3924 Год назад

If the worksheet name do not have a space do you still need to put the single quotation marks?

@rifatislam5836 2 года назад

Fantastic 😎

@GCFLearnFree 2 года назад

Thank you! Cheers!

@faresd2570 7 лет назад

Perfect thanks

@MrRottensalad 8 лет назад

Thanks!

@214sioeh 2 года назад

👍👍👍

@CraftyShawn 6 лет назад

Thks for sharing you solved as problem I was having with keeping the one variable stationary

@muhammadnazmulhasan4613 5 лет назад

Good job

@yoyocr2034 Год назад

thanks

@hazelpablo6063 5 лет назад

you are awesome

@BabaGhazi 7 лет назад

Thanks

@calebdrobnick4874 6 лет назад

Perfect

@mrmoe5272 5 лет назад

2:50 Table is useful

@nasridryden3775 Год назад

@sangeetayadav2297 4 года назад

Tysm💞 :)

@dr.smitadubey267 4 года назад

Nice

@vemulasrikanth4460 7 лет назад

Super

@vemulasrikanth4460 7 лет назад

After watching this is very easy to understand

@Understandingtgescience 6 лет назад

Good

@sunitamoktan624 4 года назад

Why did you use parenthesis ?

@bktiwari6230 4 года назад

make video on virus mam

@ahmadsafi9 Год назад

Thanks a lot

@AI_Masterpiece_ 4 года назад

Thanks so much!

@rzparksjp 6 лет назад

Thank you!

@kebigilemopaye6648 6 лет назад

thanks

@SrFK531 4 года назад

Thanks

@santoshsapkota4579 7 лет назад

thanks