Mastering Excel: Top 10 Formulas You Need to Know

Learn the most important Excel formulas in just 15 minutes.
🚀Get FREE Excel chart templates from Hubspot: clickhubspot.com/asb
🆓 DOWNLOAD Free Excel file for this video: careerprinciples.myflodesk.co...
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:
🔥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​ -​ Step 1
2:17​ - Step 2
5:50​ - Step 3
8:22​ - Step 4
11:44​ - Step 5

[@KenjiExplains]

🚀Get FREE Excel chart templates from Hubspot: clickhubspot.com/asb

[@RanveryRose]

You are so cute ❤😊

[@Perfectsound88]

Thanks so much Kenji.I have been watching your videos and they are so helpful.Thanks so much and God Bless you.

[@Luciano_mp]

Great examples. Thank you Kenji!

[@camlex6310]

Great breakdown of the key formulas!! Thank you

[@liquidapathy82]

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

[@rajuar1955]

Appreciate your efforts kenji

[@divyaglory6237]

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

[@md.nuralammiah9587]

Very informative tutorial!

[@AZ4ZEL666]

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

[@HariKenyuk]

Thanks LAB 4 this

[@muhammadhasanraza1606]

superb, keep it up

[@prefatto]

bro you are so good.

[@mugerwaferryl213]

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

[@rudrashrestha9558]

superb

[@antoniiocaluso1071]

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

[@colorfulfahim]

love your teaching style Kenji...

[@KenjiExplains]

Thank you!!!

[@MrAqadii]

Thank you

[@KenjiExplains]

You're welcome!

[@kavalimahesh4230]

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.

[@KenjiExplains]

Hey it’s because they’re quite new so depending on your excel version you might not have them

[@kavalimahesh4230]

@@KenjiExplainsyeah that explains. thank you for your response. Love your content

[@ParthAnand-zc7en]

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

[@maxsolbiz4696]

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

[@markpodesta4605]

Thank you Kenji. Very useful!

[@KenjiExplains]

Thanks for wawtching :)

[@sarahadel8621]

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

[@WeiyingChen-fu4xd]

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

[@giraudellen]

"The GROUPBY and PIVOTBY functions are currently only available to Microsoft 365 Insiders. These functions will probably be rolled out to 'regular' users in one of the coming months." Microsoft

[@divyv20]

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 ?

[@Safy-wz1cf]

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

[@willzinner8813]

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

[@KenjiExplains]

Thanks for the suggestion, I'll keep it noted :)

[@trunkbitz9168]

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.

[@itsjazzpelia5472]

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🤔

[@montana161916]

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?

[@KenjiExplains]

You’re supposed to type the holidays yourself. Excel wouldn’t know when you plan to take time off as different countries have different holiday periods

[@montana161916]

@@KenjiExplains what format? For example, 12-25 for Xmas?

[@cliffordabere1790]

HOW CAN YOU GET THE LEANING SOURCES WITHOUT THE URL?????

[@nishanth4323]

Thanks 🙏🏻

[@KenjiExplains]

You’re welcome 😊

[@vikashgarg1269]

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

[@KenjiExplains]

I have a video on that in the channel. Please check it out!

[@vikashgarg1269]

@@KenjiExplains ok

[@osiomogieasekome8799]

Why is the datedif formula hidden?

[@KenjiExplains]

Not sure tbh!

[@LyubomirRusanov]

It is not recommended to use this formula. According to Excel doc: Excel provides the DATEDIF function in order to support older workbooks from Lotus 1-2-3. The DATEDIF function may calculate incorrect results under certain scenarios. Please see the known issues section of this article for further details.

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

[@arnonomdo1341]

2:36 The function is DATE DIF ?

[@geekatari4391]

=DATEDIF(), no spaces.

[@kcincy]

@@geekatari4391 I think he's referring to Kenji calling the formula "dated if" as opposed to "date dif" (the difference between two dates).

[@geekatari4391]

@@kcincy oh, ok.

[@UtkarshKumar-mp2ls]

As usual

[@KenjiExplains]

Let's go! Thanks for watching always :)