Courses and training for financial management using Microsoft® Excel 2007

CPA Australia is offering a suite of Microsoft ® Excel 2007 training courses to help you develop more effective financial strategies. All training courses are conducted in computer training facilities and are presented by experienced Excel trainers. Increase the accuracy of your forecasting, budgeting and strategic planning with these essential Excel training courses.

Microsoft Excel 2010 training courses (PDF) now available. Download the brochure to see the full workshop series.

Workshop one: financial models using Excel 2007
Identify the procedures for developing spreadsheet models, develop and test efficient models, explore risk analysis procedures and optimisation techniques. Excel 2007 training courses are held in Melbourne, Brisbane, Perth and Sydney.

Workshop two: data analysis and business forecasting with Excel 2007
Develop data analysis and effective forecasting models. Discover a wide range of statistical functions, the data analysis add-in, summary reports, suitable models and optimisation techniques. Excel 2007 training courses are held in Melbourne, Brisbane, Perth and Sydney.

Workshop three: managing business data with Excel 2007
Master Excel’s range of chart types to improve your reports and clarify the data being analysed. Identify the most appropriate chart to accurately communicate outcomes. Excel 2007 training courses are held in Melbourne, Brisbane, Perth and Sydney.

Workshop four: using PivotTables in Excel 2007
Summarise and browse your database with PivotTables, compatible with SQL Server and online analytical processing cubes. Use PivotTables to extract and organise data, add calculated fields and publish to the web. Excel 2007 training courses are held in Melbourne, Brisbane, Perth and Sydney.

Workshop five: automating spreadsheet tasks using VBA 2007
Grasp the potential of Visual Basic for Applications (VBA) to improve your productivity. Learn to use macro recorder and VB editor, understand the importance of variable declarations and debug VBA procedures. Excel 2007 training courses are held in Melbourne, Brisbane, Perth and Sydney.