Excel 2010/13/16 Introduction

Prerequisite: Has attended the Windows XP/Vista/Windows 7 introduction course or has confidence in the use of keyboard and mouse.

Duration: One day

Course Topics

Becoming familiar with Excel
* Excel layout familiarisation
* Opening and closing workbooks
* Creating and saving workbooks
* Moving around in a worksheet
* Selecting ranges, columns and rows
* Help

Creating Spreadsheets
* Entering text, numbers, dates
* Editing cell contents
* Undo
* Auto fill to save time
* Inserting and renaming sheet tabs

Formulas
* Building formulas manually
* Building formulas with the mouse
* Arithmetic operations
* Priority of operations
* Copying formulas
* Auto calculate
* Auto sum button
* Absolute and relative references in formulas
* Functions: sum, average, count, min and max
* Checking for errors

Editing worksheets
* Columns and row widths, auto fit
* Inserting rows, columns and sheets
* Deleting cells, rows, columns and sheets
* Formats and comments
* Copying and moving text and formulas

Formatting
* Using the formatting tool bar
* Formatting text
* Formatting numbers
* Formatting dates
* Alignments
* Cell borders
* Using the formatting dialog box for

Proofing a spreadsheet
* Spell checking
* Auto correct
* Page break preview
* Page breaks
* Zoom

Printing
* Print preview
* Page set up
* Headers and footers
* Printing