CPA
CONGRESS


Masterclasses


Enrol in Key Stream or Excel Masterclasses to complete your CPA Congress program. These half and full day intensives are designed so you can master the skills needed to advance your career and impress at work.

This program is print friendly (Internet Explorer recommended)
Sorry, there is no session available in your chosen stream.

Masterclasses at Crown Palladium

Wednesday 18 October

Morning
8.30am - 9.00am
Registration and arrival refreshments
Concurrent sessions
9.00am - 12.30pm
Trends and business impacts
MC1
Big Data business models, visualisation and innovation
As the business models for Big Data and the internet of things take shape, we see ten areas of application a few frameworks which matter more than others. In this talk we focus on a few of these areas, their applications and what to expect to change in the financial service industry.
Speaker
  • Dr Neil Fraser
    Strategy, Analytics and Data Science, Macquarie Graduate School of Management (MGSM)
    • Neil is an internationally recognised thought leader and writer in analytics and data science. He has authored and contributed to number of books, book chapters and published more than 20 articles.
    • Neil has over 20 years of experience in senior executive and consulting positions and has held the positions of CEO, Executive Director Asia Pacific for an NGO, Strategy and Planning Director at Macquarie University, Analytics and Data Science Practice Manager and General Manager in Finance and Marketing
    • He currently teaches Masters of Actuarial Practice at the Macquarie Applied Finance and Actuarial Studies (AFAS), Masters of Data Science in Faculty of Science, and Strategic Frameworks at the Macquarie Graduate School of Management (MGSM).
    • He is a regular speaker at conferences, a qualified program manager and holds three postgraduate level qualifications including a PhD in Mathematical Modelling.
    /~/media/corporate/allimages/speakers/congress-2017/neil-fraser.jpg?h=180&w=180
9.00am - 12.30pm
Finance fundamentals
MC2
Strategic finance: Moving from operational support to strategic partner

SOLD OUT

Please see also MC60 and MC61

The roles of the CFO and financial controller are evolving to include higher-value-added activities and a more strategic outlook. Finance departments are seeing an increased demand to apply strategic, forward-thinking skills and to provide more strategic analysis of reports. With more organisations experiencing an evolution of the finance role to a strategic business partner, “business as usual” will no longer be enough. In this masterclass, learn how to become a strategic partner to the organisation.

Speaker
  • David Wayne
    Senior Associate Consultant, Institute for Communication, Management and Leadership
    • David Wayne has delivered more than 1,000 leadership, management and professional development workshops to hundreds of corporate and government organisations throughout Australia, New Zealand and South-East Asia.
    • For more than four years, David ran the leadership development program for the Department of Agriculture, and is a facilitator of leadership and management programs for Federal Treasury, Department of Industry and Science and Prime Minister and Cabinet.
    • David is an MBA Graduate from Macquarie Graduate School of Management and Member of the Australian Institute of Management.
    /~/media/corporate/allimages/speakers/congress-2017/david-wayne.jpg?h=180&w=180
9.00am - 12.30pm
Operational transformation
MC3
Cross-cultural intelligence for business with Asia
In this session:
• Identify, compare and respect the complex differences between Australian and Asian cultural drivers
• Develop cultural intelligence skills and strategies to build confidence, personally and professionally, when engaging with Asian counterparts
• Understand how different cultural styles may be misinterpreted and how to apply appropriate frameworks and tools for effective engagement
• Manage challenges and use practical strategies to collaborate effectively with others in cross-cultural work environments
Speaker
  • Donna Webster
    Business Program Manager, Asialink
    • Donna has lived and worked within an Asian context for over two decades, with long-term residential stays in Japan, Malaysia, Singapore and Thailand.
    • She has extensive adult education qualifications and vast business experience, across multiple industries and countries.
    • With Asialink Business, she continues to equip individuals and organisations with the knowledge, skills and networks to enable them to engage effectively with the Asia region.
    /~/media/corporate/allimages/speakers/congress-2017/donna-webster.jpg?h=180&w=180
9.00am - 12.30pm
Strategy and leadership
MC4
Building grit, resilience and well-being
This session will cover evidence-based strategies that work, to fuel your people’s well-being, manage their stress and build their grit.

You will also discover:
• how to build true resilience to manage your work and life
• how to cultivate a growth mindset and why it matters
• the new research behind ‘grit’ and its impact when it comes to your goals
• the tools you need to build a well-being toolkit that will help you learn to thrive.
Speaker
  • Megan Dalla-Camina
    Strategist, coach, speaker and author
    • Megan is a strategist, coach, speaker and author passionate about creating positive change.
    • She has worked for GE, PwC and IBM in the areas of business strategy, marketing, gender diversity, leadership, culture and change management.
    • Her work has been featured in Forbes, Fortune, BRW and she writes for Huffington Post, Psychology Today, and other media on business, leadership and unlocking success.
    /~/media/corporate/allimages/speakers/congress-2017/megan_dalla_camina.jpg?h=180&w=180
9.00am - 12.30pm
Personal development
MC5
Focus

Unleash productivity by exploring the science of focus. It has become almost impossible to focus at work these days – quite a conundrum considering most of our tasks require high levels of concentration. In this interactive and insightful presentation, prepare to be confronted as we explore the science of focus and the limitations of this precious mental capability.

Speaker
  • Ethan Glessich
    Founder and Managing Director, Kognitive Consulting
    • Ethan assists organisations enhance productivity, performance and well-being by leveraging the latest research from cognitive science.
    • Previously an Aerospace Engineer and business consultant, Ethan is also a paragliding acrobatic pilot.
    /~/media/corporate/allimages/speakers/congress-2017/ethan-glessich.jpg?h=180&w=180
9.00am - 12.30pm
Sector in focus
MC6
Technology: Expense or asset?
This 'hands on' session is designed for finance managers and decision makers (rather than techies). Using real life example from the sector, this session will help you understand the benefits and risks associated with using technology in the NFP sector and what to consider when selecting and implementing systems.

You will learn:
• technology trends in the NFP sector
• cloud vs server based technologies
• improving mobility and accessing information remotely
• assessing your organisations digital capability and developing an improvement plan
• building a business case for moving your organisation to the cloud
• free or cheap systems that are available and commonly used by NFPs
• Business Intelligence, data visualisation and reporting
• where to find free tools, resources and help.
Speaker
  • Matt Walton
    Senior IT Consultant, Infoxchange
    • Matt Walton has over 20 years working with NFPs in a range of management and IT related roles.
    • Matt currently works as a Senior IT consultant at Infoxchange, who are a not for profit organisation delivering technology solutions to thousands of NFP organisations across the sector. 
    • Infoxchange specialise in providing independent advice and cost effective, cloud based solutions designed specifically for NFP organisations.
    /~/media/corporate/allimages/speakers/congress-2017/matt_walton.jpg?h=180&w=180
9.00am - 12.30pm
Operational transformation
MC7
Learning with LEGO® - adaptable and agile project management
A fun and highly interactive session that will get you familiar with concepts of adaptable and agile project management. You will learn Scrum methodology and focus on five of the key principles of the Agile Manifesto, all the while using LEGO® to reinforce your new found skills.
Speaker
  • James Bawtree
    Chief Executive Officer and Founder, PM Logic, President, NSW Chapter of the Australian Institute of Project Management
    • Globally qualified consultant and trainer in project, program and PMO management
    • Trained more than 1000 project, program and PMO managers
    • More than 17 years’ experience in strategy execution through project management
    • Experience also includes benefits management, strategic planning, capability management, manufacturing engineering, transformation change, mergers and acquisitions, system engineering and organisational design
    /~/media/corporate/allimages/congress/speaker-images/james-bawtree.jpg?h=180&w=180
9.00am - 12.30pm
Finance fundamentals
MC58
Performance engagements: Applying the new assurance standards

Learn how to apply the new Performance Engagement Standard (ASAE 3500), particularly the concepts of materiality and risk to improve the efficiency and quality of performance audits.

This session will include an introduction by the AUASB as it will coincide with its release of the new standard. Our presenter, Caroline Spencer, will draw on her extensive experience in conducting outsourced performance audits and performance audit quality reviews for the Auditors General, in addition to a broad range of financial and non-financial assurance engagements. This Masterclass will illustrate the approach and requirements in ASAE 3500 through case studies. Performance audits, already used extensively in the public sector (as a way to examine and hold entities accountable), are also expected to grow in use in the private sector as stakeholders increasingly hold organisations accountable for non-financial performance.

Speaker
  • Caroline Spencer FCPA
    Managing Partner, Vista Advisory
    • Founding partner of Vista Advisory and a senior advisor to public sector executives and regulated entities. 
    • Previously worked as an auditor for the private sector. 
    • Prior to relocating from Sydney to Canberra, Caroline worked the for the Big 4 and a smaller chartered firm where she audited publicly listed companies and some of Australia’s largest utilities.
    /~/media/corporate/allimages/speakers/congress-2017/caroline-spencer.jpg?h=180&w=180
9.00am - 5.00pm
Finance fundamentals
MC8
Key Accounting Standards in one day
Speaker
  • Carmen Ridley
    Principal, Australian Financial Reporting Solutions
    • Principal of Australian Financial Reporting Solutions, an independent financial reporting consulting firm 
    • Board member of the Australian Accounting Standards Board
    • External auditor for nine years in both Australia and the UK
    • Worked for one of the Big Four accounting firms prior to working in and running the technical divisions of three major accounting firms, most recently Grant Thornton
    /~/media/corporate/allimages/congress/speaker-images/carmen-ridley.jpg?h=180&w=180
