On this page you will find a collection of on-line demonstrations and text based tutorials from Microsoft Learning web sites. Demonstrations are best viewed using Internet Explorer. Some videos take time to download. If you do not see the video, click the link for 'How to do it (text version)' below the video.
Excel Overview
- Get started with Excel - overview for beginners
- Up to speed with Excel 2007
- New Excel 2007 interface
Formulas
- Basic Formulas
- Formula AutoComplete
- Define and use names in formula
- Using VLOOKUP
- Using formula to combine contents of the cells
- more on formulas >>
Analysing data
- Conditional Formatting (Video)
- Conditional Formatting (Text)
- Sorting
- Filtering
- Subtotals
- Pivot Tables and Pivot Reports
Formatting Sheets
- Insert/delete Columns and Rows
- Hide/unhide Columns and Rows
- Freeze Columns and Rows
- Merge cells
- Convert text to columns
Working with data
Formatting Documents
Charts and Graphics
More Excel 2007 Demo's available online from Microsoft. Very Useful. You will need sound on your computer.