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-jt5fq2 ай бұрын
For the first time I found a creator who made it easy for beginners to learn. Thank you ❤
@spreadsheetlife2 ай бұрын
Thank you so much for your kind words. I'm so glad that you were able to follow along and learn! 😊👍
@bikkavillivamsi10718 ай бұрын
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.
@spreadsheetlife8 ай бұрын
That's awesome! I'm so glad you found this video and had fun building the template!
@Still_H3re3 ай бұрын
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!
@spreadsheetlife3 ай бұрын
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. 😄
@nourahahmed90053 ай бұрын
It’s really clear you make it very easy..thank you
@spreadsheetlife3 ай бұрын
You're very welcome! Thank you for your feedback. 😊
@meaganlong20558 ай бұрын
This was so much fun to build! I love getting the practice in with the graph. I can't wait to start using this!
@spreadsheetlife8 ай бұрын
I'm so glad you enjoyed building the template and now have it to use on a daily basis! 😄
@ayishashah794224 күн бұрын
Thanks a lot, I do the same step by step and I succeeded 🎉 appreciate your support, it was so easy with you ❤
@spreadsheetlife24 күн бұрын
That's so amazing to hear!! 😄🎉 Thank you for sharing!
@gurupravin14015 ай бұрын
Simple and Good One which i needed,very clear and slow Guidance to create this,Thanks
@spreadsheetlife5 ай бұрын
You're very welcome! Thank you for your feedback.
@bharat-1k4 ай бұрын
Amazing video such a nice step by step walkthrough.
@spreadsheetlife4 ай бұрын
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!
@ketsiasanon56 ай бұрын
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
@spreadsheetlife5 ай бұрын
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. 👍
@ketsiasanon55 ай бұрын
@@spreadsheetlife will do!
@spreadsheetlife5 ай бұрын
😊👍
@LordshipWindows-eg3br5 ай бұрын
Thanks. Easy to follow. I'll try this out.
@spreadsheetlife5 ай бұрын
Awesome! I hope it works for you!
@vava1030Ай бұрын
Thank you ❤
@spreadsheetlifeАй бұрын
You are very welcome! 😊👍
@IVvOOvVI3 ай бұрын
The best!!!
@spreadsheetlife3 ай бұрын
😄😊👍
@elpangilinan74013 ай бұрын
Thank you so much!
@spreadsheetlife3 ай бұрын
You're welcome! 😊👍
@JPerpetualKid_7 ай бұрын
Thanks for this! :)
@spreadsheetlife7 ай бұрын
You are very welcome! 😄
@arts4addi7 ай бұрын
Hi! Thanks for the tutorial. Very informative. Do you know if I could apply these methods in Microsoft Excel 2003?
@spreadsheetlife7 ай бұрын
A lot of the methods will not be transferable to Excel 2003 unfortunately. I am so sorry that's the case.
@pulchritudinouschannel76114 ай бұрын
thank you so much
@spreadsheetlife4 ай бұрын
You're very welcome! 😊
@bmanmitch20057 ай бұрын
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.
@spreadsheetlife7 ай бұрын
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.
@bmanmitch20057 ай бұрын
@@spreadsheetlife Initially I did at a few rows but retried it by adding 10 rows of sample data with the same result.
@spreadsheetlife7 ай бұрын
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.
@bmanmitch20057 ай бұрын
@@spreadsheetlife Thanks, will do.
@bmanmitch20056 ай бұрын
@@spreadsheetlife I have just sent you the spreadsheet. Thanks again
@Idk-dw7gs6 ай бұрын
Is possible to add the number of percentages in bar chart? Instead of being blank green or yellow.
@spreadsheetlife6 ай бұрын
Yes it is. Click on the chart > Click the plus in the right corner > Select labels. I hope this helps.
@tuneshiaroach73935 ай бұрын
It only gave how many tasks not percentages unless I’m doing it wrong 😑
@spreadsheetlife5 ай бұрын
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.
@IVvOOvVI3 ай бұрын
@@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.
@spreadsheetlife3 ай бұрын
Very cool approach! Thanks for sharing. I love to hear how others take my creations and either modify them or add to them. 😄
@tuneshiaroach73935 ай бұрын
can you merge this with another spreadsheet?
@spreadsheetlife5 ай бұрын
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!