Excel Formulas: Intermediate Level – Recorded Webinar
This free recorded webinar explores Excel formulas further to boost efficiency and refine the skills of those with a basic understanding of Excel. This session is ideal for users familiar with basic functions who aim to build a stronger, more comprehensive understanding of Excel intermediate formulas.
Dave Casuto, your expert trainer, explores advanced Excel functions beginning with Named Ranges for simpler formula creation and management. He thoroughly covers the IF function and variations like Calculated IFs, Nested IF functions, and the IFERROR function. The session also includes an extensive look at lookup functions, including VLOOKUP, HLOOKUP, and the newer XLOOKUP, providing practical applications for each within business scenarios.
In this webinar, you will learn the following:
- Named Ranges
- IF Function
- Calculated IFs Function
- Nested IF Function
- IFERROR Function
- Lookup Functions (VLOOKUP, HLOOKUP, XLOOKUP)
Watch the session here, and download the instructor demo file to follow along.
Excel Formulas: Intermediate Level – Recorded Webinar
Download the instructor files and follow along.
Other Microsoft Webinars:
Excel Formulas: Beginner Level
Please visit our free Microsoft Office resources center for more high-quality Microsoft guides.
Simon Calder
Chris “Simon” Calder was working as a Project Manager in IT for one of Los Angeles’ most prestigious cultural institutions, LACMA.He taught himself to use Microsoft Project from a giant textbook and hated every moment of it. Online learning was in its infancy then, but he spotted an opportunity and made an online MS Project course - the rest, as they say, is history!
