Excel 2019 Advanced
Excel 2019 Advanced
- DURATION: 8h 10m
- VIDEOS: 57
- LEVEL: Advanced
- Description
- Course Resources
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.
WHAT YOU GET


Certificate of Completion
- Earn a certificate each time you complete a course.
- Showcase your commitment to continuous growth and professional development.
- Impress potential employers.
- Enhance your professional profile.
- Available in PDF format to Download or Print.
INSTRUCTOR


Deborah Ashby
Meet Deb, your go-to guide in the exciting world of Excel and beyond! With her infectious enthusiasm and razor-sharp expertise, she's on a quest to turn everyone into Excel wizards. Deb doesn't just stop at Excel, though. She'll lead you through the fascinating realms of Microsoft Word, PowerPoint, and other Microsoft 365 apps, helping businesses and individuals alike to unlock their full potential. But she's no ordinary trainer. Boasting an impressive track record of over 25 years and revered by past and current learners alike, Deb's teaching prowess is unparalleled. To top it off, she's a proud recipient of the coveted Microsoft MVP (Most Valuable Professional) award. Buckle up and join Deb on this exhilarating learning journey!
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