Download the free course exercise files to follow along
️ https://theskillstream.com/excel-adv-2016-course-exercise-files

During this epic 4 hour, 32 minute, advanced Excel training we look at some of the 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.

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 tutorial is an extract from our full Advanced Excel 2019 course, available here https://bit.ly/3iVdBHg

Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead!

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.

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

Watch more free popular training tutorials from Simon Sez IT:

Check out our FREE 300+ hour training course playlist here ️
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

Check out our free video playlist for Excel beginners https://www.youtube.com/playlist?list=PLzj7TwUeMQ3iZHn4cv_fZagWSN8tubU9Z

Excel 2021 Tutorials for Intermediate Users here https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jhT7yg37LKe8aSTA7OuWn3

Microsoft Excel Tips and Tricks https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc

Microsoft Office 2021 and Office 365 Training here https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hH_MxteY6LR3OSMHpDkt_j

Stay in touch!
SimonSezIT.com: https://www.SimonSezIT.com/
LinkedIn: https://www.linkedin.com/company/simon-sez-it/
FaceBook: https://www.facebook.com/SimonSezIT

Subscribe to our channel:
https://www.youtube.com/simonsezittraining?sub_confirmation=1

If you enjoyed the video, please give a thumbs up ;-)