Excel Video Tutorials |
![]() |
Basics - general |
* The video tutorials are NOT included with the resource subscription licence |
Basics - columns, rows, worksheet | |
Formatting your spreadsheet | |
Formulae - Basics | |
Formulae - specific formulae | |
Charts and Graphs | |
Sorting and Searching | |
Validation | |
Modelling | |
Macros | |
Pivot Table | |
Printing | |
Basics: General
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) |
Basics: Rows, columns, worksheets
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 |
Formatting your spreadsheet
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 |
Formulae: Basics
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 |
|
Formulae: How to write specific formula and functions
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 |
Charts and Graphs
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 |
|
Sorting and Searching
Video Title |
With Sound |
Without Sound |
Sorting data in a table |
||
Auto Filter |
||
Auto Filter - customising the search criteria |
Validation
Video Title |
With Sound |
Without Sound |
Drop down pick list |
||
Validation range check |
Modelling
Video Title |
With Sound |
Without Sound |
Goal Seek |
||
Trendlines to predict the future |
Macros
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 |
|
Pivot Table
Video Title |
With Sound |
Without Sound |
How to set up a basic pivot table |
Printing
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 |
We have provided a large, comprehensive range of free flash video tutorials for Excel.