Afternoon
12.30pm - 1.30pm
Lunch
Concurrent sessions
1.30pm - 5.00pm
Trends and business impacts
MC9
The hacker’s guide to cyber security
Revolutionise the way you think about cybersecurity by embracing the mindset and tools of hackers. Learn why you might be the target of a cyberattack, what makes computers vulnerable, how encryption can be used to secure internet traffic (and why that matters), and how you can protect your organisation from its biggest threat to data security – its own employees. This entertaining session will demonstrate real-life attacks and impart practical tips to keep yourself and your organisation secure.
Speaker
  • Chris Monk
    Head of Region (Asia-Pacific), Decoded
    • BSc, Economics, First Class Honours from University College London
    • Experience building trading and risk management software
    • Set up his own successful small-to-medium enterprise in 2008 
    • Speaks on digital subjects such as data strategy, cyber security and digital transformation
    /~/media/corporate/allimages/speakers/congress-2017/chris-monk.jpg?h=180&w=180
1.30pm - 5.00pm
Finance fundamentals
MC10
Driving performance: Aligning analysis and presenting to decision makers

SOLD OUT

Please see also MC60 and MC61

There is little value in producing reports on facts and data from past activities. True value is performing analysis on information, in the context of the economic environment, and producing insights that management can use to reach the true potential of the organisation. In this masterclass, David takes us through the steps to present insights in a way that is customised to the audience.

Speaker
  • David Wayne
    Senior Associate Consultant, Institute for Communication, Management and Leadership
    • David Wayne has delivered more than 1,000 leadership, management and professional development workshops to hundreds of corporate and government organisations throughout Australia, New Zealand and South-East Asia.
    • For more than four years, David ran the leadership development program for the Department of Agriculture, and is a facilitator of leadership and management programs for Federal Treasury, Department of Industry and Science and Prime Minister and Cabinet.
    • David is an MBA Graduate from Macquarie Graduate School of Management and Member of the Australian Institute of Management.
    /~/media/corporate/allimages/speakers/congress-2017/david-wayne.jpg?h=180&w=180
1.30pm - 5.00pm
Operational transformation
MC11
The three things that make a great company culture
Culture, engagement, and alignment are the most powerful tools leaders have at their disposal today when managing their largest resource pool, their employees. Join us for this masterclass as we take a journey into the field of capability building, looking at how culture, engagement, and alignment play a role in driving organisations forward. We will focus on how the best businesses enable their team members to achieve corporate objectives, give their personal best, work together as a team and feel valued and engaged, resulting in a long-term win-win relationship.
Speaker
  • Zrinka Loverncic
    Managing Director, Great Place to Work Australia
    • Since 2008, Zrinka has been working with organisations across a variety of industries and locations to assess their workplace cultures and support them as they seek to transform their organisations to become not only great workplaces, but increase their shareholder returns. 
    • As the MD of Great Place to Work Australia, Zrinka is the curator of the Business Review Weekly “Best Places to Work” list published each year, and is a featured speaker on workplace trends and management strategies. 
    • She holds a Bachelor of Commerce and Masters of Management from Macquarie University, as well as an MBA from Macquarie Graduate School of Management. 
    • Zrinka was awarded NSW Finalist in the Telstra Business Woman of the Year Awards (2013).
    /~/media/corporate/allimages/speakers/congress-2017/zrinka_lovrencic.jpg?h=180&w=180
1.30pm - 5.00pm
Strategy and leadership
MC12
The new rules of leadership
Speaker
  • Megan Dalla-Camina
    Strategist, coach, speaker and author
    • Megan is a strategist, coach, speaker and author passionate about creating positive change.
    • She has worked for GE, PwC and IBM in the areas of business strategy, marketing, gender diversity, leadership, culture and change management.
    • Her work has been featured in Forbes, Fortune, BRW and she writes for Huffington Post, Psychology Today, and other media on business, leadership and unlocking success.
    /~/media/corporate/allimages/speakers/congress-2017/megan_dalla_camina.jpg?h=180&w=180
1.30pm - 5.00pm
Personal development
MC13
Present like a pro!
Present like a pro! is a half-day masterclass designed to help you improve delivery by conveying exactly what you want to your audience with authority and authenticity. We will provide you the tools that actors use to achieve impact on stage, and offer every participant the opportunity to test some of those tools in real time.
Speaker
  • National Institute of Dramatic Art (NIDA)
    • The National Institute of Dramatic Art (NIDA) is Australia’s leading institution for education and training in the dramatic arts.
    • In addition to full-time higher education, NIDA’s corporate consultancy and training programs provide access to the philosophy and expertise of Australia’s premier organisation dedicated to the research and practice of the dramatic arts.
    • NIDA Corporate provides executives and business professionals with access to some of the most outstanding acting, voice and movement practitioners in Australia. Expert tutors deliver each session ensuring participants obtain set outcomes with a personalised focus.
    • The Masterclass will be delivered by two tutors from the pool of experts at NIDA.
    • NIDA tutors are trained practitioners in voice, movement and direction and are highly experienced in delivering presentation and communication skills training in both the public and private sectors. NIDA tutors are thought leaders with specialist arts and entertainment industry experience. They include voice specialists, movement and body language practitioners, film and theatre directors, actors and television presenters.
    /~/media/corporate/allimages/speakers/speaker-placeholder.jpg?h=180&w=180
1.30pm - 5.00pm
Sector in focus
MC14
When the only constant is change – how do you plan, budget and forecast?
In this master class we will focus on the following, taking into account constant change:

• defining the essential elements to developing an effective plan
• developing budgets that support your organisation
• developing forecasts that work
• ways to ensure staff and stakeholder engagement during planning, budgeting and forecasting.
Speaker
  • Danette Fenton-Menzies
    Director of Learning, Magical Learning • Danette is a Chartered Accountant and CPA, a certified coach, holds a Bachelor of Economics, MBA and Certificate IV in Workplace Training and Assessment, is a graduate of the Sydney Leadership program and was a finalist in the ACT Telstra Business Women’s Award (Westpac Group Business Owner).
    • Danette’s career has included working for several of the Big 4 accounting firms as well as the Department of Finance, AusAID and the National Transmission Agency.
    • Danette was also Financial Controller for National Australia Ltd.
    /~/media/corporate/allimages/speakers/congress-2017/danette_fenton_menzies.jpg?h=180&w=180
1.30pm - 5.00pm
Personal development
MC15
Live your best life: Do. Share. Dream. Live
Speaker
  • Sue Glasser
    Workshop Consultant, kikki.K
    • Sue Glasser is a well-known consultant, speaker and mentor within the fields of mindset and organisation. 
    • Sue shares kikki-K workshops which are designed to help you live your best life and include topics such as mindfulness, goals, habits, happiness and organisation.
    • Sue's understanding within these areas, combined with her passion for training and coaching mean her workshops are not to be missed.
    /~/media/corporate/allimages/speakers/congress-2017/sue-glasser.jpg?h=180&w=180
1.30pm - 5.00pm
Finance fundamentals
MC59
Professional scepticism and the red flags of fraud and misstatements

Insolvency practitioner Robyn Erskine and forensic accountant Robyn McKern, team up in this unique session to provide auditors with practical insights gained from picking over the bones of corporate collapse and corporate fraud. Through war stories and real case studies, external auditors will gain renewed professional scepticism for the conduct of financial report audits, as well as internal auditors in their internal monitoring role. This session will be thought-provoking for auditors in considering the red flags which may have been present and whether or to what extent those red flags could have been identified and acted upon.

Speakers
  • Robyn Erskine
    Partner, Brooke Bird
    • Robyn has been actively involved in the insolvency industry over the past 30 years and has undertaken a wide range of assignments both formal and informal in many and diverse industry segments.
    • She has undertaken specific investigations into insolvent trading, unfair preferences and non-commercial transactions, and has prepared specialist reports for various stakeholders including financiers and the Australian Securities and Investments Commission.
    • With such a depth of experience, Robyn is a strong advocate of early intervention and assisting parties in understanding all of the options available to individuals and businesses in financial distress.
    /~/media/corporate/allimages/speakers/speaker-placeholder.jpg?h=180&w=180
  • Robyn McKern
    Partner, McGrath Nicol
    • Robyn is a foundation Partner of McGrathNicol and leads the forensic team in Melbourne. Robyn served as the firm’s Chief Executive Officer from 2011 to June 2016.
    • Robyn has extensive experience in dispute resolution, forensic investigations and governance matters drawn from a long career in a range of roles, including as a registered liquidator and member of the Board of ARITA (the insolvency and restructuring peak professional body).
    • Robyn has also undertaken forensic financial investigations, and analysed the financial and commercial consequences of alternative courses of action, reporting with acuity to drive effective and timely decision making by stakeholders.
    /~/media/corporate/allimages/speakers/speaker-placeholder.jpg?h=180&w=180

MASTERCLASSES AT CPA AUSTRALIA OFFICES

Thursday 19 October

