Advanced Formulas in Excel (1-Hour Recorded Webinar)
This recorded live webinar walks you through some advanced formulas in Excel.
Deb Ashby, your professional trainer, kicks off the session by looking at the popular VLOOKUP formula before moving on to lookups with multiple criteria, and much more!
Deb discusses:
- VLOOKUP with wildcards
- Lookups with duplicate lookup values
- Combining and splitting text
- INDEX and MATCH with multiple criteria
- COUNTIFS and SUMIFS
- Nested IF statements with multiple criteria (AND)
- The FILTER and SORT functions
- Creating functions with LAMBDA
Watch the session here, and download the Excel file to follow along.
Advanced Formulas in Excel – Recorded Webinar
Download the files and follow along.
Other Microsoft Webinars:
Get the Most Out of Microsoft Teams (1 Hour Recorded Webinar)
Lookup Functions in Excel – (Recorded Webinar)
Advanced PowerPoint Hacks 2022 – Recorded Webinar
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!
