Overview

Excel has long been the industry leading spreadsheet application.

Other versions

These courses are available for any version upto and including Excel 2010

Custom courses

Custom courses can be arranged containing a mixture of content from various course outlines - and other more specialised topics can be added - Webinsight aims to give you what you need.

What you get

Examples and your creations to take away with you.

3 months free support - for issues covered in the course.

Courseware or manuals are available.

Microsoft Excel

Versions:
2010, 2007, 2003

Excel introduction
1 day

Excel overview
Tour of the interface
File and filing
Navigating a worksheet
Selecting cells and ranges
Editing cell contents
Moving and copying cell contents
Autofill and Paste Special
Cell formatting
Number formats
Calculations with formulas
Caluclations with functions
Absolute vs. Relative cell addressing
Errors and error codes
Introduction to charting
Working with multiple worksheets
Protecting cells and workbooks
Page setup and printing

Excel intermediate
1 day

Hiding and displaying data
Conditional formatting
Data consolidation
Subtotals
Sorting data
Calculations with time and dates
Conditional formulas
Working with lists
AutoFilter and advanced filtering
Comments
Tracing errors
Working with templates
Pivot tables
Pivot charts
Advanced charts