|
Home
>
Training
>
Microsoft
Office 2003
Excel
2003
Intermediate
1 day
This Intermediate course will help you to make the most of Excel's
powerful, but often under-used features. The course is designed
for delegates who have been using Excel regularly on a day-to-day
basis and now wish to take advantage of the additional, time saving
features available in the product.
Excel Databases
Creating a database
Adding, editing and deleting records
Using data forms
Finding information
Sorting a database (list)
Filtering information
Using AutoFilter
Setting custom criteria
Creating totals and subtotals
Formulae Revisited
Constructing Formulae
Relative and Absolute References
Special Pasting Options
The Paste Special command
Transposing data from rows to columns
Protection and Display Options
Creating, viewing and printing comments
Editing and deleting comments
Protecting workbooks
Unlocking and locking cell ranges
Protecting a worksheet
Applying and Removing File Passwords
Administration Features
Customising Excel's default options
Viewing comments
Hiding zero values
Customising toolbars
Automating Excel
Creating and modifying Styles
Creating and using Templates
AutoTemplates
Sharing Workbooks
Introduction to Macros
Running macros
Recording a macro
Assigning a macro to a tool button
Using the Personal Macro Workbook
This course is designed for delegates who are familiar with Excel
to the level of our two day Excel
2003 Introductory course, and who have been using Excel regularly
in the work place. Delegates should be confident in using formulae
and basic functions before attending this course.
10:00am
to 5:00pm
Comprehensive
course manual
included.
Refreshments
and lunch
are provided
on all courses
at the Information
Horizons
Training
Centre.
 Back
to the top
|
