CPA Australia Podcast

The CPA Australia Podcast brings you the best in on-demand commentary and thought leadership across a variety of topics related to business, leadership and accounting. Each week, our podcast will help you increase your knowledge of business related topics and point you to some of the world’s best resources in strategy, finance and public practice accounting. Never miss an episode by subscribing today via iTunes.


Excel Yourself: Small data sets

Part of our Excel Yourself series about skills you should know in Microsoft Excel for your day to day use. In this episode learn about small data sets. Excel is not a database, but it can handle small datasets. These can be useful for data that isn’t available in existing databases, but is still required for reports or dashboards. This podcast looks at how to convert a data entry layout that is easy to input, into a layout that works best with PivotTables and other reports. The solution uses Power Query and is very flexible.


 2020-11-24  7m