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!
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!
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. 😄
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
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. 👍
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.
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!
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. 😊👍
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.
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.
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?
@@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?
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.
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!
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.
@@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.
For those that are interested, check out my new Excel course here: spreadsheetlife.com/excel-launchpad-course/
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.
That's awesome! I'm so glad you found this video and had fun building the template!
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!
Thank you so much for your kind words! I'm so glad you were able to follow and learn along the way! 😄👍
For the first time I found a creator who made it easy for beginners to learn. Thank you ❤
Thank you so much for your kind words. I'm so glad that you were able to follow along and learn! 😊👍
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!
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. 😄
This was so much fun to build! I love getting the practice in with the graph. I can't wait to start using this!
I'm so glad you enjoyed building the template and now have it to use on a daily basis! 😄
A lifesaver. Thank you so much for this!
Of course! Thank you for watching! 😊
Simple and Good One which i needed,very clear and slow Guidance to create this,Thanks
You're very welcome! Thank you for your feedback.
Thanks. Easy to follow. I'll try this out.
Awesome! I hope it works for you!
Thank you so much for your help and Explanation for this. ❤
Of course! Thank you for watching!! 😄
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
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. 👍
@@spreadsheetlife will do!
😊👍
Awsome man ❤
😄👍
It’s really clear you make it very easy..thank you
You're very welcome! Thank you for your feedback. 😊
Thanks a lot, I do the same step by step and I succeeded 🎉 appreciate your support, it was so easy with you ❤
That's so amazing to hear!! 😄🎉 Thank you for sharing!
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.
Sounds like a super cool spreadsheet for sure!
Amazing video such a nice step by step walkthrough.
Thank you for your feedback. I'm so glad you enjoyed it!
Thanks for this! :)
You are very welcome! 😄
Thank you!!!!!
You're welcome! 😊👍
Thank you for watching!
Thank you so much!
You're welcome! 😊👍
Thank you ❤
You are very welcome! 😊👍
The best!!!
😄😊👍
thank you so much
You're very welcome! 😊
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!
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. 😊👍
Hi! Thanks for the tutorial. Very informative. Do you know if I could apply these methods in Microsoft Excel 2003?
A lot of the methods will not be transferable to Excel 2003 unfortunately. I am so sorry that's the case.
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.
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.
@@spreadsheetlife Initially I did at a few rows but retried it by adding 10 rows of sample data with the same result.
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.
@@spreadsheetlife Thanks, will do.
@@spreadsheetlife I have just sent you the spreadsheet. Thanks again
how to create more vertical lines in one column? Also to expand the size of a single cell? Thank you
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?
@@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?
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.
@@spreadsheetlife that's fine . Thank you for your time to reply 🙏🙏🙏
can you merge this with another spreadsheet?
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!
Is possible to add the number of percentages in bar chart? Instead of being blank green or yellow.
Yes it is. Click on the chart > Click the plus in the right corner > Select labels. I hope this helps.
It only gave how many tasks not percentages unless I’m doing it wrong 😑
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.
@@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.
Very cool approach! Thanks for sharing. I love to hear how others take my creations and either modify them or add to them. 😄
Can u help now?
What do you need help with?