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

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

Grab it

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