Synopses & Reviews
Expert Technical Knowledge at the Turn of a Page
Maximize the power of Excel 2000--now with advanced Web-enabled collaboration and rich analysis tools. Excel 2000: The Complete Reference explains in full detail how to use all the basic and advanced features--from setting up worksheets to producing charts to adding hyperlinks to publishing on the Web. Plus, the book serves as a study guide for the Microsoft Office User Specialist (MOUS) exam for Excel 2000. Use the MOUS Objective Skills Review in the relevant chapters and chart your proficiency with the TEST YOURSELF questions on the CD to determine if your skills meet the requirements for passing the exam. Excel 2000: The Complete Reference is the best, most comprehensive resource available on the world's most popular spreadsheet program!
Inside, you'll find out how to:
- Configure Excel 2000 for your exact needs
- Enter, edit, and format data and create spreadsheets
- Generate charts and reports directly from PivotTable views using new drag-and-drop functionality
- Collaborate on Excel projects with others over an intranet or the Internet
- Build customized macros for worksheet functions using Visual Basic
- Create a strong visual presentation--display your data in charts and graphs
- Link Excel data to other Office documents, such as PowerPoint presentations, for a professional, sophisticated look
Synopsis
Excel is the #1 spreadsheet program used today and the best for exchanging and managing information over a network, intranet, or the Web. Explains all the new features including See Through View, drag-and-drop PivotTables, and saving PivotTables as HTML files. CD-ROM contains hundreds of practice exam questions covering all the material
on the Excel segment of the MOUS exam.
Description
System requirements for accompanying disk: Windows 95 or Windows 98.
Table of Contents
Acknowledgements.
Introduction.
Part I: Getting Started.
Excel Basics.
Entering Information.
Working with Files.
Manipulating Data.
Structuring Worksheets.
Printing.
Part II: Analyzing Data.
Managing data.
Using Formulas.
Worksheet Functions.
Advanced Work with Formulas.
Charting Data.
Drawing Objects.
Data Maps.
Pivot Table.
Reaching Solutions with Brute Force.
Acquiring Data.
Sharing Workbooks.
Using Web Technology.
Part IV: Extending Excel's Reach with VBA.
Automating Repetitive Tasks.
The Visual Basic Editor and the Excel Object Model. Writing Subroutines.
Writing Functions.
Controlling Input with User Forms.
Techniques for Handling VBA Arrays.
Part V: Appendices.