D1. SPREADSHEET BASICS (1 DAY)

COST: AUD$499 +GST

This course assumes a very basic understanding of spreadsheeting and is designed to provide participants with a thorough understanding of what can be achieved with spreadsheets. The course is practical in nature and attendees will develop significant skills, knowledge and proficiency. The main areas covered include: Introduction to spreadsheeting, Navigation & orientation, Data entry & manipulation, Formulas & referencing, Formatting, Spreadsheet design, Basic charting, Viewing & printing and Time saving techniques. (Basic)

Sign Up

D2. ADVANCED CALCULATION FUNCTIONS (1 DAY)

COST: AUD$599 +GST

This course provides an in depth understanding of the most useful calculations that can be performed within spreadsheets. It has particular value if your tasks involve significant calculations - you will be amazed at the possibility and efficiency of what's available - Learn how to perform advanced calculations in minimal time. Over one hundred functions are covered, across the following topics: Calculation functions, Date & Time functions, Text functions, Conversions, Loan functions, Accounting functions, Investment functions, Corporate Finance functions, Treasury & Pricing functions and Information functions. (Intermediate)

Sign Up

D3. ADVANCED ANALYSIS FUNCTIONS (1 DAY)

COST: AUD$599 +GST

This course extends the skills and knowledge gained from the 'Advanced Calculation Functions' course and focuses in detail on some of the most advanced analysis functions and are applicable to a wide range of users and industries. This course covers some of the most powerful functions available. An in depth understanding and appreciation of these super-powerful functions will be gained. Main topics include: Logic functions, Lookup functions, Sensitivity analysis, Scenario analysis and Creating amortisation tables. (Advanced)

Sign Up

D4. DATA MANIPULATION FUNCTIONS (1 DAY)

COST: AUD$599 +GST

This course is designed for users who work with very large amounts of data, and focuses on techniques to manage and manipulate this data to achieve meaningful results. However, you don't need to have huge amounts of data to benefit from this course, as these functions have wide application and provide an excellent compliment to the 'Advanced Analysis Functions' course. Mastery of these functions will help save you hours of mundane manual data manipulation, and will help you analyse data in ways which are otherwise impossible. Main topics include: Working with mass data, Sorting & filtering, Database functions, Basic User Control Tools, Advanced User Control Tools, Consolidation functions, Macros, Pivot Tables, Templates and Basic VBA. (Advanced)

Sign Up

D5. OUTPUTS & FINALISATION (1 DAY)

COST: AUD$599 +GST

This course is designed for fairly advanced users and focuses on the completion stages of large spreadsheeting and data analysis assignments. Avoid the embarrassment and cost of failing to detect errors, producing messy and unappealing outputs and presenting work which appears unprofessional. This course will enable you to take your output and professionalism to another level. Main topics include: Sanitising your work, Basic charting, Advanced charting, Data validations, Reviewing functions, Auditing functions, Output & Finalisation, and Exporting Output. (Advanced)

Sign Up

D6. POWER USER MASTERCLASS (2 DAYS)

COST: AUD$2,750 +GST

This course is designed for professional users with significant knowledge and experience. It covers some of the most advanced features and functions which could dramatically increase your efficiency, effectiveness and overcome some of the most annoying features of spreadsheets and data analysis. You may currently be using many of the functions covered in our other courses and have probably developed many of your own habits and methods, but even the most advanced spreadsheet users have found this course inspiring and extremely useful. Main topics include: Best practice spreadsheeting, Power input functions, Power calculation functions, Power output functions and Power miscellaneous functions. (Professional)

Sign Up