Morning
8.30am - 9.00am
Registration and arrival refreshments
9.00am - 12.30pm
Finance fundamentals
MC60
Strategic finance: Moving from operational support to strategic partner
The roles of the CFO and financial controller are evolving to include higher-value-added activities and a more strategic outlook. Finance departments are seeing an increased demand to apply strategic, forward-thinking skills and to provide more strategic analysis of reports. With more organisations experiencing an evolution of the finance role to a strategic business partner, “business as usual” will no longer be enough. In this masterclass, learn how to become a strategic partner to the organisation.
Speaker
  • David Wayne
    Senior Associate Consultant, Institute for Communication, Management and Leadership
    • David Wayne has delivered more than 1,000 leadership, management and professional development workshops to hundreds of corporate and government organisations throughout Australia, New Zealand and South-East Asia.
    • For more than four years, David ran the leadership development program for the Department of Agriculture, and is a facilitator of leadership and management programs for Federal Treasury, Department of Industry and Science and Prime Minister and Cabinet.
    • David is an MBA Graduate from Macquarie Graduate School of Management and Member of the Australian Institute of Management.
    /~/media/corporate/allimages/speakers/congress-2017/david-wayne.jpg?h=180&w=180
Afternoon
12.30pm - 1.30pm
Lunch
1.30pm - 5.00pm
Finance fundamentals
MC61
Driving performance: Aligning analysis and presenting to decision makers
There is little value in producing reports on facts and data from past activities. True value is performing analysis on information, in the context of the economic environment, and producing insights that management can use to reach the true potential of the organisation. In this masterclass, David takes us through the steps to present insights in a way that is customised to the audience.
Speaker
  • David Wayne
    Senior Associate Consultant, Institute for Communication, Management and Leadership
    • David Wayne has delivered more than 1,000 leadership, management and professional development workshops to hundreds of corporate and government organisations throughout Australia, New Zealand and South-East Asia.
    • For more than four years, David ran the leadership development program for the Department of Agriculture, and is a facilitator of leadership and management programs for Federal Treasury, Department of Industry and Science and Prime Minister and Cabinet.
    • David is an MBA Graduate from Macquarie Graduate School of Management and Member of the Australian Institute of Management.
    /~/media/corporate/allimages/speakers/congress-2017/david-wayne.jpg?h=180&w=180

Masterclasses at Saxons Training Facility

Thursday 19 October

Morning
Concurrent sessions
9.00am - 12.30pm
Finance fundamentals
MC16
Intermediate: Business forecasting models
Business forecasting models can help a business to understand its environment, improve its decision making and make better use of its customer database. Excel has a range of built-in functions and optimising routines that may be used to build effective forecasting models.

In this session you’ll learn to:
• become familiar with a variety of common forecasting models
• use Excel charts to identify patterns in data and suitable forecasting models
• distinguish between a stationary and a non-stationary data series
• identify and model trend and seasonality in business data
• choose appropriate models to deal with common business data
• compare forecasts and identify criteria to select the best model
• use Solver to select the optimal parameters for a model
• integrate forecasts with the budget process.
Speaker
  • Anne Flaherty
    Consultant, Glentees Professional Services /~/media/corporate/allimages/speakers/congress-2017/anne_flaherty.jpg?h=180&w=180
9.00am - 12.30pm
Finance fundamentals
MC17
Advanced: Advanced filter techniques
Excel’s Auto and Advanced filter features are an excellent method of filtering data stored in an Excel list or database. While the Auto Filter is easy to use, the Advanced filter requires greater effort but allows for the extraction of records based on more complex criteria.

In this session you’ll learn to:
• understand applications of Logical functions in Excel
• use Logical functions as criteria with the Advanced Filter
• create drop-down lists and dependent lists using Data Validation
• assign static and dynamic range names
• use array formulas with a variety of mathematical operators
• understand the different uses of the AGGREGATE function (new in Excel 2010)
• display data using worksheet controls
• create a Gage chart to display relative position in a database
• build a basic search engine in Excel
• construct a dynamic sub-list based on search characters.
Speaker
  • Dr Jason Choo
    Lecturer, Department of Banking and Finance, Monash University
    • Tenured academic in the Department of Banking and Finance of Monash University since 2002
    • Prior to academia, he worked as a private banker with Standard Chartered Bank in Singapore
    • Since 2005, Jason has consulted and trained for the CPA in professional development programs specialising in the application of Excel to improve the productivity of accounting reports and business analysis
    • BBus (Hons), MCom (Hons), PhD
    /~/media/corporate/allimages/speakers/congress-2017/jason-choo.jpg?h=180&w=180
9.00am - 12.30pm
Finance fundamentals
MC18
Advanced: Dashboard foundations
This session will introduce the key Excel tools used for developing dashboards. This collection of graphs, tables, statistical calculations and significant data, enable management to monitor critical processes.

You’ll learn how to:
• appreciate the benefits of dashboards
• understand and construct a data model that funnels source data to a dashboard
• create mini-charts and labelling techniques for use with Excel dashboards
• employ key Excel functions to organise the calculation area of a data model
• use Excel’s camera and linked picture tools to dynamically display tabular and graphical data
• use Sparklines to display trends in data
• add interactive controls.
Speaker
  • Dr John Byrne
    Consultant and former academic
    • Holds undergraduate qualifications in Civil Engineering and Computer Science, a teaching certificate, a Master’s degree in Mathematics and a PhD in Statistics
    • Former Civil Engineer in both contracting and consulting environments
    • Former academic in a university business school
    • Experience as a consultant to governments, professional bodies and commercial organisations in financial modelling and forecasting
    • Experience as a trainer for professional bodies and financial organisations
    • Regular presenter of Excel workshops for CPA Australian since 1996
    • As an academic, he published a number of theoretical papers in prestigious, international journals which are included in the Science and Social Science citation indices
    /~/media/corporate/allimages/speakers/congress-2017/john-byrne.jpg?h=180&w=180
Afternoon
12.30pm - 1.30pm
Lunch
Concurrent sessions
1.30pm - 5.00pm
Finance fundamentals
MC19
Intermediate: Visualising data level 1 – building dynamic charts
An appropriate and well-designed chart is an effective method of communicating key features of data and is essential in presenting a business case. The charts feature has been significantly improved in Excel 2007/2010/2013.

You can produce charts from Pivot Tables, customise charts and create interactive charts. Sparklines or mini charts (introduced in Excel 2010) draw attention to trends in data that would otherwise go unnoticed.  Dynamic charts will automatically update to reflect any changes in the source data.

In this session you’ll learn how to:
• use Excel's basic chart types
• format and customise charts
• create an interactive chart
• create dynamic charts using range names
• identify the right chart to use and avoid common mistakes
• create Sparklines
• add form controls to charts to enhance the display of information
• use key Excel functions to control chart display.
Speaker
  • Dr Foula Kopanidis
    Senior Lecturer, School of Economics, Finance and Marketing, RMIT University • Foula has undergraduate and postgraduate qualifications in Education and a PhD in Marketing.
    • She is currently a Senior Lecturer in the Department of Economics and Finance at RMIT University in Melbourne where she teaches a postgraduate course on consumer behaviour.
    • She has won numerous awards for both her teaching and her research papers.
    • Foula is highly regarded by her students as a teacher and a supervisor because of her well documented passionate commitment to her students.
    /~/media/corporate/allimages/speakers/speaker-placeholder.jpg?h=180&w=180
1.30pm - 5.00pm
Finance fundamentals
MC20
Advanced: Building dashboards
This workshop, part two of the dashboard course, introduces the concept of an Excel dashboard or executive report. This is a dynamic worksheet that is visible on a standard computer screen. Participants will learn to use the familiar reporting tools available in Excel 2013 and earlier versions using the Ribbon interface.

You’ll learn to:
• appreciate the benefits of dashboard reporting
• understand the data model which funnels source data to a dashboard
• employ key Excel functions to organise the calculation area of a data model
• integrate the various Excel reporting tools to create dynamic dashboards
• use Slicers to display different reports and Sparklines to examine trends
• add interactive controls to dashboards
• create dashboards supported by Tables and Pivot Table reports.

Part one and two of this workshop, which is conducted in Excel 2013, are compatible with Excel versions 2007 and 2010 with the exception of some new features available in later versions.
Speaker
  • Dr John Byrne
    Consultant and former academic
    • Holds undergraduate qualifications in Civil Engineering and Computer Science, a teaching certificate, a Master’s degree in Mathematics and a PhD in Statistics
    • Former Civil Engineer in both contracting and consulting environments
    • Former academic in a university business school
    • Experience as a consultant to governments, professional bodies and commercial organisations in financial modelling and forecasting
    • Experience as a trainer for professional bodies and financial organisations
    • Regular presenter of Excel workshops for CPA Australian since 1996
    • As an academic, he published a number of theoretical papers in prestigious, international journals which are included in the Science and Social Science citation indices
    /~/media/corporate/allimages/speakers/congress-2017/john-byrne.jpg?h=180&w=180
1.30pm - 5.00pm
Finance fundamentals
MC21
Intermediate: Data management – tables, pivot tables and consolidation
Tables and Pivot Tables are among Excel’s most powerful data management tools, making it relatively easy to combine data from different worksheets or workbooks and build reports that are directly linked to a data source.

This session will emphasise features of Excel’s new Ribbon interface and features that are new to 2007/2010.

You’ll learn to:
• create Tables and understand structured referencing
• use structured referencing to extract information from Tables
• use Tables as a dynamic range name to support PivotTable reports
• build Pivot Table reports from various data sources
• create Pivot Table reports based on multiple data sources
• understand and use calculated fields and calculated items
• understand grouping and apply it to Pivot Table reports
• employ the consolidate tool to create reports
• employ Pivot Tables to consolidate data from various worksheets.
Speaker
  • Anne Flaherty
    Consultant, Glentees Professional Services /~/media/corporate/allimages/speakers/congress-2017/anne_flaherty.jpg?h=180&w=180

Friday 20 October

