Excel 2010 Video Tutorials

Miscellaneous (basics)

Changing the start-up default options

click here

Accessing and using the 'Help' feature

click here

 

Setting up a workbook

New workbook

click here

 

Using worksheets

Column width

click here

Row - delete

click here

Row - insert

click here

Tabs - rename

click here

Worksheet - insert

click here

Worksheet - delete

click here

 

Formatting worksheets

Wrap text

click here

Merging cells

click here

Format painter

click here

Themes

click here

Theme colours

click here

Headers and footers

click here

 

Data Types

Currency

click here

 

Formulae

Addition formula

click here

Subtraction formula

click here

Multiplication formula

click here

Division formula

click here

SUM formula

click here

 

Printing

Gridlines

click here

Column headers and row numbers

click here

Setting a print area

click here

Setting multiple print areas

click here

Printing the active selection

click here

Print to one page

click here

Scale to fit printing to page

click here

 

 

 

Copyright © www.teach-ict.com