How to Make a Computer Spreadsheet on Loans
Making a computer spreadsheet can be a great way to keep track of your loan information. You can use the columns in a spreadsheet to store relevant information like the amount of a minimum payment, the principal amount of the loan, the due date and more. There are a number of different computer programs that you can use with the Windows operating system that will let you create one of these loan-related spreadsheets.
Other People Are Reading
Instructions
-
-
1
Use Microsoft Excel, a Microsoft Office program devoted entirely to spreadsheet creation. Click the "New" button to create a new blank spreadsheet. Use your keyboard to type into the boxes on the screen, called "cells." Label your cells with terms like "Minimum Payment," "Principal" and "Remaining Balance" and use the cells beneath them to track when you've made your payments, when your payments are due and how much money you have left.
-
2
Use Calc, a spreadsheet creation program that you get when you install OpenOffice. Unlike Microsoft Office and Microsoft Excel, both OpenOffice and Calc are completely free of charge. Calc operates almost identically to Microsoft Excel. Click "New" to create a new blank spreadsheet. Use your keyboard to type your loan information into the blank cells. You can set up your spreadsheet however you'd like, using either columns (groups of vertical blank cells) to track information, or using rows (groups of horizontal blank cells). Keep track of things like what date a payment was due, what date you actually made a payment and anything else you'd like to archive.
-
-
3
Use Google Docs, a web-based productivity suite of programs designed by Google. If you have a free Google account, you have access to Google Docs. Log into Google Docs and click the "Create New" button. Choose "Spreadsheet" to open a blank spreadsheet document. The first row of cells can be used to title a particular column—for example, the cell labeled "A1" could be called "Date". You could then use the cells in the column beneath that heading to keep track of the date loan payments were made.
-
1
