search for books and compare prices
Tables of Contents for Microsoft Excel 2000
Exciting New Features and Products
iii
Managing Workbooks and Preparing Them for the Web
1
1
Freezing Columns and Rows
2
2
Splitting the Worksheet into multiple panes3
1
Inserting and Deleting Worksheets
4
2
Specifying headers and footers5
1
Consolidating Data with 3-D References
6
2
Consolidating data from different workbooks using linking7
1
Hiding and Protecting Worksheet Areas
8
2
Changing workbook properties9
1
Saving Custom Views of a Worksheet
10
2
Using a workspace11
1
Controlling Page Breaks and Page Numbering
12
2
Using Page Break Preview13
1
Creating a Hyperlink between Excel Files
14
2
Using hyperlinks to navigate large worksheets14
1
Inserting a picture15
1
Saving an Excel file as an HTML Document
16
2
Send a workbook via e-mail17
1
Independent Challenges
20
4
Automating Worksheet Tasks
1
1
Macros and viruses3
1
Using Templates to Create a Workbook5
1
Adding comments to code9
1
Using Shortcut Keys with Macros
10
2
Using the Personal Macro Workbook
12
2
Working with the Personal Macro Workbook13
1
Adding a Macro as a Menu Item
14
2
Creating a Toolbar for Macros
16
2
Independent Challenges
21
3
Lists versus databases3
1
Maintaining the quality of information in a list5
1
Adding Records with the Data Form
6
2
Using wildcards to fine-tune your search9
1
Advantage of deleting records from the worksheet11
1
Sorting a List by One Fields
12
2
Rotating and indenting to improve label appearance13
1
Sorting a List by Multiple Fields
14
2
Specifying a custom sort order15
1
Setting a print area17
1
Independent Challenges
20
4
Retrieving Records with AutoFilter
2
2
Creating a Custom Filter
4
2
And and Or logical conditions5
1
Filtering a List with Advanced Filter
6
2
Understanding the criteria range7
1
Understanding the criteria range and the copy-to location9
1
Creating Subtotals Using Grouping and Outlines
10
2
Show or hide details in an Excel outline11
1
Looking Up Values in a List
12
2
Using the HLOOKUP function13
1
Using Data Validation for List Entries
16
2
Independent Challenges
21
3
Enhancing Charts and Worksheets
1
1
Selecting a Custom Chart Type
2
2
Creating a custom chart type3
1
Customizing a Data Series
4
2
Removing, inserting, and formatting legends5
1
Formatting a Chart Axis
6
2
Adding a Data Table to a Chart
8
2
Enhancing a Chart with WordArt
12
2
Rotating Chart labels15
1
Independent Challenges
21
3
Sharing Excel Files and Incorporating Web Information
1
1
Setting Up a Shared Workbook
4
2
Tracking Changes in a Shared Workbook
6
2
Merging workbooks7
1
Applying and Removing Passwords
8
2
Removing passwords9
1
Creating an Interactive Worksheet for an Intranet or the Web
10
2
Managing HTML files on an intranet or Web site11
1
Creating an Interactive PivotTable for an Intranet or the Web
12
2
Adding fields to a Pivot Table list using the Web browser13
1
Creating Hyperlinks between Excel Files and the Web
14
2
Using hyperlinks to navigate large worksheets15
1
Running Queries to Retrieve Data on the Web
16
2
Finding stock symbols16
1
Creating a new query to retrieve Web page data17
1
Independent Challenges
21
3
Word 2000 MOUS Certification Objectives
1
1
<