#### (3243-1) Exam: 77–882 Microsoft Office Specialist, Excel 2010 Core

**Lesson 1: Introducing Excel
**

Lesson Objectives

What is an Electronic Spreadsheet?

Looking at the Screen

Entering Data in a Worksheet

Working with Workbooks

Selecting Cells

Lesson Summary

Review Questions

**Lesson 2: Constructing Cell Data**

Lesson Objectives

Editing Cells and Undoing Changes

Copying and Moving Data

Inserting and Deleting Rows and Columns

Adjusting the Columns and Rows

Finding and Replacing Data

Using AutoFill

Managing Worksheets

Lesson Summary

Review Questions

**Lesson 3: Using Formulas
**

Lesson Objectives

Using Formulas

Using Functions

Using Absolute and Relative Cell References

Displaying and Printing Formulas

Lesson Summary

Review Questions

**Lesson 4: Formatting the Worksheet**

Lesson Objectives

Formatting a Cell

Clearing Cell Contents and Formatting

Themes

Using Cell Styles

Conditional Formatting

Lesson Summary

Review Questions

**Lesson 5: Viewing and Printing Workbooks**

Lesson Objectives

Changing Worksheet Views

Printing and Previewing the Workbook

Customizing the Page Layout

Changing Excel Default Settings

Lesson Summary

Review Questions

**Lesson 6: Working with Charts**

Lesson Objectives

Creating a Basic Chart

Moving and Resizing Charts

Changing Chart Types

Working with Pie Charts

Changing the Chart Layout and Location

Using Sparklines

Printing Charts

Lesson Summary

Review Questions

**Lesson 7: Working with Graphics
**

Lesson Objectives

Drawing Shapes

Modifying Graphics Objects

Using SmartArt Graphics

Lesson Summary

Review Questions

**Lesson 8: Analyzing, Organizing and Sharing Workbooks
**

Lesson Objectives

Sorting Data

Filtering Information

Working with Named Ranges

Using Hyperlinks

Using Comments

Importing and Exporting Data

Sharing Workbooks

Lesson Summary

Review Questions

**About the Microsoft Office Specialist course: Excel Expert**

Microsoft® Excel® 2010 Expert teaches the information worker how to work with different types of documents using a variety of core and intermediate features to create and edit professional-looking spreadsheets for a variety of purposes and situations. Some topics may appear to be basic skill sets but are discussed in more detail, exploring at a higher level different options that can be chosen or applied for that skill set.

Students who complete this course will have reviewed all of the exam objectives and be on their way to preparing for Microsoft Excel 2010 Expert Exam #77-888.

#### (3244-1) Exam: 77–888 Microsoft Office specialist, Excel 2010 Expert

**Lesson 1: Presenting Data Visually
**

Lesson Objectives

Customizing Charts

Using Sparklines

Creating and Using Chart Templates

Using Trendlines

Using Custom Cell Formats

Using Tables

Using Dynamic Charts

Lesson Summary

Review Questions

**Lesson 2 – Sharing and Protecting Workbooks
**

Lesson Objectives

Working with Templates

Using XML

Workgroup Functions

Protecting Your Workbook

Lesson Summary

Review Questions

**Lesson 3 – Applying Formulas and Functions**

Lesson Objectives

What are Functions?

Using Math and Trigonometric Functions

Using Statistical Functions

Working with Financial Functions

Using Logical Functions

Using Date and Time Functions

Using Text Functions

Using Information Functions

Converting Data Types

Using Advanced Functions

Auditing a Worksheet

Lesson Summary

Review Questions

**Lesson 4 – Data Analysis**

Lesson Objectives

What-If Analysis

Using the Goal Seek Tool

Using the Solver

Using a Data Table

Working with Scenarios

Analysis ToolPak

Using Array Formulas

Outlining

Advanced Filtering

Using PivotTables

Using the Data Slicer with a PivotTable

Using Slicers on External Data Connections

Using Cube Functions

Lesson Summary

Review Questions

**Lesson 5 – Macros, Forms, and Data Consolidation**

Lesson Objectives

Macros

Adding Form Controls

Data Validation

Using Pick Lists

Circling Invalid Data

Removing Duplicate Rows

Setting Advanced Excel Options

Lesson Summary

Review Questions