VIDEO TUTORIALS 
Excel Video Tutorials |
 |
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 |
|