Excel Formulas: Intermediate – Recorded Webinar
This free recorded webinar walks you through intermediate Excel formulas. This session is perfect if you have the basic foundation of Excel formulas or just want to brush up on some intermediate functions.
Dave Casuto, your expert trainer, kicks off the session by looking at IF function and Data Validation before moving on to COUNTIF, SUMIF, and AVERAGEIF functions. He also covers array functions such as XLOOKUP, FILTER, SORT, and much more!
In this webinar, you will learn the following:
- IF Function
- Relative and Absolute Referencing
- Data Validation (Dropdown Menu)
- UNIQUE
- COUNTIF and COUNTIFS
- SUMIF, AVERAGEIF, and SUMIFS
- Named Ranges
- IFS and Nested IF (OR and AND)
- IFERROR with Conditional Formatting
- XLOOKUP
- FILTER Array Function
- SORT and SORTBY
Watch the session here, and download the instructor demo file to follow along.
Excel Formulas: Intermediate – Recorded Webinar
Download the instructor files and follow along.
Other Microsoft Webinars:
Mastering Excel Lookups: VLOOKUP, HLOOKUP and XLOOKUP
Data Models, PivotTables, and Power Query in Excel
Conditional Formatting in Excel
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!
