loader from loading.io

Data Analytics - Is it Fundamentally Transforming the Audit?

CPA Australia Podcast

Release Date: 11/11/2016

Part 4 of 4: Dynamic arrays in Excel - Using new features and existing functions show art Part 4 of 4: Dynamic arrays in Excel - Using new features and existing functions

CPA Australia Podcast

This podcast includes a few ideas on how we can use the new dynamic array features as well as ideas on using existing functions with them. There will no doubt be lots of creative applications of these new features.

info_outline
How mutual respect and trust builds productive working relationships show art How mutual respect and trust builds productive working relationships

CPA Australia Podcast

This podcast episode introduces Andrew Seinor FCPA, co-creator of The H Factor, and Sainyog Prajapati CPA, founder of Next Climb and F360. They discuss how they work together on strategic planning, the benefits of digital innovation, and how mutual respect and trust are key to a productive working relationship. Listen now.

info_outline
Part 1 of 4: Dynamic arrays in Excel - an introduction show art Part 1 of 4: Dynamic arrays in Excel - an introduction

CPA Australia Podcast

This podcast episode introduces the concept of dynamic arrays in Excel. The new UNIQUE function is used as an example to help explain the new formula terminology and symbols. Listen now.

info_outline
Part 2 of 4: Dynamic arrays in Excel - two new functions show art Part 2 of 4: Dynamic arrays in Excel - two new functions

CPA Australia Podcast

This podcast episode gives an in-depth explanation of two new functions that are part of Excel’s new dynamic arrays feature. We cover the use and structure of the UNIQUE and FILTER functions.

info_outline
Part 3 of 4: Dynamic arrays in Excel - the remaining four functions show art Part 3 of 4: Dynamic arrays in Excel - the remaining four functions

CPA Australia Podcast

This podcast episode introduces and explains the remaining four new functions associated with the new dynamic arrays feature in Excel. The SORT, SORTBY, SEQUENCE and RANDARRAY functions are all discussed. Listen now.

info_outline
Stay safe: Practical tips to create a cybersafe environment show art Stay safe: Practical tips to create a cybersafe environment

CPA Australia Podcast

Discover how to create a cybersafe environment for your organisation, covering cost-effective tech solutions and remote work risks. Listen now.

info_outline
Tax time 2020: Implications for rental property investors show art Tax time 2020: Implications for rental property investors

CPA Australia Podcast

Tips for public practitioners to identify the tax consequences arising from COVID-19 for their rental property investor clients. Listen now.

info_outline
Why employers want to see micro-credentials on your resume show art Why employers want to see micro-credentials on your resume

CPA Australia Podcast

Discover why micro-credentials demonstrate a specialised skill that employers can trust, and why they can fill a skills gap at any age and career stage.

info_outline
How public practitioners can work with clients facing insolvency show art How public practitioners can work with clients facing insolvency

CPA Australia Podcast

Learn the signs that your client may be heading for insolvency and how to work with them, plus how small business owners can protect themselves. Listen now

info_outline
Career Skills Revisited: How accountants can build a business case for robotic automation  show art Career Skills Revisited: How accountants can build a business case for robotic automation

CPA Australia Podcast

As part of our career skills re-release series, listen to discover how robotic process automation can benefit your organisation, covering strategy, key factors for successful implementation, and more

info_outline
 
More Episodes

Professor Miklos Vasarhelyi , leading researcher in data analytics and a widely published professor on the topics of continuous audit, data analytics and big data, speaks to CPA Australia on whether data analytics is fundamentally transforming the audit or if it is just a new means of gathering the same evidence as in the past. Prof. Vasarhelyi talks about how data analytics is shaping the future of audit and how auditors need to embrace that future. Miklos is KPMG’s Distinguished Professor of Accounting Information Systems at Rutgers University Business School in Newark & New Brunswick in the US, and Director of Rutgers’ Accounting Research Centre and Continuous Auditing and Reporting Lab. Miklos has been a pioneer of continuous auditing, having developed the original continuous audit application, and is a leading academic in developing and promoting data analytics.