|
Lesson 1:
Getting Started
Starting Out
About Workbooks
Exploring your
Workbook
Getting Help in
Excel 2007
Lesson 2: The
2007 Interface
The Quick Access
Toolbar
The Home Ribbon
The Insert Ribbon
The Page Layout
Ribbon
The Formulas Ribbon
The Data Ribbon
The Review Ribbon
Lesson 3: Excel
Basics
Working With Excel
Basic Excel
Features
Moving your Data
Smart Tags and
Options Buttons
Editing Tools
Lesson 4:
Editing Your Workbook
Modifying Cells and
Data
Cell Formatting
Enhancing a
Worksheet’s Appearance
Working with
Charts, Part 1
Working with
Charts, Part 2
Lesson 5:
Printing and Viewing your Workbook
Using the View
Ribbon
Managing a Single
Window
Managing Multiple
Windows
Printing your
Workbook
Lesson
6: Advanced File Tasks
Using My
Computer within Excel
Saving your
Files
Using
Templates
Lesson
7: Working with Functions and Formulas
Using
Formulas in Excel
Exploring
Excel Functions
Using
Functions in Excel
Working with
Names and Ranges
Working with
Array Formulas
|
Lesson
8: Managing Tables
Working with
Tables
Working with
Records and Fields
Working with
Tables and Filters
Using Excel
as a Database
Lesson
9: Enhancing your Workbook
Customizing
your Workbook
Working with
Text Boxes
WordArt
ClipArt
Using Objects
Lesson
10: Finalizing Your Workbook
Protecting
your Workbook
Finishing
Your Workbook
Lesson
11:
Getting the Most from your Data
Getting the
Most From Your Data
PivotTables
More About
PivotTables
Exploring
Scenarios
What If
Analysis
Getting Data
from the Internet
Lesson
12:
Advanced Excel Tasks
Creating and
Using Shared Workbooks
Using Custom
AutoFill Lists
Using the
VLOOKUP Function
Linking,
Consolidating, and Combining Workbooks
| 
