CPA AUSTRALIA
PODCAST

 
 

Excel Yourself Podcast Series

Excel Yourself series - 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 part of the Microsoft Excel podcast series, Neale Blackwood CPA will explain all about the XLOOKUP function and why it is important to use. Just like VLOOKUP which is going away, XLOOKUP allows you to look up a code in a table and return entries on the same row as the code.

Continuing the Excel Yourself podcast series, Neale Blackwood CPA discusses text boxes in Microsoft Excel and why it will help in your day to day usage in Excel.

Further Resources:

A4 Accounting - Helping you Excel Yourself with spreadsheets
Neale's Excel articles on INTHEBLACK.com
More Podcasts on Excel for Accountants

 



audio Subscribe on iTunes

Play Listen to more episodes