Dive into a comprehensive 1-hour recorded webinar on advanced Excel formulas and functions. Learn to master logical functions like IF, IFS, AND, and OR. Explore two-way lookups using INDEX and MATCH, and discover how to assign random values with CHOOSE and RANDBETWEEN. Uncover techniques for finding the most recent occurrences using INDEX, MATCH, MODE, and SUMPRODUCT. Delve into value lookups with XLOOKUP, and practice extracting text strings using LEFT, RIGHT, LEN, and FIND functions. Master sum and count operations with multiple criteria using SUMIFS and COUNTIFS. Finally, learn to create dynamic SUM calculations utilizing SUM, OFFSET, and MATCH. Follow along with the provided Excel file to enhance your skills and boost your productivity in spreadsheet management.
Advanced Excel Formulas - IF, IFS, INDEX, MATCH, SUMPRODUCT, XLOOKUP, OFFSET, CHOOSE
Simon Sez IT via YouTube
Overview
Syllabus
- Introduction
- Logical Functions in Excel IF, IFS, AND, OR
- Two-way Lookups in Excel INDEX, MATCH
- Assigning Random Values in Excel CHOOSE, RANDBETWEEN
- Finding the Most Recent Occurrence INDEX, MATCH, MODE, SUMPRODUCT
- Looking up Values XLOOKUP
- Extracting Text Strings LEFT, RIGHT, LEN, FIND
- Sum and Count with Multiple Criteria SUMIFS, COUNTIFS
- Dynamic SUM Calculations SUM, OFFSET, MATCH
Taught by
Simon Sez IT
