Today’s episode examines the new data types feature in Microsoft Excel.

There are four data types you can now import from the data ribbon, and that includes stock prices.

To explain how you do all this is CPA Australia’s Excel expert, Neale Blackwood.

Listen now.

Host: Neale Blackwood CPA. He has more than 20 years of experience as a Microsoft Excel educator and is the author of more than 200 INTHEBLACK articles as well as a book, Advanced Excel Reporting for Management Accountants.

CPA Australia publishes three podcasts, providing commentary and thought leadership across business, finance, and accounting:

• With Interest
• INTHEBLACK
• Excel Tips

Search for them in your podcast service.

You can email the podcast team at [email protected]

And you can read more of Neale’s Excel articles online.

Today’s episode investigates working with dates and days in Microsoft Excel.

Excel can perform basic addition and subtraction calculations using dates, as well as dedicated functions that perform more complex calcs.

To explain is CPA Australia’s Excel expert, Neale Blackwood.

Listen now.

Host: Neale Blackwood CPA. He has more than 20 years of experience as a Microsoft Excel educator and is the author of more than 200 INTHEBLACK articles as well as a book, Advanced Excel Reporting for Management Accountants.

CPA Australia publishes three podcasts, providing commentary and thought leadership across business, finance, and accounting:

• With Interest

• INTHEBLACK

• Excel Tips

Search for them in your podcast service.

You can email the podcast team at [email protected]

And you can read more of Neale’s Excel articles online, including the accompanying article to this podcast.

Today’s episode looks at a handy tool in Microsoft Excel called Goal Seek.

It can be used to create a loan schedule with an interest-free period using formulas.

To explain how you do this is CPA Australia’s Excel expert, Neale Blackwood.

Listen now.

Host: Neale Blackwood CPA. He has more than 20 years of experience as a Microsoft Excel educator and is the author of more than 200 INTHEBLACK articles as well as a book, Advanced Excel Reporting for Management Accountants.

CPA Australia publishes three podcasts, providing commentary and thought leadership across business, finance, and accounting:

• With Interest
• INTHEBLACK
• Excel Tips

Search for them in your podcast service.

You can email the podcast team at [email protected]

And you can read more of Neale’s Excel articles online, including the accompanying article to this podcast.

Today’s episode will help with your formatting in Microsoft Excel.

Want to know how to make your files easier to read, understand and use?

To explain is CPA Australia’s Excel expert, Neale Blackwood.

Listen now.

Host: Neale Blackwood CPA. He has more than 20 years of experience as a Microsoft Excel educator and is the author of more than 200 INTHEBLACK articles as well as a book, Advanced Excel Reporting for Management Accountants.

CPA Australia publishes three podcasts, providing commentary and thought leadership across business, finance, and accounting:

• With Interest
• INTHEBLACK
• Excel Tips

Search for them in your podcast service.

You can email the podcast team at [email protected]

And you can read more of Neale’s Excel articles online, including the accompanying article to this podcast.

In this episode, we look at three new text functions released in the latest (subscription) version of Microsoft Excel.  

The functions are: “Text Before”, “Text After” and “Text Split”

To explain this is CPA Australia’s Excel expert Neale Blackwood CPA.

Listen now.

Host:  Neale Blackwood CPA

Excel Tips is for accounting, business and finance professionals looking to sharpen their spreadsheet skills and learn new hacks and tricks from Neale Blackwood CPA, a Microsoft Excel expert.

Excel Tips helps spreadsheet users discover hidden features and shortcuts and understand how best to apply the newest features and functionality.

The podcast is a companion to regular articles in INTHEBLACK, CPA Australia’s award-winning business magazine.

Neale Blackwood CPA has over 20 years of experience as a Microsoft Excel educator.

He is the author of more than 200 INTHEBLACK articles as well as a book, Advanced Excel Reporting for Management Accountants. 

Excel Tips is presented by CPA Australia, one of the world’s largest accounting bodies, with core services that include education, training, technical support and advocacy.

CPA Australia publishes three podcasts providing commentary and thought leadership across business, finance and accounting.

• With Interest
• INTHEBLACK (coming soon)
• Excel Tips

Search for them in your podcast service.

To find out more about our podcasts, visit our podcast page.

Or search for the shows in your podcast service.

To contact the podcast team, email [email protected] 

Excel Tips is a podcast for accounting, business and finance professionals who are looking to sharpen their spreadsheet skills and learn new hacks and tricks from Neale Blackwood CPA, a Microsoft Excel expert.

EXCEL TIPS helps spreadsheet users discover Excel’s hidden features and shortcuts and understand how best to apply the newest features and functionality.

The podcast is a companion to regular articles in INTHEBLACK, CPA Australia’s award-winning business magazine. Every podcast episode includes links to the accompanying EXCEL TIPS digital magazine article.

Neale Blackwood CPA has more than 20 years of experience as a Microsoft Excel educator. He is the author of more than 200 INTHEBLACK articles as well as a book, Advanced Excel Reporting for Management Accountants.

Subscribe today to stay up-to-date with the latest episodes.

EXCEL TIPS is presented by CPA Australia, one of the world’s largest accounting bodies, with core services that include education, training, technical support and advocacy.

----------------------------------------------------

CPA Australia publishes three podcasts: - With Interest - INTHEBLACK  - Excel Tips

To find out more about our podcasts, visit https://www.cpaaustralia.com.au/tools-and-resources/podcasts - or search for the shows in your podcast service. To contact the podcast team email us at [email protected].