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 UA-cam Channel:
/ @neotechnavigators
Download the practice file from below link:
www.pk-anexcel...
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcel...
See our Excel Products:
www.pk-anexcel...
Visit to learn more:
Chart and Visualizations: www.pk-anexcel...
VBA Course: www.pk-anexcel...
Download useful Templates: www.pk-anexcel...
Dashboards: www.pk-anexcel...
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-AnExcel...
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/...
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-m...

[@makogemandel]

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]

Glad I could help!

[@Up4Excel]

Nice idea to have the conditional formatting strike through completed tasks 💚😀

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@jkings6602]

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.

[@tweseltd]

Man, You deserve more than subscribing to your channel. Thanks for Saving me. I am from Kigali, RWANDA!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@tweseltd]

@@PKAnExcelExpert You're welcome brother!

[@ismailsufiani2810]

best video i ever needed great one bro thanks ⭐⭐⭐⭐⭐

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@BenDauntless]

I've never done any work tracker so this is absolutely astonishing. Thank you so much!

[@PKAnExcelExpert]

Most welcome🙏

[@PossibleTarget24]

Dear brother, It is very useful for me. Excellent job jiiii

[@PKAnExcelExpert]

Thanks🙏

[@navjotkaushal7509]

Effective tip and idea to shine in office

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@truthlover6511]

thank you for making such a detailed and easy to understand video🎉

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@prafuldate2881]

Nice video Sir

[@PKAnExcelExpert]

Thanks

[@AbhishekSharma-uh8pb]

Really helpful

[@PKAnExcelExpert]

Glad it helped

[@mayurvarma462]

you are really great help for me right now.. thank you so much for such a great video

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@roshanmhatre18]

Simple & Productive ❤

[@PKAnExcelExpert]

Glad you think so!

[@MrKartheee]

i learnt a lot

[@PKAnExcelExpert]

Thanks

[@Anil_Kolar]

Excellent

[@PKAnExcelExpert]

Thanks

[@rosanabalitan5719]

This is so cool. Thank you so much for sharing your knowledge 🤝

[@PKAnExcelExpert]

My pleasure!

[@preethladybird]

Indispensable information.
Thanks for enlighten.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@mskumar034]

Your Explanation is simply Superb. Appreciate for all the efforts you made for this Video, informative

[@PKAnExcelExpert]

You are most welcome

[@khongorzulaltangerel2742]

Thank you. I made my own daily tracker by watching your video by speed at 0.5.

[@coachvinodkt]

Thank you so much sharing this valuable info

[@PKAnExcelExpert]

You are so welcome!

[@divyanshkhorwal3704]

Thanx brother .
You get solutions from here👍

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@s.p.r.lfonseka7642]

Thank you very much. it's very helpful.

[@PKAnExcelExpert]

You are welcome!

[@saraalb2221]

Thank you such a great and helpful video

[@PKAnExcelExpert]

Most welcome🙏

[@musicsang4882]

How great your knowledge is Sir. Huge respect for you.

[@PKAnExcelExpert]

It's my pleasure

[@MHKESuperior]

Superb thank you very much you teach me in the way I'll learned all thanks

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@ahmedalfahham201]

Ive been looking for this for ages. Maan Thanks a lot.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ahmedalfahham201]

@@PKAnExcelExpert Do you offer practical course of Excel?

[@AlexPereira89187]

I´ve been leaning too much in this channel!
Many thank you, PK!

[@PKAnExcelExpert]

Most welcome

[@mike898p9]

Awesome video. Very helpful. Thank you.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Bhhkug]

Excellent Developer Type knowledge u have sir...

[@PKAnExcelExpert]

Thanks a ton

[@rashmijm9986]

Thank u so much brother it is very helpful

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@arunkiran4694]

Good training, I learn many options from your training videos, Thank you

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@okeshsharma2984]

Great valuables information

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Papikristo]

beautiful

[@PKAnExcelExpert]

Many many thanks

[@aamraja]

Thank you so much for sharing your knowledge

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@gamingsoundeffects8909]

Really help me on my daily task. Thanks for this.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@paulabraham7424]

Great teacher.

[@PKAnExcelExpert]

Wow, thank you

[@sairam6655]

really awesome bro
thank you very much

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@namikicindic7484]

Wow. Thank you so much for sharing your knowledge and ideas. I have learnt so many valuable things from just one video:)

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@raj28san]

Hi Sir, the video is really good and nice explanation. Now I can maintain my office work easily. Thank you
Gud Luck Sir.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@srushtinagargoje5604]

Very very very × ♾️ nice explanation

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@srushtinagargoje5604]

@@PKAnExcelExpert Welcome
And Thank You too ❤️

[@MrKartheee]

super....

[@PKAnExcelExpert]

Thanks🙏

[@akosuaamankwah9374]

Very clear! Thanks for sharing

[@PKAnExcelExpert]

Glad it was helpful!

[@lauranoto4292]

Great video, thank you for sharing!

[@PKAnExcelExpert]

Thanks for watching!

[@pohonkehidupannirwana]

jenius 😚

[@PKAnExcelExpert]

Thanks

[@saurabhrai5798]

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]

Thanks for your valuable feedback

[@Mukeshjhalic]

