With Interest

In this podcast episode, our expert guests discuss the findings from the report, plus explain the directors’ and audit committees’ roles in audit quality. Listen now.  

Our expert guests use current real-life cyber insurance claims to demonstrate the risks faced by public practitioners. Listen now.

Our expert guests use current real-life cyber insurance claims to demonstrate the risks faced by public practitioners. Listen now.

Discover how e-invoicing will help your business grow faster, covering improved transparency and efficiency, fewer errors, cash flow benefits, and more.

Discover how e-invoicing will help your business grow faster, covering improved transparency and efficiency, fewer errors, cash flow benefits, and more.

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.

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.

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.