Excel for Business Analysts Crash Course (XLOOKUP, IF, Forecast Sheets & More!)

Follow along and download the Excel for Business Analysts files for this tutorial here: In this 2 hour Excel tutorial we take you through a few of the Excel functions and tools you need to perform data or business analysis in Excel. We go through VLOOKUP, HLOOKUP, INDEX MATCH, XLOOKUP, IF, IFs, Nested IF, Forecast Sheets, LINEAR, SLOPE, INTERCEPT, and finally, Conditional Formatting. This tutorial was extracted from our 7-hour Excel for Business Analysts course available here: We’ve made the files that the instructor uses in this tutorial available to download. Just go here to claim them: Time Stamps: 0:00:00 - Looking up Information with VLOOKUP (Exact) 0:11:17 - Looking up information with VLOOKUP (Approx) 0:17:26 - How to use VLOOKUP with data that expands 0:27:49 - Using HLOOKUP 0:40:0