Up next in 10
Monthly Goal Tracker in Excel
5K views
Apr 3, 2023
Get motivated to achieve your goals with this Monthly Goal Tracker in Excel. Get the Monthly goals Tracker Template - https://arkiana.com/monthly-goals-tracker-in-excel/ Join my weekly Newsletter THE Snippets - https://arkim.substack.com/ In THE SNIPPETS, I share more about Data Analytics, Programming, and Opportunities surrounding the Tech World.
View Video Transcript
0:00
So I made this monthly goals tracker in Excel to help me track my monthly goals and keep me motivated
0:06
There are a lot of visuals, a lot of formulas that have been applied and together they bring out
0:11
nice simple visuals that will help me track my goals. For example, I have the go column here
0:16
where I'm going to enter my goals, then the actual and the target. Then all these will populate
0:21
depending on what I have done in these two columns. So I want to make a total of 2,000 in income
0:27
As a target, I'll say 2,000. Then I want to read four books, I'll say four
0:32
Write 10 blog posts, 10. Apply for 10 jobs, I'll say 10
0:36
Make four YouTube videos, I'll say four. Add two data ytics projects to my portfolio, two
0:42
And finally, visit five extended family members and that would be a five
0:46
So these are my targets for the month. But as the month goes by or as the month ends, there'll be things that I would have done and others that I've not done
0:54
There will be targets that I'll meet and others I'll not meet. So those I'll put the actual things that I've done, I'll put them in here
1:01
Let's say I only managed to make 1,800 and I only managed to read three books
1:06
Then I wrote 12 blog posts. I applied to nine companies. Then I made four YouTube videos
1:13
I managed to do this one as well and visited 10 family members
1:18
So you can see once I've entered my actuals and my target, the rest populate
1:23
You can see here this shows the difference between my target and the thing that I've done
1:27
For example I wanted to make 2000 I only made 1800 and the difference is 200 In other cases like this one my target was to write 10 blog posts I wrote 12 that shows that I above target and added the green highlight there just to give me a little bit of motivation
1:44
As far as the status is concerned, when something has been done like this one, it will say complete
1:49
and it will highlight in the light green color. But when it has not been done like this one
1:54
instead of 10, I did 9, then it will say incomplete. Then you also have the progress bar here that
1:59
shows in percentage how far I've gone. This table shows the number of goals that I've completed and
2:04
their percentage, the number of goals that are above target and also the number of goals that
2:09
I've not completed. Then I have this chart here that shows the progress that I've made. So this
2:14
green part is my progress showing how far I've gone with my goals. So you'll be able to see if
2:19
I change let's say this one to 4 this will increase. If I change this one to 10 again I have that
2:26
progress. Apart from that you can add more goals there. So just go to the end of the table and
2:31
press tab. Then you can add another goal here. Let's say make 10 YouTube shots like so. So the
2:38
target is to make 10 and let's say by the end of the month I only manage to make 9 and that will
2:44
show us the progress there and that it's incomplete. It will also be added to this one that I have two
2:50
that I've not completed and six that I've completed and it reduces my progress there
2:56
So this is just a simple template to help me track my goals, to keep me motivated, to push me to
3:02
accomplish my goals. If you are interested in this template, I'll leave the link in the
3:07
description on how you can get it. Thank you so much for watching. I'll see you in the next one
#Self-Help & Motivational