By . Tracking Spreadsheet. At Thursday, April 29th 2021, 22:17:03 PM.
The second big use of the Excel Spreadsheet is my direct mail campaign. I use the spreadsheet along with MsWord to create a mail merge, the two programs work together to print addresses directly on flyers, post cards or envelopes. I can print 10,000 names in a few hours. There is no need to print labels and then have to stick them on your mailer. Another use for the spreadsheet is to do job costing. You can keep track of your painters hours and compare those hours to the hours you used to calculate the estimate for the job. Enter the painters names in the first column, you can then enter to rooms or job names in the first row. Then in each column under the room name put the hours or you can break it down further, putting the separate items like walls and molding/trim and keep track of the hours spent doing individual items. Of course there is always the profit and loss statement or spreadsheet with all expenses, which you give to the accountant. Using the spreadsheet to keep track of company expenses is a good use, and again you can use the "AutoSum" feature to keep totals. One nice thing about Excel is that if you change a figure in the column or row that you are totaling, the "AutoSum" will automatically adjust the total to reflect the new figure. So whatever uses you find for this program, you will find that it saves time and energy to do these repetitious jobs. And it will do things like adding or multiplying correctly and with ease.
You do not have to do it all in one shot. You just have to take action every day to move in the right direction. It does not matter how small the action may be, what does matter is that you took action at all. Momentum builds on itself and soon you will find yourself cruising towards your goals. Reward yourself for small medium and large successes The final key to creating your goals spreadsheet is to make sure you are rewarding yourself every step along the way. If you have a small goal of getting to $4001 in a month, then you better give yourself a reward the moment you make that 4001st dollar. You have to get into a habit of giving yourself rewards no matter how big or small the accomplishments. By celebrating the small goals you are preparing yourself for receiving the large goals. The rewards do not have to be huge, go buy that ice cream cone you want for getting that small goal. Treat yourself to dinner when you hit those medium goals. Treat yourself to a nice vacation when you hit the large goals. Always reward and always celebrate.
You need to keep track of domain names, and if you are writing for online writing platform such as Hubpages, or Squidoo, you need to keep track of all these URLs as well. You also need to keep track of all the pages within your websites. The reason you want to do this is because you will want to continue to build more and more back links to these pages, and if you have them all stored away neatly in one file, you will not have to dig through your site every time you want to create a simple back link. You should also keep track of all articles which you may be writing and submitting to article directories. You can create multiple spreadsheets in one main sheet to have all your information from one domain, or from one niche all in one main spreadsheet file. Once you get going in internet marketing you will soon discover that you have registered with more sites, such as social networking sites, bookmarking sites, affiliate networks, and created more usernames and passwords than you can remember. Spreadsheets are an excellent tool to keep track of all this information. If you are an affiliate marketer, you can use Google spreadsheets to keep track of all your affiliate links; and if you have products to sell, you can use is to keep track all your products and prices.