Cover image for Excel 2000 MOUS study guide
Title:
Excel 2000 MOUS study guide
Author:
Courter, Gini.
Personal Author:
Publication Information:
San Francisco, Calif. ; London : SYBEX, [1999]
Physical Description:
xxii, 323 pages : illustrations ; 21 cm
Language:
English
Added Author:
ISBN:
9780782125139
Format :
Book

Available:*

Library
Call Number
Material Type
Home Location
Status
Central Library HF5548.4.M523 C68 1999 Adult Non-Fiction Central Closed Stacks
Searching...

On Order

Summary

Summary

Extracting content from text continues to be an important research problem for information processing and management. Approaches to capture the semantics of text-based document collections may be based on Bayesian models, probability theory, vector space models, statistical models, or even graph theory.


Author Notes

Gini Courter and Annette Marquis are co-owners of TRIAD Consulting, LLC, a firm specializing in computer applications training and database development, including customized solutions using Microsoft Outlook and Microsoft Exchange Server. Courter and Marquis are the authors of numerous books, including Microsoft Office 97 Certification Study Guide, Mastering Microsoft Office 2000, Mastering Microsoft Outlook 2000, and Word 2000 MOUS Study Guide, all from Sybex.


Table of Contents

Introductionp. xix
Chapter 1 Working in Office 2000p. 1
Office Pro 2000p. 2
Exploring Common Features in Officep. 3
Launching the Shortcut Bar and New Excel Filesp. 3
The Office Assistantp. 5
Using the Excel 2000 Interfacep. 7
Workbooks and Worksheetsp. 11
Entering Text and Numbersp. 13
Working with Filesp. 14
Saving a Filep. 14
Opening an Existing Filep. 16
Hands Onp. 17
Sending Files Using E-Mailp. 18
A Quick Look at Spellingp. 19
Finding and Replacing Textp. 20
Selecting, Moving, and Copyingp. 21
Selecting Cellsp. 21
Moving and Copying Textp. 22
Pasting Multiple Itemsp. 23
Hands Onp. 23
Adding Pizzazzp. 24
Fonts and Font Stylesp. 24
Copying Existing Formatsp. 25
Hands Onp. 26
Chapter 2 Editing Excel Worksheetsp. 27
Entering and Editing Cell Entriesp. 28
Correcting Mistakesp. 28
Revising Text and Numbersp. 29
Working with Numbers and Formulasp. 29
Creating Formulasp. 30
Formatting Numbersp. 36
Hands Onp. 41
Changing Worksheet Layoutp. 42
Adjusting Column Width and Row Heightp. 42
Inserting and Deleting Rows and Columnsp. 43
Inserting and Deleting Cellsp. 45
Moving and Copying Cell Contentsp. 46
Naming a Worksheetp. 48
Selecting Worksheetsp. 49
Copying and Moving Worksheetsp. 49
Inserting and Deleting Worksheetsp. 50
Hiding and Unhiding Rows and Columnsp. 51
Freezing and Unfreezing Rows and Columnsp. 51
Hands Onp. 52
Other Formatting Optionsp. 53
Aligning Textp. 53
Borders and Colorp. 57
Hands Onp. 59
Printing in Excelp. 59
Print Previewp. 59
Printing a Documentp. 61
Hands Onp. 63
Changing Page Setupp. 63
Hands Onp. 72
Chapter 3 Beyond Excel Basicsp. 75
Working with Relative and Absolute Cell Referencesp. 76
Working with Rangesp. 78
Naming Rangesp. 78
Using Namesp. 80
Hands Onp. 81
Understanding Functionsp. 81
Entering Functionsp. 83
Hands Onp. 86
Financial Functionsp. 86
Hands Onp. 95
Charting Your Datap. 96
Pie and Series Chartsp. 97
Creating Easy-to-Use Chartsp. 100
Moving and Sizing Chart Objectsp. 103
Printing Chart Objectsp. 104
Hands Onp. 104
Editing and Formatting Chartsp. 105
Adding a Data Seriesp. 105
Deleting a Data Seriesp. 105
Modifying and Formatting Chartsp. 105
Hands Onp. 110
Using Custom and Special Formatsp. 110
AutoFormattingp. 110
Working with Stylesp. 111
Conditional Formattingp. 114
Using Formatting Codesp. 117
Creating a Custom Formatp. 121
Hands Onp. 122
Tracking Data with Excelp. 123
Sorting a Databasep. 124
Filtering a Databasep. 127
Creating Subtotalsp. 135
Querying a Databasep. 137
Outlining Worksheetsp. 140
Using a Data Formp. 141
Hands Onp. 143
Chapter 4 Taking Excel to the Maxp. 145
Analyzing Data with Pivot Tablesp. 146
Creating Pivot Tablesp. 146
Creating Pivot Chartsp. 153
Hands Onp. 154
Error-Proofing Your Workbookp. 155
Minimizing Data-Entry Errorsp. 155
Resolving Logical Errorsp. 158
Using the Auditing Toolbarp. 162
Hands Onp. 163
Using and Constructing Templatesp. 164
Working with Existing Templatesp. 164
Creating a Templatep. 167
Hands Onp. 169
Linking Informationp. 169
Linking Workbooksp. 169
References That Span Worksheetsp. 173
Using a Workspacep. 175
Hands Onp. 175
Working with Others in Excelp. 176
Sharing Workbooksp. 176
Merging Workbook Changesp. 181
Setting Passwords and Protectionp. 182
Changing Workbook Propertiesp. 184
Hands Onp. 185
Forecasting and Modelingp. 186
Building a Business Modelp. 187
Using Excel's Forecasting Toolsp. 190
Creating Scenariosp. 194
Creating a Viewp. 197
Using the Report Managerp. 197
Hands Onp. 199
Chapter 5 Working with Objects and Graphicsp. 201
Converting, Linking, and Embedding in Excelp. 202
Editing an OLE Objectp. 205
Importing from PowerPoint, Access, and Outlookp. 205
Exporting Excel Datap. 205
OLE with Filesp. 206
Creating New Objectsp. 207
Importing a Text Filep. 209
Importing a Table from an HTML filep. 212
Inserting and Creating Hyperlinksp. 214
Hands Onp. 216
Inserting Clips and Graphicsp. 217
Adding Clips to an Excel Documentp. 218
Inserting Other Picturesp. 222
Modifying Picturesp. 222
Hands Onp. 224
Doing It Yourself with Drawp. 224
Inserting AutoShapesp. 225
Inserting Line Art Objectsp. 225
Adding WordArtp. 226
Formatting Objectsp. 228
Arranging Objectsp. 229
Grouping and Ungrouping Objectsp. 229
Hands Onp. 230
Chapter 6 Internet Publishing with Excel 2000p. 231
Saving Worksheets and Workbooks for the Webp. 232
Using Web Page Previewp. 234
Publishing Interactive Web Pagesp. 235
Browsing an Interactive Pagep. 239
Hands Onp. 242
Chapter 7 Customizing and Automating Excel 2000p. 245
Creating a Simple Macrop. 246
Storing a Macrop. 247
Recording a Macrop. 248
Formatting Options in Macrosp. 248
Cell References in Macrosp. 248
Opening a File with Macrosp. 249
Updating Macros from Previous Versionsp. 250
Running Macrosp. 250
Examining and Editing Macrosp. 251
Deleting Macrosp. 252
Customizing Toolbarsp. 253
Hiding and Displaying Toolbarsp. 253
Customizing Menus and Toolbarsp. 254
Hands Onp. 257
Appendix A Preparing for the Microsoft Office 2000 User Specialist Examsp. 259
The MOUS Differencep. 260
Should You Become a Microsoft Office User Specialist?p. 261
Getting Your Employer to Foot the Billp. 262
Microsoft Office 2000 User Specialist Designationsp. 263
The MOUS Examsp. 265
Appendix B Glossaryp. 269
Indexp. 299

Google Preview