Second to word processing, spreadsheets are one of the the most popular uses of computers. If you cannot find a program to do what you need to do, think about creating your own spreadsheet program. If you want to program a budget or time sheet, it is just a matter of finding the correct formulas to get the spreadsheet to do what you want.
Things You'll Need
- Spreadsheet program (i.e. Excel, Quattro Pro, etc)
Draw out your ideal program on a piece of paper. This will help you to visualize what you need the spreadsheet program to do. If you need to create a time sheet for employees, start by listing what information you need. If you need to know what the employee did during each day, create several rows that can be divided into days of the week. If you want the totals to carry over to a different page, make notes on the side of the paper so you have a reference of things you will be looking for.
Open the spreadsheet program and begin transferring your paper image into the cells of the spreadsheet. Keep in mind that cells can be combined and borders can be drawn to help you get the look you want.
Add formulas where you need them. Highlight a set of cells and use the hot-button to total them. Most formulas begin with the equals sign and use the address of the cell you want to calculate. For example, cell A4 has a number in it. You want to multiply that number by 16. Highlight the box where you want the formula to go and enter =A4*16 When you hit enter, the answer will appear. Now, you can change the number in cell A4 and the number will automatically be updated to the new number times 16.
Copy the formula and paste it in the cell below. When you mouse over, the formula in the new cell now reads =B4*16. This makes it simple to get one line of formula in then to copy and paste as many in a series as you need.
Finish one page of your spreadsheet by adding formulas where you need them. To duplicate, copy the entire page and paste it onto the next page in the spreadsheet workbook. As you come across things you need, you can use the Help file in your spreadsheet program to find the commands for the cells.
Tips & Warnings
- Save your work often and to a couple of different files. If you make a mistake, you can go to a previous version.
- Play and tweak with your spreadsheet before putting it into use. You may discover improvements that are easier implemented before you use it.
- Photo Credit Pixland/Pixland/Getty Images
How to Create a Calendar From Spreadsheet Data
Using a spreadsheet such as Microsoft Excel or Google Docs Spreadsheets for creating a calendar allows you to generate a customized view...
How to Create Your Own Envelope Budget Spreadsheet
With so many people living paycheck to paycheck and attempting to live beyond their means with credit cards, it may be time...
How to Create an Accounting Spreadsheet
No matter your income, monitoring your bank account is a wise thing to do. It can prevent you from overdrawing your account,...
How to Make Easy Spreadsheets
Teaching yourself to use a spreadsheet program can help you on the job and in your personal life. You can use spreadsheet...
How to Make My Own Histogram
A histogram can be made in Microsoft Excel based on the data that is entered into a spreadsheet. Insert a chart into...