Course Guide: Microsoft Excel 2002-Illustrated INTERMEDIATE

by Wermers,Lynn

• ISBN13: 9780619045067
• ISBN10: 061904506X
• Edition: Disk
• Format: Spiral Bound
• Copyright: 2001-10-22
• Publisher: Cengage Learning

Table of Contents

Illustrated Series Vision	iii
Preface	iv
Managing Workbooks and Preparing Them for the Web	1	(1)
Freezing Columns and Rows	2	(2)
Splitting the worksheet into multiple panes	3	(1)
Inserting and Deleting Worksheets	4	(2)
Previewing and printing multiple worksheets	4	(1)
Specifying headers and footers	5	(1)
Consolidating Data with 3-D References	6	(2)
Linking data between workbooks	7	(1)
Hiding and Protecting Worksheet Areas	8	(2)
Changing workbook properties	9	(1)
Saving Custom Views of a Worksheet	10	(2)
Creating a workspace	11	(1)
Controlling Page Breaks and Page Numbering	12	(2)
Using Page Break Preview	13	(1)
Creating a Hyperlink Between Excel Files	14	(2)
Using hyperlinks to navigate large worksheets	14	(1)
Finding and replacing data and formats	15	(1)
Saving an Excel File as a Web Page	16	(2)
Holding Web discussions	17	(1)
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)
Macros and viruses	3	(1)
Recording a Macro	4	(2)
Running a Macro	6	(2)
Editing a Macro	8	(2)
Adding comments to Visual Basic code	9	(1)
Using Shortcut Keys with Macros	10	(2)
Using the Personal Macro Workbook	12	(2)
Working with the Personal Macro Workbook	13	(1)
Adding a Macro as a Menu Item	14	(2)
Adding a custom menu	14	(2)
Creating a Toolbar for Macros	16	(2)
Concepts Review	18	(2)
Skills Review	20	(1)
Independent Challenges	21	(3)
Visual Workshop	24
Using Lists	1	(1)
Planning a List	2	(2)
Using lists versus databases	3	(1)
Creating a List	4	(2)
Filtering lists using AutoFilter	5	(1)
Adding Records with the Data-Form	6	(2)
Finding Records	8	(2)
Using wildcards to fine-tune your search	8	(2)
Deleting Records	10	(2)
Deleting records using the worksheet	11	(1)
Sorting a List on One Field	12	(2)
Sorting a List on Multiple Fields	14	(2)
Specifying a custom sort order	15	(1)
Printing a List	16	(2)
Setting a print area	17	(1)
Concepts Review	18	(1)
Skills Review	19	(1)
Independent Challenges	20	(4)
Visual Workshop	24
Analyzing List Data	1	(1)
Retrieving Records with AutoFilter	2	(2)
Creating a Custom Filter	4	(2)
``And'' and ``Or'' logical conditions	5	(1)
Filtering a List with Advanced Filter	6	(2)
Extracting List Data	8	(2)
Understanding the criteria range and the copy-to location	9	(1)
Creating Subtotals Using Grouping and Outlines	10	(2)
Using Show Details and Hide Details buttons in an outline	11	(1)
Look up Values in a List	12	(2)
Using the Hlookup and Match functions	13	(1)
Summarizing List Data	14	(2)
Using Data Validation for List Entries	16	(2)
Concepts Review	18	(1)
Skills Review	19	(2)
Independent Challenges	21	(3)
Visual Workshop	24
Enhancing Charts and Worksheets	1	(1)
Selecting a Custom Chart Type	2	(2)
Creating your own custom chart type	3	(1)
Customizing a Data Series	4	(2)
Removing, inserting, and formatting legends	4	(2)
Formatting a Chart Axis	6	(2)
Adding a Data Table to a Chart	8	(2)
Creating a trendline	8	(2)
Rotating a Chart	10	(2)
Enhancing a Chart with WordArt	12	(2)
Rotating Text	14	(2)
Using Speech Recognition	14	(1)
Rotating chart labels	15	(1)
Adding a Picture to a Chart	16	(2)
Concepts Review	18	(1)
Skills Review	19	(2)
Independent Challenges	21	(3)
Visual Workshop	24
Sharing Excel Files and Incorporating Web Information	1	(1)
Sharing Excel Files	2	(2)
Setting up a Shared Workbook for Multiple Users	4	(2)
Tracking Revisions in a Shared Workbook	6	(2)
Applying and Modifying Passwords	8	(2)
Removing passwords	8	(2)
Creating an Interactive Worksheet for the Web	10	(2)
Exporting XML structured data from Excel	11	(1)
Creating a PivotTable List for the Web	12	(2)
Adding fields to a PivotTable list using the Web browser	13	(1)
Adding Web Hyperlinks to an Excel File	14	(2)
Creating Web queries	15	(1)
Running Web Queries to Retrieve External Data	16	(2)
Exporting XML structured data from Excel	17	(1)
Concepts Review	18	(1)
Skills Review	19	(1)
Independent Challenges	20	(4)
Visual Workshop	24
Project Files	1	(4)
MOUS Certification Objectives	5	(5)
Glossary	10	(4)
Index	14