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
