Excel Video Tutorials

* The video tutorials are NOT included with the resource subscription licence

Video Title

With Sound

Without Sound

Autosave feature

Comments - how to insert a comment

Default start-up options - how to change them

Find and Replace tool

Freezing panes

Go To tool

Importing external data

Header / Footer

Hyperlink - inserting one

Paste Special

Protecting cells

Transposing data (changing from column to row)

Video Title

With Sound

Without Sound

Column - deleting one

Column - hiding them

Column - inserting new one

Column - altering the width

Row - deleting one

Row - altering the row height

Row - inserting new one

Worksheet - making a copy

Worksheet - deleting one

Worksheet - inserting new one

Worksheet - moving one

Video Title

With Sound

Without Sound

Aligning text in cells

Borders

Clearing all of the cell formats

Colouring background cells

Comment box - how to insert one

Comment box - changing the shape

Comment box - how to show all the time

Conditional Formatting

Currency

Format Painter

Gridlines - showing and hiding them

Merging cells

Scroll bars - hiding them

Tabs - hiding them

Tabs - renaming

Wrapping text

Video Title

With Sound

Without Sound

Absolute cell reference

Autofill / replicate: how to copy a formula

Hiding formulas

Showing formulas

Picking up a value from the same sheet

Picking up a value from another sheet

Using a named cell in a formula

Video Title

With Sound

Without Sound

Addition

AVERAGE

CONCATONATE

COS

COUNTA

COUNTBLANK

COUNTIF

Date today

Day of the week

IF

IF..OR

Nested IF

MAX

MEDIAN

MIN

MODE

Multiplication

Percentage

RANDBETWEEN

RANK

ROUND

ROUNDUP and ROUNDDOWN

SUM

SUMIF

TAN

VLOOKUP

Video Title

With Sound

Without Sound

Making a chart

Creating a professional looking chart

Creating a pie chart correctly

Changing the colours on a chart

Changing the axis values

Changing the chart type

Formatting the chart legend

Adding a title or labels after the chart is made

Adding a trendline

Adding an average line to a chart

Adding a dynamic title to a chart

Adding a shadow effect to a chart

Video Title

With Sound

Without Sound

Sorting data in a table

Auto Filter

Auto Filter - customising the search criteria

Video Title

With Sound

Without Sound

Drop down pick list

Validation range check

Video Title

With Sound

Without Sound

Goal Seek

Trendlines to predict the future

Video Title

With Sound

Without Sound

Opening a workbook which contains macros

Recording a basic macro (buttons to navigate)

Recording a macro to print part of a worksheet

Editing the text on macro buttons

Viewing the macro code

Video Title

With Sound

Without Sound

How to set up a basic pivot table

Video Title

With Sound

Without Sound

Print preview

Page orientation - portrait / landscape

Print Area - setting it

Printing to one page

Print a section of the worksheet

Page breaks - viewing and moving them

Gridlines

Row and column headers

Titles to repeat at the top and side of each sheet

Margins - setting them

Comments - printing comments in a worksheet