Changing the start-up default options

Accessing and using the 'Help' feature

Autofill to increment dates and values

Find and replace tool

Freezing panes

Unfreezing panes

Splitting the screen

Using 'Go to' cell

Spell check

Transposing data

Zooming in and out

Selecting data

Undo, redo

Saving as a .csv file

Importing data from a database

Importing data from a text file

Setting the file properties

Creating a new workbook

Multiple workbooks

Cells - moving cells and tables

Column - deleting one

Column - hiding

Column - unhiding

Column - inserting

Column - moving

Column - altering width

Row - deleting

Row - altering height

Scroll bars - hiding

Tabs - renaming

Tabs - setting tab colours

Worksheet - making a copy

Worksheet - deleting one

Worksheet - inserting a new one

Worksheet - moving position

Worksheet - hiding

Worksheet - showing hidden

Format painter

Shading cells - colour

Shading cells - fill effects

Cell styles - using

Cell styles - creating custom

Borders - adding

Borders - removing

Borders - double line

Borders - changing line colour

Gridlines - showing

Gridlines - hiding

Gridlines - changing colour

Gridlines - printing

Showing row and column headers

Merge cells

Unmerge cells

Wrapping text

Line breaks

Clearing contents

Themes - applying

Themes - fonts

Inserting a comment box

Deleting a comment box

Editing a comment box

Changing the colour of a comment box

How to show a comment box all the time

Cut a value from a cell

Paste no borders

Paste values

Paste special

Clearing the contents of cells

Currency format

Date format

Time format

Decimal points

Number format

Accounting style (commas)

Conditional formatting

Data bars

Icon sets

Removing rules

Header, footer - adding

Adjusting header & footer height

Adding an image to the header/footer

Adjusting the size of an image in the header

Hyperlink to a website

Hyperlink to a document

Hyperlink within a worksheet

Removing a hyperlink

Mailto hyperlink

Text formatting

Wrapping text

Line breaks

Text orientation

Symbols

Text box - adding

Text box - removing outer line and fill

Creating a table

Adding a new row to the bottom of a table

Inserting a row in the middle of a table

Adding a new column to a table

Changing the table style

Naming a table

Sorting data in a table

Moving a table

Print preview

Page orientation - portrait/ landscape

Print area - setting it

Print area - remove

Printing to one page

Page breaks - viewing

Page breaks - removing view

Page breaks - setting

Gridlines

Row and column headers

Rows to repeat at the top

Margins - changing settings

Margins - changing in print preview

Saving work

Saving as 2003 compatible

Setting default save format to 2003

Setting the autosave (recover) options

Default file save location

Save as template

Save as csv

Inserting an image

Inserting clip art

Resizing an image

Cropping an image

Rotating an image

Deleting an image

Styles and frames for images

Border around an image

Effects - shadows, glows, reflections

Order - bring to front, send behind

Grouping and ungrouping objects

Aligning objects

Brightness and contrast

Making an image black and white

Recolouring an image

Transparent background

Basic shapes - drawing

Basic shapes - adding effects

Line - drawing

Line - changing width

Line - changing colour

Line - effects e.g. bevel, shadow

Dashed line

Arrow

Arrow - changing the style

Arrows - other types

Creating a Smart Art graphic

Changing the design

Changing colours

Applying styles

Adding further boxes

Adding bullet points

Relative cell reference

Absolute cell reference

Autofill - replicating a formula

Hiding and showing a formula

Include a value from another sheet in a formula

Named range - creating

Named range - go to

Named range - delete

Named range - rename

Named range - using in a formula

Sum, average, count with no formula

Addition

Divide

Multiplication

Subtract

AVERAGE

CONCATENATE (basic)

CONCATENATE (advanced)

COUNT

COUNTA

COUNTBLANK

COUNTIF

HLOOKUP

IF

IF OR

IF AND

NESTED IF

MAX

MEDIAN

MIN

MODE

NOW (date today)

RANDBETWEEN

RANK

ROUND

ROUNDDOWN

ROUNDUP

SUM

SUMIF

VLOOKUP

Single column sort in a table

Multiple column sort in a table

Custom list sort

Create new custom list sort

Auto filter basics

Auto filter - display all rows in filtered list

Auto filter - customising search criteria

Column chart - creating

Chart title - adding

Chart title background colour

Chart title - formatting text

Legend - show, hide, move

Data labels - adding and removing

Adding X and Y axis titles

Gridlines - adding horizontal and vertical

Changing the axis

Changing the chart style

Changing the chart type

Creating a chart from data in non adjacent columns

Pie chart - creating

Pie chart - changing the style

Pie chart - moving segments

Line chart - creating

Trendline - adding

Average line - adding to a chart

Make a chart into a new sheet

Drop down pick list

Validation for data entry

Goal seek

Trendlines

Developer tab

Record a macro

Assigning a macro to a button

Viewing the macro code

Closing the macro code

Combo box

Spinner

Protecting a worksheet

Unprotecting a worksheet

Protecting a range of cells