5 Excel Formulas Everyone Should Know

Top Excel formulas/functions you should know.
🚀Get FREE Excel chart templates from Hubspot: clickhubspot.com/wuo
🆓 DOWNLOAD Free Excel file for this video: careerprinciples.myflodesk.co...
LEARN:
👉 Excel for Business & Finance Course: www.careerprinciples.com/cour...
🔥Power BI for Business Analytics: www.careerprinciples.com/cour...
📈 The Complete Finance & Valuation Course: www.careerprinciples.com/cour...
🚀 All our courses: www.careerprinciples.com/courses
In this tutorial we go over 5 excel formulas or functions everyone should know. To follow along, you can download the excel file linked in this video. The five formulas are the convert function, which very few people know about. Second is the filter function, then the sequence function, followed by the xlookup function. Finally, we'll have the sumifs function. Then, at the very end we'll go over a surprise bonus function you probably don't know. For each formula, we'll go over an easy example and a hard one!
SOCIALS:
📸 Instagram - careerprinc...
🤳 TikTok - / career_principles
🧑‍💻 LinkedIn - / careerprinciples
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00​ -​ Convert Function
2:05​ - Filter Function
5:23​ - Sequence Function
7:05​ - Xlookup Function
10:21​ - Sumifs Function
12:58 Bonus Function

[@KenjiExplains]

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

[@09deekshith]

Literally been searching about *fanta* things for months. Finally found it. Thanks alot❤

[@KenjiExplains]

Glad I could help!

[@carolinaforbes5020]

awesome!thank you,kenji!

[@moniqued3778]

Thank you 4 sharing your expertise. Such a blessing.

[@pulakchakma5947]

Thanks Kenji! All of your videos on Excel are very helpful.

[@joeonk]

Excellent explanation of formulas.

[@prafulchavan3845]

You are explaining so easily, videos are very helpful.

[@excelgazialimuhiddinhacibekir]

A useful, helpful and also joyful collection of Excel formulas for daily data analysis/analytics tasks, Well done! Impeccable presentation and video, Kenji! A targeted choice of a set of problems indeed! Thanks a lot!

[@vitoc.1535]

Excellent and simple explanations that are easy to understand, thank you!

[@KenjiExplains]

Great to hear!

[@antonynganga7868]

Beautiful lesson Kenjie..it's easy to forget some of these formulas if you're just used to specific ones.

[@KenjiExplains]

Thank you!

[@camlex6310]

Super helpful video!!

[@khanhhuyenhoang9576]

Really appreciate your explaination. Thanks a million

[@KenjiExplains]

Appreciate you :)

[@antoniop.3586]

Great video! Very useful. Thank you very much!

[@KenjiExplains]

Glad it was helpful :)

[@user-kp2mi3mr5w]

Great video as always, fellow Excel enthusiast

[@NaveenKumar-wi7wm]

Didn't knew about that fanta things, thanx man

[@KenjiExplains]

Thanks for letting me know :)

[@Michael_Alaska]

As always, very informative video. I did play around with the Sumifs formula to make it dynamic, using "*"&H2&"*" instead of "*Fanta*".

[@sasavienne]

This is an excellent video with great and truly helpful formulas. I know many of them and keep using them all the time at work. Thanks once again.

[@KenjiExplains]

Glad it was helpful!

[@abiodunalade7368]

Waww Thanks for this life Saver

[@charanm2819]

Thanks for briefly explaining

[@KenjiExplains]

My pleasure!

[@marcogiubar]

Grazie !! Veramente utile e bravo ad esporre! Continua così!

[@KenjiExplains]

Grazie mille! Hopefully I said that right haha

[@joshuasarpong1194]

Thank you for these videos. Pretty helpful

[@KenjiExplains]

Glad it was helpful!

[@joshuasarpong1194]

🤗

[@musamaiza6259]

Thanks for this helpful video. Really helpful

[@KenjiExplains]

Glad to hear that!

[@Prettorian]

Nice one, Kenji!👍

[@KenjiExplains]

Many thanks!!

[@hiprateek025]

In the SUMIFs function, you can reference the cell using &H2& between * to make it dynamic. Overall, a great video.

[@engineeringbook8955]

Really great 👍

[@benny9321]

Thank so much

