Descripciones mejoradas de Syndetics:

Provides details of all the features of Excel 2000. The CD-ROM contains practice exam questions covering all the material on the Excel MOUS exam. Includes appendices on what is new and what was left out of Excel 2000, how to become a Microsoft Office User Specialist and a glossary of computer and Excel terms.

Tabla de contenidos provista por Syndetics

• Acknowledgments(p. xxiii)
• Introduction(p. xxv)
• Part I Getting Started
• 1 Excel Basics(p. 3)
• The Excel Window(p. 4)
• The Help System(p. 11)
• Customizing Toolbars and Menus(p. 17)
• Nifty Configuration Changes(p. 20)
• Certification Skills Covered in This Chapter(p. 20)
• 2 Entering Information(p. 21)
• Entering Data(p. 22)
• Editing Data(p. 28)
• Using Comments(p. 30)
• Validating Data Entry(p. 32)
• Controlling the Appearance of Data(p. 37)
• Working with Styles(p. 46)
• Checking Your Spelling(p. 49)
• Certification Skills Covered in This Chapter(p. 52)
• 3 Working with Files(p. 53)
• Saving Files(p. 54)
• Opening Files(p. 63)
• Using Save As(p. 66)
• Saving as HTML(p. 67)
• Closing Workbooks(p. 69)
• Mailing and routing Workbooks(p. 69)
• Opening Text Files(p. 73)
• Certification Skills Covered in This Chapter(p. 77)
• 4 Manipulating Data(p. 79)
• Moving and Copying(p. 80)
• Using Go To(p. 82)
• Using Paste Special(p. 86)
• Working with Multiple Worksheets(p. 87)
• Using AutoFill(p. 90)
• Using the Office Clipboard(p. 93)
• Finding and Replacing Data(p. 94)
• Certification Skills Covered in This Chapter(p. 97)
• 5 Structuring Worksheets(p. 99)
• Adding Columns, Rows, and Cells(p. 100)
• Deleting Columns, Rows, and Cells(p. 104)
• Hiding Columns and Rows(p. 105)
• Freezing Panes(p. 107)
• Changing Column Width and Row Height(p. 108)
• Automatically Formatting Columns and Rows(p. 114)
• Using Headers and Footers(p. 121)
• Using Outlines(p. 123)
• Working with Views(p. 127)
• Certification Skills Covered in This Chapter(p. 129)
• 6 Printing(p. 131)
• Using the Page Setup Dialog Box(p. 132)
• Previewing the Print Job(p. 136)
• Manipulating page Breaks(p. 139)
• Creating Custom Views(p. 141)
• Printing Your Document(p. 143)
• Certification Skills Covered in This Chapter(p. 146)
• Part II Analyzing Data
• 7 Managing Data(p. 149)
• Understanding Lists(p. 150)
• Filtering Lists(p. 153)
• Sorting Data(p. 160)
• Examining Alternatives with Scenarios(p. 165)
• 8 Using Formulas(p. 171)
• Entering Formulas: Values, Cells, and Operators(p. 172)
• Entering and Editing Formulas(p. 172)
• Relative, Absolute, and Mixed References(p. 178)
• Linking Formulas, External References, and 3-D References(p. 183)
• Auditing Formulas(p. 188)
• Certification Skills Covered in This Chapter(p. 195)
• 9 Worksheet Functions(p. 197)
• Functions and Arguments(p. 198)
• Combining Functions(p. 219)
• Paste Function(p. 225)
• Certification Skills Covered in This Chapter(p. 227)
• 10 Advanced Work with Formulas(p. 229)
• Array Formula Specifics(p. 230)
• When Is Array Entry Necessary?(p. 232)
• Using Names(p. 235)
• Dynamic Definitions for Named Ranges(p. 243)
• Using Functions in Array Formulas(p. 247)
• String Handling(p. 252)
• Certification Skills Covered in This Chapter(p. 255)
• 11 Charting Data(p. 257)
• Using the Chart Wizard(p. 258)
• Types of Charts(p. 261)
• Chart Options(p. 273)
• Certification Skills Covered in This Chapter(p. 290)
• 12 Drawing Objects(p. 291)
• Using the Drawing Toolbar(p. 292)
• Creating Shapes(p. 297)
• Adding ClipArt(p. 303)
• Using WordArt(p. 308)
• Using 3-D Shapes(p. 312)
• Adding Text to Shapes(p. 313)
• Working with Layers(p. 313)
• Working with Groups(p. 316)
• Certification Skills Covered in This Chapter(p. 316)
• 13 Data Maps(p. 317)
• Creating a Map-Friendly Worksheet(p. 318)
• Creating a Map(p. 319)
• Customizing Maps(p. 326)
• Creating Templates and Pictures of a Map(p. 334)
• 14 Pivot Tables(p. 337)
• Pivot Table Components(p. 338)
• PivotTable Wizard(p. 350)
• Manipulating Pivot Tables(p. 365)
• Pivot Charts(p. 372)
• 15 Reaching Solutions with Brute Force(p. 377)
• Using Goal Seek(p. 378)
• Using Solver(p. 381)
• Part III The Outside World
• 16 Acquiring Data(p. 395)
• Returning Data to the Worksheet(p. 396)
• Understanding the Effects of Query Options(p. 405)
• 17 Sharing Workbooks(p. 413)
• Enabling Security for Workbooks(p. 414)
• Protecting Workbooks and Worksheets(p. 417)
• Using Shared Workbooks(p. 422)
• 18 Using Web Technology(p. 427)
• Working with HTML Workbooks(p. 428)
• Using Hyperlinks(p. 437)
• Using Web Queries(p. 443)
• Certification Skills Covered in This Chapter(p. 450)
• Part IV Extending Excel's Reach with VBA
• 19 Automating Repetitive Tasks(p. 453)
• Creating, Storing, and Running Macros(p. 454)
• Editing Macros(p. 462)
• Stepping Through Macros(p. 467)
• Running Macros from Toolbar Buttons(p. 472)
• 20 The Visual Basic Editor and the Excel Object Model(p. 479)
• Viewing and Using VBE Windows(p. 480)
• The Object Browser(p. 490)
• Modules(p. 493)
• User Forms(p. 495)
• 21 Writing Subroutines(p. 501)
• When to Use Subroutines(p. 502)
• Passing Variables to Subroutines(p. 507)
• Types of Variables(p. 513)
• Using With Blocks, Loops, Functions, and Cells in a Subroutine(p. 523)
• 22 Writing Functions(p. 527)
• Writing UDFs for Use on the Worksheet(p. 528)
• UDFs Solely for Use in Code(p. 543)
• 23 Controlling Input with User Forms(p. 549)
• Designing the Form(p. 550)
• 24 Techniques for Handling VBA Arrays(p. 567)
• Declaring and Populating Arrays(p. 568)
• Getting Data from the Worksheet(p. 572)
• Putting Data on the Worksheet(p. 578)
• User-Defined Data Types(p. 584)
• Sorting Arrays(p. 589)
• Using VBA Arrays with Workbooks(p. 592)
• Part V Appendixes
• A Becoming a Microsoft Office User Specialist(p. 619)
• How to Get MOUS Certified for Excel 2000(p. 620)
• B Microsoft Office User Specialist Exam Objectives(p. 623)
• C How to Use the Personal Testing Center TEST YOURSELF CD-ROM(p. 631)
• D Excel Functions(p. 637)
• Database Functions(p. 638)
• Date and Time Functions(p. 642)
• Engineering Functions(p. 647)
• Financial Functions(p. 649)
• Information Functions(p. 673)
• Logical Functions(p. 674)
• Lookup and Reference Functions(p. 674)
• Math and Trigonometry Functions(p. 675)
• Statistical Functions(p. 678)
• Text Functions(p. 700)
• Functions and Visual Basic(p. 706)
• Index(p. 715)

Notas de autor provistas por Syndetics

Kathy Ivens is the best-selling author of more than 30 computer books, including Quicken: The Official Guide. She has been a computer consultant since 1984, specializing in high-end accounting applications.
Contral Carlberg is the author of seven books on Microsoft Office applications. He is president of NCS, Inc., a provider of statistical control and analysis software to the health industry.