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.
Simon Sez IT – Microsoft Excel 2019 – Advanced Course
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.
Method Purchase & Reveice Course
> All courses are available in our website
> You will receive download link course (Google Drive) to your order email or File Manager in website
> If you can’t find the download link for the course you paid for, please don’t worry about it. We will notify and update you via your email at 7:00 AM – 11:00 PM (UTC +7)
> All courses are digital online versions, so you will download and save to your hard drive.
