Microsoft Excel 2019: Advanced

Microsoft Excel 2019: Advanced

With this expert-led video training course, ’Microsoft Excel 2019 – Advanced’, you’ll gain an in-depth understanding of more advanced Excel features that delve into high-level consolidation, analysis and reporting of financial information. Length: 9 hours | Project Files Included!

£199.99

£199.99

Why Choose Us?

Description

With this expert-led video training course, ’Microsoft Excel 2019 – Advanced’, you’ll gain an in-depth understanding of more advanced Excel features that delve into high-level consolidation, analysis and reporting of financial information. Length: 9 hours | Project Files Included!

In this Microsoft Excel 2019 – Advanced course, you will 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 awesome 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.
This course includes practice exercises so you can practice as you learn.
This course is suitable for Windows users.

Modules

Chapter 1: Introduction to Excel 2016 Advanced Course

Prerequisites of the Course and Version of Excel

Course Structure

Chapter 2: Functions

Functions – Part 1

Functions – Part 2

Autosum

Chapter 3: Date and Time Functions

How Date and Time Works

Basic Date and Time Functions

Complex Date and Time Functions

Chapter 4: Text Functions

Using Text Functions – Part 1

Using Text Functions – Part 2

Chapter 5: Logical Functions

Using Logical Functions

Exercise 01

Chapter 6: Lookup Functions

HLOOKUP Function

VLOOKUP Function

Exercise 02

Chapter 7: Financial Functions

Financial Functions and Terminology

Personal Financial Functions

Professional Financial Functions

Depreciation

Exercise 03

Chapter 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

Chapter 9: Connecting to External Data

Connecting to Other Workbooks

Connecting to Access Databases

Connecting to Web Data Sources

Get and Transform

Exercise 05

Chapter 10: Tables

Introduction to Tables

Working with Tables

Table References

Table Styles

Exercise 06

Chapter 11: Pivot Tables

Introduction to Pivot Tables

Working with Pivot Tables

Filters and Slicers

Pivot Charts

Exercise 07

Chapter 12: Data Analysis

What If Analysis

Scenario Manager

Goal Seek

Solver

Exercise 08

Chapter 13: Graphs and Charts

Area Charts

Surface Charts

Radar Charts

Bubble Charts

Sparklines

Stock Charts

Exercise 09

Chapter 14: Excel Web App

Introduction to Excel Web App

Using the Excel Web App

Chapter 15: Course Conclusion

Closing Message

Shopping Basket