Don’t Fall Behind: My System for Mastering Excel Formulas

Learn the most important Excel formulas in just 15 minutes.

Excel has over 470 functions, so knowing which one to use can be rather overwhelming. That's why in this video I'm going to teach you some of the most important Excel functions through the fast-track method, where we group formulas into 5 steps so you can remember them easily. The 5 steps are MATH, TEXT, DATES, LOOKUP and LOGIC. More specifically, the functions we'll look at are the AGGREGATE function, RANDARRAY function, DATEDIF function, YEARFRAC formula, NETWORKDAYS function, TEXTJOIN, TEXTSPLIT, TRIM, PROPER, IF, AND, OR, VSTACK and GROUPBY.

LEARN:

SOCIALS:

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

Chapters:
0:00​ -​ Step 1
2:17​ - Step 2
5:50​ - Step 3
8:22​ - Step 4
11:44​ - Step 5

[camlex]

Great breakdown of the key formulas!! Thank you

[liquidapathy]

One of the best informative excel videos I’ve seen in years.

[divyaglory]

Hi kenji, this was really useful for me, I loved it, thank you ❤

[AZZEL]

Sir, you explain it very well.
THANK YOU SO MUCH❤

[mugerwaferryl]

Mr. Kenji am so inspired by your educative videos, thanks again please. could you be knowing any way how i can update my windows without a PK( PRODUCT KEY)? thanks

[antoniiocaluso]

your Channel's content is AMAZING! thank you!! sub'd/liked

[WeiyingChen-fuxd]

How to get groupby and pivotby function in Excel? I have subscribed MS 365.

[maxsolbiz]

I have installed the updated version of Office 365, but the groupby function is not available
After some Google, I found that it is in the testing phase and only available in Office insider.😢

[divyv]

Hey Kenji, very good video . I can do better editing in your videos which can help you to get more engagement in your videos . Pls lmk what do you think ?

[kavalimahesh]

This is exactly that i'm looking for improving my excel skills. But not sure why some functions like VSTACK and GROUPBY aren't supported in my EXCEL. Thanks for video. Looking forward to leaning more from you.

[sarahadel]

the last formula does not appear, how can I get it?

[willzinner]

can you do a part 2 with more formulas for each group?

[ParthAnand-zcen]

Love your teaching Kenji,
I request you to kindly make some more videos on SQL and Power BI, your excel tutorials has really increased my confidence in Excel

[Safy-wzcf]

thank you Kenji..could you please help me why i can'tfind text join in my excel.it's 2016 plus

[trunkbitz]

Kenji did not explain the DATEDIF month and year is rounded down. I think he should have. I tried changing the decimal place for the month but it seems to have internal round down function.

[cliffordabere]

HOW CAN YOU GET THE LEANING SOURCES WITHOUT THE

[montana]

awesome! For networkdays, you said to just add the holidays at the end of the formula but didn't show how. if you click on "holidays" nothing happens. are you supposed to add the date of the holiday or letter of the holiday or other?

[itsjazzpelia]

how to update query with new data without deleting the exsiting data, because the linked query updates automatically but doesen´t save the previous data🤔

[vikashgarg]

Can you tell me how to merge different Excel sheet into one sheet

[SportsHunterArea]

Create video on click item picture add value or price that item.
Like click pizza picture 🍕 add value or object or price add price to total