Course details

Excel Level 1

Using the Desktop Icon

Using the Start button and program list

Using the Search programs and files  

Closing Excel

Creating a New Spreadsheet

Page layout

Selecting Cells

- Selecting a Single Cell

- Selecting Multiple Cells

- Deselecting Cells

- Moving Between Cells

Entering data into a Workbook

Saving a Workbook

- Checking the Workbook has been saved correctly

Opening an Existing Workbook

Changing Data

Changing a Data Entry

Deleting a Data Entry

Deleting the data in a selection of cells

Undo and Redo

Saving a Workbook with a Different Name

Inserting Rows and Columns

Deleting Rows and Columns

Changing a Workbook using Cut, Copy and Paste

Formatting

- Alignment

- Adjusting Column Width and Row Height

- Formatting the properties of a cell according to its contents

- Formatting to Currency

- Formatting to Percentage

- Adjusting the number of decimal places

- Formatting to Number

Formulas and Functions

The difference between a Formula and a Function

Formulas

- Creating Formulas

- Entering Formulas using the Mouse

- Relative Cell References

- Using the Fill Handle tool to enter formula

Bodmas:  dealing with the order of sums in brackets

Functions

Printing

- Displaying Row and Column Headings on your printout

- Displaying Gridlines on your printout

Borders & Shading

Charts

- Pie Chart

- Line Chart

- Bar/Column Chart

- Adding Titles and Axis Titles to a Chart

- Chart Title

- Axis Title's

- Changing the Axis Values

- Displaying Values on a Chart

- Inserting Headers and Footers on a Chart

Spell Checking

Headers and Footers