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!
=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!
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
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 🤨
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.🙏
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 * *?
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.
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.
🚀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!
I absolutely love how you simplify and explain things. Thank you very much and keep up your good work
Thanks Kenji! You are really fantastic in explaining concepts in slow and crystal clear.
Beautiful lesson Kenjie..it's easy to forget some of these formulas if you're just used to specific ones.
Thank you!
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!
Excellent and simple explanations that are easy to understand, thank you!
Great to hear!
Thanks Kenji! All of your videos on Excel are very helpful.
As always, very informative video. I did play around with the Sumifs formula to make it dynamic, using "*"&H2&"*" instead of "*Fanta*".
In the SUMIFs function, you can reference the cell using &H2& between * to make it dynamic. Overall, a great video.
Didn't knew about that fanta things, thanx man
Thanks for letting me know :)
You are explaining so easily, videos are very helpful.
Thank you 4 sharing your expertise. Such a blessing.
=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 appreciate your explaination. Thanks a million
Appreciate 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
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 🤨
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!
Awesome 😎😎
how to find duplicate values with multiple criteria in excel.
I appreciate if make a video about that.
Thanks a lot...🤗
Great video as always, fellow Excel enthusiast
Great video! Very useful. Thank you very much!
Glad it was helpful :)
13:47 Can we do WEEKDAYS function here instead?
Thanks for briefly explaining
My pleasure!
THANK YOU!
Excellent. I know four of them. But excluding bonus formula and convert
Awesome! Thanks for your comment :)
Which version is this Excel?
This is superb!
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.🙏
very nice video, thanks Kenji
awesome!thank you,kenji!
Excellent explanation of formulas.
Can we use the "**" in the function Filter() ?
Grazie !! Veramente utile e bravo ad esporre! Continua così!
Grazie mille! Hopefully I said that right haha
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
Thanks for this helpful video. Really helpful
Glad to hear that!
Thank you for the video ❤️👍👍🙏
Thank you too!
filter formula is it possible to add total amount column at end
Nice one, Kenji!👍
Many thanks!!
Really great 👍
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
Hey can i get this data to apply logic by using your data ? If so pls provide us
Ur simply superb❤
Super helpful video!!
Thank you for these videos. Pretty helpful
Glad it was helpful!
🤗
Thanks.. for the Fanta solution
haha lets go!
Waww
Thanks for this life Saver
Thank so much
IIn my exel under data the ticker symbol are not to find how do I get it visual?
Kenji ... Ur awesome bro 🎉
Thank you man!
Can you show a count of each different item
Oppa you’re the best
ahah thank you!
Thanks really helpful
Glad it helped!!
Really helpful 🎉
Glad it was helpful!!
didnt know convert thank you
thanks for watching!
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.
Really useful
Glad to hear that thank you
How to convert a date i.e 26 June, 2024 10:09:12 to ddmmyy hh:mm:ss
First 🥇😅🙏
haha let's go!
No idea what the sequence was about
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.