Microsoft Excel 2000: Intermediate Course Guide

Unit 1: Managing Workbooks and Preparing Them for the Web Freezing Columns and Rows Inserting and Deleting Sheets Referencing Worksheet Data Hiding and Protecting Worksheet Areas Controlling Page Breaks and Page Numbering Creating a Hyperlink Between Excel files Saving an Excel File as an HTML document Viewing Excel data in HTML format Unit 2: Automating Worksheet Tasks Planning a Macro Recording a Macro Running a Macro Editing a Macro Using Shortcut Keys with Macros Using the Personal Macro Workbook Adding a Macro as a Menu Item Creating a Toolbar for Macros Unit 3: Using Lists Planning a List Creating a List Adding Records with the Data Form Finding Records Deleting Records Sorting a List by One Field Sorting a List by Multiple Fields Printing a List Unit 4: Analyzing List Data Retrieving Records with AutoFilter Creating a Custom Filter Filtering a List with Advanced Filter Extracting List Data Creating Automatic Subtotals Looking Up Values in a List Summarizing List Data Using Data Validation for List Entries Unit 5: Enhancing Charts and Worksheets Selecting a Custom Chart Type Customizing a Data Series Formatting a Chart Axis Adding a Data Table to a Chart Rotating a Chart Enhancing a Chart with WordArt Rotating Text Mapping Data Unit 6: Sharing Files over Intranets and the Internet Sharing Excel Files with Others Tracking Changes Applying and Removing Passwords Browsing Excel Files Using Hyperlinks and the Web Toolbar Creating Hyperlinks between Excel Files and the Web Creating Interactive PivotTables for the Web Creating a Web Form Run Queries to Retrieve Data on the Web