Excel for Business Analysts Crash Course - XLOOKUP, IF, Forecast Sheets & More
Simon Sez IT via YouTube
Overview
Syllabus
- Looking up Information with VLOOKUP Exact
- Looking up information with VLOOKUP Approx
- How to use VLOOKUP with data that expands
- Using HLOOKUP
- Combining VLOOKUP and MATCH
- Using INDEX, MATCH and XLOOKUP
- How to use the IF function
- More Examples of the IF Function
- Working with Nested Ifs
- The IFS function
- Using SUMIFS and COUNTIFS
- Forecast Sheets
- The Forecast Function
- Conditional Formatting
Taught by
Simon Sez IT