A

Absolute cell reference

Accounting style (commas)

Adding a border

Adding a new column to a table

Adding a new row to the bottom of a table

Adding a text box

Adding an image to the header/footer

Adding X and Y axis titles to charts

Addition formula

Adjusting header & footer height

Adjusting the size of an image in the header

Aligning objects

Applying themes to fonts

Applying themes to a worksheet

Arrow

Arrow - changing the style

Arrows - other types

Autofill - replicating a formula

Autofill to increment dates and values

Auto filter basics

Auto filter - display all rows in filtered list

Auto filter - customising search criteria

Autosave (recover) options

AVERAGE function

Average without using a formula

Average line - adding to a chart

Axis on charts - changing

B

Background transparent (image)

Basic shapes - drawing

Basic shapes - adding effects

Behind - send to back

Black and white image

Borders - adding

Border around an image

Borders - changing line colour

Borders - double line

Borders - pasting without the borders

Borders - removing

Brightness and contrast of image

Bring to front

Bullet points to smart art graphic

C

Cell styles - creating custom

Cell styles - using

Cells - merging

Cells - unmerging

Cells - moving cells and tables

Cells - giving a shaded colour

Changing the chart style

Changing the chart type

Changing the table style

Changing the margin settings

Changing the margin settings using print preview

Chart - column chart - creating

Chart title - adding

Chart title background colour

Chart title - formatting text

Chart legend - show, hide, move

Chart data labels - adding and removing

Chart adding X and Y axis titles

Chart gridlines - adding horizontal and vertical

Chart changing the axis

Chart changing the chart style

Chart changing the chart type

Chart creating a chart from data in non adjacent columns

Chart: pie chart - creating

Chart: pie chart - changing the style

Chart: pie chart - moving segments

Chart: line chart - creating

Chart trendline - adding

Chart average line - adding to a chart

Chart: make a chart into a new sheet

Circle shape

Clearing contents

Clip art - inserting

Colours of borders

Colours of comment boxes

Colours of gridlines

Colours of lines

Colours - fill effects in cells

Colours - shading cells

Colours of smart art graphic

Colour of chart titles

Column - adding one to a table

Column - deleting one

Column - hiding

Column - inserting

Column - moving

Column - unhiding

Column - altering width

Column chart - creating

Combo box (form control)

Comment box - changing colours

Comment box - deleting one

Comment box - editing one

Comment box - inserting one

Comment box - show all the time

CONCATENATE function (basic)

CONCATENATE function (advanced)

Conditional formatting

Conditional formatting - data bars

Conditional formatting - icon sets

Conditional formatting - removing rules

Contents of cells - clearing

Contrast and brightness of images

Copying a worksheet

COUNT function

COUNTA function

COUNTBLANK function

COUNTIF function

Count without using a formula

Creating a new workbook

Creating a new worksheet

Create named range

Cropping an image

csv file

Currency format

Custom list sort

Custom list sort - create new

Customising cell styles

Cut a value from a cell

D

Dashed line

Data bars

Data labels on a chart - adding and removing

Data sort

Date format

Decimal points

Default file save location

Default save format - setting to 2003

Deleting a column

Deleting a comment box

Deleting an image

Delete a named range

Deleting a row

Deleting a worksheet

Deleting the contents of cells

Displaying gridlines

Division formula

Double line border

Drawing basic shapes

Drawing a line

Drop down pick list

E

Editing a comment box

Effects for images- shadows, glows, reflections

Effects for basic shapes - shadows, glows, reflections

Effects for lines - bevel, shadow

F

File properties

File save location - setting the default

Fill effects in cells

Find and replace tool

Font themes

Footer - adding

Form controls - Combo box

Form controls - Spinner

Format painter

Formatting text

Formula - basic addition

Formula - replicating

Formula - hiding and showing

Formula - Include a value from another sheet

Formula - using a named range

Forward - bring to front

Frames for images

Freezing panes

G

Glow effects

'Go to' cell

Go to named range

Goal seek

Gridlines

Gridlines - changing colour

Gridlines - hiding

Gridlines - printing

Gridlines - showing

Gridlines - adding horizontal and vertical to charts

Grouping and ungrouping objects

H

Header, footer - adding

Header, footer - adjusting the height

Header, footer - adding an image

Header, footer - adjusting the size of an image

'Help' feature

Height of a row

Hiding a column

Hiding a chart legend

Hiding a formula

Hiding gridlines

Hiding scroll bars

Hiding a worksheet

HLOOKUP function

Hyperlink to a website

Hyperlink to a document

Hyperlink in the same worksheet

Hyperlink - mailto

Hyperlink - removing

I

Icon sets

IF

IF OR

IF AND

IF NESTED

Image border

Image - black and white

Image - brightness and contrast

Image - crop

Image - delete

Image effects - shadows, glows, reflections

Image - insert

