Cell Referencing in Excel (When to add a $ in a cell)

Cell Referencing in Excel. Learn where to add the $ Sign.
🚀Get the FREE Graph Templates from Hubspot: clickhubspot.com/t55
🆓 DOWNLOAD Free Excel file for this video: careerprinciples.myflodesk.co...
One of the most confusing things in Excel is knowing when to put the dollar sign for cell referencing (applied with the F4 key). Is it before the cell column letter? before the cell row number? or both? This took me months to learn correctly, but by the end of this video you'll be super crystal on how to go both absolute and relative referencing in excel.. And for this we'll go through five examples from easy to hard! First we'll go through examples where we fix both the row and column, and eventually we'll transition to some where we only fix the row or the column depending on the scenario. Finally, we'll combine the $ sign cell referencing in Excel with other formulas like an IF statement or an INDEX MATCH.
LEARN:
🔥Power BI for Business Analytics: www.careerprinciples.com/cour...
📈 The Complete Finance & Valuation Course: www.careerprinciples.com/cour...
👉 Excel for Business & Finance Course: www.careerprinciples.com/cour...
🚀 All our courses: www.careerprinciples.com/courses
SOCIALS:
📸 Instagram - careerprinc...
🤳 TikTok - / career_principles
🧑‍💻 LinkedIn - / careerprinciples
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00​ -​ Level 1 Example
1:54​ - Level 2 Example
5:17​ - Level 3 Example
7:09​ - Combining $ Sign with IF Statement
9:11​ - Hard Example with Index Match

[@KenjiExplains]

🚀Get the FREE Graph Templates from Hubspot: clickhubspot.com/t55

[@mohsinashfaq101]

At this point,I am just waiting for ONE TINY formatting video from our boi, You taught me more than I could have ever imagined.

[@AnthonyOssai-xv1uy]

This was very helpful, thank you

[@JustReadTheQuran]

Thank you. I learnt something...

[@roberth.9558]

Great presentation and instruction. Thank you.

[@willzinner8813]

best tutorila on this i've seen thank you

[@KenjiExplains]

Glad you think so! I appreciate it :)

[@tomjun8945]

Your videos are amazing and so clear to follow. I learned a lot from your contents and helped me with my job everyday. Thank you !!

[@wallywechs4694]

Wow, I like your tutorial sir, thumbs up

[@antoniop.3586]

Very clear. Finally, I understood it. Thank you very much Kenji!

[@lichunhwang6707]

Was confused about where to put the dollar sign when I was watching your tutorial before, finally got the point of this locking function, just need more practice, big thanks!

[@KenjiExplains]

Glad I could help!

[@NaveenKumar-sf5tx]

Thanks alot love from India I am your student from India

[@camlex6310]

Really insightful!! Thank you!!

[@silvestrecamposano6317]

The best formulas.. Thank you!..

[@Dexter101x]

Nice one Kenji

[@SPYROS4KX]

Thanks! Please do a video for the MO-201 exam.

[@cigstarkyt9719]

Thanks!!!

[@user-dv2mf1sf6v]

Thank u so much

[@samratdey85]

After successfully passing the HR round of my recent interview, I faced a technical round where I was given several Excel exercises. Unfortunately, I struggled there because I got confused with the formulas. Is there a way to determine which formula to use in a problem statement in Excel to avoid such confusion in the future?

[@LivingGuy484]

You just have to learn what commonly used formulas do. There's no magic shortcut to knowing the answer when excel formulas address a large variety of problems.

[@mayankchheda311]

Bro i love your videos...❤

[@KenjiExplains]

Thank you!

[@user-op1qe4fg8f]

Really useful! Thank you! 🤩But what if the data is contained in a table? How to reference in this case?

[@serbonkers4130]

Salamat

[@RealSubs-ji8if]

I spend over 1 hour in your channel, good job.

[@Goddibaba]

Nice one, bro

[@HighTechTK]

Sir please upload one data analytics and data cleaning playlist

[@waynez8136]

For challenge 5, can I use the nested xlookup functions to replace index(match)?

[@aneyeforthepeople6204]

Thank you sir. Nagode(means thank-you in Hausa Nigeria 🇳🇬)

[@KenjiExplains]

Awesome thanks for watching!

[@JoseAntonioMorato]

Although not everyone has MS365, the future of Excel is dynamic arrays that do not require references: 1: =E3:E8*B3 2: =G3:G8*B3:D3 3: =C6:C9*D5:G5 4: =IF(C5:C15>F5,C5:C15*F8,"") 5: =INDEX(C9:G19,XMATCH(B4:B6,B9:B19),XMATCH(C3:D3,C9:G9)) 🤗

[@UtkarshKumar-mp2ls]

As usual 🎉

[@KenjiExplains]

Thank you for watching :)

[@user-ly3ox7rc1d]

this video seen complete

[@mustakmnm7]

thanks alot 🫡

[@KenjiExplains]

thank you!