CPA AUSTRALIA
PODCAST

Excel functions for accountants


Are you across the latest functions in Excel? In this podcast episode, Excel expert Neale Blackwood CPA takes you through the main functions that will assist accountants in their day to day work. Neale has more than 20 years' experience as an Excel expert, trainer and author.

Highlights

  • 01.17 Adding up or SUM function
  • 04.22 SUMIFS function
  • 06.16 SUBTOTAL function
  • 07.48 AGGREGATE function
  • 08.16 Logic functions – IF, AND and OR functions
  • 10.09 IFERROR function, IFNA error and VLOOKUP functions
  • 14:00 INDEX and MATCH and COUNTIF functions
  • 14.43 Date functions EOMONTH, EDATE, WORKDAYS, NETWORKDAYS
  • 17.37 Text functions TRIM and TEXT functions the & symbol, TEXTJOIN
  • 20.58 The ROUND, INDIRECT and GETPIVOTDATA functions


audio Subscribe on iTunes

Play Listen to more episodes