How To Create A Powerful Productivity Tracker In Excel [Full Training & Free Download]

In this week’s training, I will show you how to create your own Productivity Tracker in Excel, complete with Dashboard, Scheduling, Projects, Tasks & Employees. Designed completely from scratch during the video.

⬇𝗗𝗢𝗪𝗡𝗟𝗢𝗔𝗗 𝗧𝗛𝗜𝗦 𝗪𝗘𝗘𝗞'𝗦 𝗪𝗢𝗥𝗞𝗕𝗢𝗢𝗞 𝗧𝗘𝗠𝗣𝗟𝗔𝗧𝗘 𝗛𝗘𝗥𝗘:

GET AN UPDATED TRAINING AND TEMPLATE WITH THE FOLLOWING FEATURES:
⭐️Added Highlighted Hover Menu
⭐️Drag & Drop Scheduling
⭐️Go To Task From Scheduler
⭐️Refresh Scheduler Button
⭐️Updated Shape Issue

EXCEL COURSES:

EXCEL PRODUCTS:


TIMESTAMPS:
0:00 – Introduction
0:40 – Overview
8:47 – Worksheet Design
55:43 – Menu Change
1:06:19 – List Tasks
1:14:27 – Selection Change Event
1:15:41 – Load Task
1:20:30 – New Task
1:21:55 – Save and Update Task
1:29:12 – Make Recurring Task
1:36:10 – Delete Task
1:44:54 – Refresh Schedule
1:59:35 – Worksheet Change Event
2:01:19 – Schedule Today, Previous and Next Day
2:03:01 – Show Calendar
2:12:56 – Refresh Dashboard
2:37:15 – Change Event Worksheet
2:37:36 – Change Date Range

Follow me on my Social Media Accounts:

About Us:
I help Microsoft Excel enthusiasts turn their passion into profits so they can earn passive income using their skills without having to trade time for money.
I love making these videos for you each and every week. A great way of supporting Excel For Freelancers to keep this training free each and every week is by supporting us through one of the amazing products offered that will help you skyrocket your Excel Skills and reach your dreams.

Get Alerted IMMEDIATELY with new Free Training Videos & Workbook by subscribing here:

New Training Video Uploaded Every Tuesday And Saturday!

Thank you very much for your continued support,
Randy Austin

[czechyorker]

I am well behind on all training videos. But my believe is - that supporting your channel is something that I am obligated to do. Your Excel training videos are the best one can find online. Thank you.

[rodexcel]

After seeing many of your videos and many views, you are really at a very high level in using Excel, your work is excellent and seen by a large community.
Best regards, you Randy are one of the best!

[Jojosmith]

reminder is on. As always thumbs up for the BEST teacher Randy on youtube VBA. Thanks a lot Randy for your valuable time & all your hard work 👍

[barbademojon]

probably the best training video ive seen so far this was otherwordly
you have no idea how much i appreciate your work

[SyedMuzammilMahasanShahi]

Thank you so much Randy for this amazing video.

[asifosman]

Randy, is there another angel like you on YouTube doing the same for Google sheets? 😊

[YoucefYoucef-ftce]

Wow wow wow wait for it
YOU ARE AMAZING SIR

[jimwaa]

For upcoming videos, I would suggest a manufacturing production scheduling system. Where you would have multiple project gantt views overlaid with machine, people and process schedules. This would be for job shops to use.

[rechannel]

I am new subscriber to your channel, and I am not well verse in excel, but I am glad if you could help me develop a Dashboard for Rainfall reports, dam levels and daily temperature in one like this video, as this vital on my work assignment. Your expertise on the matter are best I can find. Thank you.🙏🙏🙏

[kellyroberts]

Hey Randy. Do you have a video on how to set up a workbook to keep track of when employees have their trainings, and if they train in the same thing more then once to show the most current date?

[Khadija_work]

Thank you so much it is greatly appreciated 👍💐

[TheLegend_lab]

Hi Rendy, your videos are great. However, i think the missing part when you start your videos is name manager input. If you could show more of name managers input that will be excellent. Other than that, all inform on videos from scratch will be well covered.

[slminc]

Almost done customising this one. Not that straight forward but it was doable

[JAMRCK]

On the selection change section (@ 1:14:22) I'm getting a sub or function error, that highlights (line 1) Private Sub Target As Range)

& in (blue on line 7) ReplaceCalendar

I've double checked the code & it appears to be in order. I'm following it step by step. Is it possibly due to a function that hasn't been assigned yet but will be in the next few steps?

[Entertainment-jp]

❤❤❤ sir i impressed your video sir i kandy a suggestion sir create a worker attendants sheet workbook with government holy days sir🎉🎉🎉

[ballacusORIGINAL]

Do you have a video showing how to setup the admin/settings sheet?

[burner]

Hi

Do you have a video on how to make your employee names

[Cosmicsciences]

Hi Randy, But how will it calculate total time like today i work 2 hours and tomorrow i work 2 hours so total it will be 4 hours i have spent for the perticular project or task will it calculate like this or i have to tweak the formula or can you share if you have anything to work like this

[karenbrock]

I have a query on the Admin WorkSheet for the Date Ranges. Is it possible to calculate from today as an example to last 30 days? I think I missed something with the Admin setup sheet as it just appeared from somewhere.

[minaashraf]

Hello Randy, thank you so much for your tranings, iam stuck in a specific situation when i delete the already present tasks in Tasks sheet in order to add my own and try to add a task using "New task" button it inserts the new task in row 115 although i deleted the already present tasks.