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 ⏩ https://www.simonsezit.com/excel-biz-analysis-instructor-files/ 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 ⏩ https://bit.ly/3f1dRDK We've made the files that the instructor uses in this tutorial available to download. Just go here to claim them ⏩ https://www.simonsezit.com/excel-biz-analysis-instructor-files/ 📝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:03 - Combining VLOOKUP and MATCH 0:52:29 - Using INDEX, MATCH and XLOOKUP 1:09:56 - How to use the IF function 1:15:25 - More Examples of the IF Function 1:22:34 - Working with Nested Ifs 1:29:08 - The IFS function 1:37:56 - Using SUMIFS and COUNTIFS 1:49:48 - Forecast Sheets 1:57:06 - The Forecast Function 2:04:31 - Conditional Formatting 🌍 Get unlimited training with Simon Sez IT’s 200+ courses ⏩ https://www.simonsezit.com/courses/ 🚀 Supercharge your skills with a FREE 14-day trial to our extensive training library. Learn from 10,000+ ad-free videos and begin your transformation today! ➡️ https://simonsezit.lpages.co/ssit-14-day-free/ Check out our Excel 2021 tutorials for beginners playlist here ✅https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jqRlmIaj6jb_X9EGQueMDb Check out our FREE 300+ hour training course playlist here ➡️ 🔥https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 💻Watch more popular tutorials from Simon Sez IT: ✅Microsoft Office 2021 and Office 365 Training Tutorials playlist 👉https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hH_MxteY6LR3OSMHpDkt_j ✅Microsoft Office 2019 Training Tutorials for Beginners playlist 👉https://www.youtube.com/playlist?list=PLzj7TwUeMQ3i2OE0G9fSMaVjcW4qi_z_7 ✅ PivotTable training here 👉 https://www.youtube.com/playlist?list=PLzj7TwUeMQ3iJ5hWG_iZuIvFvnuJJ-mtc 💬Stay in touch! ✅SimonSezIT.com: 👉https://www.SimonSezIT.com/ ✅StreamSkill.com: 👉https://StreamSkill.com/ ✅YouTube Channel: 👉https://www.youtube.com/user/simonsezittraining ✅LinkedIn: 👉https://www.linkedin.com/company/simon-sez-it/ 🔔Subscribe to our channel: https://www.youtube.com/simonsezittraining?sub_confirmation=1 If you enjoyed the video, please give a "thumbs up" and subscribe to the channel 👍🏽 ;-)