Completed
- Forecast Sheets
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel for Business Analysts Crash Course - XLOOKUP, IF, Forecast Sheets & More
Automatically move to the next video in the Classroom when playback concludes
- 1 - Looking up Information with VLOOKUP Exact
- 2 - Looking up information with VLOOKUP Approx
- 3 - How to use VLOOKUP with data that expands
- 4 - Using HLOOKUP
- 5 - Combining VLOOKUP and MATCH
- 6 - Using INDEX, MATCH and XLOOKUP
- 7 - How to use the IF function
- 8 - More Examples of the IF Function
- 9 - Working with Nested Ifs
- 10 - The IFS function
- 11 - Using SUMIFS and COUNTIFS
- 12 - Forecast Sheets
- 13 - The Forecast Function
- 14 - Conditional Formatting