Morning
Concurrent sessions
9.00am - 12.30pm
Finance fundamentals
MC22
Intermediate: Data analysis
Professionals in the public and private sectors are confronted daily with mountains of data which they must interpret. Extracting and analysing key information to help the business understand its customers and markets is now readily available with Excel’s tools for data analysis.

In this session you’ll learn how to:
• use selected statistical functions in Excel
• use the Data Analysis add-In to obtain descriptive measures and apply Regression analysis
• quantify the nature and strength of relationships between variables
• appreciate Basic statistical distributions
• use handling lists in Excel
• access data stored in an external database using Microsoft Query to extract key information for subsequent analysis in Excel
• use Excel’s Sampling tools
• apply the Subtotal function.
Speaker
  • Anne Flaherty
    Consultant, Glentees Professional Services /~/media/corporate/allimages/speakers/congress-2017/anne_flaherty.jpg?h=180&w=180
9.00am - 12.30pm
Finance fundamentals
MC23
Intermediate: Data management – filters and functions
The management and reporting of data is an important feature of the modern business organisation. Excel’s features provide considerable flexibility and are a very powerful and efficient way to extract and summarise data.

In this session you’ll learn about:
• AutoFilters and Advanced Filter techniques
• importing data from a Microsoft Access file and other database formats
• techniques to clean imported data
• Excel’s lookup and reference functions
• conditional functions to extract summary information from databases
• dynamic range names with conditional functions
• Form controls, such as combo boxes, to selectively display information
• data validation to create lists to conditionally display information
• Microsoft Query to import data from external sources.
Speaker
  • Dr Jason Choo
    Lecturer, Department of Banking and Finance, Monash University
    • Tenured academic in the Department of Banking and Finance of Monash University since 2002
    • Prior to academia, he worked as a private banker with Standard Chartered Bank in Singapore
    • Since 2005, Jason has consulted and trained for the CPA in professional development programs specialising in the application of Excel to improve the productivity of accounting reports and business analysis
    • BBus (Hons), MCom (Hons), PhD
    /~/media/corporate/allimages/speakers/congress-2017/jason-choo.jpg?h=180&w=180
9.00am - 12.30pm
Finance fundamentals
MC24
Advanced: VBA level one
Prerequisite: advanced spreadsheet skills

Visual Basic for Applications (VBA) is a programming language that extends the functionality of the Microsoft Excel spreadsheet. This course introduces modular programming using VBA, the first step in automating routine tasks in Excel and ultimately leading to dramatic productivity improvements.

In this session you’ll learn:
• the basics of VBA and how it adds functionality to Excel
• the structure of the VBA language
• how to use the macro recorder to record simple tasks in Excel and how it assists with understanding VBA code
• how to use the Visual Basic Editor, Project Explorer window and the Object Browser
• how to create procedures to solve modularised tasks
• how to debug VBA procedures with the aid of built-in debugging tools
• the concept of loops and program control.
Speaker
  • Alan Serry
    Lecturer, Department of Accounting, Monash University • Alan has undergraduate and postgraduate qualifications in economics and accounting. He is a Chartered Accountant who has worked in a consulting role for a large accounting firm and has also worked as an advisor to government.
    • Since 1991 he has been employed with the Department of Accounting (Clayton) in the Faculty of Business and Economics of Monash University.
    • For many years he has worked as a presenter at the CPA Congress in Melbourne.
    /~/media/corporate/allimages/speakers/speaker-placeholder.jpg?h=180&w=180
Afternoon
12.30pm - 1.30pm
Lunch
Concurrent sessions
1.30pm - 5.00pm
Finance fundamentals
MC25
Intermediate: Tips and tricks to improve your Excel productivity

SOLD OUT

Look at MC30

Many end-users of Excel are self-taught and may be using it inefficiently without getting the maximum benefit.

This session will introduce techniques that can improve your productivity when using Excel and put you on the road to becoming a power user.

In this session you’ll learn how to:
• master shortcut techniques for copying and pasting
• master the fill handle and other data-entry techniques
• employ data-entry techniques for layout and formula entry
• use range names to refer to specific data
• replace many formulas with one array formula
• apply styles and themes to worksheet data
• use formatting and the format painter for consistency of appearance
• understand and use custom lists and drop down lists
• perform inexact searches
• create an image of a range
• password protect the workbook
• limit the usable area in a worksheet
• convert a list table
• use the AutoSum function and the VLOOKUP function
• understand and use various text and reference functions
• understand and use Excel tables, Pivot Tables and Sparklines
• use hyperlinks to navigate worksheets, send emails and access the internet.
Speaker
  • Dr John Byrne
    Consultant and former academic
    • Holds undergraduate qualifications in Civil Engineering and Computer Science, a teaching certificate, a Master’s degree in Mathematics and a PhD in Statistics
    • Former Civil Engineer in both contracting and consulting environments
    • Former academic in a university business school
    • Experience as a consultant to governments, professional bodies and commercial organisations in financial modelling and forecasting
    • Experience as a trainer for professional bodies and financial organisations
    • Regular presenter of Excel workshops for CPA Australian since 1996
    • As an academic, he published a number of theoretical papers in prestigious, international journals which are included in the Science and Social Science citation indices
    /~/media/corporate/allimages/speakers/congress-2017/john-byrne.jpg?h=180&w=180
1.30pm - 5.00pm
Finance fundamentals
MC26
Advanced: Power Pivot using Excel 2013
Microsoft introduced some powerful business intelligence tools with the release of Excel 2010. Significant among these was Power Pivot.

In this session you’ll learn to:
• install the Power Pivot add-in
• become familiar with the Power Pivot Ribbon
• get data into Power Pivot from different sources
• understand and use the Data Model
• establish relationships between Power Pivot tables
• become familiar with the process of creating reports using the Power Pivot field list
• work with calculated formulas in the Power Pivot Window
• create Pivot Tables from linked tables
• use Slicers and Timelines.
Speaker
  • Sam Broder
    Analytics Consultant, KPMG Australia
    • Sam is an Analytics Consultant with more than 3 years’ experience in the strategic assessment, development and implementation of analytical, data-driven solutions to clients, leveraging Excel and a range of other technical software.
    • Sam has worked across a range of industries, liaising with clients to understand business problems and applying quantitative, analytical and research-driven methodologies to recommend and deliver solutions that bring value to businesses.
    • Specialising in business intelligence and data visualisation, Sam has experience across a range of industries, with extensive experience within tertiary education, marketing services, private health insurance and banking.
    /~/media/corporate/allimages/speakers/speaker-placeholder.jpg?h=180&w=180
1.30pm - 5.00pm
Finance fundamentals
MC27
Intermediate: Data management – tables, pivot tables and consolidations

SOLD OUT

Look at MC43

Tables and Pivot Tables are among Excel’s most powerful data management tools, making it relatively easy to combine data from different worksheets or workbooks and build reports that are directly linked to a data source.

This session will emphasise features of Excel’s new Ribbon interface and features that are new to 2007/2010.

You’ll learn to:
• create Tables and understand structured referencing
• use structured referencing to extract information from Tables
• use Tables as a dynamic range name to support PivotTable reports
• build Pivot Table reports from various data sources
• create Pivot Table reports based on multiple data sources
• understand and use calculated fields and calculated items
• understand grouping and apply it to Pivot Table reports
• employ the consolidate tool to create reports
• employ Pivot Tables to consolidate data from various worksheets.
Speaker
  • Anne Flaherty
    Consultant, Glentees Professional Services /~/media/corporate/allimages/speakers/congress-2017/anne_flaherty.jpg?h=180&w=180

Monday 23 October

Morning
Concurrent sessions
9.00am - 12.30pm
Finance fundamentals
MC28
Advanced: VBA level one
Prerequisite: advanced spreadsheet skills

Visual Basic for Applications (VBA) is a programming language that extends the functionality of the Microsoft Excel spreadsheet. This course introduces modular programming using VBA, the first step in automating routine tasks in Excel and ultimately leading to dramatic productivity improvements.

In this session you’ll learn:
• the basics of VBA and how it adds functionality to Excel
• the structure of the VBA language
• how to use the macro recorder to record simple tasks in Excel and how it assists with understanding VBA code
• how to use the Visual Basic Editor, Project Explorer window and the Object Browser
• how to create procedures to solve modularised tasks
• how to debug VBA procedures with the aid of built-in debugging tools
• the concept of loops and program control.
Speaker
  • Dr Vince Bruno
    Lecturer, Business IT and Logistics, RMIT University
    • Has worked in IT industry and academia
    • Academically, he has focused on the Information Systems area for teaching and learning, and research activities
    • Extensive experience teaching IT-related courses from database, programming and the Microsoft range of products
    • Research has predominantly focused on qualitative research methods having taught and supervised students
    • Holds a Bachelor and Master’s in Computer Science and completed a PhD in Information Systems that examined the improvement of usability activities in IT projects
    /~/media/corporate/allimages/speakers/congress-2017/vince-bruno.jpg?h=180&w=180
9.00am - 12.30pm
Finance fundamentals
MC29
Intermediate: Business forecasting models
Business forecasting models can help a business to understand its environment, improve its decision making and make better use of its customer database. Excel has a range of built-in functions and optimising routines that may be used to build effective forecasting models.

In this session you’ll learn to:
• become familiar with a variety of common forecasting models
• use Excel charts to identify patterns in data and suitable forecasting models
• distinguish between a stationary and a non-stationary data series
• identify and model trend and seasonality in business data
• choose appropriate models to deal with common business data
• compare forecasts and identify criteria to select the best model
• use Solver to select the optimal parameters for a model
• integrate forecasts with the budget process.
Speaker
  • Anne Flaherty
    Consultant, Glentees Professional Services /~/media/corporate/allimages/speakers/congress-2017/anne_flaherty.jpg?h=180&w=180
