Instructions For Excel Spreadsheet – Excel is a powerful spreadsheet program created by Microsoft Office. You can create and format a spreadsheet and a book, build models for data analysis, write formulas, perform calculations and present professional graphics. If you learn to master this program, you could easily create cash flow statements, income statements, budgets, calendars, or loss statements.
Set up spreadsheet
1. Open the Excel program. There may be a shortcut on your desktop, or you may have to click “Start” and then “Programs” to locate the Excel icon.
2. Start a new workbook (an Excel file). Click “File” and then “New”. Under “Available Templates,” click “Blank Book” and then “Create.” Then a blank book opens.
3. Save the book. Click the Office button (or the File tab if you have an older version of Excel) and select “Save As.” Choose a location on your computer to save the file (for example, the “My Documents” folder), type the name of your book in the “File Name” box, and make sure the file type is set to “Book Of Excel “.
4. Familiarize yourself with the tabs on the tape at the top of your book. These are “File”, “Start”, “Insert”, “Page Layout”, “Formulas”, “Data”, “Review” and “View”.
5. Familiarize yourself with the language needed to use this program. It is important to know the most common terms in technology in order to be able to easily use and understand the guides of this type of programs.
A row is a section that crosses the screen from right to left. Rows are indicated by numbers along the left side of the screen.
A column is a set of data that goes from the top to the bottom of the worksheet, and is identified with a letter at the top of the sheet.
A cell is any individual square of the spreadsheet within which the data is placed.
6. Prepare the spreadsheet to store the data. Each Excel workbook has 3 default worksheets. “Sheet 1” opens by default and you can find its tab at the bottom of the window.
7. Rename a sheet by right clicking on the “Sheet 1” tab. Select the “Rename” option and type the new name for the sheet.
If necessary, add more sheets by clicking on the button to the right of “Sheet 3”, which shows a sheet of paper with a star in the corner.
8. In the top row of the sheet, write a title in each cell to identify what you are going to place in each column. For example, you could write “Name”, “Date” and “Quantity”. The rows below these titles are for placing your data.
9. Keep your progress frequently. As you enter your data, you must save your work frequently by clicking on the diskette symbol at the top left of the screen, or by clicking the Office button and selecting the “Save” option. Alternatively, you can hold down the “Ctrl” key on your keyboard while pressing the “G” key.