Advanced Excel Tutorial: Advanced Functions Course (VLOOKUP, IF, Forecasting, Statistical)

Download the Excel exercise files and follow along here ► https://theskillstream.com/excel-adv-2016-course-exercise-files

Get the complete 15.5-hour Excel 2019 Beginner-Advanced courses here ► https://www.simonsezit.com/courses/business/quickbooks-pro-2020/

For more Excel videos, take a look here ►
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3i2AbeLeQt3UqLvTSoO4SAL

During this epic 4 hour, 32 minute Excel tutorial we look at many of the more advanced Excel formulas and advanced Excel functions including the IF statement and VLOOKUP in Excel. This Excel course assumes you already know how to use Microsoft Excel to a good standard and it teaches you how to take your spreadsheeting skills to the next level.

WARNING: This course has a full introduction. If you don't wish to watch the introduction then skip to 0:13:50 which is where the content starts.

This video was made using the Simon Sez IT Excel tutorials: https://www.simonsezit.com/course-category/excel/

In this Advanced Excel tutorial, we show you:

0:00:00 - Prerequisites of the Course and Version of Excel
0:08:47 - Course Structure
0:13:50 - Functions - Part 1 (Start here to skip the introduction)
0:29:35 - Autosum
0:35:52 - Functions - Part 2
0:46:36 - How Date and Time Works
0:57:57 - Basic Date and Time Functions
1:09:53 - Complex Date and Time Functions
1:24:39 - Using Text Functions - Part 1
1:39:16 - Using Text Functions - Part 2
1:54:24 - Using Logical Functions
2:05:38 - Exercise 01
2:07:58 - HLOOKUP Function
2:23:16 - VLOOKUP Function
2:32:12 - Exercise 02
2:38:19 - Financial Functions and Terminology (PMT Function)
2:49:40 - Personal Financial Functions (FV Function, DATE Function, DATEDIF Function, RRI Function, PDURATION Function)
3:00:21 - Professional Financial Functions (PPMT Function, IPMT Function)
3:08:10 - Depreciation (SLN Function)
3:13:24 - Exercise 03
3:15:10 - Statistical Functions for Description - Part 1 (MIN Function, MAX Function, AVERAGE Function, MODE.MULT Function, AVERAGEIF Function)
3:29:24 - Statistical Functions for Description - Part 2 (QUARTILE.INC Function, QUARTILE.EXC Function, STDEV.P Function)
3:44:00 - Statistical Functions for Forecasting - Part 1 (SLOPE Function, FORECAST.LINEAR Function, TREND Function)
3:56:18 - Statistical Functions for Forecasting - Part 2 (LINEST Function)
4:08:45 - Exercise 04
4:10:30 - One Click Forecasting
4:19:46 - Statistical Functions for Inference

Note, this video was recording using Excel 2016, but much of what is shown is still relevant in Excel 2013, 2019 and Office 365 versions of the Excel software.

More Excel training 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

If you enjoyed the video, please give a "thumbs up", leave some comments and subscribe to the channel ;-)

Видео Advanced Excel Tutorial: Advanced Functions Course (VLOOKUP, IF, Forecasting, Statistical) канала Simon Sez IT