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!
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
We use cookies to ensure that we give you the best experience on our website and for more personalised ads and content. Click accept if you are happy with this. You can opt out of cookies used for personalised ads and content by clicking here.