Are you a self-taught Excel user?  If so, you have probably overlooked some of the real power of Excel. 

This workshop will help you move beyond the ‘table with totals at the bottom’ spreadsheet and learn some new techniques to make your spreadsheets sing. 

This is an advanced workshop for EXCEL users who would like a new approach to spreadsheet design. This hands-on workshop demonstrates techniques for automating and securing spreadsheet applications and examines techniques for more efficient use of data. 

If you ever thought that Excel couldn’t do quite what you want it to do then this is the workshop you need to hone your skills.

This hands-on workshop demonstrates techniques for automating and securing spreadsheet applications and examines techniques for more efficient use of data.

If you ever thought that Excel couldn't do quite what you want it to do then this is the workshop you need to hone your skills.

• Rule No. 1 - Thinking it through!
• Useful Excel functions and features you probably missed.
• Sensible names - (how do you remember you typed something in cells AU147-V152)?
• Making decisions - logical operators and clever formulae
• Saving on typing time - lookup tables and automating entries
• Future proofing - making formulae work .... forever
• Changing your point of view - using Pivot Tables
• It can’t be done in Excel - it probably can!
• Speeding things up and automation - MACROS
• Visual Basic programming

The skills learnt on this workshop will: 

Save you time, save you frustration, enhance your use of Excel and improve the stability and validity of your spreadsheets, and broaden your knowledge of Excel and its capabilities

$650.00 per person + GST

(Minimum numbers apply before a course is confirmed)