You are here: Home > Excel finance > Excel finance

Excel finance

The first thing to do is create an Excel file. It’s called “Finance” or something similar and save it on your computer and a flash drive for backups.

If you’ve never used before to excel, then let me tell you the first time that you invest in learning some basic skills of Excel will help you later, because once you set up a basic model, while having little time. I do not deal with the rudimentary basis to excel in this article, but are supposed to know how to work their way into an Excel spreadsheet and some basic commands.

You can separate rules for checking and savings accounts. Then the following lines to all currents, such as recurring monthly bills, credit card payments and estimate your monthly food bills, invoices, etc. Feel free to color code input and output. The last line should subtract the inputs and outputs must be labeled as “savings”. Its objective is the positive line every month. A dish has to keep track of your bank, your savings account to another survey, and the third – the credit card and so on. Connect each output sheet to sheet. Keep track of your finances this way and not lose sight.

 

Tags: , , ,

  • Digg
  • Del.icio.us
  • StumbleUpon
  • Reddit
  • Twitter
  • RSS

Leave a Reply