search for books and compare prices
Tables of Contents for Microsoft Excel 2000
Chapter/Section Title
Page #
Page Count
Exciting New Features and Products
iii
Preface
iv
Excel 2000
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
Specifying headers and footers
5
1
Consolidating Data with 3-D References
6
2
Consolidating data from different workbooks using linking
7
1
Hiding and Protecting Worksheet Areas
8
2
Changing workbook properties
9
1
Saving Custom Views of a Worksheet
10
2
Using 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
Inserting a picture
15
1
Saving an Excel file as an HTML Document
16
2
Send a workbook via e-mail
17
1
Concepts Review
18
1
Skills Review
19
1
Independent Challenges
20
4
Visual Workshop
24
Automating Worksheet Tasks
1
1
Planning a Macro
2
2
Macros and viruses
3
1
Recording a Macro
4
2
Using Templates to Create a Workbook
5
1
Running a Macro
6
2
Editing a Macro
8
2
Adding comments to 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
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
Lists versus databases
3
1
Creating a List
4
2
Maintaining the quality of information in a list
5
1
Adding Records with the Data Form
6
2
Finding Records
8
2
Using wildcards to fine-tune your search
9
1
Deleting Records
10
2
Advantage of deleting records from the worksheet
11
1
Sorting a List by One Fields
12
2
Rotating and indenting to improve label appearance
13
1
Sorting a List by 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
Understanding the criteria range
7
1
Extracting List Data
8
2
Understanding the criteria range and the copy-to location
9
1
Creating Subtotals Using Grouping and Outlines
10
2
Show or hide details in an Excel outline
11
1
Looking Up Values in a List
12
2
Using the HLOOKUP function
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 a custom chart type
3
1
Customizing a Data Series
4
2
Removing, inserting, and formatting legends
5
1
Formatting a Chart Axis
6
2
Adding a Data Table to a Chart
8
2
Rotating a Chart
10
2
Enhancing a Chart with WordArt
12
2
Rotating Text
14
2
Rotating Chart labels
15
1
Mapping Data
16
2
Concepts Review
18
2
Skills Review
20
1
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
4
2
Tracking Changes in a Shared Workbook
6
2
Merging workbooks
7
1
Applying and Removing Passwords
8
2
Removing passwords
9
1
Creating an Interactive Worksheet for an Intranet or the Web
10
2
Managing HTML files on an intranet or Web site
11
1
Creating an Interactive PivotTable for an Intranet or the Web
12
2
Adding fields to a Pivot Table list using the Web browser
13
1
Creating Hyperlinks between Excel Files and the Web
14
2
Using hyperlinks to navigate large worksheets
15
1
Running Queries to Retrieve Data on the Web
16
2
Finding stock symbols
16
1
Creating a new query to retrieve Web page data
17
1
Concepts Review
18
1
Skills Review
19
2
Independent Challenges
21
3
Visual Workshop
24
Word 2000 MOUS Certification Objectives
1
1
Glossary
1
2
Index
3
<