Skip to content

Microsoft Excel 2000 Core and Expert Certification

ISBN-10: 0763802360

ISBN-13: 9780763802363

Edition: 2000

Authors: Nita H. Rutkosky, Meredith Flynn

List price: $64.20
Blue ribbon 30 day, 100% satisfaction guarantee!
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
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
Customers also bought

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

Introductionp. vi
Excel 2000 Core Levelp. 1
Microsoft Excel 2000 Core Level MOUS Skillsp. 2
Preparing and Formatting an Excel Worksheetp. 3
Creating a Worksheetp. 4
Saving a Workbookp. 10
Opening a Workbookp. 11
Printing a Workbookp. 11
Completing Computer Exercisesp. 13
Selecting Cellsp. 15
Applying Formatting with Buttons on the Formatting Toolbarp. 17
Previewing a Worksheetp. 17
Changing Column Width and Row Heightp. 21
Formatting Data in Cellsp. 27
Formatting Cellsp. 36
Using Helpp. 44
Chapter Summaryp. 50
Commands Reviewp. 52
Thinking Offlinep. 52
Working Hands-Onp. 54
Maintaining and Enhancing a Worksheetp. 57
Inserting/Deleting Rows and Columnsp. 57
Formatting a Worksheet Pagep. 61
Customizing Print Jobsp. 73
Completing a Spelling Checkp. 75
Finding and Replacing Data in a Worksheetp. 76
Sorting Datap. 78
Chapter Summaryp. 82
Commands Reviewp. 83
Thinking Offlinep. 84
Working Hands-Onp. 85
Maintaining Workbooks and Creating Web Pagesp. 89
Maintaining Workbooksp. 89
Managing Worksheetsp. 101
Company Intranetsp. 104
Sending a Workbook by E-mailp. 104
Creating a Web Pagep. 105
Chapter Summaryp. 108
Commands Reviewp. 110
Thinking Offlinep. 110
Working Hands-Onp. 111
Moving Data within and between Workbooksp. 113
Moving, Copying, and Pasting Cellsp. 113
Creating a Workbook with Multiple Worksheetsp. 116
Working with Windowsp. 122
Formatting with Format Painterp. 128
Formatting with Stylesp. 129
Using Excel Templatesp. 134
Chapter Summaryp. 143
Commands Reviewp. 144
Thinking Offlinep. 145
Working Hands-Onp. 146
Inserting Formulas in a Worksheetp. 151
Using the AutoSum Buttonp. 152
Writing Formulas with Mathematical Operatorsp. 153
Inserting a Formula with the Paste Function Buttonp. 158
Writing Formulas with Functionsp. 159
Working with Rangesp. 174
Automatically Outlining a Worksheetp. 182
Planning a Worksheetp. 184
Chapter Summaryp. 185
Commands Reviewp. 186
Thinking Offlinep. 187
Working Hands-Onp. 188
Creating a Chart in Excelp. 195
Creating a Chartp. 195
Deleting a Chartp. 201
Sizing and Moving a Chartp. 201
Changing the Chart Typep. 202
Changing Data in Cellsp. 206
Changing the Data Seriesp. 207
Adding Chart Elementsp. 209
Formatting Chart Elementsp. 214
Chapter Summaryp. 218
Commands Reviewp. 219
Thinking Offlinep. 219
Working Hands-Onp. 220
Integrated Topic: Inserting Clip Art Images and Creating Mapsp. 223
Adding Clip Art to Worksheetsp. 223
Displaying Data in a Mapp. 232
Drawing Lines and Objectsp. 247
Changing Objectsp. 250
Chapter Summaryp. 251
Commands Reviewp. 252
Thinking Offlinep. 252
Working hands-Onp. 253
Excel 2000 Core Level Performance Assessmentsp. 257
Assessing Core Proficienciesp. 257
Writing Activitiesp. 262
Internet Activityp. 264
Excel Core Indexp. 265
Excel 2000 Expert Levelp. Expert E-1
Microsoft Excel 2000 Expert Level MOUS Skillsp. 2
Formatting Excel Worksheets Using Advanced Formatting Techniquesp. 3
Applying Number Formatsp. 4
Creating Custom Formatsp. 5
Formatting Large Labelsp. 8
Automatically Adjusting Column Widths and Row Heightsp. 9
Creating, Applying, and Editing Stylesp. 12
Using the Format Painter Buttonp. 13
Applying Borders and Shadingp. 14
Turning Off Zerosp. 16
Using AutoFormatp. 20
Using Conditional Formattingp. 21
Adjusting the Layout of a Worksheetp. 23
Using the Paste Special Commandp. 27
Hiding and Unhiding Rows, Columns, and Sheetsp. 28
Using the Page Break Preview Commandp. 31
Changing Page Orderp. 32
Renaming Sheetsp. 32
Chapter Summaryp. 36
Commands Reviewp. 37
Thinking Offlinep. 38
Working Hands-Onp. 39
Working with Templates and Workbooksp. 43
Using Excel Templatesp. 44
Creating a New Templatep. 49
Editing a Templatep. 51
Automating Data Collection with a Built-In Templatep. 54
Using Multiple Workbooksp. 58
Consolidating Data from Several Worksheets into a Listp. 60
Linking Workbooksp. 62
Sharing Workbooksp. 67
Chapter Summaryp. 74
Commands Reviewp. 75
Thinking Offlinep. 76
Working Hands-Onp. 77
Using Advanced Functionsp. 85
Entering a Functionp. 86
Financial Functionsp. 88
Math and Trig Functionsp. 92
Statistical Functionsp. 95
Lookup and Reference Functionsp. 99
Logical Functionsp. 102
Using Array Formulasp. 104
Chapter Summaryp. 109
Commands Reviewp. 110
Thinking Offlinep. 110
Working Hands-Onp. 111
Working with Listsp. 117
Creating a Listp. 118
Entering Data Using the Data Formp. 119
Using Data Validationp. 121
Sorting a Listp. 127
Modifying Recordsp. 131
Outlining a Worksheetp. 135
Subtotaling a Listp. 139
Filtering a Listp. 143
Filtering a List Using Advanced Filtersp. 147
Chapter Summaryp. 153
Commands Reviewp. 154
Thinking Offlinep. 154
Working Hands-Onp. 155
Using Excel's Analysis Toolsp. 161
Introduction to PivotTablesp. 161
Creating PivotChart Reportsp. 181
Creating Interactive PivotTables for the Webp. 189
Analyzing Data Using Goal Seekp. 193
Analyzing Data Using Solverp. 195
Creating Scenariosp. 199
Chapter Summaryp. 202
Commands Reviewp. 203
Thinking Offlinep. 204
Working Hands-Onp. 205
Managing and Auditing Worksheetsp. 209
Introduction to Macrosp. 210
Working with Toolbarsp. 222
Auditing Workbooksp. 228
Chapter Summaryp. 232
Commands Reviewp. 233
Thinking Offlinep. 233
Working Hands-Onp. 234
Collaborating with Workgroupsp. 237
Benefits and Limitations of Sharing Workbooksp. 238
Changing Workbook Propertiesp. 238
Protecting Workbooksp. 240
Tracking Changesp. 248
Working with Multiple Worksheetsp. 258
Using the Report Managerp. 259
Chapter Summaryp. 262
Commands Reviewp. 263
Thinking Offlinep. 264
Working Hands-Onp. 265
Integrated Topic: Importing and Exporting Datap. 269
Importing from and Exporting to Text Filesp. 270
Accessing and Placing Data on the Webp. 276
Importing Data from a Web Page into Excelp. 283
Using a Microsoft Queryp. 286
Linking and Embedding Objectsp. 289
Chapter Summaryp. 294
Commands Reviewp. 295
Thinking Offlinep. 295
Working Hands-Onp. 296
Excel 2000 Expert Level Performance Assessmentsp. 301
Assessing Expert Proficienciesp. 301
Writing Activitiesp. 312
Internet Activityp. 316
Excel Expert Indexp. 321
Table of Contents provided by Syndetics. All Rights Reserved.