Excel for Business Analysts Crash Course - XLOOKUP, IF, Forecast Sheets & More

Excel for Business Analysts Crash Course - XLOOKUP, IF, Forecast Sheets & More

Simon Sez IT via YouTube Direct link

- Using SUMIFS and COUNTIFS

11 of 14

11 of 14

- Using SUMIFS and COUNTIFS

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. 1 - Looking up Information with VLOOKUP Exact
  2. 2 - Looking up information with VLOOKUP Approx
  3. 3 - How to use VLOOKUP with data that expands
  4. 4 - Using HLOOKUP
  5. 5 - Combining VLOOKUP and MATCH
  6. 6 - Using INDEX, MATCH and XLOOKUP
  7. 7 - How to use the IF function
  8. 8 - More Examples of the IF Function
  9. 9 - Working with Nested Ifs
  10. 10 - The IFS function
  11. 11 - Using SUMIFS and COUNTIFS
  12. 12 - Forecast Sheets
  13. 13 - The Forecast Function
  14. 14 - Conditional Formatting

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.