How to Make a Daily Activity Tracker in Excel

[@spreadsheetlife]

For those that are interested, check out my new Excel course here: spreadsheetlife.com/excel-launchpad-course/

[@beemungie9184]

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!

[@spreadsheetlife]

Thank you so much for your kind words! I'm so glad you were able to follow and learn along the way! 😄👍

[@KdSteele-jt5fq]

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

[@spreadsheetlife]

Thank you so much for your kind words. I'm so glad that you were able to follow along and learn! 😊👍

[@bikkavillivamsi1071]

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.

[@spreadsheetlife]

That's awesome! I'm so glad you found this video and had fun building the template!

[@Still_H3re]

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!

[@spreadsheetlife]

That is absolutely awesome to hear! Thank you so much for sharing. It's crazy what you might stumble upon in the middle of the night. Anyway, I hope you do get back into it. Excel can be the gateway to a lot of amazing things. 😄

[@nourahahmed9005]

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

[@spreadsheetlife]

You're very welcome! Thank you for your feedback. 😊

[@meaganlong2055]

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

[@spreadsheetlife]

I'm so glad you enjoyed building the template and now have it to use on a daily basis! 😄

[@ayishashah7942]

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

[@spreadsheetlife]

That's so amazing to hear!! 😄🎉 Thank you for sharing!

[@gurupravin1401]

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

[@spreadsheetlife]

You're very welcome! Thank you for your feedback.

[@bharat-1k]

Amazing video such a nice step by step walkthrough.

[@spreadsheetlife]

Thank you for your feedback. I'm so glad you enjoyed it!

[@user-ko3um5sm3r]

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.

[@spreadsheetlife]

Sounds like a super cool spreadsheet for sure!

[@ketsiasanon5]

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

[@spreadsheetlife]

I'm super glad you found this helpful! And yes for sure. It'd be easier for me to offer suggestions via email though if that's ok? Just email me and I can help from there. 👍

[@ketsiasanon5]

@@spreadsheetlife will do!

[@spreadsheetlife]

😊👍

[@LordshipWindows-eg3br]

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

[@spreadsheetlife]

Awesome! I hope it works for you!

[@vava1030]

Thank you ❤

[@spreadsheetlife]

You are very welcome! 😊👍

[@IVvOOvVI]

The best!!!

[@spreadsheetlife]

😄😊👍

[@elpangilinan7401]

Thank you so much!

[@spreadsheetlife]

You're welcome! 😊👍

[@JPerpetualKid_]

Thanks for this! :)

[@spreadsheetlife]

You are very welcome! 😄

[@arts4addi]

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

[@spreadsheetlife]

A lot of the methods will not be transferable to Excel 2003 unfortunately. I am so sorry that's the case.

[@pulchritudinouschannel7611]

thank you so much

[@spreadsheetlife]

You're very welcome! 😊

[@bmanmitch2005]

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.

[@spreadsheetlife]

Did you add in any sample data? This might be the issue. Adding sample data is a good way to help you build your formulas and charts.

[@bmanmitch2005]

@@spreadsheetlife Initially I did at a few rows but retried it by adding 10 rows of sample data with the same result.

[@spreadsheetlife]

Interesting. That's strange that you are still having trouble. If you want, send me an email with your spreadsheet attached, and I will happily take a look at it for you.

[@bmanmitch2005]

@@spreadsheetlife Thanks, will do.

[@bmanmitch2005]

@@spreadsheetlife I have just sent you the spreadsheet. Thanks again

[@Idk-dw7gs]

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

[@spreadsheetlife]

Yes it is. Click on the chart > Click the plus in the right corner > Select labels. I hope this helps.

[@tuneshiaroach7393]

It only gave how many tasks not percentages unless I’m doing it wrong 😑

[@spreadsheetlife]

Oh my gosh, that's right! I'm so sorry, I forgot that the chart is generated from counts for each task. You didn't do anything wrong, I gave you poor advice. I apologize. To add percentages, you would have to create a new data column, write a formula to calculate the percentages, and then change the chart so it uses the percentages as the source data. I know this can seem like a lot. If you are really interested in learning how to do this, send me an email and I can help more there.

[@IVvOOvVI]

@@spreadsheetlife I actually tried doing this today. I tracked the % of activities that were done by their priority using a pie graph and included the % as a label for each 3 slices. I use the countifs formula in my table and inserted the graph with the results of the calculation.

[@spreadsheetlife]

Very cool approach! Thanks for sharing. I love to hear how others take my creations and either modify them or add to them. 😄

[@tuneshiaroach7393]

can you merge this with another spreadsheet?

[@spreadsheetlife]

Hi there! By merge with another spreadsheet, do you mean add this particular worksheet to another workbook? If so, yes you can. Follow these steps. 1 - Open both workbooks on your computer (this one and your other one) 2 - In the Daily Activity Tracker workbook, right-click on the worksheet tab and select Move or Copy. 3 - Under "To Book", select your other workbook. 4 - Select (move to end) 5 - Check create a copy. 6 - Click ok. I hope this helps!