Completed
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.
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Advanced Excel Tutorial - Advanced Functions - VLOOKUP, IF, Forecasting, Statistical
Automatically move to the next video in the Classroom when playback concludes
- 1 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.
- 2 - Prerequisites of the Course and Version of Excel
- 3 - Course Structure
- 4 - Functions - Part 1 Start here to skip the introduction
- 5 - Autosum
- 6 - Functions - Part 2
- 7 - How Date and Time Works
- 8 - Basic Date and Time Functions
- 9 - Complex Date and Time Functions
- 10 - Using Text Functions - Part 1
- 11 - Using Text Functions - Part 2
- 12 - Using Logical Functions
- 13 - Exercise 01
- 14 - HLOOKUP Function
- 15 - VLOOKUP Function
- 16 - Exercise 02
- 17 - Financial Functions and Terminology PMT Function
- 18 - Personal Financial Functions FV Function, DATE Function, DATEDIF Function, RRI Function, PDURATION Function
- 19 - Professional Financial Functions PPMT Function, IPMT Function
- 20 - Depreciation SLN Function
- 21 - Exercise 03
- 22 - Statistical Functions for Description - Part 1 MIN Function, MAX Function, AVERAGE Function, MODE.MULT Function, AVERAGEIF Function
- 23 - Statistical Functions for Description - Part 2 QUARTILE.INC Function, QUARTILE.EXC Function, STDEV.P Function
- 24 - Statistical Functions for Forecasting - Part 1 SLOPE Function, FORECAST.LINEAR Function, TREND Function
- 25 - Statistical Functions for Forecasting - Part 2 LINEST Function
- 26 - Exercise 04
- 27 - One Click Forecasting
- 28 - Statistical Functions for Inference
