Microsoft Excel 2019 Advanced eLearning Course
Course Overview
Get beyond the basics and supercharge your current skill level in Excel. With this 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.
Learning Objectives:
In this 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 exercise files.
- This course is suitable for Windows users.
This course has a minimum of 25 learner registrations for us to provide a quotation.
Request a Quotation- Language
- UK
- Date last updated
- 5/29/2023
- Duration
- 8 Hours
- Suitable Devices
-
- PC
- Tablet
- Audio is Required
-
- Yes
- Includes Video
-
- Yes
- Downloadable Resources
-
- Accessibility Files
- Exercise Files
- Transcripts
- Completion Criteria
-
- Visit all pages
- Pass Mark
-
- None
- Course Technology
-
- HTML5
- SCORM 1.2
- Can be customised
-
- No
- Accreditation or Endorsements
-
- No
- Languages
-
- English
