Skip to content

Microsoft Excel 2002 : Expert Certification

Spend $50 to get a free DVD!

ISBN-10: 0763814474

ISBN-13: 9780763814472

Edition: 2002

Authors: Meredith Flynn

Blue ribbon 30 day, 100% satisfaction guarantee!
Out of stock
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!


Teaches the Microsoft OfficeUser Specialist (MOUS) skills required for certification on the Core and/or Expert level of one or more major applications within the Office XP suite-benchmark skills by which prospective instructors are evaluated in the certification exams. CD-ROM includes pre-keyed documents and files required for completing the exercises. c. Book News Inc.
Customers also bought

Book details

Copyright year: 2002
Publisher: EMC/Paradigm Publishing
Binding: Hardcover
Size: 8.25" wide x 10.75" long x 0.50" tall
Weight: 1.386
Language: English

Welcomep. vi
MOUS Certificationp. viii
Advanced Formatting and Functionsp. E1
Unit 1 MOUS Skillsp. E2
Formatting Excel Worksheets Using Advanced Formatting Techniquesp. E3
Applying Number Formatsp. E4
Creating Custom Formatsp. E5
Formatting Large Labelsp. E8
Automatically Adjusting Column Widths and Row Heightsp. E9
Creating, Applying, and Editing Stylesp. E12
Using the Format Painter Buttonp. E13
Applying Borders and Shadingp. E13
Turning Off Zerosp. E15
Using AutoFormatp. E19
Using Conditional Formattingp. E20
Adjusting the Layout of a Worksheetp. E22
Using the Paste Special Commandp. E25
Hiding and Unhiding Rows, Columns, and Sheetsp. E27
Using the Page Break Preview Commandp. E30
Changing Page Orderp. E31
Renaming Sheets and Selecting a Tab Colorp. E32
Chapter Summaryp. E36
Commands Reviewp. E37
Concepts Checkp. E37
Skills Checkp. E38
Working with Templates and Workbooksp. E43
Using Excel Templatesp. E43
Creating a New Templatep. E46
Editing a Templatep. E47
Using Multiple Workbooksp. E50
Arranging Multiple Workbooks in the Desktopp. E50
Using a Workspacep. E50
Merging Multiple Workbooks into a Single Workbookp. E51
Consolidating Data from Several Worksheets into a Listp. E52
Linking Workbooksp. E54
Sharing Workbooksp. E58
Chapter Summaryp. E64
Commands Reviewp. E65
Concepts Checkp. E65
Skills Checkp. E66
Using Advanced Functionsp. E73
Entering a Functionp. E74
Financial Functionsp. E75
The PMT Functionp. E77
The PV Functionp. E78
Math and Trig Functionsp. E79
The Round Functionp. E80
The Rand Functionp. E80
The Sumif Functionp. E80
Statistical Functionsp. E82
The Countif Functionp. E82
Naming a Rangep. E84
Using a Named Range in a Formulap. E85
Lookup and Reference Functionsp. E86
The Vlookup Functionp. E86
Logical Functionsp. E88
Using the IF Functionp. E88
Using Array Formulasp. E90
Chapter Summaryp. E93
Commands Reviewp. E94
Concepts Checkp. E9
Skills Checkp. E96
Working with Listsp. E101
Creating a Listp. E102
Entering Data Using the Data Formp. E102
Using Data Validationp. E105
Validating List Datap. E107
Including Input and Error Messagesp. E107
Sorting a Listp. E111
Performing a Multi-Level Sortp. E111
Creating a Custom Listp. E112
Modifying Recordsp. E115
Finding Recordsp. E115
Editing Recordsp. E117
Deleting Recordsp. E117
Outlining a Worksheetp. E119
Subtotaling a Listp. E123
Filtering a Listp. E126
Filtering a List Using AutoFilterp. E126
Creating a Custom AutoFilterp. E127
Filtering a List Using Advanced Filtersp. E130
Extracting Unique Recordsp. E130
Using a Criteria Rangep. E131
Chapter Summaryp. E135
Commands Reviewp. E136
Concepts Checkp. E136
Skills Checkp. E137
Expert Unit 1 Performance Assessmentp. 143
Assessing Proficiencyp. 143
Writing Activitiesp. 149
Internet Projectp. 151
Job Studyp. 151
Interpreting and Integrating Datap. 153
Unit 2 MOUS Skillsp. 154
Using Excel's Analysis Toolsp. 155
Introduction to PivotTablesp. 155
Creating a PivotTablep. 157
Formatting and Sorting a PivotTablep. 161
Managing a PivotTable Reportp. 166
Creating PivotChart Reportsp. 170
Creating Interactive PivotTables for the Webp. 176
Analyzing Data Using Goal Seekp. 179
Analyzing Data Using Solverp. 180
Creating Scenariosp. 185
Creating a Trendline on a Chartp. 187
Chapter Summaryp. 191
Commands Reviewp. 192
Concepts Checkp. 193
Skills Checkp. 193
Managing and Auditing Worksheetsp. 199
Introduction to Macrosp. 200
Recording a Macrop. 200
Running a Macrop. 202
Assigning a Macro to a Command Buttonp. 204
Editing a Macrop. 205
Working with Toolbars and Menusp. 210
Floating and Docked Toolbarsp. 210
Hiding and Displaying Toolbarsp. 211
Customizing Toolbars and Menusp. 211
Auditing Workbooksp. 217
Displaying the Auditing Toolbarp. 217
Tracing Dependents and Precedentsp. 219
Tracing Errorsp. 219
Chapter Summaryp. 220
Commands Reviewp. 221
Concepts Checkp. 222
Skills Checkp. 222
Collaborating with Workgroupsp. 225
Benefits and Limitations of Sharing Workbooksp. 225
Protecting Workbooksp. 226
Applying and Removing Passwordsp. 226
Applying and Removing Cell, Worksheet, and Workbook Protectionp. 228
Tracking Changesp. 234
Accepting and Rejecting Tracked Changesp. 235
Creating, Editing, and Removing a Commentp. 239
Merging Workbooksp. 240
Working with Multiple Worksheetsp. 242
Chapter Summaryp. 244
Commands Reviewp. 245
Concepts Checkp. 245
Skills Checkp. 246
Using Data from the Internet and Other Sourcesp. 251
Importing from and Exporting to Text Filesp. 252
Importing Data from Text Filesp. 252
Importing Data from Word Using Drag and Dropp. 254
Exporting Data to Text Filesp. 256
Accessing and Placing Data on the Webp. 257
Publishing Excel Worksheets as HTMLp. 258
Importing Data from a Web Page into Excelp. 261
Using Database and Web Queriesp. 262
Using XML to Share Excel Data of the Webp. 267
Linking and Embedding Objectsp. 267
Chapter Summaryp. 271
Commands Reviewp. 272
Concepts Checkp. 272
Skills Checkp. 273
Expert Unit 2 Performance Assessmentp. 277
Assessing Proficiencyp. 277
Writing Activitiesp. 281
Internet Projectp. 283
Job Studyp. 284
Indexp. 285
Table of Contents provided by Syndetics. All Rights Reserved.