Completed
- How Date and Time Works
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
