Microsoft Office Excel 2003

by Reding, Elizabeth Eisner

• ISBN13: 9780619188030
• ISBN10: 0619188030
• Format: Paperback
• Copyright: 2003-11-26
• Publisher: Course Technology

Summary

Part of the Illustrated series, this text offers a visual, flexible way to build Microsoft Excel 2003 skills.

Table of Contents

Preface	iv
EXCEL 2003
Getting Started with Excel 2003	1	(1)
Defining Spreadsheet Software	2	(2)
Starting Excel 2003	4	(2)
Viewing the Excel Window	6	(2)
Working with toolbars and menus in Excel 2003
Opening and Saving a Workbook	8	(2)
Creating a new workbook
Opening a workbook using a template
Entering Labels and Values	10	(2)
Navigating a worksheet
Naming and Moving a Sheet	12	(2)
Copying worksheets
Previewing and Printing a Worksheet	14	(2)
Using Zoom in Print Preview
Getting Help	16	(2)
Using the Office Assistant
Closing a Workbook and Exiting Excel	18	(2)
Concepts Review	20	(1)
Skills Review	21	(2)
Independent Challenges	23	(3)
Visual Workshop	26
EXCEL 2003
Building and Editing Worksheets	1	(1)
Planning and Designing a Worksheet	2	(2)
Editing Cell Entries	4	(2)
Recovering a lost workbook file
Entering Formulas	6	(2)
Creating Complex Formulas	8	(2)
Order of precedence in Excel formulas
Editing formulas
Introducing Excel Functions	10	(2)
Using the MIN and MAX functions
Using Excel Functions	12	(2)
Copying and Moving Cell Entries	14	(2)
Using the Office Clipboard
Understanding Relative and Absolute Cell References	16	(2)
Using a mixed reference
Printing worksheet formulas
Copying Formulas with Relative Cell References	18	(2)
Filling cells with sequential text or values
Copying Formulas with Absolute Cell References	20	(2)
Inserting and deleting selected cells
Concepts Review	22	(1)
Skills Review	23	(1)
Independent Challenges	24	(4)
Visual Workshop	28
EXCEL 2003
Formatting a Worksheet	1	(1)
Formatting Values	2	(2)
Using the Format Painter
Using Fonts and Font Sizes	4	(2)
Inserting and adjusting clip art
Changing Attributes and Alignment	6	(2)
Rotating and indenting cell entries
Using AutoFormat
Adjusting Column Widths	8	(2)
Specifying row height
Inserting and Deleting Rows and Columns	10	(2)
Hiding and unhiding columns and rows
Adding and editing comments
Applying Colors, Patters, and Borders	12	(2)
Formatting columns or rows
Using Conditional Formatting	14	(2)
Deleting conditional formatting
Checking Spelling	16	(2)
Using e-mail to send a workbook
Concepts Review	18	(2)
Skills Review	20	(2)
Independent Challenges	22	(4)
Visual Workshop	26
EXCEL 2003
Working with Charts	1	(23)
Planning and Designing a Chart	2	(2)
Creating a Chart	4	(2)
Moving and Resizing a Chart	6	(2)
Changing the location of a chart
Editing a Chart	8	(2)
Rotating a 3-D chart
Formatting a Chart	10	(2)
Adding data labels to a chart
Enhancing a Chart	12	(2)
Changing text alignment in charts
Annotating and Drawing on a Chart	14	(2)
Adding an organizational chart or other diagram type
Exploding a pie slice
Previewing and Printing a Chart	16	(2)
Using the Page Setup dialog box for a chart
Concepts Review	18	(1)
Skills Review	19	(2)
Independent Challenges	21	(3)
Visual Workshop	24