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:  With Interest INTHEBLACK Excel Tips Search for them in your podcast platform. You can email the podcast team at [email protected]

Ver todos los episodios