A more recent version of the Excel course is available here: Excel Course

Excel Course: The Basics (saving, printing, sheets)

Saving a Workbook

To save your file, click on the diskette to the upper left of the window.

save excel basics5

If it is the first time, Excel will ask you where to save the file, what file name to use, and which extension.

The 3 main extensions are the following (shown in green on the image below):

extensions excel basics5

Printing

Click on "File" then "Print".

print excel basics5

You will see a print preview on the right hand side. Click the "Print" button to start printing.

print preview excel basics5

Document Templates

Click on "File" then "New".

You will see a good selection of readymade templates from which you can choose.

excel templates basics5

Here is an example of one of the included templates (a timesheet):

template example excel basics5

Workbook Sheets

To bring up the menu shown below, right click on the name of one of the sheets.

managing sheets excel basics5

From this menu, you will be able to:

Selecting Cells

In the image below, 8 cells have been selected (the number of rows and columns is displayed when they are selected):

cell selection excel basics5

To select an entire row or column, click on its number.

select rows excel basics5

To select all the cells on a sheet, press "Ctrl+A" or click on the button shown in the image below:

select all cells excel basics5

To select multipe non-contiguous cells, hold down "Ctrl" and click on the cells to select them.

select non contiguous cells excel basics5