Microsoft® Office Excel® 2010: Certification Preparation

Course Specifications

Course number: 084979
Course length: 3.0 day(s)
Certification: MOS: Microsoft Office Excel 2010 Exam 77–882, MOS: Microsoft Office Excel 2010 Expert Exam 77–888

Course Description

Course Objective: You will use the features of Microsoft® Office Excel® 2010 to attain proficiency as an Excel power user.

Target Student: This course is designed for students who desire to gain the necessary skills to perform basic through advanced functions using Microsoft Office Excel 2010.

Prerequisites: To be successful in this course, you should be familiar with using personal computers and you should have used the mouse and keyboard. You should be comfortable in the Windows environment and be able to use Windows to manage information on the computer. Specifically, you should be able to launch and close programs; navigate to information stored on the computer; and manage files and folders. To ensure your success, we recommend you first take one of Element K's introductory Windows courses, such as either of the following, or have equivalent skills and knowledge:


This course is one of a series of Element K courseware titles that addresses Microsoft Office Specialist (MOS) certification skill sets. The MOS certification program is for individuals who use Microsoft's business desktop software and who seek recognition for their expertise with specific Microsoft products.

Hardware Requirements

For this course, you will need one computer for each student and the instructor. Each computer should have the following minimum hardware configuration:

Software Requirements

Each computer requires the following software:

Course Objectives

Upon successful completion of this course, students will be able to:

Course Content

Lesson 1: Getting Started with Excel

Topic 1A: Identify the Elements of the Excel Interface
Topic 1B: Navigate and Select Cells in Worksheets
Topic 1C: Customize the Excel Interface
Topic 1D: Create a Basic Worksheet
Lesson 2: Performing Calculations in an Excel Worksheet

Topic 2A: Create Formulas in a Worksheet
Topic 2B: Insert Functions in a Worksheet
Topic 2C: Reuse Formulas
Lesson 3: Modifying an Excel Worksheet

Topic 3A: Edit Worksheet Data
Topic 3B: Find and Replace Data
Topic 3C: Manipulate Worksheet Elements
Lesson 4: Modifying the Appearance of a Worksheet

Topic 4A: Apply Font Properties
Topic 4B: Align Content in a Cell
Topic 4C: Apply Number Formatting
Topic 4D: Apply Cell Styles
Lesson 5: Managing an Excel Workbook

Topic 5A: Manage Worksheets
Topic 5B: View Worksheets and Workbooks
Lesson 6: Printing Excel Workbooks

Topic 6A: Define the Page Layout
Topic 6B: Print a Workbook
Lesson 7: Calculating Data with Advanced Formulas

Topic 7A: Apply Cell and Range Names
Topic 7B: Analyze Data with Logical and Lookup Functions
Lesson 8: Organizing Worksheet and Table Data

Topic 8A: Create and Modify Tables
Topic 8B: Sort or Filter Data
Lesson 9: Presenting Data Using Charts

Topic 9A: Create a Chart
Topic 9B: Create Advanced Charts
Lesson 10: Analyzing Data Using PivotTables, Slicers, and PivotCharts

Topic 10A: Create a PivotTable Report
Topic 10B: Filter Data Using Slicers
Topic 10C: Analyze Data Using PivotCharts
Lesson 11: Inserting Graphic Objects

Topic 11A: Insert and Modify Pictures and ClipArt
Topic 11B: Draw and Modify Shapes
Topic 11C: Illustrate Workflow Using SmartArt Graphics
Lesson 12: Customizing and Enhancing the Excel Environment

Topic 12A: Customize the Excel Environment
Topic 12B: Customize Workbooks
Topic 12C: Create and Use Templates
Lesson 13: Streamlining Workflow

Topic 13A: Update Workbook Properties
Topic 13B: Create a Macro
Topic 13C: Edit a Macro
Topic 13D: Apply Conditional Formatting
Topic 13E: Add Data Validation Criteria
Lesson 14: Collaborating with Other Users

Topic 14A: Protect Files
Topic 14B: Share a Workbook
Topic 14C: Set Revision Tracking
Topic 14D: Review Tracked Revisions
Topic 14E: Merge Workbooks
Topic 14F: Restrict Document Access
Lesson 15: Auditing Worksheets

Topic 15A: Trace Cells
Topic 15B: Troubleshoot Invalid Data and Formula Errors
Topic 15C: Watch and Evaluate Formulas
Topic 15D: Create a Data List Outline
Lesson 16: Analyzing Data

Topic 16A: Create a Trendline
Topic 16B: Create Sparklines
Topic 16C: Create Scenarios
Topic 16D: Perform a What-If Analysis
Topic 16E: Perform a Statistical Analysis with the Analysis ToolPak
Lesson 17: Working with Multiple Workbooks

Topic 17A: Create a Workspace
Topic 17B: Consolidate Data
Lesson 18: Importing and Exporting Data

Topic 18A: Export Excel Data
Topic 18B: Import a Delimited Text File
Topic 18C: Import and Export XML Data
Lesson 19: Manipulating Data Using Functions

Topic 19A: Forecast GDP Using Statistical Functions
Topic 19B: Manipulate Data Using Text Functions
Topic 19C: Validate Data Using Information Functions
Lesson 20: Analyzing Data Using Data Analysis Tools

Topic 20A: Analyze Sales Data Using Descriptive Statistics
Topic 20B: Analyze Time Series Data Using Exponential Smoothing
Topic 20C: Analyze Data Using Regression
Topic 20D: Analyze Sector Data Using Correlation and Covariance Matrices
Topic 20E: Optimize a Stock Portfolio Using Solver
Lesson 21: Working with Data Using Financial Functions

Topic 21A: Develop an Investment Schedule Using Financial Functions
Topic 21B: Make Investment Decisions Using Financial Functions
Lesson 22: Examining Data Using Math Functions

Topic 22A: Analyze Sales Data Using Math Functions
Topic 22B: Calculate Stock Returns Using Math Functions
Topic 22C: Aggregate GDP Data Using Math Functions
Appendix A: Creating Excel Forms
Appendix B: Commonly Used Excel Functions
Appendix C: Microsoft Office Excel 2010 Exam 77–882
Appendix D: Microsoft Office Excel 2010 Expert Exam 77–888