CPA AUSTRALIA
PODCAST

 
 

Excel Yourself Podcast Series

Welcome to the Excel Yourself podcast series. Here you’ll find a series of podcast episodes on Microsoft Excel.

Build your skills in Excel and make your work easier, faster and more efficient. Listen now.  

Guest: Neale Blackwood CPA, Principal, A4 Accounting 

Excel Yourself: Use LET function to solve tricky Excel challenges

As part of the Excel Yourself CPA Australia Podcast series, hear how the LET function offers useful solutions to tricky Excel challenges.

Excel Yourself: Creating hyperlinked index sheets

In this latest episode find out more about creating hyperlinked index sheets. Hyperlinked index sheets are useful tools for speeding up and simplifying navigation around large Excel files.

Excel Yourself: How to import Excel files using power query

Listen to this Excel Yourself podcast episode to find out how using power query can help in your data transformation and data preparation in Microsoft Excel.

Excel Yourself: Flexible conditional formats

Listen to this Excel Yourself podcast episode to find out what you need to know about making conditional formats work for you in dashboards and reporting. 

Excel yourself: Top tips on formatting in Excel

Once you have your figures right, the next step is presenting them. Here are a few ideas to help you improve your formatting and make your files easier to read, understand and use. Listen now.

Excel Yourself: LET function

The LET function enables you to use variables within your Excel formulas. This means you can avoid using helper cells and create standalone formulas to solve real world problems. Currently it is only available in the subscription version of Excel.

Excel Yourself: How to use an IS function in Excel

Knowing what a cell contains can be useful when developing your formulas. Excel has a collection of IS functions that can help.

Excel Yourself: Dynamic Charts in Microsoft Excel

Dynamic charts allow you to make selections that are automatically updated in the chart. Here, you’ll learn how to use range names to convert a static chart in a dynamic one.

Excel Yourself: Slicers in Microsoft Excel

Slicers are an easy-to-use filter interface for pivot tables. In this podcast episode, you will learn how to use slicers on formatted tables in Microsoft Excel.

Excel Yourself: Small data sets



This podcast episode 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. Listen now.

Excel Yourself: Function Macros

Did you know you can create your own functions in Excel? In this podcast episode, 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. Listen now.

Excel Yourself: XLOOKUP Function

In this podcast episode, you will learn 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. Listen now.

Excel Yourself: Text Boxes

Text boxes are an old Excel feature that can provide flexibility to all types of Excel files. In this podcast episode, discover how to use text boxes and why it will help in your day to day work. Listen now.

Further Resources:

A4 Accounting - Helping you Excel Yourself with spreadsheets
Neale's Excel articles on INTHEBLACK.com
More Podcasts on Excel for Accountants
INTHEBLACK article and video: Formatting in Excel



audio Subscribe on iTunes

Play Listen to more episodes