Excel 2007 Video Tutorials

video tutorials for sale

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

 
or Search by topic
Charts and graphs
Comment boxes
Conditional formatting
Cutting, copying, pasting and clearing
Data types
Form controls
Formatting text
Formula - basics
Formula - general Modelling (goal seek)
Functions Printing work
Formatting worksheets - cells Saving work
Graphics and drawing tools Security
Headers and footers Setting up a workbook
Hyperlinks Smart Art graphics
Importing and exporting data Sorting and filtering
Lines and arrows Tables
Macros Using worksheets
Miscellaneous (basics) Validation

Miscellaneous (basics)

Changing the start-up default options

click here

Accessing and using the 'Help' feature

click here

Autofill to increment dates and values

click here

Find and replace tool

click here

Freezing panes

click here

Unfreezing panes

click here

Splitting the screen

click here

Using 'Go to' cell

click here

Spell check

click here

Transposing data

click here

Zooming in and out

click here

Selecting data

click here

Undo, redo

click here

 

Importing and exporting data

Saving as a .csv file

click here

Importing data from a database

click here

Importing data from a text file

click here

 

Setting up a workbook

Setting the file properties

click here

Creating a new workbook

click here

Multiple workbooks

click here

 

Using workbooks

Cells - moving cells and tables

click here

Column - deleting one

click here

Column - hiding

click here

Column - unhiding

click here

Column - inserting

click here

Column - moving

click here

Column - altering width

click here

Row - deleting

click here

Row - altering height

click here

Scroll bars - hiding

click here

Tabs - renaming

click here

Tabs - setting tab colours

click here

Worksheet - making a copy

click here

Worksheet - deleting one

click here

Worksheet - inserting a new one

click here

Worksheet - moving position

click here

Worksheet - hiding

click here

Worksheet - showing hidden

click here

 

Formatting cells in a worksheet

Format painter

click here

Shading cells - colour

click here

Shading cells - fill effects

click here

Cell styles - using

click here

Cell styles - creating custom

click here

Borders - adding

click here

Borders - removing

click here

Borders - double line

click here

Borders - changing line colour

click here

Gridlines - showing

click here

Gridlines - hiding

click here

Gridlines - changing colour

click here

Gridlines - printing

click here

Showing row and column headers

click here

Merge cells

click here

Unmerge cells

click here

Wrapping text

click here

Line breaks

click here

Clearing contents

click here

Themes - applying

click here

Themes - fonts

click here

 

Comment boxes

Inserting a comment box

click here

Deleting a comment box

click here

Editing a comment box

click here

Changing the colour of a comment box

click here

How to show a comment box all the time

click here

 

Cutting, copying, pasting and clearing

Cut a value from a cell

click here

Paste no borders

click here

Paste values

click here

Paste special

click here

Clearing the contents of cells

click here

 

Data types

Currency format

click here

Date format

click here

Time format

click here

Decimal points

click here

Number format

click here

Accounting style (commas)

click here

 

Conditional formatting

Conditional formatting

click here

Data bars

click here

Icon sets

click here

Removing rules

click here

 

Header and footer

Header, footer - adding

click here

Adjusting header & footer height

click here

Adding an image to the header/footer

click here

Adjusting the size of an image in the header

click here

 

Hyperlinks

Hyperlink to a website

click here

Hyperlink to a document

click here

Hyperlink within a worksheet

click here

Removing a hyperlink

click here

Mailto hyperlink

click here

 

Text

Text formatting

click here

Wrapping text

click here

Line breaks

click here

Text orientation

click here

Symbols

click here

Text box - adding

click here

Text box - removing outer line and fill

click here

 

Tables

Creating a table

click here

Adding a new row to the bottom of a table

click here

Inserting a row in the middle of a table

click here

Adding a new column to a table

click here

Changing the table style

click here

Naming a table

click here

Sorting data in a table

click here

Moving a table

click here

 

Printing work

Print preview

click here

Page orientation - portrait/ landscape

click here

Print area - setting it

click here

Print area - remove

click here

Printing to one page

