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: 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.


 2020-11-24  10m