Course Outline

Course name: Excel Advanced 2003

Price: $269.00 (Includes GST)

Duration: 1 day

Summary

Some of the more complex aspects of Excel 2003 are covered in this Advanced course. You’ll learn about Excel’s many powerful advanced formulas as well as database features. How macros work, how to create and edit macros, and how to customise the toolbars to run macros are covered; there’s even an introduction to VBA (Visual Basic for Applications). You’ll also learn how to create more user-friendly spreadsheets with data validation and conditional formatting.

Register for this course

Course start date	Course end date	Location	Mode	Info/register

Volume discounts
1 booking no discount 2 or 3 bookings 5% discount 4 bookings 10% discount 5 or more 20% discount

Course details

By the end of this course you will be able to:

Import other types of files & manipulate them.
Use advanced formulas (text, IF, COUNTIF, etc).
Use LookUp functions.
Use Excel’s database features.
Create & work with macros.
Customise the toolbars & menus.
Use data validation and conditional formatting.
Use Visual Basic to create an application.
Apply protection to spreadsheets.
Integrate Excel with other applications.