Excel Video Tutorials

Basics - general

video tutorials for sale

* 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.

 

 

 

 

Copyright © www.teach-ict.com