How To Use Excel To Make Holiday Purchases

By: jaliam

Break Studios Contributing Writer

Keeping track of your holiday expenses, particularly the purchases you’ve made online or at a local store, can be challenging if you do not have everything organized. There is however a solution to this fiasco: Microsoft Excel. With this robust program, you will be able to effectively organize all your holiday expenditures and this will result in fewer headaches in tracking down or determining where your hard earned dollars went during the holiday season.

In order to implement your expenditure tracking system, you will need:

  • Stable computer
  • Microsoft Excel
  • Reliable internet connection
  1. Stable computer. Since you will need to use Microsoft Excel to track your holiday spending, you must have a stable running computer with proper technical specifications. It can either be a notebook or a desktop computer. As long as your computer meets the minimum requirements to run Microsoft Excel, you should be fine.
  2. Microsoft Excel. You can actually save some precious time in tracking your purchases during the holiday season with Excel. All you have to do is enter all the data such as stores where you made your purchases, items you bought, and most important of all, the costs of the items you purchased. This way you can keep your records organized and be able to track how much you spent for your families and friends, and of course, for yourself. It is also a great idea to scan your receipts so you can insert them as well in your Excel spreadsheet.
  3. Internet account. Most of the purchases or great deals for shopping are now available and done online, so having an internet account is quite favorable and beneficial to you. It is also easier to capture the data from your computer screen and transpose them to your Excel spreadsheet for automated tracking. Just enter the data and it will automatically be computed.

Now that you have the tools and means to keep track of your holiday purchases, enjoy your shopping! Excel will keep you afloat, undoubtedly.

Posted on: Jun. 01, 2010