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

Training Series Overview

This series builds upon the foundational knowledge presented in the Microsoft Office Excel 2016 Basic training series. Students will start down the road to creating advanced workbooks and worksheets that can help deepen understanding of organizational intelligence. This series is meant for students who want to advance their skill set by learning to work with advanced formulas, lists, and illustrations. Students will also work with charts and advanced formatting including styles.

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 FunctionsAccess Now - No Membership Required 1hr 11m

Course 02 - Working with Lists 36m

Course 03 - Analyzing Data 26m

Course 04 - Visualizing Data with Charts 35m

Course 05 - Using PivotTables and PivotCharts 40m

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