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

[@antoniop.3586]

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

[@camlex6310]

Really insightful!! Thank you!!

[@silvestrecamposano6317]

The best formulas.. Thank you!..

[@wallywechs4694]

Wow, I like your tutorial sir, thumbs up

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

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

[@Dexter101x]

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

[@SPYROS4KX]

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

[@cigstarkyt9719]

Thanks!!!

[@user-op1qe4fg8f]

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

[@serbonkers4130]

Salamat

[@NaveenKumar-sf5tx]

Thanks alot love from India I am your student from India

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

[@user-dv2mf1sf6v]

Thank u so much

[@mayankchheda311]

Bro i love your videos...❤

[@KenjiExplains]

Thank you!

[@waynez8136]

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

[@HighTechTK]

Sir please upload one data analytics and data cleaning playlist

[@RealSubs-ji8if]

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

[@Goddibaba]

Nice one, bro

[@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)) 🤗

[@aneyeforthepeople6204]

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

[@KenjiExplains]

Awesome thanks for watching!

[@UtkarshKumar-mp2ls]

As usual 🎉

[@KenjiExplains]

Thank you for watching :)

[@user-ly3ox7rc1d]

this video seen complete

[@mustakmnm7]

thanks alot 🫡

[@KenjiExplains]

thank you!