• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL



Just as Microsoft Excel 2000 is the most comprehensive and powerful tool for creating spreadsheets, this book, Special Edition Using Microsoft Excel 2000, is the most comprehensive and powerful reference of its kind.

Written by a team of talented authors, this book represents decades of experience teaching, using, and developing spreadsheet solutions with Excel. We bring our expertise to you in this accessible yet extensive book and its accompanying CD-ROM.

Whether you'll use this book as a reference to solve problems and research new features or you plan to read it from cover to cover, this book is designed for people who've used Excel before. We don't want to exclude the new or self-taught user, however, so the first chapter has been designed to provide you with a great foundation in spreadsheet concepts and the basics of Excel.

We welcome you to our book!

New Features and Enhancements in Excel 2000

There are a variety of new and enhanced features in Excel 2000—some the result of Office-wide changes and additions, others found solely in Excel.

Enhancements and new features you'll find in Excel fall into the following categories:

  • A true Web focus improves Excel's HTML document-creation and Web-publishing capabilities. Look for online collaboration tools as well.

  • Improved data analysis tools to support decision-making include PivotTable enhancements such as AutoFormat and PivotCharts, and the capability to pivot data when saved as HTML. Access and use of data tables are improved through enhanced database queries.

  • Access to Enterprise Data enables you to create OLAP PivotTables, and use Excel's new OLE DB and ADO data access technologies in a SQL Server environment.

  • Office Web Components allow Excel objects (worksheets, charts, PivotTables) to be manipulated through your Web browser.

  • User interface improvements include new mouse pointers, better charting tools, improved AutoFill features, and year 2000 support.

  • The Clipboard is enhanced to allow up to 12 selections, from any Office 2000 application, to be stored on the Clipboard at once. Paste them individually or as a group.

  • Currency formatting now includes the new Euro, offering both the symbol and the ISO code.

  • Another new feature in all of the Office 2000 applications is the combining of the Standard and Formatting toolbars into one toolbar. At the beginning of the book, you'll see the default single toolbar, and then as the authors move forward through their coverage of Excel, the default may be turned off and the two toolbars appear separately. You'll also notice a variety of Office Assistant characters throughout the book—this reflects the different authors' personal preferences.

How This Book Is Organized

Special Edition Using Microsoft Excel 2000 is divided into logically ordered and carefully divided sections. This makes it easier for you to find the topics you need, and ensures that the book flows from basic to advanced topics in a manner that enables you to read the book from start to finish, effectively building your Excel skills.

Part I: Workbook Basics

Chapters 1 and 2 introduce you to the Excel environment and discuss the process of building a worksheet. Although this book is designed for the intermediate user, basic users will also benefit from the content of these chapters as they build a solid Excel foundation. If you're a self-taught Excel user, you may find these chapters very useful in filling in the gaps that can occur without formal training.

Part II: Editing Worksheet Content

Chapters 3, 4, and 5 take you through the process of selecting, editing, and deleting worksheet entries, and using the Clipboard to move and copy worksheet content. Tools for moving, copying, and naming sections of your worksheet are discussed, improving your comfort level and the speed with which you navigate even your most complex worksheet.

Part III: Formatting and Printing Excel Worksheets

Chapters 6 through 9 help you add formatting, drawing shapes, and clip art to achieve a visually powerful worksheet environment for your data. Then learn to print your data—in sections, specific pages, or the entire workbook.

Part IV: Using Formulas and Functions

Chapters 10, 11, and 12 go to the real core of any worksheet—formulas and functions. Build your own formulas with your mouse and/or keyboard, or use named ranges and Excel's built-in functions to simplify even the most complex or esoteric mathematical procedure. These chapters start from the ground up to make sure you're building your formulas correctly, and then pick up the pace to show you tools that will help you build any formula you need.

Part V: Creating and Modifying Charts

Chapters 13 through 16 take you on a comprehensive tour of Excel's considerable charting tools. From building a simple bar or pie chart to stacking multiple charts, you'll learn which chart type best depicts your data and how to manipulate its appearance and content to express your numeric data effectively. Learn professional techniques for making your charts stand out visually as well as in terms of their content, communicating complex data in a dynamic visual format.

