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 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
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 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
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. 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?
@@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😢
![Lethal Company Music Video 🎵 "Follow The Orders" [VERSION A]](http://i.ytimg.com/vi/QeooZB4Z7RA/mqdefault.jpg)
👉 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!!! 🙂
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!
Thanks Kenji you're so far the best 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 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/
Thanks a lot Kenji, this one of wonderful tutorial.
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
Awesome work Kenji, thank you
Will replicate this. Thank you for all that you do
i have learned a lot excel tips from you.waiting for another Video❤
Amazing and super helpful!!! Thank you!!
thank you,kenji!keep it up!
Hello! I am been waiting for a simple vidio like this to make habbit tracker
Glad it was helpful!
Such a useful template!!
Glad you think so!
Very well, ty bro.
😃
Amazing 💯
thanks kenji 😍
You're welcome :)
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.
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 :)
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 👍🏻
Wow, I will watch this later
thanks!
Great as usual 🎉🎉🎉
Any method to color the line chart red if the score is below 60%?
Maybe we could create a daily sales dashboard and the Kpis to track it, can you include in your next example please
*SEARCH*
I am making a fin model for my cfa. Still want to make this delight
Awesome!
Make a video on wheel strategy dashboard/tracker
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"?
How do you modify the dates to reflect only Monday-Friday each week?
Thank you!
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
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?
Does this only work for the checks? I’m using the x and I have 15 habits, it keeps giving me 100% completed
Hey Kenji I am facing difficulty to access the date file.
best
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
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
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 ☹️☹️
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😢
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