Daily Activity Tracker in Excel
#ExcelTemplate #ActivityTracker
Hello Friends,
In this video, you will learn how to create a simple daily activity tracker. You can use this Activity tracker to track your daily activity and you can create a database also. We have created a progress bar chart also to display the activity completion%.
Subscribe our new KZread Channel:
/ @neotechnavigators
Download the practice file from below link:
www.pk-anexcelexpert.com/dail...
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcelexpert.com/prod...
See our Excel Products:
www.pk-anexcelexpert.com/prod...
Visit to learn more:
Chart and Visualizations: www.pk-anexcelexpert.com/cate...
VBA Course: www.pk-anexcelexpert.com/vba/
Download useful Templates: www.pk-anexcelexpert.com/cate...
Dashboards: www.pk-anexcelexpert.com/exce...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Learn and free download best excel Dashboard template:
• Excel Dashboards
Learn Step by Step VBA:
• VBA Tutorial
Website:
www.PK-AnExcelExpert.com
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/AAAAAE2OnviiEk5...
Twitter:
/ priyendra_kumar
Pinterest:
/ pkanexcelexpert
Send me your queries on telegram:
@PKanExcelExpert
************ Suggested Books ********
VBA: amzn.to/2TMMikX
Excel Dashboard: amzn.to/2WZi2Fj
Power Query: amzn.to/2Ibd7xR
Power Pivot and Power BI: amzn.to/2DCg8BB
Exam Ref 70-778 (Power BI): amzn.to/2GnWYTN
************ My Stuff ***************
Mic : amzn.to/2TLnF88
Video Editor: screencast-o-matic.com/refer/...
Пікірлер: 231
I´ve been leaning too much in this channel! Many thank you, PK!
@PKAnExcelExpert
2 жыл бұрын
Most welcome
Wow. Thank you so much for sharing your knowledge and ideas. I have learnt so many valuable things from just one video:)
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
Another amazing video PK. I will surely prepare this to ease out my daily task. Please bring your dashboard series back too......its a request.
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
Thank you. I made my own daily tracker by watching your video by speed at 0.5.
Good training, I learn many options from your training videos, Thank you
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
Nice idea to have the conditional formatting strike through completed tasks 💚😀
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
@jkings6602
4 жыл бұрын
Appreciate video content! Forgive me for chiming in, I would love your opinion. Have you heard the talk about - Weydaniel Organized Dominator (Sure I saw it on Google)? It is an awesome one of a kind guide for getting 7000 plus project management and business templates minus the headache. Ive heard some incredible things about it and my buddy at last got astronomical success with it.
This is wonderful. thank you for the lesson.
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
Indispensable information. Thanks for enlighten.
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
This one is really very very useful ! Thanks for sharing
This is great! Thank you so much :)
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
How great your knowledge is Sir. Huge respect for you.
@PKAnExcelExpert
Жыл бұрын
It's my pleasure
Man, You deserve more than subscribing to your channel. Thanks for Saving me. I am from Kigali, RWANDA!
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
@tweseltd
3 жыл бұрын
@@PKAnExcelExpert You're welcome brother!
Simply amazing. Thanks a ton.
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
Thanks PK. Looking forward to see more.
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
I've never done any work tracker so this is absolutely astonishing. Thank you so much!
@PKAnExcelExpert
10 ай бұрын
Most welcome🙏
Really help me on my daily task. Thanks for this.
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
Exactly what i wanted. Thank you 👍🏻
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
Your Explanation is simply Superb. Appreciate for all the efforts you made for this Video, informative
@PKAnExcelExpert
2 жыл бұрын
You are most welcome
you are really great help for me right now.. thank you so much for such a great video
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
Hi Sir, the video is really good and nice explanation. Now I can maintain my office work easily. Thank you Gud Luck Sir.
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
thanks you , you are always doing a great works
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
Awesome video. Very helpful. Thank you.
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
This was a masterpiece. I have been trying to do the progress bar for some time now to no avail. Thank you for this.
@PKAnExcelExpert
29 күн бұрын
Glad I could help!
Beautiful work. Thanks for the share
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
Simple & Productive ❤
@PKAnExcelExpert
3 ай бұрын
Glad you think so!
Ive been looking for this for ages. Maan Thanks a lot.
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
@ahmedalfahham201
3 жыл бұрын
@@PKAnExcelExpert Do you offer practical course of Excel?
Great PK, thank you so much
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
best video i ever needed great one bro thanks ⭐⭐⭐⭐⭐
@PKAnExcelExpert
Жыл бұрын
Thanks for your valuable feedback🙏
You are mind-blowing sir...
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
Thanx brother . You get solutions from here👍
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
Thank you so much for sharing your knowledge
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
Thank u sir, best tracking list...
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
Nice video. Very helpful. But can we automatically switch status based on date. e.g. show "Delayed" if production has not completed within the given delivery time or show "In progress" if the date has not surpassed the delivery date.
Needful, thanks for sharing
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
Excellent Developer Type knowledge u have sir...
@PKAnExcelExpert
3 жыл бұрын
Thanks a ton
This is so cool. Thank you so much for sharing your knowledge 🤝
@PKAnExcelExpert
Жыл бұрын
My pleasure!
This is really helpful, very structured and easy to follow.
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
@MohammadFokrulIslam-cg6ef
Жыл бұрын
Thanks for your assistance it will be very helpful for the job life.❤
Gr8 job sir....I wish to meet u in person..I m a big fan of yours and excel enthusiast
thank you for making such a detailed and easy to understand video🎉
@PKAnExcelExpert
10 ай бұрын
Thanks for your valuable feedback🙏
Really great work sir hats off to you
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback.
Great video, thank you for sharing!
@PKAnExcelExpert
2 жыл бұрын
Thanks for watching!
well done, thank you
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
Effective tip and idea to shine in office
@PKAnExcelExpert
Жыл бұрын
Thanks for your valuable feedback
Thank you very much. it's very helpful.
@PKAnExcelExpert
2 жыл бұрын
You are welcome!
Great stuff bud thx...
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
Superb thank you very much you teach me in the way I'll learned all thanks
@PKAnExcelExpert
2 жыл бұрын
Thanks for your valuable feedback🙏
THANK U SO MUCH FOR THIS 🙏
@PKAnExcelExpert
2 жыл бұрын
Most Welcome
Very clear! Thanks for sharing
@PKAnExcelExpert
3 ай бұрын
Glad it was helpful!
Thanks. But considering of Beginner learner, movement should be slower than current speed. Overall its helpful video. Thanks once again. (Y)
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
Dear brother, It is very useful for me. Excellent job jiiii
@PKAnExcelExpert
10 ай бұрын
Thanks🙏
Ive been looking and looking for this information, thanks!
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
Wow!! This is so good I need this, but I am a beginner and the instructions are too fast paced for me. This is brilliant though
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
Superb!! 👌🏼
@PKAnExcelExpert
4 жыл бұрын
Thank you so much 😀
Thank you such a great and helpful video
@PKAnExcelExpert
Жыл бұрын
Most welcome🙏
It's helped me, thanks alot man.
@PKAnExcelExpert
2 жыл бұрын
Glad it helped
Great video!!! I created for me same sheet. Thank you!
@PKAnExcelExpert
Жыл бұрын
Most welcome🙏
Thank you so much sharing this valuable info
@PKAnExcelExpert
2 жыл бұрын
You are so welcome!
Hi PK, nice video. Thank you so much. I tried but I couldn't do what you did at 10:46. It was disjointed. Any tip, please? Did it eventually but couldn't group this time. The group link is inactive. Any tip on this please? Update: I did it. I clicked on one chart, pressed "shift"and selected the other, right clicked and grouped. Thank you.
Thank u so much brother it is very helpful
@PKAnExcelExpert
2 жыл бұрын
Thanks for your valuable feedback
❤❤❤
@PKAnExcelExpert
Жыл бұрын
Thanks🙏
Great valuables information
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
Great teacher.
@PKAnExcelExpert
Жыл бұрын
Wow, thank you
The video is awesome can you upload the same thing in google sheet also.
නියමයි
really awesome bro thank you very much
@PKAnExcelExpert
2 жыл бұрын
Thanks for your valuable feedback
Really helpful
@PKAnExcelExpert
Жыл бұрын
Glad it helped
Grabe, nakakapagod beh. Isang oras ko tong sinusundan. HAHAHAHA but thankk you
i learnt a lot
@PKAnExcelExpert
Жыл бұрын
Thanks
THanks 😍
@PKAnExcelExpert
4 ай бұрын
Welcome 😊
Nice video Sir
@PKAnExcelExpert
2 жыл бұрын
Thanks
I just loveit bro..super..
@PKAnExcelExpert
2 жыл бұрын
Thanks for your valuable feedback
nicely explained dear...lots of value
@PKAnExcelExpert
Жыл бұрын
Thanks a ton
very well explained. I have implemented this in our daily task excel
I want to keep a track of the progress of my product assembly. Do you have any suggestions.
Thanks pk... Can you please make a vedio on fully automated employee activities tracker (time tracker )
@PKAnExcelExpert
4 жыл бұрын
Sure I will definitely try to make such video
thanks from sri lanka
@PKAnExcelExpert
3 жыл бұрын
Most welcome
Super dude.. Ts is what i am looking for so long time. And is it possible to do the same using VBA???
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback. I will definitely try to make such video very soon
Thank u so much maaan
@PKAnExcelExpert
9 ай бұрын
Most welcome🙏
*It's helpful to us* Nice video PK ✌️
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
@Excel_Mantra
4 жыл бұрын
@@PKAnExcelExpert WhatsApp number please.!! *Raj from Delhi 9891951706*
very good :) :)
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
Excellent
@PKAnExcelExpert
Жыл бұрын
Thanks
Thank you
@PKAnExcelExpert
2 жыл бұрын
Most welcome
Very very very × ♾️ nice explanation
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
@srushtinagargoje5604
3 жыл бұрын
@@PKAnExcelExpert Welcome And Thank You too ❤️
Thank you, sir, But after complete the percentage bar, for example, if 80% complete, only 50% green color is showing only. Can you please clarify on this.
1st view,1st comment,1st like
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable support.
jenius 😚
@PKAnExcelExpert
2 жыл бұрын
Thanks
thank yoou sir
@PKAnExcelExpert
2 жыл бұрын
Welcome
Hello sir thanks for the video. I tried the same in an excel file and den copy pasted the same in different tabs for different days but the file has now turn very heavy about 50 mb😅 and the file gets hanged soon.. Any solution for this?
super....
@PKAnExcelExpert
Жыл бұрын
Thanks🙏
beautiful
@PKAnExcelExpert
Жыл бұрын
Many many thanks
pls guide us, how to create this wonderful format in Google sheet..
Hi Sir, in place of copying, can how u show me by clicking a single refresh button it should refresh in in starting
Very useful
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
The serial number formula didn’t work for me. We have different column number. Yours was b5 mine was c5. after just changing the column number press enter it showed 1 right away even if I didn’t yet type the first task on d5. then when I type another task on the next row it didn’t automatically show the #2 serial number. How can I fix that?
Can u pls help to get daily weekly monthly and by yearly percentage of work done based the total hours 8.30. also how to incorporate if there is two Saturday working in month
@lilliangilham6936
3 жыл бұрын
Hi Did you ever get an answer to this info, I need the same for a project I am working on.
The video is great and thank you share this with everyone, but while explaining can u be bit slow it will help a lot👍
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback. I will take care in future videos
Which excel version are you using?
Hi PK, How to create map in excel with location and employee number?
Nice video
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
mastt !!!!!
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback