Excel 2019 Advanced
- Description
- Course Resources
Excel 2019 Advanced
- DURATION: 8.7 hours
- VIDEOS: 57
- LEVEL: Advanced
Get beyond the basics and supercharge your Excel capabilities. With this 8-hour, expert-led video training course, you’ll gain an in-depth understanding of the most business-relevant advanced features of Microsoft Excel. In this course, we’ll dive into high-level consolidation, analysis, and reporting of financial information.
What You’ll 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 impressive 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 Certificate Included
This course includes an optional online quiz that will generate a course certificate upon completion.
Course Format
This is a video-led training course. You can preview some videos in the pane above. This course includes practice exercises so you can practice as you learn. This course is suitable for Windows users.
This course is also suitable for Office 365 users.
Excel 2019 Advanced
The course exercise and instructor demo files consist of 2 .ZIP files. You will need to download the Excel 2019 Advanced Course Instructor Files.zip file and Excel 2019 Advanced Course Exercise Files.zip file to your PC or Mac (the file are not compatible with a mobile device) and unzip the file. Once unzipped, all of the exercise and instructor demo files will reside in individual folders.
What people are saying
Trusted by
Start Your Membership
Simon Sez: “Let’s make you a software superstar!”
From Excel to photo editing, experience quality courses that ensure easy learning.
START YOUR MEMBERSHIPLearn More