5 Excel Formulas Everyone Should Know
Vložit
- čas přidán 11. 06. 2024
- 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
🚀Get FREE Excel chart templates from Hubspot: clickhubspot.com/wuo
Thanks Kenji! All of your videos on Excel are very helpful.
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!
Literally been searching about *fanta* things for months. Finally found it. Thanks alot❤
Glad I could help!
Thank you 4 sharing your expertise. Such a blessing.
You are explaining so easily, videos are very helpful.
Excellent explanation of formulas.
Beautiful lesson Kenjie..it's easy to forget some of these formulas if you're just used to specific ones.
Thank you!
awesome!thank you,kenji!
Excellent and simple explanations that are easy to understand, thank you!
Great to hear!
Really appreciate your explaination. Thanks a million
Appreciate you :)
Great video! Very useful. Thank you very much!
Glad it was helpful :)
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.
Glad it was helpful!
Super helpful video!!
As always, very informative video. I did play around with the Sumifs formula to make it dynamic, using "*"&H2&"*" instead of "*Fanta*".
Great video as always, fellow Excel enthusiast
Didn't knew about that fanta things, thanx man
Thanks for letting me know :)
Thanks for briefly explaining
My pleasure!
Waww
Thanks for this life Saver
Thank so much
Thank you for these videos. Pretty helpful
Glad it was helpful!
🤗
Thanks for this helpful video. Really helpful
Glad to hear that!
Grazie !! Veramente utile e bravo ad esporre! Continua così!
Grazie mille! Hopefully I said that right haha
Really great 👍
Nice one, Kenji!👍
Many thanks!!
Thank you for the video ❤️👍👍🙏
Thank you too!
In the SUMIFs function, you can reference the cell using &H2& between * to make it dynamic. Overall, a great video.
Thanks really helpful
Glad it helped!!
Thanks.. for the Fanta solution
haha lets go!
Ur simply superb❤
Really helpful 🎉
Glad it was helpful!!
Kenji ... Ur awesome bro 🎉
Thank you man!
Excellent. I know four of them. But excluding bonus formula and convert
Awesome! Thanks for your comment :)
Really useful
Glad to hear that thank you
Awesome 😎😎
how to find duplicate values with multiple criteria in excel.
I appreciate if make a video about that.
Thanks a lot...🤗
didnt know convert thank you
thanks for watching!
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 🤨
Oppa you’re the best
ahah thank you!
Which version is this Excel?
This is superb!
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
=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!
filter formula is it possible to add total amount column at end
Hey can i get this data to apply logic by using your data ? If so pls provide us
For the "Filter" function, I find it much easier to just hi "ctrl+shift+L" which makes the data set a more intuitive filter.
Yeah but you can’t visualize the whole starting table then
13:47 Can we do WEEKDAYS function here instead?
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.🙏
Can we use the "**" in the function Filter() ?
IIn my exel under data the ticker symbol are not to find how do I get it visual?
xlookup formula is not showing in my excel workbook
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 * *?
Great question, would like to know too
Sequence Function isn't working on my Excel, what could be the issue? Kindly support, thank you.
Please let me know how to remove national holidays when we use networkdays formula.
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.
First 🥇😅🙏
haha let's go!
No idea what the sequence was about
How to convert a date i.e 26 June, 2024 10:09:12 to ddmmyy hh:mm:ss
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.