Discover how to work with the ATO on complex issues, covering the risks of being unprepared for compliance activity and when to seek expert assistance.
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.
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.
As accounting firms embrace digital transformation, the new technologies are changing the skills early-career accountants need to succeed. Our guests discuss the findings from a research report, revealing five ways technology is changing accounting skills. Listen now.
In this re-release episode, originally released in July 2020, Simon Eassom discusses how having a micro-credential on your resume demonstrates specialised skills that employers can trust. He covers why you’ll start to see the rise of importance of micro-credentials in our education system, why they give an employer a third-party validation of your skills, and why micro-credentials can fill a skills gap from entry level to the C-suite.
Join two experts to discover which components of annual reports users consider important, and the key decisions they make from the report. Listen now.
Using current professional indemnity insurance claims as examples, in this podcast episode Drew Fenton CPA and Kevin Nhan discuss the risks public practitioners face if they operate outside of their mandate and areas of expertise.
Guest: Kevin Nhan, Service Manager, Professional Lines Claims, QBE
Host: Drew Fenton CPA, Managing Director, Fenton Green and co