Excel 2003 - Intermediate level

View our full Excel Course Schedule or call 0845 485 1173 today for more details

You can view this course outline as a PDF for printing

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

If you would like to make an enquiry about our Training, fill in the form below, or call us on 0845 485 1173, or email us at sales@computertrainingsolutions.co.uk

If you would like to make an enquiry about our Training, fill in the form below, or call us on 0845 485 1173, or email us at sales@computertrainingsolutions.co.uk

Name:* Please enter your name

Company:

Email:* Please enter your email

Telephone:

Contact us for:* Booking Enquiry Information Request

Course interest: Access Dreamweaver Excel Google AdWords Illustrator Indesign Not Listed/Other Outlook Photoshop PowerPoint Project Publisher Word

Message: Please enter your message