Microsoft Excel 2003 Fast & Easy

Diane Koers, Course Technology PTR

ISBN:1592000797, Edition: 1, 2003-10-23

Price: $19.99

Table of Contents

Dedication

Acknowledgments

About the Author

Introduction
How This Book Is Organized
Who Should Read This Book?
Added Advice to Make You a Pro

Part I: Building a Basic Worksheet

Chapter 1. Exploring the Excel Screen
Starting Excel
Exploring the Worksheet Screen
Moving around the Worksheet Screen
Using Excel Help

Chapter 2. Creating a Simple Worksheet
Entering Data
Saving a Worksheet File
Closing a Worksheet
Enabling AutoRecover
Opening an Existing File
E-Mailing a Worksheet
Starting a New Worksheet

Chapter 3. Editing a Worksheet
Editing Data
Learning Selection Techniques
Inserting Areas
Deleting Areas
Using Undo and Redo
Moving Data Around
Copying Data
Using the Office Clipboard
Using the Fill Feature

Chapter 4. Making the Worksheet
Using AutoFormat
Formatting Numbers
Formatting with Fonts
Adjusting Column Width
Adjusting Row Height
Setting Worksheet Alignment
Adding Cell Borders
Adding Background Color
Using Cell Patterns
Copying Cell Formatting

Chapter 5. Selecting Printing Options
Setting Up the Pages
Creating a Header or Footer
Selecting a Print Area
Printing a Worksheet
Review Questions

Part II: Working with Formulas and Larger Worksheets

Chapter 6. Working with Formulas
Creating Formulas
Editing Formulas
Copying Formulas
Creating an Absolute Reference in a Formula
Viewing Formulas
Understanding Common Formula Error Messages

Chapter 7. Using Excel Functions
Understanding Function Syntax
Creating a Total with the SUM Function
Using Other Functions
Getting Help with Excel Functions

Chapter 8. Working with Larger Workbooks
Moving from Worksheet to Worksheet
Inserting Worksheets
Naming Worksheets
Hiding a Worksheet
Deleting Worksheets
Creating a Reference to Another Worksheet
Creating Links to Other Workbooks

Chapter 9. Worksheets Managing Larger
Modifying Worksheet Views
Working with Ranges
Using Find and Replace
Review Questions

Part III: Adding Visual Interest

Chapter 10. Working with Art Images
Inserting Images
Customizing Art
Adding WordArt
Making Adjustments to the WordArt
Deleting an Art Image

Chapter 11. Creating Charts from Excel Data
Creating a Chart
Modifying a Chart
Deleting a Chart

Chapter 12. Using the Drawing Toolbar
Drawing Shapes
Editing the Drawing Object
Review Questions

Part IV: Analyzing Data

Chapter 13. Working with Data
Sorting
Using Filters
Data Subtotals
Conditional Formatting

Chapter 14. Discovering Tools for Speed and Quality
Checking the Spelling
Working with AutoCorrect
Using the Excel Research Tools
Translating Words
Checking for Errors
Understanding Smart Tags

Chapter 15. Customizing Excel
Setting Preferences
Working with Templates
Review Questions

Part V: Integrating Excel Technology

Chapter 16 . Integrating Excel with Word
Using Excel Worksheets in Word
Inserting an Existing Excel Worksheet into Word
Inserting Word Data into Excel

Chapter 17. Using Excel with Access
Exporting an Access Table or Query to Excel
Importing Excel Data into Access
Linking an Excel Worksheet to Access

Chapter 18. Collaborating with Others
Working with Comments
Working with Revisions
Sharing a Workbook
Securing a Workbook
Review Questions

Appendix A . Excel Shortcut Keys
Learning the Basic Shortcuts
Working inside Workbooks
Moving around a Workbook
Typing and Editing Cell Data
Selecting Ranges of Cells
Formatting Data
Miscellaneous Commands

Glossary

Symbols
A
B
C
D
F
G
H
I
J
L
M
N
O
P
R
S
T
U
V
W
X
Y
Z