Simon Sez IT – Microsoft Excel 2019 – Advanced Course

Get beyond the basics and supercharge your current skill level in Excel. With this 9-hour, 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.

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 Format

• This is a video-led course. You can preview some videos below.
• This course includes practice exercises so you can practice as you learn.
• This course is suitable for Windows users.
• Course suitable for Office 365 Users.

Why Trust Us?

Stream Skill is part of the Simon Sez IT family and has been in business 10+ years and taught over 400,000 students in that time. We’ve created over 90 software training courses, 5,000+ video tutorials, and we’ve helped thousands of people across around the world learn how to use Microsoft Excel. We’ve now created 10+ Microsoft Excel courses and continue to help people get to grips with spreadsheets.