9.00am - 12.30pm
Finance fundamentals
MC30
Intermediate: Tips and tricks to improve your excel productivity
Excel 2016 introduces a number of innovations. The Data Ribbon has changed, Power Query and Power Pivot are now an integral part of Excel, there is a new Forecast tool and additional features among the tabs in the Tell Me facility. There are also a number of new charts available such as hierarchy, waterfall, Pareto, box and whisker charts.

In this session you’ll learn how to:
• understand the changes to the Backstage View and ribbon
• use the Forecast button to enable predictive forecasts
• make use of the Tell Me facility
• understand the use of the new chart types available in Excel 2016
• master the data gathering and data modelling facilities now incorporated into Excel 2016.
Speaker
  • Miriam O'Brien
    Miriam O’Brien Consulting • Miriam O'Brien offers management consulting services to federal, state and local government, large corporations, small and medium businesses, industry and community-based organisations and professional associations.
    • Miriam established the firm in 1991 after four years senior consulting experience with Touche Ross / KPMG Management Consultants.
    • She draws on experience in both public and private sectors, including seven years in a senior role in state government and several years in the manufacturing and service sectors.
    /~/media/corporate/allimages/congress/speaker-images/speaker-no-photo-headshot.jpg?h=180&w=180
Afternoon
12.30pm - 1.30pm
Lunch
Concurrent sessions
1.30pm - 5.00pm
Finance fundamentals
MC31
Advanced: VBA level two
Prerequisites: advanced spreadsheet skills. Prior completion of the level one course (introduction to VBA) recommended.

This workshop builds on the concepts introduced in the level one session. The power of VBA becomes more apparent as one’s knowledge of the language increases and with the experience gained from using it to automate progressively more complex tasks.

In this session you’ll learn how to:
• generate code by using the Macro Recorder for specific tasks
• understand various types of Excel objects
• understand and use the code generated by the macro recorder
• learn about naming and code writing conventions
• use the macro recorder to generate and understand the code required for the creation of Pivot Tables and Charts
• use VBA and MS Outlook to email Excel files and add data to Word documents.
Speaker
  • Dr Vince Bruno
    Lecturer, Business IT and Logistics, RMIT University
    • Has worked in IT industry and academia
    • Academically, he has focused on the Information Systems area for teaching and learning, and research activities
    • Extensive experience teaching IT-related courses from database, programming and the Microsoft range of products
    • Research has predominantly focused on qualitative research methods having taught and supervised students
    • Holds a Bachelor and Master’s in Computer Science and completed a PhD in Information Systems that examined the improvement of usability activities in IT projects
    /~/media/corporate/allimages/speakers/congress-2017/vince-bruno.jpg?h=180&w=180
1.30pm - 5.00pm
Finance fundamentals
MC32
Powerful presentations using Microsoft Office
This session will help you build your presentation skills to communicate more effectively with your audience, using Microsoft Office 2013 and integrating information between Word, Excel and PowerPoint.

In this session you’ll learn how to:
• structure your presentation or report so that the information sticks with your audience
• be more productive by using valuable shortcuts
• get familiar with different ways of linking or copying information between Word, Excel and PowerPoint
• display in one application, using updateable charts and tables created in another application through dynamic links
• copy charts and tables from one application to another
• use animation and hyperlinks in Microsoft PowerPoint
• save your PowerPoint slide show in different ways and which to choose for different purposes
• avoid common pitfalls and wow your audience with easy-to-use features and guidelines for good presentation
• best use PowerPoint, Word and Excel to convey a message
• make a Word report more readable, making good use of templates, styles, and dynamically shared charts and data.
Speaker
  • Miriam O'Brien
    Miriam O’Brien Consulting • Miriam O'Brien offers management consulting services to federal, state and local government, large corporations, small and medium businesses, industry and community-based organisations and professional associations.
    • Miriam established the firm in 1991 after four years senior consulting experience with Touche Ross / KPMG Management Consultants.
    • She draws on experience in both public and private sectors, including seven years in a senior role in state government and several years in the manufacturing and service sectors.
    /~/media/corporate/allimages/congress/speaker-images/speaker-no-photo-headshot.jpg?h=180&w=180
1.30pm - 5.00pm
Finance fundamentals
MC33
Power Query and Power View using Excel 2013
Power Query is an Excel add-in that can be used for data discovery, reshaping data and combining data from different sources, including the internet and virtually any standard database format.

Power View is a powerful report generating tool and a key component of the Power BI suite. The reports, called visualisations, take the familiar form of tables, charts and geospatial positioning on a map supported by the Bing search engine.

In this session you’ll learn how to:
• download and install the Power Query add-in
• use Power Query to download data from the internet and add it to a data model
• create and merge queries, and append files
• transform data and make it suitable for report creation
• employ Power View to create visualisations supported by the data model
• create interactive dashboards using Power Query
• add filters and slicers to visualisations.
Speaker
  • Dr John Byrne
    Consultant and former academic
    • Holds undergraduate qualifications in Civil Engineering and Computer Science, a teaching certificate, a Master’s degree in Mathematics and a PhD in Statistics
    • Former Civil Engineer in both contracting and consulting environments
    • Former academic in a university business school
    • Experience as a consultant to governments, professional bodies and commercial organisations in financial modelling and forecasting
    • Experience as a trainer for professional bodies and financial organisations
    • Regular presenter of Excel workshops for CPA Australian since 1996
    • As an academic, he published a number of theoretical papers in prestigious, international journals which are included in the Science and Social Science citation indices
    /~/media/corporate/allimages/speakers/congress-2017/john-byrne.jpg?h=180&w=180

Tuesday 24 October

Morning
Concurrent sessions
9.00am - 12.30pm
Finance fundamentals
MC34
Intermediate: Analysing residential investment property
An efficiently designed spreadsheet model for financial analysis can provide enormous flexibility and important insights for investment decision making.

This session employs various Excel tools in practical applications of investing in the residential property market, emphasising features of Excel’s new Ribbon interface and those that are new to 2007, 2010 and 2013.

In this session you’ll learn how to:
• estimate the after-tax return for residential property investments under conditions of certainty and uncertainty
• evaluate property investments using alternative loan structures
• examine tax-effective methods of investing in residential property
• implement strategies for building a wealth base using property investments
• build spreadsheet-based investment models
• link model components across worksheets and consolidate information
• use nested functions and array formulas to enhance the model-building process
• use Excel's model-interrogation tools
• appreciate the benefits of investing in residential property
• evaluate investment alternatives and make recommendations.
Speaker
  • Anne Flaherty
    Consultant, Glentees Professional Services /~/media/corporate/allimages/speakers/congress-2017/anne_flaherty.jpg?h=180&w=180
9.00am - 12.30pm
Finance fundamentals
MC35
Intermediate: Financial models using Excel
Building financial models in Excel requires a structured approach and a sound knowledge of the tools available. A model that has not been well designed can lead to incorrect conclusions. This session focuses on a structured approach to spreadsheet model building.

You’ll learn to:
• become familiar with specific features of Excel 2013 (including 2007 and 2010)
• appreciate the benefits of properly constructing spreadsheet-based financial models
• design structured spreadsheets models that clearly identify inputs, calculations and results
• acquire an applied knowledge of selected Excel financial functions
• build an efficient model to incorporate the measurement of risk
• carry out what if and scenario analysis, including the use of in-built scenario summaries and scenario pivot tables
• identify the best and worst outcomes, and how they may be used in a decision framework
• develop optimisation models using Solver and appreciate the reports generated by Solver
• appreciate the limitations of modelling.
Speaker
  • Dr Jason Choo
    Lecturer, Department of Banking and Finance, Monash University
    • Tenured academic in the Department of Banking and Finance of Monash University since 2002
    • Prior to academia, he worked as a private banker with Standard Chartered Bank in Singapore
    • Since 2005, Jason has consulted and trained for the CPA in professional development programs specialising in the application of Excel to improve the productivity of accounting reports and business analysis
    • BBus (Hons), MCom (Hons), PhD
    /~/media/corporate/allimages/speakers/congress-2017/jason-choo.jpg?h=180&w=180
9.00am - 12.30pm
Finance fundamentals
MC36
Introduction to Power Pivot using Excel 2013
Microsoft introduced some powerful business intelligence tools with the release of Excel 2010. Significant among these was Power Pivot.

In this session you’ll learn to:
• install the Power Pivot add-in
• become familiar with the Power Pivot Ribbon
• get data into Power Pivot from different sources
• understand and use the Data Model
• establish relationships between Power Pivot tables
• become familiar with the process of creating reports using the Power Pivot field list
• work with calculated formulas in the Power Pivot Window
• create Pivot Tables from linked tables
• use Slicers and Timelines.
Speaker
  • Dr John Byrne
    Consultant and former academic
    • Holds undergraduate qualifications in Civil Engineering and Computer Science, a teaching certificate, a Master’s degree in Mathematics and a PhD in Statistics
    • Former Civil Engineer in both contracting and consulting environments
    • Former academic in a university business school
    • Experience as a consultant to governments, professional bodies and commercial organisations in financial modelling and forecasting
    • Experience as a trainer for professional bodies and financial organisations
    • Regular presenter of Excel workshops for CPA Australian since 1996
    • As an academic, he published a number of theoretical papers in prestigious, international journals which are included in the Science and Social Science citation indices
    /~/media/corporate/allimages/speakers/congress-2017/john-byrne.jpg?h=180&w=180
