The With Interest podcast brings you unrivalled commentary and thought leadership for businesses, accounting and finance professionals. Each week, we share expert industry opinions, insights and resources across accounting, public practice, taxation, auditing, finance, strategy, leadership, economic and business-related issues. Subscribe today to stay up-to-date with the latest episodes. With Interest is presented by CPA Australia, one of the world’s largest accounting bodies, with core services that include education, training, technical support and advocacy. In 2018, CPA Australia won an Award of Excellence at the 24th Annual Communicator Awards in the category of 'Podcasts - General-Corporation/Business'. ---------------------------------------------------- CPA Australia publishes three podcasts: - With Interest - INTHEBLACK - Excel Tips To find out more about our podcasts, visit https://www.cpaaustralia.com.au/tools-and-resources/podcasts - or search for the shows in your podcast service. To contact the podcast team email us at podcasts@cpaaustralia.com.au.
https://cpaaustraliapodcast.libsyn.com/WITHINTEREST
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.