Excel 2003 - Intermediate level
Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...  
Excel 2003 - Intermediate level

Objectives
After completing this course you will know how to:
- Customise view options
- Use further techniques to format worksheet data
- Use more functions
- Use the function wizard
- Use absolute cell references in formulas
- Use Excel as a database
- Use filters and subtotals in a database
- Create charts
- Create drawing objects
- Use hyperlinks

Pre-requisites
- Experience of Windows 2000 or later
- Attendance on Excel 2003 Introduction course or equivalent experience

Course Contents
Viewing Worksheets
- Customise view options
- Display and customise toolbars
- Hide workbooks and worksheets
- Freeze panes
- Group worksheets

More Formatting Techniques
- Using styles
- Conditional formatting
- The format painter
- Hiding and displaying cells

More Formulas and Functions
- Using the series command
- Using the function wizard
- Financial functions

Correcting formulas
- Using the error checker
- Using the auditing toolbar
- Using the watch window

Absolute Cell References
- Entering an absolute column and row reference into a formula
- Entering mixed cell references into a formula

Using Logical Functions
- Using the IF function
- Nesting IF functions

Database and List Management
- Using Excel as a database
- Sorting a database
- Using Autofilters and advanced filters
- Using data forms

Charts
- Creating charts using the wizard
- Formatting charts

Linking Worksheets within a Workbook
- Renaming worksheets
- Inserting and deleting worksheets
- Creating formulas to link worksheets

Drawing and Picture Objects
- Creating drawing objects
- Using drawing toolbar to control objects

Excel 2003 and Other Applications
- Copying data from another application
- Using hyperlinks




 
Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...  
My Location
Results for location are highlighted in the table below. Click here to remove highlight
The course either has new dates in data loading, or is only run as a dedicated or In Company course.
Tools
 
Key Details
Duration1 day
 
£225
per delegate
 
 
Bookings Helpline: 01933 233884 (Monday to Thursday - 8:00am to 5:30pm and Friday 8:00am to 5:00pm).