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.
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/
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
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
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).
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"?
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.
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?
@@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.
Great video Kenji. It has blown my mind, specially the "Total completed" trick. Thank you very much!!! 🙂
Thanks Kenji you're so far the best teacher
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/
i have learned a lot excel tips from you.waiting for another Video❤
Awesome work Kenji, 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
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!
Perfect teacher
This was a great help thank you
Thanks a lot Kenji, this one of wonderful tutorial.
Will replicate this. Thank you for all that you do
Amazing and super helpful!!! Thank you!!
Hello! I am been waiting for a simple vidio like this to make habbit tracker
Glad it was helpful!
thank you,kenji!keep it up!
❤JUST AMAZING
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 :)
Such a useful template!!
Glad you think so!
Very well, ty bro.
😃
Thanks a lot it helped so much ✨
thanks kenji 😍
You're welcome :)
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).
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))
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"?
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.
Wow, I will watch this later
Maybe we could create a daily sales dashboard and the Kpis to track it, can you include in your next example please
How do you modify the dates to reflect only Monday-Friday each week?
Thank you!
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?
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
I am making a fin model for my cfa. Still want to make this delight
Awesome!
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: th-cam.com/video/RAAwSmjlGoQ/w-d-xo.html
Hey Bro you got any financial model for a phone repair shop?
thanks!
Hey Kenji I am facing difficulty to access the date file.
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! 😃
Make a video on wheel strategy dashboard/tracker
I cant find the check box in the insert ribbon can someone help me
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.
Sir am unable to add c/25counta %
I tired it 10times but it's not calculating ☹️☹️
WHAT IF I WANTS TO ONLY DO A THING IN MON AND SAT
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
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!
*SEARCH*
best
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