Microsoft Excel 2000 Upgrade [OLD VERSION]

by Microsoft

Product Details

• Shipping Weight: 9.6 ounces
• Shipping: Currently, item can be shipped only within the U.S. and to APO/FPO addresses. For APO/FPO shipments, please check with the manufacturer regarding warranty and support issues.
• ASIN: B00002JV96
• Item model number: 065-01730
• Date first available at Amazon.com: September 17, 2002
• Amazon Best Sellers Rank: #7,259 in Software (See Top 100 in Software)
  • #21 in Software > Business & Office > Spreadsheet
• Discontinued by manufacturer: Yes

Product Description

Amazon.com Product Description

Discover better ways to analyze data and find solutions by using Microsoft Excel 2000 and its streamlined spreadsheet creation tools, enhanced analysis tools, and powerful Web integration. Whether you are an expert or a novice, Excel will help you work more efficiently, turning your data into answers you can count on.

Excel 2000 provides comprehensive tools to help you create, analyze, and share spreadsheets. Create rich spreadsheets more easily than ever using enhanced formatting features. Analyze your data with charts, PivotTable dynamic views, and graphs. And post your results to the Web for universal viewing and collaboration.

As part of Office 2000, Excel 2000 adopts HTML as its companion file format, so you can easily share data-rich spreadsheets in a Web browser--letting even those who don't have Excel view your data. Further Office integration introduces seamless e-mail and powerful collaboration tools that help your team work together more effectively.

Excel 2000 makes it easier to access vital business information using your organization's intranet, and then analyze that information to help you make informed and timely business decisions. Excel and Office 2000 bring you the power of Office Web components, providing Web viewers the ability to manipulate spreadsheet, chart, and PivotTable data from within their browser for on-the-spot data analysis.

The intelligent features of Excel 2000 not only help you work faster, but also help you create, edit, and format powerful spreadsheets and reports with less effort than ever.

From Winmag®

The most impressive feature in Excel is the ease with which you can create interactive charts and tables on the Web. If your organization wants to share sales data in the form of a PivotTable, you can publish the table on the Web and allow readers who are also running Office 2000 to manipulate the table. You can even link a chart directly to the table in one easy step; the chart will be updated as the PivotTable changes.

Let the browsers play, too
It's all extremely easy to do. We selected a PivotTable, saved it as a Web page to a Web server and let Excel publish the table, which we could immediately open in our browser. Because the Web page uses an ActiveX control, you'll have to view it with IE 4.0 or 5.0, since Netscape Navigator 4 doesn't handle the pages properly. This is still, essentially, an Intranet/workgroup enhancement in that only other users running Office 2000 will be able to view and use the interactive pivot tables within their browsers.

The new PivotTable Wizard is a much-needed Office addition. Instead of using Office 97's unintuitive tool (which is still available if you actually like it), you can drag and drop fields to the PivotTable and watch data appear automatically. The wizard is loaded with options (for enabling drill down and grand totals for columns and rows).

SUMs and See-Throughs make more sense
Of the other improvements to Excel, the one we find most helpful is the new way the SUM function behaves. In Excel 7, when you used the SUM function to add a column of, say, 10 numbers, everything was fine until you added a new row after the 10th element (and before the cell in the 11th row that contained the SUM). Excel 7 would add the row, but keep the SUM function (now in the 12th row) pointin g to the first 10 elements, completely ignoring the new number you entered. What you really want is the SUM function to be modified to add all 11 numbers--and that's just what happens in Excel 2000.

Another useful change is what Microsoft calls the See-through View. In Excel 7, when you selected a range of negative numbers (displayed in red), Excel would display the cells in blue on black. Excel 2000 displays the numbers in red with a blue-gray background. It's a subtle improvement, but if you are particular about cell formatting, it's a real time saver.

You can also apply AutoFormatting to PivotTables; the new colorful headers or alternating colors may take the boredom out of your analysis. As PivotTables are pivoted, the formatting is re-applied automatically. Queries are somewhat easier to apply with the new Database Query tool: You can add and format columns that retain their settings even when you refresh data. Still, the Query tool remains too complex for ordinary users.

If you have to import text data repeatedly, a new "refreshable text import" feature lets you save your specifications (such as formatting and formulas) and reuse them when you re-import text. This is an especially handy feature when you have repetitive imports to do-such as converting data from another source once a month. However, Lotus' 1-2-3 has one handy feature that Excel lacks: Using voice-recognition technology, 1-2-3 allows you to dictate data into spreadsheets.