Excel 2016 Advanced
- Description
- Course Resources
Excel 2016 Advanced
- DURATION: 9.0 hours
- VIDEOS: 57
- LEVEL: Advanced
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 2016
- 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. 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.
Course Certificate Included
This course includes an optional online quiz that will generate a course certificate upon completion.
30-Day Guarantee
We offer an unconditional, 30-day, full money-back guarantee, no questions asked. It’s our way of ensuring you have complete confidence in your membership to Simon Sez IT. With 30 days of risk-free membership, you can test-drive all of our courses and feel entirely sure you’re getting just what you need. If you don’t learn, you don’t pay.
Why Trust Us?
Simon Sez IT has been in business 10+ years and taught over 500,000 students in that time. We’ve created over 100 software training courses, 5,900+ video tutorials, and we’ve helped thousands of people across around the world learn how to use Microsoft Office and developed multiple Microsoft Word training courses.
How Do I Start?
Simon Sez IT makes complicated software simple at a fantastic price. To access this course and over 90 others, select a membership option on the right-hand side >>>
All Simon Sez IT memberships are entirely flexible (cancel anytime) and all include our no questions asked 30-day money-back guarantee.
Excel 2016 Advanced
The course support files consist of a single .ZIP file. You will need to download the Excel 2016 Advanced Course Instructor 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/example files will reside in one folder.
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