click here

Page breaks - viewing

click here

Page breaks - removing view

click here

Page breaks - setting

click here

Gridlines

click here

Row and column headers

click here

Rows to repeat at the top

click here

Margins - changing settings

click here

Margins - changing in print preview

click here

 

Saving work

Saving work

click here

Saving as 2003 compatible

click here

Setting default save format to 2003

click here

Setting the autosave (recover) options

click here

Defualt file save location

click here

Save as template

click here

Save as csv

click here

 

Graphics and drawing tools

Inserting an image

click here

Inserting clip art

click here

Resizing an image

click here

Cropping an image

click here

Rotating an image

click here

Deleting an image

click here

Styles and frames for images

click here

Border around an image

click here

Effects - shadows, glows, reflections

click here

Order - bring to front, send behind

click here

Grouping and ungrouping objects

click here

Aligning objects

click here

Brightness and contrast

click here

Making an image black and white

click here

Recolouring an image

click here

Transparent background

click here

Basic shapes - drawing

click here

Basic shapes - adding effects

click here

 

Lines and arrows

Line - drawing

click here

Line - changing width

click here

Line - changing colour

click here

Line - effects e.g. bevel, shadow

click here

Dashed line

click here

Arrow

click here

Arrow - changing the style

click here

Arrows - other types

click here

 

Smart Art Graphics

Creating a Smart Art graphic

click here

Changing the design

click here

Changing colours

click here

Applying styles

click here

Adding further boxes

click here

Adding bullet points

click here

 

Formulae - basics

Relative cell reference

click here

Absolute cell reference

click here

Autofill - replicating a formula

click here

Hiding and showing a formula

click here

Include a value from another sheet in a formula

click here

Named range - creating

click here

Named range - go to

click here

Named range - delete

click here

Named range - rename

click here

Named range - using in a formula

click here

Sum, average, count with no formula

click here

 

Formulae

Addition

click here

Divide

click here

Multiplication

click here

Subtract

click here

 

Functions

AVERAGE

click here

CONCATENATE (basic)

click here

CONCATENATE (advanced)

click here

COUNT

click here

COUNTA

click here

COUNTBLANK

click here

COUNTIF

click here

HLOOKUP

click here

IF

click here

IF OR

click here

IF AND

click here

NESTED IF

click here

MAX

click here

MEDIAN

click here

MIN

click here

MODE

click here

NOW (date today)

click here

RANDBETWEEN

click here

RANK

click here

ROUND

click here

ROUNDDOWN

click here

ROUNDUP

click here

SUM

click here

SUMIF

click here

VLOOKUP

click here

 

Sorting and filtering

Single column sort in a table

click here

Multiple column sort in a table

click here

Custom list sort

click here

Create new custom list sort

click here

Auto filter basics

click here

Auto filter - display all rows in filtered list

click here

Auto filter - customising search criteria

click here

 

Charts and graphs

Column chart - creating

click here

Chart title - adding

click here

Chart title background colour

click here

Chart title - formatting text

click here

Legend - show, hide, move

click here

Data labels - adding and removing

click here

Adding X and Y axis titles

click here

Gridlines - adding horizontal and vertical

click here

Changing the axis

click here

Changing the chart style

click here

Changing the chart type

click here

Creating a chart from data in non adjacent columns

click here

Pie chart - creating

click here

Pie chart - changing the style

click here

Pie chart - moving segments

click here

Line chart - creating

click here

Trendline - adding

click here

Average line - adding to a chart

click here

Make a chart into a new sheet

click here

 

Validation

Drop down pick list

click here

Validation for data entry

click here

 

Modelling

Goal seek

click here

Trendlines

click here

 

Macros

Developer tab

click here

Record a macro

click here

Assigning a macro to a button

click here

Viewing the macro code

click here

Closing the macro code

click here

 

Form controls

Combo box

click here

Spinner

click here

 

Security

Protecting a worksheet

click here

Unprotecting a worksheet

click here

Protecting a range of cells

click here

 

 

Copyright © www.teach-ict.com