5 Excel Formulas Everyone Should Know
Рет қаралды 67,541
Күн бұрын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 7 ай бұрын
🚀Get FREE Excel chart templates from Hubspot: clickhubspot.com/wuo
@09deekshith 7 ай бұрын
Literally been searching about *fanta* things for months. Finally found it. Thanks alot❤
@KenjiExplains 7 ай бұрын
Glad I could help!
@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 7 ай бұрын
Excellent and simple explanations that are easy to understand, thank you!
@KenjiExplains 7 ай бұрын
Great to hear!
@moniqued3778 3 ай бұрын
Thank you 4 sharing your expertise. Such a blessing.
@pulakchakma5947 Ай бұрын
Thanks Kenji! All of your videos on Excel are very helpful.
@antonynganga7868 7 ай бұрын
Beautiful lesson Kenjie..it's easy to forget some of these formulas if you're just used to specific ones.
@KenjiExplains 7 ай бұрын
Thank you!
@carolinaforbes5020 6 ай бұрын
awesome!thank you,kenji!
@joeonk 6 ай бұрын
Excellent explanation of formulas.
@prafulchavan3845 4 ай бұрын
You are explaining so easily, videos are very helpful.
@khanhhuyenhoang9576 7 ай бұрын
Really appreciate your explaination. Thanks a million
@KenjiExplains 7 ай бұрын
Appreciate you :)
@antoniop.3586 7 ай бұрын
Great video! Very useful. Thank you very much!
@KenjiExplains 7 ай бұрын
Glad it was helpful :)
@sasavienne 7 ай бұрын
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 7 ай бұрын
Glad it was helpful!
@Michael_Alaska 5 ай бұрын
As always, very informative video. I did play around with the Sumifs formula to make it dynamic, using "*"&H2&"*" instead of "*Fanta*".
@camlex6310 7 ай бұрын
Super helpful video!!
@marcogiubar 6 ай бұрын
Grazie !! Veramente utile e bravo ad esporre! Continua così!
@KenjiExplains 6 ай бұрын
Grazie mille! Hopefully I said that right haha
@charanm2819 7 ай бұрын
Thanks for briefly explaining
@KenjiExplains 7 ай бұрын
My pleasure!
@abiodunalade7368 6 ай бұрын
Waww Thanks for this life Saver
@joshuasarpong1194 7 ай бұрын
Thank you for these videos. Pretty helpful
@KenjiExplains 7 ай бұрын
Glad it was helpful!
@joshuasarpong1194 7 ай бұрын
🤗
@user-kp2mi3mr5w 5 ай бұрын
Great video as always, fellow Excel enthusiast
@musamaiza6259 6 ай бұрын
Thanks for this helpful video. Really helpful
@KenjiExplains 6 ай бұрын
Glad to hear that!
@NaveenKumar-wi7wm 7 ай бұрын
Didn't knew about that fanta things, thanx man
@KenjiExplains 7 ай бұрын
Thanks for letting me know :)
@benny9321 2 ай бұрын
Thank so much
@hiprateek025 5 ай бұрын
In the SUMIFs function, you can reference the cell using &H2& between * to make it dynamic. Overall, a great video.
@engineeringbook8955 5 ай бұрын
Really great 👍
@dominatorgaming2980 7 ай бұрын
Thank you for the video ❤️👍👍🙏
@KenjiExplains 7 ай бұрын
Thank you too!
@ruslanazimov8616 7 ай бұрын
Thanks really helpful
@KenjiExplains 7 ай бұрын
Glad it helped!!
@brightappiah7809 7 ай бұрын
Thanks.. for the Fanta solution
@KenjiExplains 7 ай бұрын
haha lets go!
@PK-hj8vx 4 ай бұрын
Ur simply superb❤
@Prettorian 7 ай бұрын
Nice one, Kenji!👍
@KenjiExplains 7 ай бұрын
Many thanks!!
@mohammadusmanshafi696 7 ай бұрын
Excellent. I know four of them. But excluding bonus formula and convert
@KenjiExplains 7 ай бұрын
Awesome! Thanks for your comment :)
@rabiasami4208 7 ай бұрын
Really useful
@KenjiExplains 7 ай бұрын
Glad to hear that thank you
@ragulmarley4900 7 ай бұрын
Really helpful 🎉
@KenjiExplains 7 ай бұрын
Glad it was helpful!!
@arezoozare5294 6 ай бұрын
Awesome 😎😎 how to find duplicate values with multiple criteria in excel. I appreciate if make a video about that. Thanks a lot...🤗
@ohdjrp4 4 ай бұрын
=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!
@willzinner8813 7 ай бұрын
didnt know convert thank you
@KenjiExplains 7 ай бұрын
thanks for watching!
@mayuronce 7 ай бұрын
Kenji ... Ur awesome bro 🎉
@KenjiExplains 7 ай бұрын
Thank you man!
@Jobat98 6 ай бұрын
Which version is this Excel? This is superb!
@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 🤨
@lonerpirate 7 ай бұрын
Oppa you’re the best
@KenjiExplains 7 ай бұрын
ahah thank you!
@chenkeith7272 3 ай бұрын
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
@gduke25 3 ай бұрын
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 3 ай бұрын
Yeah but you can’t visualize the whole starting table then
@sudarshanshetty9663 7 ай бұрын
filter formula is it possible to add total amount column at end
@Nevermindme87 5 ай бұрын
Can we use the "**" in the function Filter() ?
@j-suahcomedyshouse5888 4 ай бұрын
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.🙏
@dakshbhatnagar 7 ай бұрын
13:47 Can we do WEEKDAYS function here instead?
@shaikhyaseen8322 4 ай бұрын
Hey can i get this data to apply logic by using your data ? If so pls provide us
@familiensmalfod4339 4 ай бұрын
IIn my exel under data the ticker symbol are not to find how do I get it visual?
@kelvinchan4362 5 ай бұрын
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 5 ай бұрын
Great question, would like to know too
@yourgamingspot6754 7 ай бұрын
xlookup formula is not showing in my excel workbook
@abdubakanayo1254 4 ай бұрын
Sequence Function isn't working on my Excel, what could be the issue? Kindly support, thank you.
@rajdantani636 6 ай бұрын
Please let me know how to remove national holidays when we use networkdays formula.
@mikedbman 6 ай бұрын
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.
@nishanth4323 7 ай бұрын
First 🥇😅🙏
@KenjiExplains 7 ай бұрын
haha let's go!
@user-ud4fg2gs5h 5 ай бұрын
No idea what the sequence was about
@RahulDarekar-ub1eb 3 ай бұрын
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.
Leila Gharani
Рет қаралды 229 М.