nicely explained dear...lots of value

[@PKAnExcelExpert]

Thanks a ton

[@ayeshkodikara5093]

thanks from sri lanka

[@PKAnExcelExpert]

Most welcome

[@PushpendraSingh-fx3ei]

It's helped me, thanks alot man.

[@PKAnExcelExpert]

Glad it helped

[@user-fx1wf9mh2w]

THanks 😍

[@PKAnExcelExpert]

Welcome 😊

[@linafamily3600]

Thank u so much maaan

[@PKAnExcelExpert]

Most welcome🙏

[@keshav_k_0793]

thank yoou sir

[@PKAnExcelExpert]

Welcome

[@9850039183]

very well explained. I have implemented this in our daily task excel

[@charlestumwesigye7742]

This is wonderful. thank you for the lesson.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@libaybuay11]

Grabe, nakakapagod beh. Isang oras ko tong sinusundan. HAHAHAHA but thankk you

[@naveenjangra717]

You are mind-blowing sir...

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@dharmendrasuthar4342]

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.

[@fhatuwanimakungo24]

thanks you , you are always doing a great works

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@bestofx9013]

Really great work sir hats off to you

[@PKAnExcelExpert]

Thanks for your valuable feedback.

[@karma1835]

Exactly what i wanted. Thank you 👍🏻

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@narayanjuti3403]

Thank you

[@PKAnExcelExpert]

Most welcome

[@deepeshparmar395]

Great video!!! I created for me same sheet.
Thank you!

[@PKAnExcelExpert]

Most welcome🙏

[@zeeshanzeesee914]

I just loveit bro..super..

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@SyedMuzammilMahasanShahi]

Beautiful work. Thanks for the share

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@md.alamin9342]

Thanks. But considering of Beginner learner, movement should be slower than current speed. Overall its helpful video.
Thanks once again. (Y)

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@igking009]

THANK U SO MUCH FOR THIS 🙏

[@PKAnExcelExpert]

Most Welcome

[@kkarsd]

Needful, thanks for sharing

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@kartikshetty7989]

Simply amazing. Thanks a ton.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@katerina6495]

Great PK, thank you so much

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@dinilsabadu3974]

9:26 ...... countif selected the entire row...how it's selected ?

[@pradeeptiwari5697]

Gr8 job sir....I wish to meet u in person..I m a big fan of yours and excel enthusiast

[@vinayakvagare405]

Thank u sir, best tracking list...

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@bunty341]

This one is really very very useful !
Thanks for sharing

[@padmasusarla6209]

This is really helpful, very structured and easy to follow.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@MohammadFokrulIslam-cg6ef]

Thanks for your assistance it will be very helpful for the job life.❤

[@blackmotivation2027]

Very useful

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@growqueen]

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]

Thanks for your valuable feedback

[@axlwrosess]

Great stuff bud thx...

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@mishelathauda2677]

Superb!! 👌🏼

[@PKAnExcelExpert]

Thank you so much 😀

[@manakamanai.t3661]

The video is awesome can you upload the same thing in google sheet also.

[@saleem6r7]

Thanks PK. Looking forward to see more.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@suraj_Gamer_1M]

❤❤❤

[@PKAnExcelExpert]

Thanks🙏

[@clickclick8761]

well done, thank you

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@spurthichadharam9144]

Wastage Remarks we can shall may ( or any suitable helping verb) follow this too

[@daisy.9955]

This is great! Thank you so much :)

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@samanm.d3163]

නියමයි

[@rajeshmuthu9881]

Super dude.. Ts is what i am looking for so long time.
And is it possible to do the same using VBA???

[@PKAnExcelExpert]

Thanks for your valuable feedback. I will definitely try to make such video very soon

[@Success_Mantra82]

*It's helpful to us* Nice video PK ✌️

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Success_Mantra82]

@@PKAnExcelExpert WhatsApp number please.!! *Raj from Delhi 9891951706*

[@dharmendrayadav-bw2gp]

Nice video

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@msmotivation6492]

Ive been looking and looking for this information, thanks!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@harshitbhatnagar2645]

pls guide us, how to create this wonderful format in Google sheet..

[@romlef526]

very good :) :)

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@puransingh-sx2tk]

Thanks pk... Can you please make a vedio on fully automated employee activities tracker (time tracker )

[@PKAnExcelExpert]

Sure I will definitely try to make such video

[@chetangujrathi8002]

We can also create a simple macro to automatically copy data in to data sheet....

[@prafuldate2881]

I want to keep a track of the progress of my product assembly. Do you have any suggestions.

[@sonunewton]

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]

Thanks for your valuable feedback. I will take care in future videos

[@amolangane532]

mastt !!!!!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@vaseemakram9609]

Nicely explained

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@dorothyodu6786]

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.

[@omprakashyadav9272]

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]

Hi Did you ever get an answer to this info, I need the same for a project I am working on.

[@dnyanuidhate6039]

Sir please
Tell me this progress chart create by 2007

[@its_anilmamidi]

Hi Sir, in place of copying, can how u show me by clicking a single refresh button it should refresh in in starting

[@aryanshrivastav9020]

1st view,1st comment,1st like

[@PKAnExcelExpert]

Thanks for your valuable support.