search for books and compare prices
Tables of Contents for Microsoft Office 2000
Chapter/Section Title
Page #
Page Count
Preface
iv
How to Use This Book
vi
What's New
viii
Start-Up Checklist
ix
Guide for Using This Book
x
The Microsoft Office User Specialist Program
xii
Unit Introduction
Office 2000 and the Internet
2
1
Advanced Word Features
2
3
Advanced Excel Features
5
1
Advanced Access Features
6
1
Advanced PowerPoint Features
7
1
Advanced Outlook Features
8
1
Accessing Internet Resources
9
4
Summary
13
Unit Advanced Microsoft Word
Sorting and Calculating
2
15
Sorting Text
2
6
Sorting Tables
8
1
Performing Math Calculations
9
3
Summary
12
5
Customizing Tables and Creating Charts
17
23
Customizing Tables
17
10
Integrating Word and Excel
27
3
Creating a Chart
30
4
Summary
34
6
Merging Form Documents, Mailing Labels, and Envelopes
40
25
Creating Mail Merge Documents
40
10
Sorting and Filtering Data Sources
50
3
Preparing Mailing Labels and Envelopes
53
6
Creating Catalogs and Lists
59
1
Summary
60
5
Formatting Columns and Sections
65
14
Formatting Columns
65
3
Formatting Sections
68
3
Controlling Column Breaks
71
1
Find and Replace Formats, Special Characters, and Nonprinting Elements
72
2
Summary
74
5
Formatting Graphics and Text Boxes
79
20
Formatting Graphics
79
7
Formatting Text Boxes
86
7
Using AutoShapes to Create Objects
93
1
Round-Trip Documents from HTML
94
2
Summary
96
3
Working with Long Documents
99
24
Working with Multiple Documents
99
4
Using Text Flow Options
103
2
Working with Styles
105
6
Navigating Through a Document
111
3
Creating and Revising Footnotes and Endnotes
114
4
Summary
118
5
Editing in Workgroups
123
30
Sharing Documents
123
18
Working with Master Documents
141
5
Summary
146
7
Creating Forms
153
20
Creating a Printed Form
153
4
Creating an Online Form Using Form Controls
157
11
Summary
168
5
Customizing Features
173
25
Working with Templates
173
4
Customizing Toolbars
177
2
Working with Macros
179
10
Customizing the AutoCorrect Feature
189
3
Creating a Custom Dictionary
192
2
Summary
194
4
Creating Indexes and Tables of Contents
198
1
Creating and Modifying an Index
198
7
Creating and Modifying a Table of Contents
205
6
Summary
211
3
Unit Review
214
Unit Advanced Microsoft Excel
Applying Advanced Formats to Worksheets and Charts
2
17
Introduction
2
1
Exploring Number Formats
2
3
Creating a Custom Format
5
1
Using AutoFormat and Conditional Formatting
6
2
Using Styles and Data Validation
8
2
Enhancing the Appearance of Charts
10
4
Summary
14
5
Printing Workbooks
19
10
Print Preview
19
2
Choosing Sheet Preferences
21
1
Creating Page Breaks
22
1
Applying Printing Features
23
1
Printing Formulas or Zeros
24
1
Summary
25
4
Using Data Lists
29
12
Introduction
29
5
Sorting a List
34
1
Searching for Records Meeting a Specific Criteria
35
1
Summary
36
5
Filtering and Extracting Data
41
13
Introduction
41
1
Displaying Records Using AutoFilter
41
2
Searching for Records Using Top 10
43
1
Searching a List Using Search Operators
44
3
Displaying Records Using Advanced Filters
47
3
Summary
50
4
Working with Analysis Tools and PivotTables
54
19
Introduction
54
1
Creating Scenarios
54
2
Using Excel's Auditing Feature
56
3
Creating a PivotTable Report
59
4
Creating a PivotChart
63
4
Using Goal Seek
67
1
Using Solver
68
1
Summary
69
4
Creating Macros
73
11
Introduction
73
1
Understanding Macros
73
1
Creating, Recording, and Running a Macro
74
2
Editing a Macro
76
1
Customize a Toolbar by Adding Macro Buttons
77
1
Removing a Button from a Toolbar
78
1
Assign a Macro to a Command Button
78
2
Summary
80
4
Importing, Exporting, and Integrating Data
84
11
Introduction
84
1
Importing Data
84
6
Exporting Excel Data
90
1
Using Round-Tripping
91
1
Summary
92
3
Using Templates
95
12
Introduction
95
1
Creating and Saving a Template
95
1
Opening and Using a Template
96
2
Using Excel's Built-in Templates
98
4
Summary
102
5
Working with Multiple Worksheets and Workbooks
107
12
Introduction
107
1
Moving Between Worksheets
107
1
Adding and Deleting a Worksheet
108
1
Copying Data Between Worksheets
109
3
Moving Between Workbooks
112
1
Saving a Workspace
112
1
Summarizing Worksheets and Workbooks
113
2
Summary
115
4
Creating Shared Workbooks, Data Maps, and Web Pages
119
12
Introduction
119
1
Creating a Shared Workbook
119
4
Adding Protection Options
123
2
Creating a Web Page
125
1
Summary
126
5
Using Outlines, Subtotals, and Lookup Functions
131
11
Introduction
131
1
Creating Outlines
131
3
Creating Subtotals
134
2
Naming Ranges
136
1
Using Lookup Functions
137
1
Summary
138
4
Working with Graphics and Embedded Elements
142
1
Introduction
142
1
Displaying the Drawing Toolbar
142
3
Drawing AutoShapes and Text Boxes
145
2
Graphic Objects
147
1
Embedded Objects
148
2
Summary
150
3
Unit Review
153
Unit Advanced Microsoft Access
Modifying Table Design
2
14
Introduction
2
1
Choosing an Input Mask
2
6
Setting Validation Rules
8
1
Setting Required Properties
9
1
Creating Lookup Fields
10
2
Summary
12
4
Relationships in Tables and Queries
16
14
Introduction
16
1
Understanding Table Relationships
16
2
Defining Relationships Between Tables
18
5
Setting and Removing Joins in a Query
23
4
Summary
27
3
Advanced Form Features
30
12
Creating a Subform
30
5
Adding a Record in the Subform
35
1
Modifying a Subform
36
1
Creating and Modifying a Form in Design View
37
1
Summary
38
4
Analyzing Data
42
13
Introduction
42
1
Using Queries to Calculate Data
42
4
Building Summary Queries
46
2
Using Concatenation
48
1
Creating an AND Query
49
1
Creating an OR Query
50
1
Applying Filters to a Query
51
1
Summary
52
3
Advanced Queries
55
14
Modifying a Query's Design
55
2
Creating a Parameter Query
57
2
Understanding Action Queries
59
6
Summary
65
4
Advanced Report Features
69
16
Understanding Bound, Unbound, and Calculated Controls
69
3
Creating a Title Page
72
1
Customizing Report Footers
73
1
Adding a Chart to a Report
74
5
Creating and Modifying a Report in Design View
79
2
Summary
81
4
Importing and Exporting Data
85
11
Importing Data
85
6
Exporting Data to Other Programs
91
1
Using Drag-and-Drop to Integrate Data
92
1
Summary
93
3
Creating Macros and Switchboards
96
19
Creating a Basic Macro
96
5
Creating a Switchboard
101
3
Creating Conditional Macros
104
5
Using the Macro Builder
109
1
Summary
110
5
Working with Web Features
115
15
Creating a Hyperlink
115
3
Understanding Data Access Pages
118
7
Summary
125
5
Using Advanced Access Tools
130
1
Compacting a Database
130
1
Encrypting and Decrypting a Database
131
1
Securing a Database
131
2
Setting Startup Options
133
1
Using Add-Ins
134
3
Summary
137
3
Unit Review
140
Unit Advanced Microsoft PowerPoint
Using Advanced Text Features
2
18
Finding and Replacing Text
2
2
Adjusting Text Using Tabs and Indents
4
2
Inserting Symbols
6
1
Numbering Paragraphs
7
1
Replacing Fonts in a Presentation
8
1
Adding Text Boxes
9
1
Creating and Modifying a Macro
10
2
Inserting Hyperlinks on Slides
12
2
Creating a Summary Slide
14
1
Summary
15
5
Creating Tables and Charts
20
25
Working with Text Tables
20
7
Integration: Inserting Worksheet Data on a Slide
27
3
Working with Data Charts
30
6
Working with Organization Charts
36
5
Summary
41
4
Working with Visual and Sound Objects
45
14
Working with Clip Art
45
4
Using Drawing Tools
49
3
Inserting Pictures and Scanned Images
52
2
Inserting Sound Objects
54
1
Inserting Movie Clips
55
1
Summary
56
3
Customizing Options
59
22
Customizing the Color Scheme
59
3
Customizing the Slide Background
62
3
Customizing Masters
65
2
Creating Custom Shows
67
1
Customizing Toolbars
68
2
Creating Custom Animation
70
2
Creating a Design Template
72
1
Customizing Web Pages
73
4
Summary
77
4
Importing and Exporting Information
81
17
Creating Slides from an Outline
81
1
Importing Slides from Another Presentation
82
2
Integration: Sharing Data Among Office 2000 Applications
84
7
Sending PowerPoint Presentations to Others
91
1
Changing Output Options
92
2
Summary
94
4
Using Advanced Presentation Features
98
1
Before the Presentation
99
6
During the Presentation
105
3
Other Ways to Present Slides
108
5
Summary
113
4
Unit Review
117
Unit Advanced Microsoft Outlook
Customizing and Sharing Outlook Information
2
20
Introduction
2
2
Using Organizing Options
4
3
Creating a Form
7
3
Finding Items in a Folder
10
1
Other Productivity Features
11
2
Integration: Sharing Information in Outlook
13
4
Outlook and the Web
17
1
Summary
18
4
Advanced Outlook Features
22
1
Advanced Calendar Features
22
5
Advanced Tasks Features
27
3
Advanced Contacts Features
30
5
Customizing E-Mail Messages
35
3
Other E-Mail Options
38
1
Summary
38
4
Unit Review
42
Capstone Simulation
1
1
Appendix A
1
1
Glossary
1
1
Index
1