(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
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
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
Adding Form Controls
Data Validation
Using Pick Lists
Circling Invalid Data
Removing Duplicate Rows
Setting Advanced Excel Options
Lesson Summary
Review Questions