Pagoda Training Ltd
Helping clients deliver effective IT training projects
 
Microsoft Excel 2003 Intermediate - Course outline
   
Duration One Day
Objectives To enable delegates to use more advanced formulae and functions, and provide a more comprehensive overview of charts. Delegates will also learn how to manage lists of data and to link two or more workbook files.
Who should attend Those who have attended the introductory course, and wish to develop more complex spreadsheet applications.
Experience needed Delegates should have attended an introductory Excel course, or gained the relevant experience through working with Excel.
   
Content Working with relative/absolute cell addresses
Named cell ranges
The Go To command

Using functions
The Paste Function Wizard
Logical functions
Date functions
Statistical functions

Creating charts
Editing charts/chart objects
Different chart types
Adding graphic objects to charts and worksheets

Using Excel to manage lists of data
Sorting data in a list
Filtering data in a list
The Data Form
The Watch Window

Linking sheets in a workbook
Linking one workbook file to another
Linking to and updating web page data
Worksheet protection
Auditing a worksheet
   
   
 

Pagoda Training Ltd, 2nd Floor, Thornborough Hall, Leyburn, North Yorkshire, DL8 5AB
Tel 01969 625596 Email training@pagoda.co.uk
Incorporated in England Registration No. 3132465
  Back to top