This topic came to mind when I was thinking about how I can utilize my Excel VBA skills to help millennial entrepreneurs further simplify their day to day business activities. I don’t consider myself an “Excel guru” but I’m definitely advanced. Anything I need to get done in Excel, I can figure it out either on my own or by Googling to see if someone else has figured out an easier solution. After giving it a bit of thought, I realized that if I am going to create a useful Excel tool, it should be one that helps my readers increase their productivity. Then it hit me… create a timesheet (Video found at the bottom of the blog)!
Some of you might be thinking, “well why the heck would I want an Excel timesheet when I can just download an app to track my time”? The answer is quite obvious. You would use it to simplify your life. To help increase your productivity.
check out this related article “The Most Common Mistakes Made By Entrepreneurs” that talks more about being organized.
I know of so many entrepreneurs out there that prefer to track their time in Excel. Having their timesheet in Excel allows them to have less clutter on their computer screen. They often already do a lot of tracking with Excel and may have multiple tabs already in an Excel workbook. So, why not keep everything consolidated?
Another reason why someone would use this tool is if they just don’t want to work with apps or are tired of them. Maybe they don’t have enough space on their phone because of all the other millions of apps that were downloaded. For some reason, millennials just don’t like to delete apps. Even if they haven’t used them for months. I sure as heck am guilty of this. If I looked in my pone or iPad, I probably have at least 6 apps that I don’t use. We are digital hoarders!
The timesheet, as you saw above, is very simple. It is meant to be that way… simple and clean. Download it and use it as you please. I have outlined step by step on how to move it into a different workbook. However, if you are not Excel savvy and end up having issues during the process, I would suggest you stick to using the tool as is with minimal changes. Regardless, don’t be afraid to experiment with moving things around as needed. If you mess something up, just re-download a fresh copy.
The timesheet I created is a standalone tool but you can decide to add other worksheet tabs to it. You can also copy the sheet into an existing workbook which will also carry the VBA code over as well. If you need to copy the sheet into another workbook, you will need to do the following steps:
Note that the timesheet was made on Excel 2016 so all the directions given are based on the 2016 version of Excel.
Right click on the worksheet tab containing the timesheet to get the options below and choose “Move or Copy”:
You will then see the following:
Under “Move selected sheets To book”, choose where you want the sheet to be copied to. The workbook that you are copying the timesheet into needs to first be open. Otherwise, you will be unable to move or copy the timesheet into that workbook. In my example, I want the timesheet to be copied to “TheMillennialBullSampleWorksheet.xlsx”:
I then choose “Move to end” because I want the worksheet to be placed at the end of my workbook. Make sure “Create a copy” is checked so that you are copying the worksheet instead of moving it completely:
Save the workbook that now has the timesheet by going to “File” then “Save As”. Make sure you save it as an “Excel Macro-Enabled Workbook (*.xlsm)”:
You are now good to go and should be able to continue using your Excel workbook as normal except now you have integrated it with a timesheet that doesn’t depend on you having to be online. That’s the beauty with this timesheet because you don’t need to have internet for it to accurately track your time.
Remember, the time logged is based on the time zone that was set on your computer. If you need the time zone to change and you don’t know how, do a google search on “changing my timezone on my computer” and you should find many helpful resources.
Assuming you end up downloading this tool and find it helpful, please be sure to comment below to let me know and share the link with others as well. If you make changes to this tool but used it as a base for your changes, please make sure that others still know where it originated from (this website). Do me a favor and let me know what improvements you have made to it by commenting below so that others can see and learn from it as well. You can also comment with suggestions on what changes I can make that will be useful to you and I might decide to come out with a new and improved version based on your suggestions.
A Few Last Words
Alright my fellow millennials. That just about wraps this up. Let me know what other Excel tools I can create for you that will help you be more productive. If you don’t know how to create macros or are not very good with Excel, take some time to watch some YouTube videos or get yourself an account with Lynda.com or Udemy.com. These two online learning centers are very useful.
I highly recommend taking the time to at least be proficient in Excel. If you do, your productivity will literally increase exponentially. At work, I have written Excel macros that do repetitive tasks consisting of opening 100 different workbooks and doing different actions in each workbook. That task alone would take a person a couple days to do it (probably more). I spent a day or so writing the macro three years ago, and the macro only takes 20 minutes to complete all of the tasks (yes I still use it. I use it monthly). Honestly… how amazing is that!?
My Time Clock Video
Lastly, during my research phase on this topic (I had to make sure that there were enough of you out there interested in potentially reading this) I ran into a very useful post by Pryor.com. The post is called “A Great Way to Create an Excel Macro Timer”. Check it out for additional information. My timesheet is already built for you. You can download it by clicking the button below. However, if you want to record a macro and try to build a timesheet yourself, check out the link I provided above.
Unlike the macro from Pryor which is built by using the “record macro” feature in excel and then making adjustments to it, this macro is completely independent of that. For my geek squads out there, the button is built using “ActiveX Controls” instead of “Forms Controls”.
Ok bulls, that is all. Hope this was useful to you. Again, don’t forget to comment below! Also, don’t forget to subscribe to my email list. Lastly, check out the video below that demonstrates the Excel timesheet and further illustrates some of the steps mentioned above.
The shortcut to financial freedom is hard work, determination and perseverance!