Excel 2019 Advanced

What You'll Learn

What's new/different in Excel 2019
Advanced charting and graphing in Excel
How to use detailed formatting tools
Lookup and advanced lookup functions
Financial functions including calculating interest and depreciation
Statistical functions
Connecting to other workbooks and datasets outside of Excel, e.g. MS Access and the web.
How to create impressive visualizations using sparklines and data bars
Mastery of PivotTables and Pivot Charts
Scenario Manager, Goal Seek and Solver
Advanced charts such as Surface, Radar, Bubble and Stock Charts

Course Format

This is a video-led course. You can preview some videos below.
This course includes practice exercises so you can practice as you learn.
This course is suitable for Windows users.
Course suitable for Office 365 Users.

Get beyond the basics and supercharge your current skill level in Excel. With this 9-hour, expert-led video training course, you'll gain an in-depth understanding of more advanced Excel features that delve into high-level consolidation, analysis and reporting of financial information.

Course curriculum

1
Introduction to Excel 2016 Advanced Course
- Prerequisites of the Course and Version of Excel
- Course Structure
2
Functions
- Functions - Part 1
- Functions - Part 2
- Autosum
3
Date and Time Functions
- How Date and Time Works
- Basic Date and Time Functions
- Complex Date and Time Functions
4
Text Functions
- Using Text Functions - Part 1
- Using Text Functions - Part 2
5
Logical Functions
- Using Logical Functions
- Exercise 01
6
Lookup Functions
- HLOOKUP Function
- VLOOKUP Function
- Exercise 02
7
Financial Functions
- Financial Functions and Terminology
- Personal Financial Functions
- Professional Financial Functions
- Depreciation
- Exercise 03
8
Statistical Functions
- Statistical Functions for Description - Part 1
- Statistical Functions for Description - Part 2
- Statistical Functions for Forecasting - Part 1
- Statistical Functions for Forecasting - Part 2
- Exercise 04
- One Click Forecasting
- Statistical Functions for Inference
9
Connecting to External Data
- Connecting to Other Workbooks
- Connecting to Access Databases
- Connecting to Web Data Sources
- Get and Transform
- Exercise 05
10
Tables
- Introduction to Tables
- Working with Tables
- Table References
- Table Styles
- Exercise 06
11
Pivot Tables
- Introduction to Pivot Tables
- Working with Pivot Tables
- Filters and Slicers
- Pivot Charts
- Exercise 07
12
Data Analysis
- What If Analysis
- Scenario Manager
- Goal Seek
- Solver
- Exercise 08
13
Graphs and Charts
- Area Charts
- Surface Charts
- Radar Charts
- Bubble Charts
- Sparklines
- Stock Charts
- Exercise 09
14
Excel Web App
- Introduction to Excel Web App
- Using the Excel Web App
15
Exercise and Demo Files
- Exercise and Demo Files