Microsoft Excel 2003

by REDING/WERMERS

• ISBN13: 9780619188047
• ISBN10: 0619188049
• Format: Paperback
• Copyright: 2003-12-15
• 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	vi
Getting Started with Excel 2003	1	(1)
Defining Spreadsheet Software	2	(2)
Starting Excel 2003	4	(2)
Viewing the Excel Window	6	(2)
Opening and Saving a Workbook	8	(2)
Entering Labels and Values	10	(2)
Naming and Moving a Sheet	12	(2)
Previewing and Printing a Worksheet	14	(2)
Getting Help	16	(2)
Closing a Workbook and Exiting Excel	18	(2)
Concepts Review	20	(1)
Concepts Review	20	(1)
Skills Review	21	(2)
Independent Challenges	23	(3)
Visual Workshop	26
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 formules 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
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, Patterns, 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
Working with Charts	1	(1)
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 lables to a chart
Enhancing a Chart	12	(2)
Changing text alignment in charts
Annotating and Drawing on a Chart	14	(2)
Adding an oganizational 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
Working with Formulas and Functions	1	(1)
Creating a Formula with Several Operators	2	(2)
Using Paste Special
Using Names in a Formula	4	(2)
Defining and removing styles Producing a list of names
Generating Multiple Totals with AutoSum	6	(2)
Quick calculations with AutoCalculate
Using Dates in Calculations	8	(2)
Applying and creating custom number and date formats
Building a Conditional Formula with the if Function	10	(2)
Correcting circular references
Using Statistical Functions	12	(2)
Using the Counta function
Calculating Payments with the PMT Function	14	(2)
Calculating future value with the FV function
Displaying and Printing Formula Content	16	(2)
Setting margins and alignment when printing part of a worksheet
Concepts Review	18	(1)
Skills Review	19	(2)
Independent Challenges	21	(3)
Visual Workshop	24
Managing Workbooks and Preparing Them for the Web	1	(1)
Freezing Columns and Rows	2	(2)
Inserting and Deleting Worksheets	4	(2)
Consolidating Data with 3-D References	6	(2)
Hiding and Protecting Worksheet Areas	8	(2)
Saving Custom Views of a Worksheet	10	(2)
Controlling Page Breaks and Page Numbering	12	(2)
Creating a Hyperlink Between Excel Files	14	(2)
Saving an Excel File as a Web Page	16	(2)
Concepts Review	18	(1)
Skills Review	19	(2)
Independent Challenges	21	(3)
Visual Workshop	24
Automating Worksheet Tasks	1	(1)
Planning a Macro	2	(2)
Recording a Macro	4	(2)
Running a Macro	6	(2)
Editing a Macro	8	(2)
Using Shortcut Keys with Macros	10	(2)
Using the Personal Macro Workbook	12	(2)
Adding a Macro as a Menu Item	14	(2)
Creating a Toolbar for Macros	16	(2)
Concepts Review	18	(1)
Skills Review	19	(2)
Independent Challenges	21	(3)
Visual Workshop	24
Using Lists	1	(1)
Planning a List	2	(2)
Creating a List	4	(2)
Adding Records with the Data Form	6	(2)
Finding Records	8	(2)
Deleting Records	10	(2)
Sorting a List on One Field	12	(2)
Sorting a List on Multiple Fields	14	(2)
Printing a List	16	(2)
Concepts Review	18	(1)
Skills Review	19	(1)
Independent Challenges	20	(4)
Visual Workshop	24
Glossary	1	(5)
Index	6