Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

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

Simon Sez IT via YouTube

Overview

Master essential Excel functions and tools for business analysis in this comprehensive 2-hour tutorial. Learn to efficiently look up information using VLOOKUP, HLOOKUP, and XLOOKUP. Explore the versatility of IF functions, including nested IFs and IFS. Dive into data analysis with SUMIFS, COUNTIFS, and Forecast Sheets. Enhance your spreadsheets with Conditional Formatting. Download accompanying files to practice alongside the instructor, covering topics from basic lookups to advanced forecasting techniques. Perfect for business analysts seeking to improve their Excel skills and streamline data analysis processes.

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

Reviews

Start your review of Excel for Business Analysts Crash Course - XLOOKUP, IF, Forecast Sheets & More

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.