[@dominatorgaming2980]

Thank you for the video ❤️👍👍🙏

[@KenjiExplains]

Thank you too!

[@PK-hj8vx]

Ur simply superb❤

[@ruslanazimov8616]

Thanks really helpful

[@KenjiExplains]

Glad it helped!!

[@brightappiah7809]

Thanks.. for the Fanta solution

[@KenjiExplains]

haha lets go!

[@arezoozare5294]

Awesome 😎😎 how to find duplicate values with multiple criteria in excel. I appreciate if make a video about that. Thanks a lot...🤗

[@mayuronce]

Kenji ... Ur awesome bro 🎉

[@KenjiExplains]

Thank you man!

[@ragulmarley4900]

Really helpful 🎉

[@KenjiExplains]

Glad it was helpful!!

[@user-wv3wk3iu6d]

Thanks for this great video, I did saving the ecxel as templete and in the folder you mentioned, however when I open new excel the templete not work with me 🤨

[@mohammadusmanshafi696]

Excellent. I know four of them. But excluding bonus formula and convert

[@KenjiExplains]

Awesome! Thanks for your comment :)

[@Jobat98]

Which version is this Excel? This is superb!

[@rabiasami4208]

Really useful

[@KenjiExplains]

Glad to hear that thank you

[@chenkeith7272]

Thanks for sharing. I have a question for countif and countifs. Not only do I want to count, but I also I want excel to highlight or bold or cell fill color those counted from the data all at one goal. Can it be done? Thanks

[@willzinner8813]

didnt know convert thank you

[@KenjiExplains]

thanks for watching!

[@ohdjrp4]

=DATE(YEAR(G3),MONTH(G3),SEQUENCE(DAY(EOMONTH(G3,0)))) in cell G3, where you type the start date. I think the formula above is dynamic. Thanks for the video!

[@lonerpirate]

Oppa you’re the best

[@KenjiExplains]

ahah thank you!

[@sudarshanshetty9663]

filter formula is it possible to add total amount column at end

[@gduke25]

For the "Filter" function, I find it much easier to just hi "ctrl+shift+L" which makes the data set a more intuitive filter.

[@sql638]

Yeah but you can’t visualize the whole starting table then

[@dakshbhatnagar]

13:47 Can we do WEEKDAYS function here instead?

[@shaikhyaseen8322]

Hey can i get this data to apply logic by using your data ? If so pls provide us

[@Nevermindme87]

Can we use the "**" in the function Filter() ?

[@j-suahcomedyshouse5888]

Thanks for the lesson but I'm having little problem performing this function to find the sum where cell A1 contain 76 ,B1 87 C1 67 Divided by 3 plus 76 in cell D1 divided by 2 to display in cell E1. Please I need your help.🙏

[@kelvinchan4362]

In the SUMIFs function, how can we avoid including any words/strings that contain "fanta" (e.g. fantacy which also contain "fanta") while using wild card * *?

[@user-kp2mi3mr5w]

Great question, would like to know too

[@yourgamingspot6754]

xlookup formula is not showing in my excel workbook

[@familiensmalfod4339]

IIn my exel under data the ticker symbol are not to find how do I get it visual?

[@rajdantani636]

Please let me know how to remove national holidays when we use networkdays formula.

[@mikedbman]

There is a 3rd parameter in the Networkdays formula. It could be like this: =NETWORKDAYS("1/1/2020","12/31/2020",K14:K20) where K14:K20 has a list of specific days you wish to recognize as holidays. If you don't use that parameter, it defaults to the "standard" holidays. There is a different formula NETWORKDAYS.INTL() that calculates the number of weekdays between two dates, but lets you specify which days should be counted as weekend days.

[@abdubakanayo1254]

Sequence Function isn't working on my Excel, what could be the issue? Kindly support, thank you.

[@nishanth4323]

First 🥇😅🙏

[@KenjiExplains]

haha let's go!

[@user-ud4fg2gs5h]

No idea what the sequence was about

[@RahulDarekar-ub1eb]

How to convert a date i.e 26 June, 2024 10:09:12 to ddmmyy hh:mm:ss

[@creationsoffarzid1154]

Hi Grayson, have you checked out the videos on the scientific and mathematical miracles of the Quran ? The more research you do , the more your questions will be answered.