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 150+ courses ⏩ https://www.simonsezit.com/courses/

Level up your skills with a free 30 day trial to our complete training library of 8,500+ videos ⏩ https://www.simonsezit.com/ssit-first-month-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 ;-)