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