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.
What’s Included?
Unlimited 12 months access
Access anywhere, any time
Fast effective training, written and designed by industry experts
Track your progress with our Learning Management System
Unlimited support
Save money, time and travel costs
Learn at your own pace and leisure
Easier to retain knowledge and revise topics than traditional methods
Exam preparation quizzes, tests and mock exams to ensure that you are 100% ready
$160.99Add to basket
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