|
View our full
Excel Course Schedule or call 0800 019
6882 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
I | 
0800
019 6882
