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

Introduction to Excel 2001

Introduction to Excel 2001


Excel 2001, a component of Microsoft Office 2001, is a powerful spreadsheet software package. With it, you can create picture-perfect worksheets, charts, and lists based on just about any data you can enter into a Macintosh.

This Visual QuickStart Guide will help you take control of Excel by providing step-by-step instructions, plenty of illustrations, and a generous helping of tips. On these pages, you'll find everything you need to know to get up and running quickly with Excel 2001—and more!

This book was designed for page flipping. Use the thumb tabs, index, or table of contents to find the topics for which you need help. If you're brand new to Excel or spreadsheets, however, I recommend that you begin by reading at least the first two chapters. Chapter 1 provides basic information about Excel's interface. Chapter 2 introduces spreadsheet concepts and explains exactly how they work in Excel.

If you've used other versions of Excel and are interested in information about new Excel 2001 features, be sure to browse through this Introduction. It'll give you a good idea of the new things Excel has in store for you.

One last word of advice before you start: don't let Excel intimidate you! Sure, it's big, and yes, it has lots of commands. But as you work with Excel, you'll quickly learn the techniques you need to get your work done. That's when you'll be on your way to harnessing the real power of Excel.

New & Improved Features in Excel 2001

Excel 2001 includes many brand new features, as well as major improvements to some existing features. Here's a list. This book covers many of these features.

Figure 1. The Project Gallery let you create documents with any installed Microsoft Office application.

Document Creation

  • The Project Gallery (Figure 1) offers quick and easy access to all kinds of Office documents, right from within Excel.

  • The List Wizard makes it easy to create new list-based documents with Excel.

>Entering, Editing, & Formatting Values, Formulas, & Graphics

  • The new Calculator (Figure 2) offers a more intuitive interface for entering formulas into cells.

    Figure 2. The new Calculator shows the results of a formula as you enter it.

  • Tabular information can now be selected in a Web browser window and dragged into an Excel worksheet to enter it into Excel.

  • The new Collect and Paste feature introduces the Office Clipboard (Figure 3). This enables you to copy and store multiple items, then paste them as desired in any Excel (or Office) document.

    Figure 3. The Office Clipboard enables you to store multiple clips so you can paste them as desired in your documents.

  • The Formatting Palette (Figure 4) includes many options not available on the old Formatting toolbar.

    Figure 4. The Formatting Palette offers many options.

  • Excel now supports the Euro as a currency format.

  • The border drawing feature is more like Microsoft Word's and offers additional new options.

  • The Clip Gallery has been improved to add drag-and-drop capabilities and better image management features.


  • The new List Manager feature (Figure 5) offers additional features and tools for working with lists or databases.

    Figure 5. List Manager includes Sort and Filter buttons at the top of each column, a List toolbar, and more.

  • The List Wizard makes it easy to convert existing lists for use with Excel's new List Manager.

  • The List AutoFill feature automatically copies cell formatting and formulas to rows added at the bottom of a list.

  • AutoComplete has been improved to offer a menu of existing items that match the current entry (Figure 6).

    Figure 6. AutoComplete now offers a menu of options for a cell entry.

  • The FileMaker Pro Import Wizard enables you to import selected fields and records directly from FileMaker Pro database files into Excel.

Web Authoring

  • The new Web Page Preview command launches your default Web browser to display the current workbook as a Web page (Figure 7).

    Figure 7. You can use the Web Page Preview command to see your workbook as Web pages.

  • The Web Page Wizard has been replaced by a simpler Save as Web Page command for saving a workbook, sheet, or selection as a Web page.

  • The Insert Hyperlink dialog box (Figure 8) has been improved to make it easier to create links to Web pages, documents, and e-mail addresses.

    Figure 8. The improved Insert Hyperlink dialog box makes it easier to create links.

Integration with Other Office Applications

  • Excel 2001 is 100 percent compatible with Excel 98 for Macintosh and Excel 97 and 2000 for Windows.

  • Shortcut keys for many Excel commands have been changed to correspond with those in Microsoft Word and other Office applications.

  • The new Flag for Follow Up feature enables you to attach an Entourage reminder to a document so you remember to work on it in the future.

  • The File menu's Send To submenu (Figure 9) enables you to e-mail workbook files via Entourage (or other e-mail application).

    Figure 9. The Send To submenu offers a command to send the current workbook file to someone via e-mail.

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