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

Check out more popular MS Office tutorials from Simon Sez IT:

- 6-Hour Microsoft Excel Crash Course: https://youtu.be/sM0Lldwt7iA
- 5-Hour Microsoft Project 2019 Course: https://youtu.be/5v_42_4Vl2o
- How to Add video to Microsoft PowerPoint: https://youtu.be/yvWv1bk6mu8
- Learn PivotTables in One Hour: https://youtu.be/2RKw-HGCLB0

Other, free Microsoft Excel playlists from Simon Sez IT:

Microsoft Excel 2019 Beginners playlist:
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gABy6lbJgp6kZtXVhadATg

Microsoft Excel 2019 Advanced playlist:
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gL_KnxdZzkDExVeX5vngx9
Stay in touch!
SimonSezIT.com: https://www.SimonSezIT.com/
StreamSkill.com: https://StreamSkill.com/
YouTube Channel: https://www.youtube.com/user/simonsezittraining

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 ;-)

Видео Excel for Business Analysts Crash Course (XLOOKUP, IF, Forecast Sheets & More!) канала Simon Sez IT