Advanced Excel Tutorial - Advanced Functions - VLOOKUP, IF, Forecasting, Statistical

WARNING: This course has a full introduction. If you don't wish to watch the introduction then skip to which is where the content starts.
- Prerequisites of the Course and Version of Excel
- Course Structure
- Functions - Part 1 Start here to skip the introduction
- Autosum
- Functions - Part 2
- How Date and Time Works
- Basic Date and Time Functions
- Complex Date and Time Functions
- Using Text Functions - Part 1
- Using Text Functions - Part 2
- Using Logical Functions
- Exercise 01
- HLOOKUP Function
- VLOOKUP Function
- Exercise 02
- Financial Functions and Terminology PMT Function
- Personal Financial Functions FV Function, DATE Function, DATEDIF Function, RRI Function, PDURATION Function
- Professional Financial Functions PPMT Function, IPMT Function
- Depreciation SLN Function
- Exercise 03
- Statistical Functions for Description - Part 1 MIN Function, MAX Function, AVERAGE Function, MODE.MULT Function, AVERAGEIF Function
- Statistical Functions for Description - Part 2 QUARTILE.INC Function, QUARTILE.EXC Function, STDEV.P Function
- Statistical Functions for Forecasting - Part 1 SLOPE Function, FORECAST.LINEAR Function, TREND Function
- Statistical Functions for Forecasting - Part 2 LINEST Function
- Exercise 04
- One Click Forecasting
- Statistical Functions for Inference