CourseGuide: Microsoft Office Excel 2003-Illustrated INTERMEDIATE

by Reding,Elizabeth Eisner

• ISBN13: 9780619057732
• ISBN10: 0619057734
• Edition: 1st
• Format: Spiral Bound
• Copyright: 2004-05-04
• Publisher: Course Technology

Summary

Help users master computer skills quickly and easily with this colorful, highly-visual Illustrated Course Guide for Excel 2003. Lessons are presented in an easy-to-follow 2-page spread that introduces step-by-step instructions on the left page and large screenshots and illustrations on the right. This signature, streamlined approach allows continuing education students learn quickly, while also serving as an excellent reference tool.

Table of Contents

Preface	iv
EXCEL 2003
Managing Workbooks and Preparing Them for the Web	1	(1)
Freezing Columns and Rows
Viewing and arranging worksheets
Splitting the worksheet into multiple panes	2	(2)
Inserting and Deleting Worksheets
Grouping worksheets
Specifying headers and footers	4	(2)
Consolidating Data with 3-D References
Linking data between workbooks	6	(2)
Hiding and Protecting Worksheet Areas
Changing workbook properties	8	(2)
Saving Custom Views of a Worksheet
Creating a workspace	10	(2)
Controlling Page Breaks and Page Numbering
Using Page Break Preview	12	(2)
Creating a Hyperlink Between Excel Files
Finding and replacing data and formats
Using research services	14	(2)
Saving an Excel File as a Web Page
Converting Excel files to other file types
Holding Web discussions	16	(2)
Concepts Review	18	(1)
Skills Review	19	(2)
Independent Challenges	21	(3)
Visual Workshop	24
EXCEL 2003
Automating Worksheet Tasks	1	(1)
Planning a Macro
Macros and viruses	2	(2)
Recording a Macro	4	(2)
Running a Macro
Setting macro security levels
Adding a digital signature to a macro	6	(2)
Editing a Macro
Adding comments to Visual Basic code	8	(2)
Using Shortcut Keys with Macros
Running a macro from a hotspot on your worksheet	10	(2)
Using the Personal Macro Workbook
Working with the Personal Macro Workbook	12	(2)
Adding a Macro as a Menu Item
Adding a custom menu	14	(2)
Creating a Toolbar for Macros
Organizing macros	16	(2)
Concepts Review	18	(1)
Skills Review	19	(2)
Independent Challenges	21	(3)
Visual Workshop	24
EXCEL 2003
Using Lists	1	(1)
Planning a List	2	(2)
Creating a List
Filtering lists using AutoFilter	4	(2)
Adding Records with the Data Form	6	(2)
Finding Records
Using wildcards to fine-tune your search	8	(2)
Deleting Records
Deleting records using the worksheet	10	(2)
Sorting a List on One Field
Sorting records using the AutoFilter	12	(2)
Sorting a List on Multiple Fields
Specifying a custom sort order	14	(2)
Printing a List
Setting a print area	16	(2)
Concepts Review	18	(1)
Skills Review	19	(1)
Independent Challenges	20	(4)
Visual Workshop	24
EXCEL 2003
Analyzing List Data	1	(1)
Retrieving Records with AutoFilter	2	(2)
Creating a Custom Filter
And and Or logical conditions	4	(2)
Filtering a List with Advanced Filter	6	(2)
Extracting List Data
Understanding the criteria range and the copy-to location	8	(2)
Creating Subtotals Using Grouping and Outlines
Converting a list to a range
Using the Show Details and Hide Details buttons in an outline	10	(2)
Looking up Values in a List
Using the Hlookup and Match functions	12	(2)
Summarizing List Data	14	(2)
Using Data Validation for List Entries
Adding input messages and error alerts	16	(2)
Concepts Review	18	(1)
Skills Review	19	(1)
Independent Challenges	20	(4)
Visual Workshop	24
EXCEL 2003
Enhancing Charts and Worksheets	1	(1)
Selecting a Custom Chart Type
Creating your own custom chart type	2	(2)
Customizing a Data Series
Removing, inserting, and formatting legends	4	(2)
Formatting a Chart Axis	6	(2)
Adding a Data Table to a Chart
Creating a trendline	8	(2)
Rotating a Chart	10	(2)
Enhancing a Chart with WordArt	12	(2)
Rotating Text
Using the Speech Recognition feature
Rotating chart labels	14	(2)
Adding a Picture to a Chart	16	(2)
Concepts Review	18	(1)
Skills Review	19	(2)
Independent Challenges	21	(3)
Visual Workshop	24
EXCEL 2003
Sharing Excel Files and Incorporating Web Information	1	(1)
Sharing Excel Files	2	(2)
Setting up a Shared Workbook for Multiple Users
Merging workbooks
Comparing workbooks side by side	4	(2)
Tracking Revisions in a Shared Workbook	6	(2)
Applying and Modifying Passwords
Removing passwords	8	(2)
Creating an Interactive Worksheet for the Web
Adding Web hyperlinks to a worksheet	10	(2)
Creating a PivotTable List for the Web
Exporting a PivotTable list from a Web page to an Excel workbook	12	(2)
Working with XML Data
What is XML?	14	(2)
Running Web Queries to Retrieve External Data
Creating your own Web queries	16	(2)
Concepts Review	18	(1)
Skills Review	19	(1)
Independent Challenges	20	(4)
Visual Workshop	24
Glossary	1	(5)
Index	6