Course Outline

Course name: Excel Advanced 2007

Price: $299.00 (Includes GST)

Duration: 1 day

Summary

Some of the more complex aspects of Excel 2007 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
Fri, 6/08/2010	Fri, 6/08/2010	Balcatta (Rm 1)	Day	Info/register
Fri, 1/10/2010	Fri, 1/10/2010	Balcatta (Rm 1)	Day	Info/register
Tue, 23/11/2010	Tue, 23/11/2010	Balcatta (Rm 1)	Day	Info/register
Thu, 30/12/2010	Thu, 30/12/2010	Balcatta (Rm 1)	Day	Info/register

Volume discounts
1 place only - no discount 2 places 5% discount 3 places 10% discount Over 3 places 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, conditional formatting and data bars.
Use Visual Basic to create an application.
Apply protection to spreadsheets.
Integrate Excel with other applications.