Unleash your Excel skills by using the valuable functionality of formulas.

Go straight to episode sections:

1. The formula bar – 1:06
2. Starting formulas – 1:41
3. Using functions – 2:58
4. Function arguments – 4:09
5. Relative and absolute cell and range references – 7:15
6. The calculation sequence – 9:46
7. Parentheses (brackets) – 10:39
8. Colours in formulas – 12:37
9. Entering cell and Range references – 13:50
10. The Function Wizard – 15:57
11. Formula auditing – 17:01
12. IF error – 19:12
13. REF error – 20:01
14. Dynamic arrays and the SPILL error – 20:26

Tune in now to level up with these expert shortcuts and techniques.

Host: 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.

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 platform.

You can email the podcast team at podcasts@cpaaustralia.com.au