Audio is streamed directly from the publisher (traffic.libsyn.com) as published in their RSS feed. Play Podcasts does not host this file. Rights-holders can request removal through the copyright & takedown page.
Show Notes
Unleash your Excel skills by using the valuable functionality of formulas.
Go straight to episode sections:
- The formula bar – 1:06
- Starting formulas – 1:41
- Using functions – 2:58
- Function arguments – 4:09
- Relative and absolute cell and range references – 7:15
- The calculation sequence – 9:46
- Parentheses (brackets) – 10:39
- Colours in formulas – 12:37
- Entering cell and Range references – 13:50
- The Function Wizard – 15:57
- Formula auditing – 17:01
- IF error – 19:12
- REF error – 20:01
- 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:
Search for them in your podcast platform.
You can email the podcast team at [email protected]