🚀Get the FREE Graph Templates from Hubspot: clickhubspot.com/t55
@mohsinashfaq1017 ай бұрын
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.
@charlestoneoyoo2 ай бұрын
Great explanation, I loved how you explained the mixed cell referencing 🎉
@giorgimodebadze18693 ай бұрын
It now turns out that actually using $ sign into the formula is easy. Thanks, this was the best explain I've ever seen
@willzinner88137 ай бұрын
best tutorila on this i've seen thank you
@KenjiExplains7 ай бұрын
Glad you think so! I appreciate it :)
@lichunhwang67077 ай бұрын
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!
@KenjiExplains7 ай бұрын
Glad I could help!
@antoniop.35867 ай бұрын
Very clear. Finally, I understood it. Thank you very much Kenji!
@s2r24205 ай бұрын
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
@tomjun89457 ай бұрын
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.95586 ай бұрын
Great presentation and instruction. Thank you.
@AnthonyOssai-xv1uy6 ай бұрын
This was very helpful, thank you
@camlex63107 ай бұрын
Really insightful!! Thank you!!
@wallywechs46947 ай бұрын
Wow, I like your tutorial sir, thumbs up
@RealSubs-ji8if7 ай бұрын
I spend over 1 hour in your channel, good job.
@Goddibaba7 ай бұрын
Nice one, bro
@silvestrecamposano63177 ай бұрын
The best formulas.. Thank you!..
@JustReadTheQuran6 ай бұрын
Thank you. I learnt something...
@Dexter101x7 ай бұрын
Nice one Kenji
@NaveenKumar-sf5tx7 ай бұрын
Thanks alot love from India I am your student from India
@samratdey857 ай бұрын
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?
@LivingGuy4847 ай бұрын
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.
@ofumekelvin96072 ай бұрын
Nice 👏👏👍👍
@mayankchheda3117 ай бұрын
Bro i love your videos...❤
@KenjiExplains7 ай бұрын
Thank you!
@SPYROS4KX7 ай бұрын
Thanks! Please do a video for the MO-201 exam.
@cigstarkyt97197 ай бұрын
Thanks!!!
@JoseAntonioMorato7 ай бұрын
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)) 🤗
@waynez81367 ай бұрын
For challenge 5, can I use the nested xlookup functions to replace index(match)?
@NeagVasileNV-P7 ай бұрын
Really useful! Thank you! 🤩But what if the data is contained in a table? How to reference in this case?
@Wanaw-i7y7 ай бұрын
Thank u so much
@serbonkers41307 ай бұрын
Salamat
@petecullan31133 ай бұрын
Thanks. But how does this work with tables with a named header? That’s where I struggle.
@Techeyeforthepeople7 ай бұрын
Thank you sir. Nagode(means thank-you in Hausa Nigeria 🇳🇬)
@KenjiExplains7 ай бұрын
Awesome thanks for watching!
@ABhiJain_17 ай бұрын
Sir please upload one data analytics and data cleaning playlist
@UtkarshKumar-mp2ls7 ай бұрын
As usual 🎉
@KenjiExplains7 ай бұрын
Thank you for watching :)
@duncsindevon5 ай бұрын
xlookup as opposed to index,match may be better
@Rimonvai-k8e7 ай бұрын
this video seen complete
@echodelta76805 ай бұрын
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.
@montebont2 ай бұрын
Typical needlessly complicated "accounting" approach...Just add filters to the original table...all the info is already there...