Microsoft Office Excel 2007: Core Essentials

Module 1: The Basics

Getting Started

Anatomy of a Spreadsheet

Creating a Spreadsheet

Understanding Workbooks

Using Templates

Using Ribbons and Tabs

Summary

Module 2: Working With Data

Inserting and Deleting Rows and Columns

Merging and Splitting Cells

Moving Cells

Using Paste Special

Using Find and Replace

Hiding and Unhiding Cells

Summary

Module 3: Basic Excel Tools

Understanding Cell References and Formulas

Basic Functions

Advanced Functions

AutoFill

AutoComplete

Spell Check

Sort and Filter

Summary

Module 4: Basic Formatting Tools

Working with Fonts on the Home Tab

Using the Font Tab

Changing the Size of Rows and Columns

Adjusting Cell Alignment

Changing Text Direction

Changing Number Format

Summary

Module 5: Advanced Formatting Tools

Adding Borders and Colors

Using the Format Painter

Using Cell Styles

Using Conditional Formatting

Formatting Data as a Table

Summary

Module 6: Advanced Elements

Adding Pictures

Inserting SmartArt

Drawing Shapes

Drawing Text Boxes

Creating a PivotTable

Creating a Chart

Summary

Module 7: Viewing and Printing

Using Views

Using Zoom.

Using Page Setup

Previewing Your Worksheet

Printing Your Worksheet

E-mailing a Workbook

Summary