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

Подписаться 538 тыс.

Просмотров 28 тыс.

50% 1

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

Опубликовано:

7 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 52

@KenjiExplains 21 день назад

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

@RanveryRose 18 дней назад

You are so cute ❤😊

@Luciano_mp 20 дней назад

Great examples. Thank you Kenji!

@camlex6310 17 дней назад

Great breakdown of the key formulas!! Thank you

@divyaglory6237 16 дней назад

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

@liquidapathy82 20 дней назад

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

@md.nuralammiah9587 20 дней назад

Very informative tutorial!

@AZ4ZEL666 12 дней назад

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

@kavalimahesh4230 6 дней назад

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 6 дней назад

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

@kavalimahesh4230 6 дней назад

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

@HariKenyuk 20 дней назад

Thanks LAB 4 this

@mugerwaferryl213 21 день назад

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

@prefatto 16 дней назад

bro you are so good.

@muhammadhasanraza1606 13 дней назад

superb, keep it up

@WeiyingChen-fu4xd 20 дней назад

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

@antoniiocaluso1071 20 дней назад

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

@MrAqadii 20 дней назад

Thank you

@KenjiExplains 20 дней назад

You're welcome!

@colorfulfahim 21 день назад

love your teaching style Kenji...

@KenjiExplains 21 день назад

Thank you!!!

@markpodesta4605 21 день назад

Thank you Kenji. Very useful!

@KenjiExplains 20 дней назад

Thanks for wawtching :)

@ParthAnand-zc7en 21 день назад

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-wz1cf 11 дней назад

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

@divyv20 17 дней назад

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 ?

@willzinner8813 21 день назад

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

@KenjiExplains 21 день назад

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

@nishanth4323 21 день назад

Thanks 🙏🏻

@KenjiExplains 20 дней назад

You’re welcome 😊

@maxsolbiz4696 20 дней назад

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

@trunkbitz9168 16 дней назад

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.

@cliffordabere1790 20 дней назад

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

@itsjazzpelia5472 16 дней назад

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🤔

@sarahadel8621 6 дней назад

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

@vikashgarg1269 21 день назад

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

@KenjiExplains 20 дней назад

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

@vikashgarg1269 20 дней назад

@@KenjiExplains ok

@SportsHunterArea 17 дней назад

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

@osiomogieasekome8799 21 день назад

Why is the datedif formula hidden?

@KenjiExplains 20 дней назад

Not sure tbh!

@LyubomirRusanov 6 дней назад

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.