Excel Module 1 - Key Skills and Formula Creation

Create workbooks and worksheets

Create different types of formula

Use basic Excel functions

Use absolute and relative references in formula

Edit and manipulate information

Format worksheets for professional presentation

Create and amend graphs

Preview, print and PDF information

Adding text, numbers, dates and times

Using automatic features

Renaming worksheets

Saving a workbook

Basic formulas

Formula syntax

Operators and brackets

Ordering calculations

The function wizard

Using SUM, AVERAGE, MAX and MIN

Copying formula

Auto calculate

Editing formulas

Using absolute references in formulas

Navigating and editing worksheets

Moving and copying

Adjusting column widths and row heights

Deleting data

Inserting and deleting columns and rows

Zoom

Freeze panes

Changing text attributes

Changing number formats

Using list autofill

Adding simple borders

Using the Mini Toolbar

Applying cell styles

Creating simple charts

Changing the type of graph

Adding data labels

Customising the graph

Creating Sparklines

Using print preview

Amending page setup options

Printing a worksheet

Using Page Layout view and Page Break

Preview