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.

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.

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.