Afternoon
12.30pm - 1.30pm
Lunch
Concurrent sessions
1.30pm - 5.00pm
Finance fundamentals
MC37
Intermediate: Financial models using Excel
Building financial models in Excel requires a structured approach and a sound knowledge of the tools available. A model that has not been well designed can lead to incorrect conclusions. This session focuses on a structured approach to spreadsheet model building.

You’ll learn to:
• become familiar with specific features of Excel 2013 (including 2007 and 2010)
• appreciate the benefits of properly constructing spreadsheet-based financial models
• design structured spreadsheets models that clearly identify inputs, calculations and results
• acquire an applied knowledge of selected Excel financial functions
• build an efficient model to incorporate the measurement of risk
• carry out what if and scenario analysis, including the use of in-built scenario summaries and scenario pivot tables
• identify the best and worst outcomes, and how they may be used in a decision framework
• develop optimisation models using Solver and appreciate the reports generated by Solver
• appreciate the limitations of modelling.
Speaker
  • Dr Jason Choo
    Lecturer, Department of Banking and Finance, Monash University
    • Tenured academic in the Department of Banking and Finance of Monash University since 2002
    • Prior to academia, he worked as a private banker with Standard Chartered Bank in Singapore
    • Since 2005, Jason has consulted and trained for the CPA in professional development programs specialising in the application of Excel to improve the productivity of accounting reports and business analysis
    • BBus (Hons), MCom (Hons), PhD
    /~/media/corporate/allimages/speakers/congress-2017/jason-choo.jpg?h=180&w=180
1.30pm - 5.00pm
Finance fundamentals
MC38
Advanced: DAX formulas for Power Pivot using Excel 2013
Prerequisite: Introduction to Power Pivot using Excel 2013

Data Analysis eXchange (DAX) is the formula language in Power Pivot and is used to create new fields, combine fields from several tables, combine tables and perform various forms of customisation.

In this session you’ll become familiar with DAX functions and learn to:
• download and install the Power Pivot add-in
• build a Data Model in Power Pivot
• understand the structure of the DAX formula language
• create calculated fields to support multiple Pivot Table reports
• use DAX formulas to construct new fields from data sourced in different tables
• use Aggregation functions and Date and Time functions.
Speaker
  • Dr Vince Bruno
    Lecturer, Business IT and Logistics, RMIT University
    • Has worked in IT industry and academia
    • Academically, he has focused on the Information Systems area for teaching and learning, and research activities
    • Extensive experience teaching IT-related courses from database, programming and the Microsoft range of products
    • Research has predominantly focused on qualitative research methods having taught and supervised students
    • Holds a Bachelor and Master’s in Computer Science and completed a PhD in Information Systems that examined the improvement of usability activities in IT projects
    /~/media/corporate/allimages/speakers/congress-2017/vince-bruno.jpg?h=180&w=180
1.30pm - 5.00pm
Finance fundamentals
MC39
Intermediate: Tips and tricks to improve your Excel productivity
Many end-users of Excel are self-taught and may be using it inefficiently without getting the maximum benefit.

This session will introduce techniques that can improve your productivity when using Excel and put you on the road to becoming a power user.

In this session you’ll learn how to:
• master shortcut techniques for copying and pasting
• master the fill handle and other data-entry techniques
• employ data-entry techniques for layout and formula entry
• use range names to refer to specific data
• replace many formulas with one array formula
• apply styles and themes to worksheet data
• use formatting and the format painter for consistency of appearance
• understand and use custom lists and drop down lists
• perform inexact searches
• create an image of a range
• password protect the workbook
• limit the usable area in a worksheet
• convert a list table
• use the AutoSum function and the VLOOKUP function
• understand and use various text and reference functions
• understand and use Excel tables, Pivot Tables and Sparklines
• use hyperlinks to navigate worksheets, send emails and access the internet.
Speaker
  • Dr Foula Kopanidis
    Senior Lecturer, School of Economics, Finance and Marketing, RMIT University • Foula has undergraduate and postgraduate qualifications in Education and a PhD in Marketing.
    • She is currently a Senior Lecturer in the Department of Economics and Finance at RMIT University in Melbourne where she teaches a postgraduate course on consumer behaviour.
    • She has won numerous awards for both her teaching and her research papers.
    • Foula is highly regarded by her students as a teacher and a supervisor because of her well documented passionate commitment to her students.
    /~/media/corporate/allimages/speakers/speaker-placeholder.jpg?h=180&w=180

Wednesday 25 October

Morning
Concurrent sessions
9.00am - 12.30pm
Finance fundamentals
MC40
Advanced: VBA level one
Prerequisite: advanced spreadsheet skills

Visual Basic for Applications (VBA) is a programming language that extends the functionality of the Microsoft Excel spreadsheet. This course introduces modular programming using VBA, the first step in automating routine tasks in Excel and ultimately leading to dramatic productivity improvements.

In this session you’ll learn:
• the basics of VBA and how it adds functionality to Excel
• the structure of the VBA language
• how to use the macro recorder to record simple tasks in Excel and how it assists with understanding VBA code
• how to use the Visual Basic Editor, Project Explorer window and the Object Browser
• how to create procedures to solve modularised tasks
• how to debug VBA procedures with the aid of built-in debugging tools
• the concept of loops and program control.
Speaker
  • Alan Serry
    Lecturer, Department of Accounting, Monash University • Alan has undergraduate and postgraduate qualifications in economics and accounting. He is a Chartered Accountant who has worked in a consulting role for a large accounting firm and has also worked as an advisor to government.
    • Since 1991 he has been employed with the Department of Accounting (Clayton) in the Faculty of Business and Economics of Monash University.
    • For many years he has worked as a presenter at the CPA Congress in Melbourne.
    /~/media/corporate/allimages/speakers/speaker-placeholder.jpg?h=180&w=180
9.00am - 12.30pm
Finance fundamentals
MC41
Intermediate: Data analysis
Professionals in the public and private sectors are confronted daily with mountains of data which they must interpret. Extracting and analysing key information to help the business understand its customers and markets is now readily available with Excel’s tools for data analysis.

In this session you’ll learn how to:
• use selected statistical functions in Excel
• use the Data Analysis add-In to obtain descriptive measures and apply Regression analysis
• quantify the nature and strength of relationships between variables
• appreciate Basic statistical distributions
• use handling lists in Excel
• access data stored in an external database using Microsoft Query to extract key information for subsequent analysis in Excel
• use Excel’s Sampling tools
• apply the Subtotal function.
Speaker
  • Anne Flaherty
    Consultant, Glentees Professional Services /~/media/corporate/allimages/speakers/congress-2017/anne_flaherty.jpg?h=180&w=180
9.00am - 12.30pm
Finance fundamentals
MC42
Advanced: Dashboard foundations
This session will introduce the key Excel tools used for developing dashboards. This collection of graphs, tables, statistical calculations and significant data, enable management to monitor critical processes.

You’ll learn how to:
• appreciate the benefits of dashboards
• understand and construct a data model that funnels source data to a dashboard
• create mini-charts and labelling techniques for use with Excel dashboards
• employ key Excel functions to organise the calculation area of a data model
• use Excel’s camera and linked picture tools to dynamically display tabular and graphical data
• use Sparklines to display trends in data
• add interactive controls.
Speaker
  • Dr John Byrne
    Consultant and former academic
    • Holds undergraduate qualifications in Civil Engineering and Computer Science, a teaching certificate, a Master’s degree in Mathematics and a PhD in Statistics
    • Former Civil Engineer in both contracting and consulting environments
    • Former academic in a university business school
    • Experience as a consultant to governments, professional bodies and commercial organisations in financial modelling and forecasting
    • Experience as a trainer for professional bodies and financial organisations
    • Regular presenter of Excel workshops for CPA Australian since 1996
    • As an academic, he published a number of theoretical papers in prestigious, international journals which are included in the Science and Social Science citation indices
    /~/media/corporate/allimages/speakers/congress-2017/john-byrne.jpg?h=180&w=180
Afternoon
12.30pm - 1.30pm
Lunch
Concurrent sessions
1.30pm - 5.00pm
Finance fundamentals
MC43
Intermediate: Data management – tables, pivot tables and consolidation
Tables and Pivot Tables are among Excel’s most powerful data management tools, making it relatively easy to combine data from different worksheets or workbooks and build reports that are directly linked to a data source.

This session will emphasise features of Excel’s new Ribbon interface and features that are new to 2007/2010.

You’ll learn to:
• create Tables and understand structured referencing
• use structured referencing to extract information from Tables
• use Tables as a dynamic range name to support PivotTable reports
• build Pivot Table reports from various data sources
• create Pivot Table reports based on multiple data sources
• understand and use calculated fields and calculated items
• understand grouping and apply it to Pivot Table reports
• employ the consolidate tool to create reports
• employ Pivot Tables to consolidate data from various worksheets.
Speaker
  • Anne Flaherty
    Consultant, Glentees Professional Services /~/media/corporate/allimages/speakers/congress-2017/anne_flaherty.jpg?h=180&w=180
1.30pm - 5.00pm
Finance fundamentals
MC44
Advanced: VBA level two
Prerequisites: advanced spreadsheet skills. Prior completion of the level one course (introduction to VBA) recommended.

This workshop builds on the concepts introduced in the level one session. The power of VBA becomes more apparent as one’s knowledge of the language increases and with the experience gained from using it to automate progressively more complex tasks.