Image - recolouring

Image - resize

Image - rotate

Images - styles and frames

Image - transparent background

Image in the header/footer

Image size in the header - changing it

Inserting clip art

Import data from a database

Import data from a text file

Inserting a comment box

Inserting a header or footer

Inserting an image

Inserting a line break

Inserting a new column

Inserting a new worksheet

Inserting a row in the middle of a table

Inserting a text box

L

Landscape / portrait

Legend - show, hide, move on a chart

Line - drawing

Line - changing width

Line - changing colour

Line - effects e.g. bevel, shadow

Line breaks

Line - dashed

Line chart - creating

Link to another website

Link to a document or file

Link to another place within a worksheet

M

Macros - developer tab

Macros - record

Macros - assigning a button

Macros - Viewing the code

Macros - closing the macro code

Mailto hyperlink

Making an image black and white

Margins - changing settings

Margins - changing in print preview

MAX function

MEDIAN function

Merge cells

Merge cells - unmerging them

MIN function

MODE function

Moving cells

Moving columns

Moving a chart legend

Moving tables

Moving a table

Moving a worksheet

Multiple column sort in a table

Multiple workbooks

Multiplication formula

N

Named range - creating

Named range - go to

Named range - delete

Named range - rename

Named range - using in a formula

Naming a table

NESTED IF

New workbook

New worksheet

New sheet for charts

NOW (date today) function

Number format

O

Order - bring to front, send behind

P

Page orientation - portrait/ landscape

Page breaks - removing view

Page breaks - setting

Page breaks - viewing

Paste no borders

Paste values

Paste special

Pie chart - creating

Pie chart - changing the style

Pie chart - moving segments

Pivot table

Portrait/ landscape

Print area - setting it

Print area - remove

Print preview

Printing to one page

Printing gridlines

Printing row and column headers

Protecting a range of cells

Protecting a worksheet

R

RANDBETWEEN function

RANK function

Recolouring an image

Rectangle shape

Reflection effect

Relative cell reference

Removing a border

Removing a hyperlink

Removing conditional formatting rules

Removing chart data lables

Removing the page break view

Removing the outer line from a text box

Removing the print area

Rename a named range

Renaming tabs

Resizing an image

Rotating an image

ROUND function

ROUNDDOWN function

ROUNDUP function

Row and column headers

Row - adding to the bottom of a table

Row - deleting from a worksheet

Row - altering height in a worksheet

Row - inserting a row in the middle of a table

S

Save as a .csv file

Saving as 2003 compatible

Save as template

Saving work

Scroll bars - hiding

Security - protecting a worksheet

Security - unprotecting a worksheet

Security - protecting a range of cells

Selecting data

Send to back/ behind

Segments in a pie chart

Setting default save format to 2003

Setting page breaks

Setting the autosave (recover) options

Setting the default file save location

Setting the file properties

Setting the print area

Shading cells - colour

Shading cells - fill effects

Shadow effect

Showing a comment box all the time

Showing a formula

Showing gridlines

Showing a chart legend

Showing row and column headers

Smart Art graphic - creating

Smart Art graphic - changing the design

Smart Art graphic - changing colours

Smart Art graphic - applying styles

Smart Art graphic - adding further boxes

Smart Art graphic - adding bullet points

Sorting data - custom list sort

Sorting data - create new custom list sort

Sorting data in a table (single column)

Sorting data in a table (multiple columns)

Spell check

Spinner (form control)

Splitting the screen

Square root sign

Square shape

Start-up default options

Straight line

Styles and frames for images

Styles for smart art graphic

Subtract formula

Sum without using a formula

SUM function

SUMIF

Symbols

T

Table - creating

Table - adding a new row to the bottom

Table - adding one in the middle of a table

Table - adding a new column

Table - moving

Table - naming

Table - sort data

Table style - changing

Tabs - renaming

Tabs - setting tab colours

Template - saving as

Text box - adding

Text box - removing outer line and fill

Text formatting

Text orientation

Text themes

Text - wrapping

Themes - applying

Time format

Title - adding to a chart

Title on chart - changing background colour

Title on chart - formatting text

Transparent background on image

Transposing data

Trendline - adding

Triangle shape

U

Undo, redo

Unfreezing panes

Ungrouping and grouping objects

Unhiding a column

Unhiding a worksheet

Unmerging cells

Unprotecting a worksheet

V

Validation for data entry

Value from another sheet in formulae

Vertical or diagonal text

Viewing page breaks

VLOOKUP

W

Width of columns

Width of a line

Word wrap

Workbooks multiple

Workbook new

Worksheet - deleting one

Worksheet - hiding

Worksheet - inserting a new one

Worksheet - making a copy

Worksheet - moving position

Worksheet - showing hidden

Wrapping text

X

X and Y axis titles to charts

Y

Y axis titles to charts

Z

Zooming in and out