IT solutions for WA businesses

Shopping Cart

Items: (0)

IT Training

Computer Training Microsoft Excel Microsoft Word Microsoft Powerpoint Microsoft Outlook

Training enquiries

Excellent resource for Australian document templates

A Proud Member Of
PartnerPoint
An Online Community of Microsoft Partners

Top Viruses
1.	POSSIBLE_STRAT-6
2.	WORM_NETSKY.P
3.	HTML_NETSKY.P
4.	TROJ_CONHOOK.CR
5.	ADW_SLAGENT.A
6.	TROJ_AGENT.QDV
7.	TROJ_DELF.FBO
8.	ADW_FUNWEB.Q
9.	WORM_KAPUCEN.B
10.	WORM_RJUMP.A


Webmasters: add virus info to your site

Course Outline

Course name: Excel Advanced 2007

Price: $269.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. 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, conditional formatting and data bars.
Apply protection to spreadsheets.
Integrate Excel with other applications.