Play all

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

Description:

Dive into an extensive 4.5-hour advanced Excel tutorial covering sophisticated functions and formulas. Master VLOOKUP, IF statements, forecasting techniques, and statistical analysis. Begin with a comprehensive introduction to course prerequisites and Excel versions, then progress through autosum, complex date and time functions, text manipulation, and logical operations. Explore financial calculations, depreciation methods, and advanced statistical concepts for descriptive analysis and forecasting. Practice with hands-on exercises throughout the course to reinforce learning. Conclude with one-click forecasting and statistical inference techniques. Suitable for Excel users looking to elevate their spreadsheet skills across various versions, including 2013, 2016, 2019, and Office 365.

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

Simon Sez IT

Add to list

#Business #Business Software #Microsoft Office 365 #Microsoft Excel #Mathematics #Statistics & Probability #Statistical Analysis #Data Science #Data Analysis #Forecasting #Spreadsheets #VLOOKUP

0:00 / 0:00