How to Make a Daily Activity Tracker in Excel

Learn how to build a simple but powerful daily activity tracker in Excel all the way from scratch.

LINK TO TEMPLATE

OTHER RESOURCES

VIDEO CHAPTERS
00:00 - Intro
00:49 - Build the Template
12:39 - How to Use Tips
13:21 - Outro

MUSIC TRACK
Track: Deep Dive
Music provided by Ikson™

[bikkavillivamsi]

Man, you have no idea how badly i needed this, thank you. It was fun building this from scratch and learnt new things. Have a great day.

[KdSteele-jtfq]

For the first time I found a creator who made it easy for beginners to learn. Thank you ❤

[meaganlong]

This was so much fun to build! I love getting the practice in with the graph. I can't wait to start using this!

[beemungie]

I have gone 36yrs intimidated working with excel and my boss asked me to create an excel worksheet….you made it so easy to follow and understand. Thank you so much, excel isn’t as daunting as it used to be. You are the best!

[Still_Hre]

Ngl this was a pretty random midnight activity but you made it very easy to follow even though ive barely used excel since highschool and I think your channel alone will make me want to get back into it. Thank you!

[LordshipWindows-egbr]

Thanks. Easy to follow. I'll try this out.

[ayishashah]

Thanks a lot, I do the same step by step and I succeeded 🎉 appreciate your support, it was so easy with you ❤

[gurupravin]

Simple and Good One which i needed, very clear and slow Guidance to create this, Thanks

[nourahahmed]

It’s really clear you make it very easy..thank you

[bharat-k]

Amazing video such a nice step by step walkthrough.

[koumsmr]

How I wish I recorded how our supervisor made us a tracker. It was good. One cool and helpful function was when you completed the requirements. The color also changes. He also put a function wherein you are reminded to call a department because after 3 days it a color red in the cell will appear. I regret not doing that. Cuz it will be of great help.

[artsaddi]

Hi! Thanks for the tutorial. Very informative. Do you know if I could apply these methods in Microsoft Excel 2003?

[ketsiasanon]

This was soo helpful. Can you give me some tips on how to creat and excel tracker for a bi weekly meeting where the team members can go in and list their topics for that week? I have a basic one with the dates in one column then the next column I have topic as the header then 4 spaces

[bmanmitch]

Followed up to 10:36 selected range B2 thru C4 and selected the 100% stacked bar option but once my chart appears there are no bars shown then when I right click the chart I do not have the " Format data series" option, mine shows "Format plot area" ..If you can advise me where I may have made a mistake it would be greatly appreciated. Also I noticed once you entered the first formula back at 9:45 the number 2 appeared in cell C2 but only the number 0 appeared in C2 for me.

[tuneshiaroach]

can you merge this with another spreadsheet?

[Idk-dwgs]

Is possible to add the number of percentages in bar chart? Instead of being blank green or yellow.