In this session you’ll learn how to:
• generate code by using the Macro Recorder for specific tasks
• understand various types of Excel objects
• understand and use the code generated by the macro recorder
• learn about naming and code writing conventions
• use the macro recorder to generate and understand the code required for the creation of Pivot Tables and Charts
• use VBA and MS Outlook to email Excel files and add data to Word documents.
Speaker
  • Dr Vince Bruno
    Lecturer, Business IT and Logistics, RMIT University
    • Has worked in IT industry and academia
    • Academically, he has focused on the Information Systems area for teaching and learning, and research activities
    • Extensive experience teaching IT-related courses from database, programming and the Microsoft range of products
    • Research has predominantly focused on qualitative research methods having taught and supervised students
    • Holds a Bachelor and Master’s in Computer Science and completed a PhD in Information Systems that examined the improvement of usability activities in IT projects
    /~/media/corporate/allimages/speakers/congress-2017/vince-bruno.jpg?h=180&w=180
1.30pm - 5.00pm
Finance fundamentals
MC45
Advanced: Building dashboards
This workshop, part two of the dashboard course, introduces the concept of an Excel dashboard or executive report. This is a dynamic worksheet that is visible on a standard computer screen. Participants will learn to use the familiar reporting tools available in Excel 2013 and earlier versions using the Ribbon interface.

You’ll learn to:
• appreciate the benefits of dashboard reporting
• understand the data model which funnels source data to a dashboard
• employ key Excel functions to organise the calculation area of a data model
• integrate the various Excel reporting tools to create dynamic dashboards
• use Slicers to display different reports and Sparklines to examine trends
• add interactive controls to dashboards
• create dashboards supported by Tables and Pivot Table reports.

Part one and two of this workshop, which is conducted in Excel 2013, are compatible with Excel versions 2007 and 2010 with the exception of some new features available in later versions.
Speaker
  • Dr John Byrne
    Consultant and former academic
    • Holds undergraduate qualifications in Civil Engineering and Computer Science, a teaching certificate, a Master’s degree in Mathematics and a PhD in Statistics
    • Former Civil Engineer in both contracting and consulting environments
    • Former academic in a university business school
    • Experience as a consultant to governments, professional bodies and commercial organisations in financial modelling and forecasting
    • Experience as a trainer for professional bodies and financial organisations
    • Regular presenter of Excel workshops for CPA Australian since 1996
    • As an academic, he published a number of theoretical papers in prestigious, international journals which are included in the Science and Social Science citation indices
    /~/media/corporate/allimages/speakers/congress-2017/john-byrne.jpg?h=180&w=180

Thursday 26 October

Morning
Concurrent sessions
9.00am - 12.30pm
Finance fundamentals
MC46
Advanced: Data analytics beyond Excel: An introduction to R
While Excel is capable of simple statistical analysis, it is limited in its scope, particularly when dealing with large sets of data.

R is an open source programming language and software environment able to carry out complex statistical computing and data visualisation. Among many functions, R enables users to transform and combine data sets, analyse data using numerous built-in tools or program self-defined analysis functions. R can be easily downloaded and installed on any computer.

In this session you’ll learn to:
• download and install R programming language
• understand the similarities between Excel tables and R data frames
• use common R functions, particularly those similar to Excel
• access and use the public domain R libraries and packages
• analyse data using R language and generate data visualisation
• import and export data into and out of the R environment and particularly between Excel and R.
Speaker
  • Dr John Byrne
    Consultant and former academic
    • Holds undergraduate qualifications in Civil Engineering and Computer Science, a teaching certificate, a Master’s degree in Mathematics and a PhD in Statistics
    • Former Civil Engineer in both contracting and consulting environments
    • Former academic in a university business school
    • Experience as a consultant to governments, professional bodies and commercial organisations in financial modelling and forecasting
    • Experience as a trainer for professional bodies and financial organisations
    • Regular presenter of Excel workshops for CPA Australian since 1996
    • As an academic, he published a number of theoretical papers in prestigious, international journals which are included in the Science and Social Science citation indices
    /~/media/corporate/allimages/speakers/congress-2017/john-byrne.jpg?h=180&w=180
9.00am - 12.30pm
Finance fundamentals
MC47
Intermediate: Tips and tricks to improve your Excel productivity
Many end-users of Excel are self-taught and may be using it inefficiently without getting the maximum benefit.

This session will introduce techniques that can improve your productivity when using Excel and put you on the road to becoming a power user.

In this session you’ll learn how to:
• master shortcut techniques for copying and pasting
• master the fill handle and other data-entry techniques
• employ data-entry techniques for layout and formula entry
• use range names to refer to specific data
• replace many formulas with one array formula
• apply styles and themes to worksheet data
• use formatting and the format painter for consistency of appearance
• understand and use custom lists and drop down lists
• perform inexact searches
• create an image of a range
• password protect the workbook
• limit the usable area in a worksheet
• convert a list table
• use the AutoSum function and the VLOOKUP function
• understand and use various text and reference functions
• understand and use Excel tables, Pivot Tables and Sparklines
• use hyperlinks to navigate worksheets, send emails and access the internet.
Speaker
  • Dr Foula Kopanidis
    Senior Lecturer, School of Economics, Finance and Marketing, RMIT University • Foula has undergraduate and postgraduate qualifications in Education and a PhD in Marketing.
    • She is currently a Senior Lecturer in the Department of Economics and Finance at RMIT University in Melbourne where she teaches a postgraduate course on consumer behaviour.
    • She has won numerous awards for both her teaching and her research papers.
    • Foula is highly regarded by her students as a teacher and a supervisor because of her well documented passionate commitment to her students.
    /~/media/corporate/allimages/speakers/speaker-placeholder.jpg?h=180&w=180
9.00am - 12.30pm
Finance fundamentals
MC48
Intermediate: Financial models using Excel
Building financial models in Excel requires a structured approach and a sound knowledge of the tools available. A model that has not been well designed can lead to incorrect conclusions. This session focuses on a structured approach to spreadsheet model building.

You’ll learn to:
• become familiar with specific features of Excel 2013 (including 2007 and 2010)
• appreciate the benefits of properly constructing spreadsheet-based financial models
• design structured spreadsheets models that clearly identify inputs, calculations and results
• acquire an applied knowledge of selected Excel financial functions
• build an efficient model to incorporate the measurement of risk
• carry out what if and scenario analysis, including the use of in-built scenario summaries and scenario pivot tables
• identify the best and worst outcomes, and how they may be used in a decision framework
• develop optimisation models using Solver and appreciate the reports generated by Solver
• appreciate the limitations of modelling.
Speaker
  • Dr Jason Choo
    Lecturer, Department of Banking and Finance, Monash University
    • Tenured academic in the Department of Banking and Finance of Monash University since 2002
    • Prior to academia, he worked as a private banker with Standard Chartered Bank in Singapore
    • Since 2005, Jason has consulted and trained for the CPA in professional development programs specialising in the application of Excel to improve the productivity of accounting reports and business analysis
    • BBus (Hons), MCom (Hons), PhD
    /~/media/corporate/allimages/speakers/congress-2017/jason-choo.jpg?h=180&w=180
Afternoon
12.30pm - 1.30pm
Lunch
Concurrent sessions
1.30pm - 5.00pm
Finance fundamentals
MC49
Advanced: Visualising data level two – interactive charts
Excel charts are an effective method of visually communicating complex messages and important features of data.

When charts are combined with some of Excel’s other tools, you can significantly enhance the way you analyse and report key features of data.

In this session you’ll learn to:
• use Excel’s basic chart types
• create dynamic range names
• extract data from a database based on some given criteria
• use Excel’s INDEX, MATCH and OFFSET functions to organise data
• use conditional functions
• employ tables as a dynamic source to support charts
• use form controls
• highlight a sub-section of a chart and employ a chart window to display a segment of the data.
Speaker
  • Anne Flaherty
    Consultant, Glentees Professional Services /~/media/corporate/allimages/speakers/congress-2017/anne_flaherty.jpg?h=180&w=180
1.30pm - 5.00pm
Finance fundamentals
MC50
Introduction to Microsoft Access 2013
Prerequisites: A good level of competency with Microsoft products in general

This Access Introduction Course is for people new to databases, and for self-taught users to enhance their knowledge. It enables a new skill to be learnt that will enable another class of business problems to be solved more efficiently and effectively. The key area of focus is the data and how it is captured, related to each other and converted into various forms of information to be used within an organisation. This introductory course draws together and extends the functionality and concepts covered in many Excel and Power Pivot courses.

In this session you’ll learn how to:
• become familiar with the Microsoft Access environment
• design and create a data base
• create tables
• define the fields and properties for a table
• create table relationships
• enter data
• find data
• create queries
• design and create forms and reports.
Speaker
  • Dr Vince Bruno
    Lecturer, Business IT and Logistics, RMIT University
    • Has worked in IT industry and academia
    • Academically, he has focused on the Information Systems area for teaching and learning, and research activities
    • Extensive experience teaching IT-related courses from database, programming and the Microsoft range of products
    • Research has predominantly focused on qualitative research methods having taught and supervised students
    • Holds a Bachelor and Master’s in Computer Science and completed a PhD in Information Systems that examined the improvement of usability activities in IT projects
    /~/media/corporate/allimages/speakers/congress-2017/vince-bruno.jpg?h=180&w=180
1.30pm - 5.00pm
Finance fundamentals
MC51
Advanced: Dashboard foundations
This session will introduce the key Excel tools used for developing dashboards. This collection of graphs, tables, statistical calculations and significant data, enable management to monitor critical processes.

