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:
Microsoft Excel 2019 Advanced playlist:
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 😉
source
