Microsoft Excel 2000 Core and Expert Certification

Name: Microsoft Excel 2000 Core and Expert Certification
Price: 5.54 USD
Availability: InStock
ISBN: 9780763802363

ISBN-10: 0763802360

ISBN-13: 9780763802363

Edition: 2000

Authors: Nita H. Rutkosky, Meredith Flynn

List price: $64.20

30 day, 100% satisfaction guarantee!

Marketplace

5 new & used from $5.54

what's this?

Rush Rewards U
Members Receive:

You have reached 400 XP and carrot coins. That is the daily max!

Description:

Teaches the core and expert skills required for Microsoft Office User Specialist certification. Rutkosky (Pierce College) and Meredith Flynn (Bowling Green State U.) present eight chapters that contain performance objectives, introductory material, step-by-step exercises, chapter summaries, commands

Book details

List price: $64.20
Copyright year: 2000
Publisher: EMC/Paradigm Publishing
Binding: Mixed Media
Pages: 328
Size: 9.25" wide x 10.75" long x 1.50" tall
Weight: 3.080
Language: English

Introduction	p. vi
Excel 2000 Core Level	p. 1
Microsoft Excel 2000 Core Level MOUS Skills	p. 2
Preparing and Formatting an Excel Worksheet	p. 3
Creating a Worksheet	p. 4
Saving a Workbook	p. 10
Opening a Workbook	p. 11
Printing a Workbook	p. 11
Completing Computer Exercises	p. 13
Selecting Cells	p. 15
Applying Formatting with Buttons on the Formatting Toolbar	p. 17
Previewing a Worksheet	p. 17
Changing Column Width and Row Height	p. 21
Formatting Data in Cells	p. 27
Formatting Cells	p. 36
Using Help	p. 44
Chapter Summary	p. 50
Commands Review	p. 52
Thinking Offline	p. 52
Working Hands-On	p. 54
Maintaining and Enhancing a Worksheet	p. 57
Inserting/Deleting Rows and Columns	p. 57
Formatting a Worksheet Page	p. 61
Customizing Print Jobs	p. 73
Completing a Spelling Check	p. 75
Finding and Replacing Data in a Worksheet	p. 76
Sorting Data	p. 78
Chapter Summary	p. 82
Commands Review	p. 83
Thinking Offline	p. 84
Working Hands-On	p. 85
Maintaining Workbooks and Creating Web Pages	p. 89
Maintaining Workbooks	p. 89
Managing Worksheets	p. 101
Company Intranets	p. 104
Sending a Workbook by E-mail	p. 104
Creating a Web Page	p. 105
Chapter Summary	p. 108
Commands Review	p. 110
Thinking Offline	p. 110
Working Hands-On	p. 111
Moving Data within and between Workbooks	p. 113
Moving, Copying, and Pasting Cells	p. 113
Creating a Workbook with Multiple Worksheets	p. 116
Working with Windows	p. 122
Formatting with Format Painter	p. 128
Formatting with Styles	p. 129
Using Excel Templates	p. 134
Chapter Summary	p. 143
Commands Review	p. 144
Thinking Offline	p. 145
Working Hands-On	p. 146
Inserting Formulas in a Worksheet	p. 151
Using the AutoSum Button	p. 152
Writing Formulas with Mathematical Operators	p. 153
Inserting a Formula with the Paste Function Button	p. 158
Writing Formulas with Functions	p. 159
Working with Ranges	p. 174
Automatically Outlining a Worksheet	p. 182
Planning a Worksheet	p. 184
Chapter Summary	p. 185
Commands Review	p. 186
Thinking Offline	p. 187
Working Hands-On	p. 188
Creating a Chart in Excel	p. 195
Creating a Chart	p. 195
Deleting a Chart	p. 201
Sizing and Moving a Chart	p. 201
Changing the Chart Type	p. 202
Changing Data in Cells	p. 206
Changing the Data Series	p. 207
Adding Chart Elements	p. 209
Formatting Chart Elements	p. 214
Chapter Summary	p. 218
Commands Review	p. 219
Thinking Offline	p. 219
Working Hands-On	p. 220
Integrated Topic: Inserting Clip Art Images and Creating Maps	p. 223
Adding Clip Art to Worksheets	p. 223
Displaying Data in a Map	p. 232
Drawing Lines and Objects	p. 247
Changing Objects	p. 250
Chapter Summary	p. 251
Commands Review	p. 252
Thinking Offline	p. 252
Working hands-On	p. 253
Excel 2000 Core Level Performance Assessments	p. 257
Assessing Core Proficiencies	p. 257
Writing Activities	p. 262
Internet Activity	p. 264
Excel Core Index	p. 265
Excel 2000 Expert Level	p. Expert E-1
Microsoft Excel 2000 Expert Level MOUS Skills	p. 2
Formatting Excel Worksheets Using Advanced Formatting Techniques	p. 3
Applying Number Formats	p. 4
Creating Custom Formats	p. 5
Formatting Large Labels	p. 8
Automatically Adjusting Column Widths and Row Heights	p. 9
Creating, Applying, and Editing Styles	p. 12
Using the Format Painter Button	p. 13
Applying Borders and Shading	p. 14
Turning Off Zeros	p. 16
Using AutoFormat	p. 20
Using Conditional Formatting	p. 21
Adjusting the Layout of a Worksheet	p. 23
Using the Paste Special Command	p. 27
Hiding and Unhiding Rows, Columns, and Sheets	p. 28
Using the Page Break Preview Command	p. 31
Changing Page Order	p. 32
Renaming Sheets	p. 32
Chapter Summary	p. 36
Commands Review	p. 37
Thinking Offline	p. 38
Working Hands-On	p. 39
Working with Templates and Workbooks	p. 43
Using Excel Templates	p. 44
Creating a New Template	p. 49
Editing a Template	p. 51
Automating Data Collection with a Built-In Template	p. 54
Using Multiple Workbooks	p. 58
Consolidating Data from Several Worksheets into a List	p. 60
Linking Workbooks	p. 62
Sharing Workbooks	p. 67
Chapter Summary	p. 74
Commands Review	p. 75
Thinking Offline	p. 76
Working Hands-On	p. 77
Using Advanced Functions	p. 85
Entering a Function	p. 86
Financial Functions	p. 88
Math and Trig Functions	p. 92
Statistical Functions	p. 95
Lookup and Reference Functions	p. 99
Logical Functions	p. 102
Using Array Formulas	p. 104
Chapter Summary	p. 109
Commands Review	p. 110
Thinking Offline	p. 110
Working Hands-On	p. 111
Working with Lists	p. 117
Creating a List	p. 118
Entering Data Using the Data Form	p. 119
Using Data Validation	p. 121
Sorting a List	p. 127
Modifying Records	p. 131
Outlining a Worksheet	p. 135
Subtotaling a List	p. 139
Filtering a List	p. 143
Filtering a List Using Advanced Filters	p. 147
Chapter Summary	p. 153
Commands Review	p. 154
Thinking Offline	p. 154
Working Hands-On	p. 155
Using Excel's Analysis Tools	p. 161
Introduction to PivotTables	p. 161
Creating PivotChart Reports	p. 181
Creating Interactive PivotTables for the Web	p. 189
Analyzing Data Using Goal Seek	p. 193
Analyzing Data Using Solver	p. 195
Creating Scenarios	p. 199
Chapter Summary	p. 202
Commands Review	p. 203
Thinking Offline	p. 204
Working Hands-On	p. 205
Managing and Auditing Worksheets	p. 209
Introduction to Macros	p. 210
Working with Toolbars	p. 222
Auditing Workbooks	p. 228
Chapter Summary	p. 232
Commands Review	p. 233
Thinking Offline	p. 233
Working Hands-On	p. 234
Collaborating with Workgroups	p. 237
Benefits and Limitations of Sharing Workbooks	p. 238
Changing Workbook Properties	p. 238
Protecting Workbooks	p. 240
Tracking Changes	p. 248
Working with Multiple Worksheets	p. 258
Using the Report Manager	p. 259
Chapter Summary	p. 262
Commands Review	p. 263
Thinking Offline	p. 264
Working Hands-On	p. 265
Integrated Topic: Importing and Exporting Data	p. 269
Importing from and Exporting to Text Files	p. 270
Accessing and Placing Data on the Web	p. 276
Importing Data from a Web Page into Excel	p. 283
Using a Microsoft Query	p. 286
Linking and Embedding Objects	p. 289
Chapter Summary	p. 294
Commands Review	p. 295
Thinking Offline	p. 295
Working Hands-On	p. 296
Excel 2000 Expert Level Performance Assessments	p. 301
Assessing Expert Proficiencies	p. 301
Writing Activities	p. 312
Internet Activity	p. 316
Excel Expert Index	p. 321
Table of Contents provided by Syndetics. All Rights Reserved.