Browse All Courses > Office Productivity

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.

Microsoft Excel 2010: Adv. (R2) - Unit 01 - Logical and Statistical Functions

Course Introduction

4 lessons1m 36s

Topic A: Logical Functions

12 lessons16m 47s

Topic B: Math and Statistical Functions

15 lessons19m 41s

Microsoft Excel 2010: Adv. (R2) - Unit 02 - Financial and Date Functions

Topic A: Financial Functions

5 lessons4m 11s

Topic B: Date and Time Functions

5 lessons10m 16s

Topic D: Displaying and Printing Formulas

11 lessons8m 38s

Microsoft Excel 2010: Adv. (R2) - Unit 03 - Lookups and Data Tables

Topic A: Using Lookup Functions

14 lessons14m 28s

Topic B: Using MATCH and INDEX

5 lessons6m 25s

Microsoft Excel 2010: Adv. (R2) - Unit 04 - Advanced Data Management

Topic A: Validating Cell Entries

9 lessons8m 36s

Topic B: Exploring Database Functions

8 lessons7m 10s

Microsoft Excel 2010: Adv. (R2) - Unit 05 - Exporting and Importing

Topic A: Exporting and Importing Text Files

12 lessons11m 24s

Topic B: Exporting and Importing XML Data

6 lessons3m 33s

Topic C: Querying External Databases

9 lessons9m 58s

Microsoft Excel 2010: Adv. (R2) - Unit 06 - Analytical Tools

Topic A: Goal Seek and Solver

9 lessons15m 32s

Topic B: The Analysis ToolPak

4 lessons5m 14s

Microsoft Excel 2010: Adv. (R2) - Unit 07 - Macros and Custom Functions

Topic A: Running and Recording a Macro

15 lessons19m 09s

Topic B: Working with VBA Code

6 lessons6m 58s

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.

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.

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.

- Level:
- Advanced
- Duration:
- 3h 20m 32s
- Students:
- 13

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.

- Our Company
- Why EE?
- Plans and Pricing
- Contact Us
- Who We Are
- Charities
- Careers

- Experts
- Our Experts
- Become an Expert
- Expert Awards

- Community
- Memberships
- Get Access
- Podcasts
- CloudClass Courses
- Articles
- Posts
- Videos
- Our Experts
- Groups

Experts Exchange

Take hold of your future.

© 1996-2020 Experts Exchange, LLC. All rights reserved. Covered by US Patent.

© 1996-2020 Experts Exchange, LLC. All rights reserved. Covered by US Patent.