Part VI: Analyzing and Managing Your Data

Chapters 17 through 22 focus on Excel's data analysis and data management features. Learn how to build a database or list, edit, sort, and filter the list, and create illuminating reports from the data you store. Take advantage of Excel's new and improved PivotTable and PivotChart tools for data analysis to support your business decisions. Improve your worksheets with form controls that make Excel work as a project-management program. Use the Goal Seek, Solver, and Analysis ToolPak tools to solve simple or complex business problems.

Part VII: Taking Excel to the Next Level

Chapters 23 and 24 show you new and creative ways to use Excel. Learn how to build dynamic Gantt charts in Excel for time and flow management. Employ Excel's drawing tools to build value chains for market analysis and strategic business planning. Create quadrants to compare product placement and market focus. By learning how to mix and combine Excel's tools, you'll start to see the true power and flexibility of Excel 2000.

Part VIII: Integrating Excel with Other Applications

Chapters 25 through 27 show you how to end your isolation and branch out—using Excel data in your Word documents, PowerPoint presentations, and Access tables. Work in the other direction, taking Word, PowerPoint, and Access content and using it to improve your Excel worksheets. Chapter 26 focuses extensively on Excel's database access capabilities and on retrieving data from the Web. Learn how to build database queries and retrieve infor-mation from Access and from other databases. Chapter 27 introduces you to OLAP PivotTables and data stores. Use Excel 2000's Cube Wizard to build and use cubes for quick data access and analysis offline.

Part IX: Customizing and Automating Excel

Chapters 28 through 31 focus on your ability to make Excel work the way you do—from resetting software defaults to writing and editing macros to collaborating with other Excel users on a network or the Web, these chapters show you how to tweak and automate Excel, unleashing your creativity and making you more productive.

Part X: Appendixes

Appendixes A and B are supplements that support and expand on topics covered in the rest of the book. Appendix A is a comprehensive guide to Excel's functions, providing information you'll find indispensable. Appendix B outlines the content of the CD-ROM that accompanies this book and tells you how to access and use the files and programs on the CD.

Conventions Used in This Book

Que, as well as all of Macmillan Computer Publishing's various imprints, has more than 10 years' experience creating the most popular and effective computer reference books available. From trainers to programmers, Que's authors have invaluable experience using and—most importantly—explaining computer and software concepts. From basic to advanced topics, Que's publishing experience and their authors' expertise and communication skills combine to create a highly readable and easily navigated book.


Notes contain extra information or alternate techniques for performing tasks that the author feels will enhance your use and/or understanding of the current topic.

Tip #1001 from

Found throughout the book's text, tips are just that—quick advice to help you make faster or more efficient use of Excel.


If there is a potential problem with a feature or something you should be aware of to avoid errors or unwanted results, you'll find both a description of the situation and how to resolve or avoid it in the Caution format.


Whenever an icon is referred to in a discussion paragraph or step-by-step procedure, the icon will appear in the margin, next to the text that mentions it. This helps you find the icon on the toolbar and remember its location and function for future use.

Underlined Hot Keys

To assist you in using the keyboard to issue menu and dialog box commands, you'll find the underlined letters as they appear onscreen underlined in the text. For example, File, Print tells you that pressing Alt+F to open the File menu, followed by P will open the Print dialog box. After you're in the Print dialog box, Alt+E will tell Excel that you want to print the Current page.

Keyboard Shortcuts

Whenever a combination of keys can be pressed to execute a command, they'll appear paired by a plus sign, as in Ctrl+Home (to move to cell A1) or Ctrl+P (to open the Print dialog box). When using a keyboard shortcut, press the first key, and while that key is pressed, tap the second key.


Throughout this book, a variety of typefaces will be used, each one designed to draw your attention to specific text:

MonospaceScreen messages and VBAcommands appear in this special typeface.
ItalicNew terminology and emphasized text will appear in italic.
BoldfaceReferences to text you should type will appear in boldface.

End-of-Chapter Examples

At the end of many chapters, you'll find an example of how to use that chapter's features to improve the overall functioning, legibility, and/or effectiveness of your worksheets. Often appearing in the form of before-and-after figures with explanatory callouts, these samples offer advice and practical examples for your own implementation.

  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint