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!
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 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!
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.