Beschreibung
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
£119.00In den Warenkorb
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
