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: Function macros
In our ongoing series of podcasts about Microsoft Excel, did you know you can create your own functions in Excel? In this podcast we look at three functions (called User Defined Functions or UDF’s) that you can create to improve Excel’s functionality. One function returns the username. The next determines if a cell contains a date. The last function allows you to split text and extract specific entries based on a delimiter character. This is handy for codes that have a set structure.