You’ll learn how to:
• appreciate the benefits of dashboards
• understand and construct a data model that funnels source data to a dashboard
• create mini-charts and labelling techniques for use with Excel dashboards
• employ key Excel functions to organise the calculation area of a data model
• use Excel’s camera and linked picture tools to dynamically display tabular and graphical data
• use Sparklines to display trends in data
• add interactive controls.
Speaker
  • Dr John Byrne
    Consultant and former academic
    • Holds undergraduate qualifications in Civil Engineering and Computer Science, a teaching certificate, a Master’s degree in Mathematics and a PhD in Statistics
    • Former Civil Engineer in both contracting and consulting environments
    • Former academic in a university business school
    • Experience as a consultant to governments, professional bodies and commercial organisations in financial modelling and forecasting
    • Experience as a trainer for professional bodies and financial organisations
    • Regular presenter of Excel workshops for CPA Australian since 1996
    • As an academic, he published a number of theoretical papers in prestigious, international journals which are included in the Science and Social Science citation indices
    /~/media/corporate/allimages/speakers/congress-2017/john-byrne.jpg?h=180&w=180

Friday 27 October

Morning
Concurrent sessions
9.00am - 12.30pm
Finance fundamentals
MC52
Advanced: Building dashboards
This workshop, part two of the dashboard course, introduces the concept of an Excel dashboard or executive report. This is a dynamic worksheet that is visible on a standard computer screen. Participants will learn to use the familiar reporting tools available in Excel 2013 and earlier versions using the Ribbon interface.

You’ll learn to:
• appreciate the benefits of dashboard reporting
• understand the data model which funnels source data to a dashboard
• employ key Excel functions to organise the calculation area of a data model
• integrate the various Excel reporting tools to create dynamic dashboards
• use Slicers to display different reports and Sparklines to examine trends
• add interactive controls to dashboards
• create dashboards supported by Tables and Pivot Table reports.

Part one and two of this workshop, which is conducted in Excel 2013, are compatible with Excel versions 2007 and 2010 with the exception of some new features available in later versions.
Speaker
  • Dr John Byrne
    Consultant and former academic
    • Holds undergraduate qualifications in Civil Engineering and Computer Science, a teaching certificate, a Master’s degree in Mathematics and a PhD in Statistics
    • Former Civil Engineer in both contracting and consulting environments
    • Former academic in a university business school
    • Experience as a consultant to governments, professional bodies and commercial organisations in financial modelling and forecasting
    • Experience as a trainer for professional bodies and financial organisations
    • Regular presenter of Excel workshops for CPA Australian since 1996
    • As an academic, he published a number of theoretical papers in prestigious, international journals which are included in the Science and Social Science citation indices
    /~/media/corporate/allimages/speakers/congress-2017/john-byrne.jpg?h=180&w=180
9.00am - 12.30pm
Finance fundamentals
MC53
Advanced: Power Pivot using Excel 2013
Microsoft introduced some powerful business intelligence tools with the release of Excel 2010. Significant among these was Power Pivot.

In this session you’ll learn to:
• install the Power Pivot add-in
• become familiar with the Power Pivot Ribbon
• get data into Power Pivot from different sources
• understand and use the Data Model
• establish relationships between Power Pivot tables
• become familiar with the process of creating reports using the Power Pivot field list
• work with calculated formulas in the Power Pivot Window
• create Pivot Tables from linked tables
• use Slicers and Timelines.
Speaker
  • Sam Broder
    Analytics Consultant, KPMG Australia
    • Sam is an Analytics Consultant with more than 3 years’ experience in the strategic assessment, development and implementation of analytical, data-driven solutions to clients, leveraging Excel and a range of other technical software.
    • Sam has worked across a range of industries, liaising with clients to understand business problems and applying quantitative, analytical and research-driven methodologies to recommend and deliver solutions that bring value to businesses.
    • Specialising in business intelligence and data visualisation, Sam has experience across a range of industries, with extensive experience within tertiary education, marketing services, private health insurance and banking.
    /~/media/corporate/allimages/speakers/speaker-placeholder.jpg?h=180&w=180
9.00am - 12.30pm
Finance fundamentals
MC54
Intermediate: Business forecasting models
Business forecasting models can help a business to understand its environment, improve its decision making and make better use of its customer database. Excel has a range of built-in functions and optimising routines that may be used to build effective forecasting models.

In this session you’ll learn to:
• become familiar with a variety of common forecasting models
• use Excel charts to identify patterns in data and suitable forecasting models
• distinguish between a stationary and a non-stationary data series
• identify and model trend and seasonality in business data
• choose appropriate models to deal with common business data
• compare forecasts and identify criteria to select the best model
• use Solver to select the optimal parameters for a model
• integrate forecasts with the budget process.
Speaker
  • Anne Flaherty
    Consultant, Glentees Professional Services /~/media/corporate/allimages/speakers/congress-2017/anne_flaherty.jpg?h=180&w=180
Afternoon
12.30pm - 1.30pm
Lunch
Concurrent sessions
1.30pm - 5.00pm
Finance fundamentals
MC55
Advanced: Power BI desktop using Excel 2013
Prerequisite: Power Pivot for Excel 2013
Some familiarity with Power Query and Power View is desirable


Power BI Desktop is Microsoft’s most recent addition to the Power BI suite – a feature-rich data mashup and report authoring tool. Combine data from disparate databases, files, and web services with visual tools that help in understanding data quality and formatting issues automatically. With more than 20 built-in visuals and a vibrant community of custom visualisations, you can create stunning reports that communicate your message effectively. The Power BI gateways may be used to connect SQL Server databases, Analysis Services models, and many other data sources to the same dashboards in Power BI.

In this session you’ll learn to:
• download and install Power BI Desktop
• use Power BI’s significant features
• apply the ELT (Extract Load and Transform) of Power BI
• import data from files and the web, transform the data and create data models
• use the visualisations pallet and field list
• create and format visualisations supported by the data model.
Speaker
  • Sam Broder
    Analytics Consultant, KPMG Australia
    • Sam is an Analytics Consultant with more than 3 years’ experience in the strategic assessment, development and implementation of analytical, data-driven solutions to clients, leveraging Excel and a range of other technical software.
    • Sam has worked across a range of industries, liaising with clients to understand business problems and applying quantitative, analytical and research-driven methodologies to recommend and deliver solutions that bring value to businesses.
    • Specialising in business intelligence and data visualisation, Sam has experience across a range of industries, with extensive experience within tertiary education, marketing services, private health insurance and banking.
    /~/media/corporate/allimages/speakers/speaker-placeholder.jpg?h=180&w=180
1.30pm - 5.00pm
Finance fundamentals
MC56
Advanced: Visualising data level two – interactive charts
Excel charts are an effective method of visually communicating complex messages and important features of data.

When charts are combined with some of Excel’s other tools, you can significantly enhance the way you analyse and report key features of data.

In this session you’ll learn to:
• use Excel’s basic chart types
• create dynamic range names
• extract data from a database based on some given criteria
• use Excel’s INDEX, MATCH and OFFSET functions to organise data
• use conditional functions
• employ tables as a dynamic source to support charts
• use form controls
• highlight a sub-section of a chart and employ a chart window to display a segment of the data.
Speaker
  • Anne Flaherty
    Consultant, Glentees Professional Services /~/media/corporate/allimages/speakers/congress-2017/anne_flaherty.jpg?h=180&w=180
1.30pm - 5.00pm
Finance fundamentals
MC57
Advanced: Advanced filter techniques
Excel’s Auto and Advanced filter features are an excellent method of filtering data stored in an Excel list or database. While the Auto Filter is easy to use, the Advanced filter requires greater effort but allows for the extraction of records based on more complex criteria.

In this session you’ll learn to:
• understand applications of Logical functions in Excel
• use Logical functions as criteria with the Advanced Filter
• create drop-down lists and dependent lists using Data Validation
• assign static and dynamic range names
• use array formulas with a variety of mathematical operators
• understand the different uses of the AGGREGATE function (new in Excel 2010)
• display data using worksheet controls
• create a Gage chart to display relative position in a database
• build a basic search engine in Excel
• construct a dynamic sub-list based on search characters.
Speaker
  • Dr Jason Choo
    Lecturer, Department of Banking and Finance, Monash University
    • Tenured academic in the Department of Banking and Finance of Monash University since 2002
    • Prior to academia, he worked as a private banker with Standard Chartered Bank in Singapore
    • Since 2005, Jason has consulted and trained for the CPA in professional development programs specialising in the application of Excel to improve the productivity of accounting reports and business analysis
    • BBus (Hons), MCom (Hons), PhD
    /~/media/corporate/allimages/speakers/congress-2017/jason-choo.jpg?h=180&w=180

Sectors

  • Finance fundamentals

    Enhance your core accounting and finance skills in the areas of tax, audit and assurance, compliance, financial planning, analysis and reporting.

  • Operational transformation

    Find out how to transform your business using improved processes and management skills, the latest technologies and shared services.

  • Personal development

    Refine your skills and become a highly productive, effective and well-rounded individual.

  • Sector in focus

    Hear the latest trends and opportunities specific to your sector, including corporate, SME, not for profit and public sector.

  • Strategy and leadership

    Become an outstanding finance leader by enhancing the power of innovation, successfully managing change and driving a high-performance culture.

  • Trends and business impacts

    Understand shifts in the domestic and global economy, the regulatory environment, the latest fraudulent activities, and consumer and competitive markets to build risk mitigation strategies.




Disclaimer of liability
CPA Australia reserves the right to alter any part of this program at any time without notice.