Become a Member   |   Contact Us   |   Marketplace   |   Sign In
Microsoft Excel 2016 Advanced Online Training Series

Training Series Overview

This series will teach students advanced concepts and formulas in Microsoft Excel 2016. This series is designed for students to gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros.

Career Path: In high-growth industries, entry-level employees who hold a Microsoft Office Specialist (MOS) certification can earn up to $16,000 more, annually, than their peers. Five times as many high-growth/high-salary positions require experience with Office than all non- Microsoft software skills combined. Twenty-nine percent of tomorrow’s high-growth/high-wage positions require Office or Office- related skills.

Series Taught By: Patrick Loner

Certification Details

Successful candidates for the Microsoft Office Specialist Excel 2016 certification exam will have a fundamental understanding of the Excel environment and the ability to complete tasks independently. They will know and demonstrate the correct application of the principle features of Excel 2016. Candidates will create and edit a workbook with multiple sheets, and use a graphic element to represent data visually. Workbook examples include professional-looking budgets, financial statements, team performance charts, sales invoices, and data-entry logs.

Certification Exam Details:
This training will prepare you for the Microsoft Office Specialist Certification. To learn more, please go to Click here for certification details.

Does this training qualify for college credits?
Yes! This course series does qualify for college credits to be applied towards a degree program offered at American Business and Technology University. Learn More

Available CEUs for Course Series Completion: 8
Students can earn up to 8 CEUs for fully completing this course series. This information will be displayed on the certificate of completion. Learn More

Access Training Courses Below

Click any of the titles below to launch your videos:


Course 01 - Working with Multiple Worksheets and WorkbooksAccess Now - No Membership Required 23m

Course 02 - Using Lookup Functions and Formula Auditing 27m

Course 03 - Sharing and Protecting Workbooks 25m

Course 04 - Automating Workbook Functionality 32m

Course 05 - Creating Sparklines and Mapping Data 12m

Course 06 - Forecasting Data 23m

Training Final Exam

Are you ready to earn your certificate of completion? If so, Launch the Final Exam below to do so now!

Training Final Exam

Legal