CPA AUSTRALIA
PODCAST

 
 

Excel’s hidden functions and features by version


With every new version of Excel, Microsoft adds more and more features and functions. Depending on your version, you could be sitting on some hidden gems. In this podcast episode, Excel expert and Principal of A4 Accounting Neale Blackwood CPA, discusses what you might have missed in Excel over the past 10 years, version by version. Crucial for anyone who uses Excel, this information will help you work faster, look professional, impress your boss and grow your career.

HIGHLIGHTS

02:01 – the hidden functions and features of Excel 2007: the ribbon, new file types, formatted table feature, extra functions
05:20 – the hidden functions and features of Excel 2010: slicer, sparkline charts, aggregate function, Power Query, Power Pivot, 32-bit versus 64-bit Excel
09:13 – the hidden functions and features of Excel 2013: subscription version, data model, timeline slicer, IFNA, squarer look
12:20 – the hidden functions and features of Excel 2016: Get and Transform, new charts: waterfall or bridge charts and pareto chart, TEXTJOIN function, CONCAT function, IFS function, defaults for pivot tables
17:25 – a popular topic: Power BI



audio Subscribe on iTunes

Play Listen to more episodes