5 Excel Formulas Everyone Should Know

[@KenjiExplains]

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

[@Dimpalrajkumar]

Thanks Kenji! You are really fantastic in explaining concepts in slow and crystal clear.

[@09deekshith]

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

[@KenjiExplains]

Glad I could help!

[@vitoc.1535]

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

[@KenjiExplains]

Great to hear!

[@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!

[@antonynganga7868]

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

[@KenjiExplains]

Thank you!

[@pulakchakma5947]

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

[@NaveenKumar-wi7wm]

Didn't knew about that fanta things, thanx man

[@KenjiExplains]

Thanks for letting me know :)

[@tejasd1980]

very nice video, thanks Kenji

[@prafulchavan3845]

You are explaining so easily, videos are very helpful.

[@khanhhuyenhoang9576]

Really appreciate your explaination. Thanks a million

[@KenjiExplains]

Appreciate you :)

[@hiprateek025]

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

[@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 🤨

[@moniqued3778]

Thank you 4 sharing your expertise. Such a blessing.

[@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

[@Michael_Alaska]

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

[@UsmanAfzal-h1s]

Great video as always, fellow Excel enthusiast

[@antoniop.3586]

Great video! Very useful. Thank you very much!

[@KenjiExplains]

Glad it was helpful :)

[@charanm2819]

Thanks for briefly explaining

[@KenjiExplains]

My pleasure!

[@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!

[@arezoozare5294]

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

[@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!

[@joeonk]

Excellent explanation of formulas.

[@carolinaforbes5020]

awesome!thank you,kenji!

[@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.🙏

[@musamaiza6259]

Thanks for this helpful video. Really helpful

[@KenjiExplains]

Glad to hear that!

[@marcogiubar]

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

[@KenjiExplains]

Grazie mille! Hopefully I said that right haha

[@abiodunalade7368]

Waww Thanks for this life Saver

[@camlex6310]

Super helpful video!!

[@benny9321]

Thank so much

[@brightappiah7809]

Thanks.. for the Fanta solution

[@KenjiExplains]

haha lets go!

[@Jobat98]

Which version is this Excel? This is superb!

[@Prettorian]

Nice one, Kenji!👍

[@KenjiExplains]

Many thanks!!

[@mohammadusmanshafi696]

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

[@KenjiExplains]

Awesome! Thanks for your comment :)

[@engineeringbook8955]

Really great 👍

[@Nevermindme87]

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

[@PK-hj8vx]

Ur simply superb❤

[@dominatorgaming2980]

Thank you for the video ❤️👍👍🙏

[@KenjiExplains]

Thank you too!

[@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

[@joshuasarpong1194]

Thank you for these videos. Pretty helpful

[@KenjiExplains]

Glad it was helpful!

[@joshuasarpong1194]

🤗

[@ruslanazimov8616]

Thanks really helpful

[@KenjiExplains]

Glad it helped!!

[@willzinner8813]

didnt know convert thank you

[@KenjiExplains]

thanks for watching!

[@mayuronce]

Kenji ... Ur awesome bro 🎉

[@KenjiExplains]

Thank you man!

[@shaikhyaseen8322]

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

[@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 * *?

[@UsmanAfzal-h1s]

Great question, would like to know too

[@LeaMoralesMendez-sd9cr]

Can you show a count of each different item

[@ragulmarley4900]

Really helpful 🎉

[@KenjiExplains]

Glad it was helpful!!

[@familiensmalfod4339]

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

[@lonerpirate]

Oppa you’re the best

[@KenjiExplains]

ahah thank you!

[@rabiasami4208]

Really useful

[@KenjiExplains]

Glad to hear that thank you

[@abdubakanayo1254]

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

[@sudarshanshetty9663]

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

[@dakshbhatnagar]

13:47 Can we do WEEKDAYS function here instead?

[@yourgamingspot6754]

xlookup formula is not showing in my excel workbook

[@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.

[@GaryMoore-q8z]

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.

[@nishanth4323]

First 🥇😅🙏

[@KenjiExplains]

haha let's go!