5 Excel Formulas Everyone Should Know
ฝัง
- เผยแพร่เมื่อ 4 ส.ค. 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
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.
Thanks Kenji! All of your videos on Excel are very helpful.
awesome!thank you,kenji!
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!
You are explaining so easily, videos are very helpful.
Excellent explanation of formulas.
Excellent and simple explanations that are easy to understand, thank you!
Great to hear!
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*".
Beautiful lesson Kenjie..it's easy to forget some of these formulas if you're just used to specific ones.
Thank you!
Great video as always, fellow Excel enthusiast
Waww
Thanks for this life Saver
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!
Great video! Very useful. Thank you very much!
Glad it was helpful :)
Really appreciate your explaination. Thanks a million
Appreciate you :)
Didn't knew about that fanta things, thanx man
Thanks for letting me know :)
Really great 👍
Grazie !! Veramente utile e bravo ad esporre! Continua così!
Grazie mille! Hopefully I said that right haha
Thank so much
In the SUMIFs function, you can reference the cell using &H2& between * to make it dynamic. Overall, a great video.
Thanks for briefly explaining
My pleasure!
Thanks for this helpful video. Really helpful
Glad to hear that!
Ur simply superb❤
Nice one, Kenji!👍
Many thanks!!
Thank you for these videos. Pretty helpful
Glad it was helpful!
🤗
Thank you for the video ❤️👍👍🙏
Thank you too!
Awesome 😎😎
how to find duplicate values with multiple criteria in excel.
I appreciate if make a video about that.
Thanks a lot...🤗
Thanks.. for the Fanta solution
haha lets go!
Thanks really helpful
Glad it helped!!
Excellent. I know four of them. But excluding bonus formula and convert
Awesome! Thanks for your comment :)
=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!
Really helpful 🎉
Glad it was helpful!!
Really useful
Glad to hear that thank you
Kenji ... Ur awesome bro 🎉
Thank you man!
Which version is this Excel?
This is superb!
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 🤨
didnt know convert thank you
thanks for watching!
Oppa you’re the best
ahah thank you!
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
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
filter formula is it possible to add total amount column at end
Can you show a count of each different item
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() ?
13:47 Can we do WEEKDAYS function here instead?
IIn my exel under data the ticker symbol are not to find how do I get it visual?
Hey can i get this data to apply logic by using your data ? If so pls provide us
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
xlookup formula is not showing in my excel workbook
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.
Sequence Function isn't working on my Excel, what could be the issue? Kindly support, thank you.
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.