CPA AUSTRALIA
PODCAST

Excel shortcuts for accounting and finance professionals

In this series, Excel expert Neale Blackwood CPA discusses important and time saving features that have been added to Microsoft Excel over the years that can help you out in every day Excel use. Neale has more than 20 years' experience as an Excel expert, trainer and author.

Excel shortcuts for accountants and finance professionals: F4 function key

This episode covers the double life of the F4 key, demonstrating its ability to save you time by repeating what you’ve last done and pasting, and editing a formula.


Excel shortcuts for accountants and finance professionals: F5 function key

This episode covers the useful applications of the F5 function key, such as following links, the special button, blanks, identify and select errors, and more.



Excel shortcuts for accountants and finance professionals: Find In Excel

In this episode, Neale takes you through an example of how to use ‘Find In Excel’, showing that when you’re using this function you may need to perform a few different finds to find everything that matches your search.


Excel shortcuts for accountants and finance professionals: Grid lines

This episode covers the three different types of grid lines and why turning off your grid lines might make your charts look better.


Further resources



audio Subscribe on iTunes

Play Listen to more episodes