Thank you, Kenji. I came to learn excel from no experience (beginner) to advance. Your expertise provided in your program is a great asset for me to learn and apply to my job. Thank you.
Congratulations! I have been following CP for a long time: excel, SQL, powerbi and much more! Competent and precise teacher with exercises and examples on real cases. Looking forward to the new courses! Financial modelling ? Or something else? Ema
I love your videos and the way you explain everything. This is not only very cool project but can also help us track our habits to achieve success. Thanks a lot Kenji/
Mmmmmmm........, This's superb and brilliant, 😇 I doubt if I can afford to skip any of your videos, I will always like and share your link, Your teaching is too simple, "casual" assimilating and irresistible.
I like this idea! I might personally expand it a little further, by renaming "Worst habit" to "Need to work on", then using a formula to show the bottom 3 habits, but only if the completion rate is below a certain threshold
Hey Kenji. Great habit planner and great job as always. My question is, when two or more habits have equal number of checks, the xlookup formula will return #value error. Possible solution to change it with an if statement to return message like "two or more habits"?
Greetings I don't know if you would understand my question and is as follows: How do I handle zeros in spill functions, when it is supposed to be blank, or when my answer is zero or has a zero?
Bro make a Google form, and you do not have to open sheet again and again, else you learn GAS to customize whole sheet with automatic data entry with clicking button, which you can make using GAS(Google App Script).
To avoid a zero being displayed as a blank in the example with 0%, you should not use # in the formatting but 0. Then it is forced to display a number.
@@KenjiExplains you made one and it was amazing. I just wanted to know if there's more? Any advances or maybe a video on AI prompts for excel manipulations.
Hey, I followed all the steps, but counif is not working, it only shows zero, I have checked many times for formula and other ways but it’s not working, does someone has a solution😢
Did you use checkbox like the tutorial? I don't have checkbox, so instead of leaving the cell empty, you can type 0. Only then the 'COUNTA' formula works. Hope it helps!
👉 Take our Microsoft Office Bundle: www.careerprinciples.com/courses/microsoft-office-bundle
Thank you, Kenji. I came to learn excel from no experience (beginner) to advance. Your expertise provided in your program is a great asset for me to learn and apply to my job. Thank you.
Thanks Kenji you're so far the best teacher
Great video Kenji. It has blown my mind, specially the "Total completed" trick. Thank you very much!!! 🙂
Congratulations! I have been following CP for a long time: excel, SQL, powerbi and much more!
Competent and precise teacher with exercises and examples on real cases.
Looking forward to the new courses! Financial modelling ? Or something else?
Ema
I love your videos and the way you explain everything. This is not only very cool project but can also help us track our habits to achieve success. Thanks a lot Kenji/
Thank you so much for the tutorial. I learnt a lot while following along the tutorial.
Thank you Kenji. Love to you.
Perfect teacher
Mmmmmmm........, This's superb and brilliant, 😇 I doubt if I can afford to skip any of your videos, I will always like and share your link, Your teaching is too simple, "casual" assimilating and irresistible.
I like this idea! I might personally expand it a little further, by renaming "Worst habit" to "Need to work on", then using a formula to show the bottom 3 habits, but only if the completion rate is below a certain threshold
Thank you great suggestions!
Awesome work Kenji, thank you
i have learned a lot excel tips from you.waiting for another Video❤
This was a great help thank you
Will replicate this. Thank you for all that you do
Thanks a lot Kenji, this one of wonderful tutorial.
Thank you for the free finished file can you do this for your other videos too?
Glad it was helpful! Will keep it in mind :)
Thanks a lot it helped so much ✨
Such a useful template!!
Glad you think so!
Very well, ty bro.
😃
Amazing and super helpful!!! Thank you!!
thank you,kenji!keep it up!
thanks kenji 😍
You're welcome :)
Hello! I am been waiting for a simple vidio like this to make habbit tracker
Glad it was helpful!
❤JUST AMAZING
Amazing 💯
Great as usual 🎉🎉🎉
Any method to color the line chart red if the score is below 60%?
Hey Kenji. Great habit planner and great job as always. My question is, when two or more habits have equal number of checks, the xlookup formula will return #value error. Possible solution to change it with an if statement to return message like "two or more habits"?
Hi Kenji, the formula COUNTA is not working when x is used instead of check boxes. Is there a way around it?
This is how I handled it(cell numbers will be different): =C27/(COUNTBLANK(C14:C25)+COUNTA(C14:C25))
thanks!
How do you modify the dates to reflect only Monday-Friday each week?
Thank you!
Maybe we could create a daily sales dashboard and the Kpis to track it, can you include in your next example please
When will checkbox be available for all? Haha, been waiting on this feature for months
I don't have information on that unfortunately...I provided the x feature instaed of the checkbox as an alternative, but obviously not as elegant
Wow, I will watch this later
Make a video on wheel strategy dashboard/tracker
I am making a fin model for my cfa. Still want to make this delight
Awesome!
Hey Bro you got any financial model for a phone repair shop?
Greetings
I don't know if you would understand my question and is as follows:
How do I handle zeros in spill functions, when it is supposed to be blank, or when my answer is zero or has a zero?
Kenji, did you know that Python is available for preview on Windows' version of 365? Would it be possible to do some tutorial on that?
Hey, I already did: ruclips.net/video/RAAwSmjlGoQ/видео.html
Too hard to get in the habit of opening the excel file.
Lol...you could just keep it open then
😂
Add it to your startup folder and it will open every morning 👍🏻
Bro make a Google form, and you do not have to open sheet again and again, else you learn GAS to customize whole sheet with automatic data entry with clicking button, which you can make using GAS(Google App Script).
To avoid a zero being displayed as a blank in the example with 0%, you should not use # in the formatting but 0. Then it is forced to display a number.
Hey Kenji I am facing difficulty to access the date file.
Is there more A.I in excel? Please let us know
There's plenty of AI in Excel, maybe I can make a separate video on that!
@@KenjiExplains you made one and it was amazing. I just wanted to know if there's more? Any advances or maybe a video on AI prompts for excel manipulations.
Does this only work for the checks? I’m using the x and I have 15 habits, it keeps giving me 100% completed
I have faced this problem too! Instead of leaving the cell empty, it works if you type 0 on the cell. Hope it helps! 😃
WHAT IF I WANTS TO ONLY DO A THING IN MON AND SAT
I cant find the check box in the insert ribbon can someone help me
best
Can I open it in Apple numbers?
Hey I'm not sure tbh but you should be able to install Excel for free in your computer
Sir am unable to add c/25counta %
I tired it 10times but it's not calculating ☹️☹️
Hey, I followed all the steps, but counif is not working, it only shows zero, I have checked many times for formula and other ways but it’s not working, does someone has a solution😢
Did you use checkbox like the tutorial? I don't have checkbox, so instead of leaving the cell empty, you can type 0. Only then the 'COUNTA' formula works. Hope it helps!
trash
NO FILE CAME THROUGH JUST HEADER WTF!
The file has 2 tabs (see the bottom left area) go to the second one for the full tracker