Tap to unmute

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

  Рет қаралды 32,658

Kenji Explains

Kenji Explains

Күн бұрын

Пікірлер: 45
@KenjiExplains
@KenjiExplains 7 ай бұрын
🚀Get the FREE Graph Templates from Hubspot: clickhubspot.com/t55
@mohsinashfaq101
@mohsinashfaq101 7 ай бұрын
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.
@charlestoneoyoo
@charlestoneoyoo 2 ай бұрын
Great explanation, I loved how you explained the mixed cell referencing 🎉
@giorgimodebadze1869
@giorgimodebadze1869 3 ай бұрын
It now turns out that actually using $ sign into the formula is easy. Thanks, this was the best explain I've ever seen
@willzinner8813
@willzinner8813 7 ай бұрын
best tutorila on this i've seen thank you
@KenjiExplains
@KenjiExplains 7 ай бұрын
Glad you think so! I appreciate it :)
@lichunhwang6707
@lichunhwang6707 7 ай бұрын
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
@KenjiExplains 7 ай бұрын
Glad I could help!
@antoniop.3586
@antoniop.3586 7 ай бұрын
Very clear. Finally, I understood it. Thank you very much Kenji!
@s2r2420
@s2r2420 5 ай бұрын
Thanks a lot bro. I thought I knew some excel. But this beats me. So nicely explained. As you said in the beginning, I wish these were there earlier. Anyway, thanks for exposing this now
@tomjun8945
@tomjun8945 7 ай бұрын
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
@roberth.9558 6 ай бұрын
Great presentation and instruction. Thank you.
@AnthonyOssai-xv1uy
@AnthonyOssai-xv1uy 6 ай бұрын
This was very helpful, thank you
@camlex6310
@camlex6310 7 ай бұрын
Really insightful!! Thank you!!
@wallywechs4694
@wallywechs4694 7 ай бұрын
Wow, I like your tutorial sir, thumbs up
@RealSubs-ji8if
@RealSubs-ji8if 7 ай бұрын
I spend over 1 hour in your channel, good job.
@Goddibaba
@Goddibaba 7 ай бұрын
Nice one, bro
@silvestrecamposano6317
@silvestrecamposano6317 7 ай бұрын
The best formulas.. Thank you!..
@JustReadTheQuran
@JustReadTheQuran 6 ай бұрын
Thank you. I learnt something...
@Dexter101x
@Dexter101x 7 ай бұрын
Nice one Kenji
@NaveenKumar-sf5tx
@NaveenKumar-sf5tx 7 ай бұрын
Thanks alot love from India I am your student from India
@samratdey85
@samratdey85 7 ай бұрын
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
@LivingGuy484 7 ай бұрын
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.
@ofumekelvin9607
@ofumekelvin9607 2 ай бұрын
Nice 👏👏👍👍
@mayankchheda311
@mayankchheda311 7 ай бұрын
Bro i love your videos...❤
@KenjiExplains
@KenjiExplains 7 ай бұрын
Thank you!
@SPYROS4KX
@SPYROS4KX 7 ай бұрын
Thanks! Please do a video for the MO-201 exam.
@cigstarkyt9719
@cigstarkyt9719 7 ай бұрын
Thanks!!!
@JoseAntonioMorato
@JoseAntonioMorato 7 ай бұрын
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)) 🤗
@waynez8136
@waynez8136 7 ай бұрын
For challenge 5, can I use the nested xlookup functions to replace index(match)?
@NeagVasileNV-P
@NeagVasileNV-P 7 ай бұрын
Really useful! Thank you! 🤩But what if the data is contained in a table? How to reference in this case?
@Wanaw-i7y
@Wanaw-i7y 7 ай бұрын
Thank u so much
@serbonkers4130
@serbonkers4130 7 ай бұрын
Salamat
@petecullan3113
@petecullan3113 3 ай бұрын
Thanks. But how does this work with tables with a named header? That’s where I struggle.
@Techeyeforthepeople
@Techeyeforthepeople 7 ай бұрын
Thank you sir. Nagode(means thank-you in Hausa Nigeria 🇳🇬)
@KenjiExplains
@KenjiExplains 7 ай бұрын
Awesome thanks for watching!
@ABhiJain_1
@ABhiJain_1 7 ай бұрын
Sir please upload one data analytics and data cleaning playlist
@UtkarshKumar-mp2ls
@UtkarshKumar-mp2ls 7 ай бұрын
As usual 🎉
@KenjiExplains
@KenjiExplains 7 ай бұрын
Thank you for watching :)
@duncsindevon
@duncsindevon 5 ай бұрын
xlookup as opposed to index,match may be better
@Rimonvai-k8e
@Rimonvai-k8e 7 ай бұрын
this video seen complete
@echodelta7680
@echodelta7680 5 ай бұрын
Prefixing '$' before a number means only columns will change. Prefixing '$' before a letter means only rows will change. Prefixing both letter and number with '$' completely locks cell's value.
@montebont
@montebont 2 ай бұрын
Typical needlessly complicated "accounting" approach...Just add filters to the original table...all the info is already there...
@mustakmnm7
@mustakmnm7 7 ай бұрын
thanks alot 🫡
@KenjiExplains
@KenjiExplains 7 ай бұрын
thank you!
Make Multiple Dependent Dropdown Lists in Excel (Easiest Method)
10:59
5 Excel Formulas Everyone Should Know
14:07
Kenji Explains
Рет қаралды 77 М.
Сестра обхитрила!
00:17
Victoria Portfolio
Рет қаралды 958 М.
To Brawl AND BEYOND!
00:51
Brawl Stars
Рет қаралды 17 МЛН
IL'HAN - Qalqam | Official Music Video
03:17
Ilhan Ihsanov
Рет қаралды 700 М.
Change These 10 Settings Before You Use Excel Again
12:44
Kenji Explains
Рет қаралды 81 М.
Why have a dollar sign in spreadsheet formulas?
16:41
Small Business Toolbox
Рет қаралды 8 М.
Try The DGET Function Instead of INDEXMATCH & XLOOKUP
12:29
Kenji Explains
Рет қаралды 118 М.
Simon Sinek's Advice Will Leave You SPEECHLESS 2.0 (MUST WATCH)
20:43
Alpha Leaders
Рет қаралды 1,1 МЛН
Say Goodbye to IF Statements in Excel with SWITCH
7:45
Teacher's Tech
Рет қаралды 596 М.
TOP 10 Excel Formulas to Make You a PRO User
17:00
Kenji Explains
Рет қаралды 799 М.
5 Impressive Visuals You Didn't Know Excel Could Do
14:40
Kenji Explains
Рет қаралды 54 М.
10 Excel Formulas That Will Set You Apart (+Cheat Sheet)
18:04
MyOnlineTrainingHub
Рет қаралды 356 М.
Сестра обхитрила!
00:17
Victoria Portfolio
Рет қаралды 958 М.