Redwing

Deleting cell content

Change text in a cell

Change numbers in a cell

Enter data in to multiple cells

Deleting data from multiple cells

Saving a new workbook to you PC

Saving changes to your workbook

Saving a new workbook to One Drive

Saving a new workbook to SharePoint

Using Autosave

Recover unsaved workbooks

Using the cursor to highlight cells

Using the cursor to copy

Using the cursor to move content

Open a recently used workbook

Create shortcuts to often used workbooks

Renaming a workbook

Share by using a link

Share again

Send a link to specific people

Send as an attachment

About the QAT

Moving the QAT

Making font bold

Making font italics

Underlining font

changing font colour

Changing font size

Grow and shrink fonts

Change font style

Strikethrough content

Using super and subscript

Change cell fill colour

Remove cell fill colour

Adding dates to Excel

Using the long date format

Show day and date in a cell

Accounting format in Sterling

Currency format - in Sterling

Format as Dollars

Format as Euros

Format as a percentage

Using comma seperators

Increase and decrease spaces after decimal

Align top, middle or bottom

Rotate text up

Angle content counterclockwise

Angle content clockwise

Rotate text vertical

Custom rotation

Increase and decrease indentation

Merge and centre cells

Unmerge cells

Merge across cells

Changing merge settings

Using wrap text

Using merge and centre and wrap text together

Changing cells that are merged, centred and wrapped

What are formulas

Formula operators

BODMAS

Cell referencing

When you have created a formula...

Creating formulas that add

Creating formulas that subtract

Creating formulas that divide

Creating formulas that multiply

Using SUM to add many numbers

Using SUM to add random cells

Using AVERAGE

Finding the AVERAGE of random cells

Using COUNT

Changing formulas

Using COUNT on random cells

Using MAX

Using MAX on random cells

Using MIN

Using MIN on random cells

Adding borders to a spreadsheet

Adding bottom borders

Adding top borders

Adding a border to the right

Adding a border to the left

Removing all borders

Adding a thick border

Adding an outside border

Adding a double bottom border

Adding a thick bottom border

Adding top and bottom borders

Adding a thick top and bottom borders

Drawing borders

Drawing a grid

Removing borders with the eraser

Drawing coloured borders

Drawing custom lines

Removing borders

Using custom borders

Columns - Inserting sheet columns

Columns - Deleting sheet columns

Columns - What are #######

Columns - Inserting a column in selected part of spreadsheet

Columns - Deleting a column in selected part of spreadsheet

Columns - Deleting multiple columns from one table

Columns - Automatically change column width

Columns - How to hide columns

Columns - How to unhide columns

Columns - How to set multiple columns to the exact same width

Inserting sheet rows

Deleting sheet rows

Rows - Inserting a row in selected part of spreadsheet

Rows - Deleting a row in selected part of spreadsheet

Rows - How to set multiple rows to the exact same height

Row - Automatically change row height

How to hide rows

How to unhide rows

Selecting cells using a mouse

Selecting an enttire table

Selecting random cells

Highlight ranges not next to each other

Selecting hseet columns

Selecting sheet rows

What is cut, copy and paste

How to copy and paste

How to cut and paste

Using the clipboard

Using the format painter to copy formatting

Renaming worksheets

Copy a worksheet

Copy a worksheet to a new workbook

Copy a worksheet to a different workbook

Move a worksheet to a new workbook

Deleting a worksheet

Hiding worksheets

Unhiding worksheets

Change tab colours

Preparing your data for charts

Creating a clustered column chart

Creating a bar chart

Creating a bar chart

The link between your data and your chart

Moving a chart

About the chart ribbon tabs

The Chart design tab on the ribbom

Switching chart axes over

Filtering a chart

Creating a 3D pie chart

Adding data to a pie chart

Moving a chart to a new worksheet

Moving a chart to an existing worksheet

Printing a small table

Fit print to one page

Fit printed columns on to one page

Change print to landscape

Print a chart and table together

Print just a chart

Print part of a spreadhseet

Print tables on two or more pages

Print table headings