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/

[@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!

[@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! 😊👍

[@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! 😄

[@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. 😄

[@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.

[@syan_mblcd]

A lifesaver. Thank you so much for this!

[@spreadsheetlife]

Of course! Thank you for watching! 😊

[@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!

[@EngRaid-uz4uo]

Thank you so much for your help and Explanation for this. ❤

[@spreadsheetlife]

Of course! Thank you for watching!! 😄

[@nourahahmed9005]

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

[@spreadsheetlife]

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

[@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

[@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!

[@Anbesivam1818]

Awsome man ❤

[@spreadsheetlife]

😄👍

[@bharat-1k]

Amazing video such a nice step by step walkthrough.

[@spreadsheetlife]

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

[@JPerpetualKid_]

Thanks for this! :)

[@spreadsheetlife]

You are very welcome! 😄

[@motoporn9055]

how to create more vertical lines in one column? Also to expand the size of a single cell? Thank you

[@spreadsheetlife]

To expand the size of a single cell, you must increase the column width or row height of that cell. I hope that makes sense. As for you other question, I don't quite understand. Could you re-phrase it for me?

[@motoporn9055]

@@spreadsheetlife thank you so much... For other question... What I mean is, I wanted to create more lines within one column. I just wish to divide one column the into three.. is this possible?

[@spreadsheetlife]

Oh I understand now. Unfortunately, for this specific build, you will not be able to do that. This is because you are working with an Excel table. I'm sorry that's the case.

[@motoporn9055]

@@spreadsheetlife that's fine . Thank you for your time to reply 🙏🙏🙏

[@IVvOOvVI]

The best!!!

[@spreadsheetlife]

😄😊👍

[@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.

[@JayTamayo-k3s]

Olla! Do you have one where you show an "indicator"? "For example, after 3 days of submitting a plan for a review, you will be notified by that color that 3 days have passed already, and I need to remind the architect about the plan. That's what my supervisor did in our tracker after he saw me tried to make one but it was no good. It was the first tracker ever made in the building. So after 2-3 days it would automatically change the color. And he even made in the same tracker to change the cells' color when the requirements sas been complete. Hope you can make one. Thank you!

[@spreadsheetlife]

I don't currently have one that works exactly like you have described, but I may make one similar in the future. I will note down your comment and add it to my ideas list. No promises that I will make it, but it will definitely go on my list for sure. 😊👍

[@JayTamayo-k3s]

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!

[@vava1030]

Thank you ❤

[@spreadsheetlife]

You are very welcome! 😊👍

[@soniashah2370]

Thank you!!!!!

[@spreadsheetlife]

You're welcome! 😊👍 Thank you for watching!

[@elpangilinan7401]

Thank you so much!

[@spreadsheetlife]

You're welcome! 😊👍

[@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. 😄

[@pulchritudinouschannel7611]

thank you so much

[@spreadsheetlife]

You're very welcome! 😊

[@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!

[@salwaibrahim3766]

Can u help now?

[@spreadsheetlife]

What do you need help with?