Excel is a spreadsheet program that allows you to enter, edit and track numerical information and data. The basics can be mastered in a lesson, but the program is powerful enough to also deal with the very sophisticated statistical and computational information. The most important part of learning Excel getting the elementary functions of entering data, formatting it and saving it for later use or distribution. The same techniques can be used to enter figures or data such as an address list, as Excel reads automatically whether you are entering numbers or text.
This is a list of short and easy steps by Excel tutors at http://excelhomework.com team.
- Open Excel on your computer and open and new file by selecting “File” and “New” from your menu bar (at the top of the window).
- Note that the columns are labeled by letter, and the rows are labeled by number. Each square (otherwise know as a cell) has a cell address made up of a letter and a number. The uppermost cell on the left is thus A1.
- Move the cursor to the A1 cell and type “Expenses,” which will be the title of the table you will build. When you are done, press “Enter,” and you will notice the cursor will go down to the cell below automatically. This is a time-saving data entry feature.
- Type “Supplies” in cell A2, “Rent” in cell A3 and “Shipping” in cell A3.
- Move the cursor to cell B2 (you can use the arrow keys, or just mouse to it and click). Type “Quarter 1.” Instead of pressing “Enter” this time, press the right arrow key to go to cell C2.
- Type “Quarter 2” in cell C2, “Quarter 3” in cell D2 and “Quarter 4” in cell E2.
- Enter in some numbers to fill out the table.
- Click and drag the cursor from B2, sliding over to cell F2, then press the “Auto sum” icon (you will find it at the top of the window, the Greek letter sigma). The totals for supplies for the year are automatically added and entered in last cell you selected, F2. Repeat the process for “Rent” and “Shipping.”
- Click and drag the cursor from B2 to B5, and press “Auto sum,” and you will see the “Quarter 1” expenses totaled in cell B5. Repeat the process for the other three quarters.
- Format the table using Auto Format. Highlight the table by clicking and dragging from A1 to F5. Select “Format” then Auto Format” from the menu bar and choose a style from the menu shown, which will be automatically applied.
- Save your file by selecting “File” and “Save” from the menu bar, and entering a file name and a location on your disk to save it.
Tips & Warnings
Excel can perform various mathematical calculations. Learn the symbols that represent math functions, such as the asterisk indicates multiplication. Excel can also sort columns alphabetically based on the text in the column’s cells.