Microsoft Excel Professional 2007

Summary

Microsoft Excel 2007: Tutorial and Applications is designed to be a self-teaching guide for users of Excel on IBM-compatible computers. This book is written with easy-to-follow instructions and steps that are appropriate for both high school and adult students.

Features
Learning Objectives
Estimated time for completion
Simplified explanations of each feature
Hands-on exercises with easy-to-follow, step-by-step instructions
Numerous activities and applications to enhance learning

25 to 40 hours of instruction.

Table of Contents

Excel Basics
1.  Getting Started with Excel
2.  Using Excel's Menus, Dialog Boxes, and Help Features
3.  Creating a Worksheet
4.  Editing a Worksheet
5.  Number, Date, and Customer Formats
6.  Formulas and Functions
7.  Printing
 
Enhancing Excel Worksheets
8.  Text Formatting
9.  Cell Enhancement
10.  Modifying Columns and Rows
11.  Display Options
12.  Working with Multiple Worksheets and Workbooks
13.  Consolidating Data
 
Creating and Enhancing Charts
14.  Chart Basics
15.  Creating embedded Charts
16.  Editing Charts
17.  Enhancing Chart Features

Productivity Features
18.  Protection Options
19.  Using Templates
20.  Creating Outlines and Subtotals Working with Data Lists and Macros
21.  Data Lists Basics
22.  Editing and Sorting Data Lists
23.  Searching Data Lists
24.  Basic Macros

Excel's Power Features
25.  Advanced Analysis Tools
26.  Hyperlinks
27.  Graphic Objects
28.  Embedding Objects
29.  Integration with Microsoft Word
30.  Importing Data and Sharing Files

Appendix
Glossary
Index