• Excel
Certification Prep Course

Microsoft Office Specialist (MOS) - Excel 2010 Advanced

Browse All Courses > Office Productivity

Have a question while you're learning?

Get in-depth explanations, tips, further insights, and more from Certified Experts. Our experts are vetted industry professionals eager to help you learn from their experiences.

Course Syllabus(183 Lessons)

Course Description

This path builds on the skills and concepts taught in Excel 2010: Intermediate. Participants will work with advanced formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX. In addition, participants will learn about data validation and database functions such as DSUM. They will learn how to work with PivotTables and PivotCharts, how to import and export data, and how to query external databases. Finally, participants will learn about the analytical features of Excel (such as Goal Seek and Solver), running and recording macros, SmartArt graphics, and conditional formatting with graphics.

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.

This is the third and final course in the Microsoft Office Excel 2010 path. Prior to taking this course, participants should complete Microsoft Office Excel 2010 Intermediate.

Path taught by Debbie Fierst and Tracy Berry.
Office 2013 combines cloud and web technologies to extend the way you create and consume information and introduces a new cloud app model for you to build secure and flexible apps—all discoverable from the familiar Office interface.

Certification Exam Details:
Participants who complete this path can take Exam 77-882 for Microsoft Office Excel 2010.

This path is part of the training that will prepare you for the Microsoft Office Specialist Certification. Learn more about this certification.

Course Details

3h 20m 32s


Debbie Fierst
In 1990 I started—and still own—a thriving technology training, consulting, and development firm. As a summa cum laude graduate of Indiana Wesleyan University, I hold various technical certifications. I teach more than 60 software applications and programming languages both online and in-person, but I specialize in business and project-management topics. My presentations are packed with strategies, statistics, real-life examples, and common-sense messages.
Debbie FierstPresident and Owner

Share Course

  • LinkedIn

Ready to get started?