About this lesson
Create your first Excel file, enter data and create a table.
Multiple versions of this lesson are available, choose the appropriate version for you:
Download the Excel workbook used in the video tutorial and try the lesson yourself.First File - Completed.xlsx
Creating your first Excel file.
When to use
Starting a new file for the first time.
Excel Startup Choices
- Open an existing file from the Most Recent list (at left)
- Open an existing file from a folder (under the Most Recent List)
- Create a new file from a blank file (top left of the large icons)
- Create a new file based on one of Excel’s templates (the rest of the icons)
Starting a blank file
- Create a Blank file from the main Excel window
- Select the first cell you want to work with and type in some text
- Press Enter and the next cell will be selected
- Enter some more text and press Enter
Creating a table of data
- Select A4, type in “Animal” and press Tab (you should now be in B4)
- Type in “Quantity” and press Tab (you should now be in C4)
- Type in “Cost” and press Enter
- At this point you’ll be taken to cell A5, the cell directly below the first cell you started tabbing from
- Fill in some random animals, quantities and costs. Use the tab keys to move to the next column, and the Enter key to go back to the start of the next row
- Select the cell to edit and press F2 to edit directly in the cell
- Select the cell and click in the formula bar to edit in the formula bar
- In either case the edits show up in both places
Saving your file
- Go to the File tab and choose Save As
- Browse to the location where you’d like to save the document and provide a name
- The file will now be available on the Most Recent list when you re-open Excel
Lesson notes are only available for subscribers.