Главная
Study mode:
on
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
Description:
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.

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

Simon Sez IT
Add to list
0:00 / 0:00