# Microsoft Office Excel 2003

• ISBN13:

• ISBN10:

## 0619188030

• Format: Paperback
• Publisher: Course Technology
• Purchase Benefits
• Free Shipping On Orders Over \$59!
Your order must be \$59 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
• Get Rewarded for Ordering Your Textbooks! Enroll Now
List Price: \$28.95

### Summary

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

Preface iv
 EXCEL 2003
 Getting Started with Excel 2003
1(1)
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)
 Changing Attributes and Alignment
6(2)
 Rotating and indenting cell entries
 Using AutoFormat
8(2)
 Specifying row height
 Inserting and Deleting Rows and Columns
10(2)
 Hiding and unhiding columns and rows
 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