Excel Spreadsheet For Bills – Numbers, operations and a myriad of accounts are the terror of many who, from a very young age, were terrified of mathematics. Either because he did not have a good teacher or because the method was not the most appropriate, nowadays people flee to manage their finances.
reoccupations that should already go down in history and more if you are an enterprising person or if you just want to better organize your economy. In an interview for this medium, Andrés Gutiérrez, Entrepreneurship professor of Uniempresarial, explained that “the proper registration of the operations of your business will help you control and monitor the progress of the operation, deductible expenses, the payment of taxes and prepare the financial records. It is very important because it allows us to know the economic and financial reality for which the company is studying its evolution and trend “.
There are no excuses for not knowing how to properly manage your economy when there are different types of help on the web or applications that will simplify all the processes you need. Therefore, for this occasion we chose the most useful tool known to all, Excel.
It is the most used spreadsheet in the world and it is witnessed by more than 500 million users. It is very likely that at some point in your working life you have to use it and it will be a great help to know how to use it, so that you get the most benefits from it.
Excel Spreadsheet For Bills
( Click Image to Enlarge )
How to Use Excel Spreadsheet for Bills
1. Select cell ‘A1,’ located in the top-left corner of the Excel 2010 worksheet.
2. Type ‘Bill Type’ into the the cell. This column will contain the name of the bill, like ‘Rent’ or ‘Electricity.’ Select the cell to the right of the first one and enter in ‘Bill Amount.’ Continue moving one cell to the right and enter in ‘Bill Month,’ ‘Due Date,’ ‘Amount Paid’ and ‘Date Paid.’ You can also add more fields if there is some other aspect of each bill that you want to track.
3. Select cell A2. Enter in the bill type for the first bill you want to track. Then move to the cell directly to the right, and enter in the bill amount. Continue until you have entered all the available information for that bill. Leave the ‘Amount Paid’ and ‘Date Paid’ fields blank until you have paid the bill.
4. Enter another bill’s information into row 3. Continue until you have all your bill information for the month entered in.
5. Select cell A1 and hold the mouse button down. Move the mouse to the rightmost cell in the last row of the information that you entered and release the button. Select the ‘Insert’ tab at the top of the window and click the ‘Table’ button. Select ‘OK’ to build the table. This will format your information to make it readable and provide drop-down arrows that will let you narrow down your information.
6. Right-click anywhere in the table, move your mouse over ‘Table’ in the pop-up menu and choose ‘Totals Row’ to add a summation row at the bottom of the table. Select the cell in the totals row under ‘Bill Amount’ and choose ‘Sum’ from the menu that appears. This will now give you the total amount for all the bills you entered into Excel. You can do the same thing for the ‘Amount Paid’ column, or any other column that contains numerical data.
7. Right-click the row number for the totals row and select ‘Insert’ if you need to add another bill to the field. This will create a blank row at the bottom of the table. Generally you will have to do this several times each month to add that months bills.
8. Select a drop-down arrow next to each header to narrow down the table to just include rows that contain certain entries. You can look at just bills of a certain type, or just bills from a certain month. The totals row will automatically update when you narrow down the table.
- Debt Snowball Spreadsheet
- Dave Ramsey Budget Spreadsheet
- Best Spreadsheet App
- Vacation Accrual Spreadsheet
- Weight Loss Challenge Spreadsheet