Learn and master Excel 2019 by learning advanced functions and formulas
About This Video
Learn and understand advanced Excel features that delve into high-level consolidation, analysis, and reporting of financial information
Learn and master advanced charting and graphing in Excel
In Detail
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 …
Microsoft Excel Advanced 2019
Video description
Learn and master Excel 2019 by learning advanced functions and formulas
About This Video
Learn and understand advanced Excel features that delve into high-level consolidation, analysis, and reporting of financial information
Learn and master advanced charting and graphing in Excel
In Detail
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.
Upon completion of this course, you'll be able to create charts that have an impact from databases that communicate data and financial records efficiently and effectively.
You will be able to report data in various formats including: tables, graphs and PivotTables. Once completed you'll have advanced understanding of Excel that will positively impact your professional capability.
Who this book is for
This course is designed for those who have basic knowledge of Excel 2019/365 and those upgrading from previous software versions
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
Start your Free Trial Self paced Go to the Course We have partnered with providers to bring you collection of courses, When you buy through links on our site, we may earn an affiliate commission from provider.
This site uses cookies. By continuing to use this website, you agree to their use.I Accept