E
Eleanor
I would like to know what the differences are between Excel 2000 and Excel XP, and Excel 2002
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bernard Liengme
Go to John Walkenbach's site www.j-wal.com
Lots of info there.
--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in e-mail address
Lots of info there.
--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in e-mail address
XP, and Excel 2002Eleanor said:I would like to know what the differences are between Excel 2000 and Excel
J
Jim Rech
Excel 2003:
http://office.microsoft.com/assista...CTT=1&Origin=EC010229841033&QueryID=0Bx4IZ9tE
From the Excel 2002 help file:
Key new features in Microsoft Excel 2002
Importing data
Querying data from Web pages Now it's even easier to get refreshable data from the Web into Excel for viewing and analysis. Use the new browser-like interface to visually select tables on Web pages for import into Excel, or copy data from a Web page and create a refreshable query. Web queries included with Excel provide fast, accurate information such as stock quotes for your spreadsheets. You can also create Web queries to Extensible Markup Language (XML) files.
Importing data Getting data where you need it and when you need it is as easy as choosing an option and finding your data source in the Select Data Source dialog box. If you want to import data from a remote data source, use the Data Connection Wizard to locate and import data from sources as varied as Microsoft SQL Server, Open Database Connectivity (ODBC), and Online Analytical Processing (OLAP) data sources. Microsoft Office data connection (.odc) files are shareable.
Formulas and functions
ScreenTips for function arguments Type a function in a cell and a convenient screen tip appears showing all of the arguments for the function, along with a link to the Help topic for the function.
Recommended functions in the Function Wizard Type a natural language query, such as "How do I determine the monthly payment for a car loan", and the Function Wizard returns a list of recommended functions you can use to accomplish your task.
Cut-and-paste function reference examples If you've wondered how to translate Help examples into meaningful worksheet data, you'll find the cut-and-paste function examples in Excel Help useful and time saving.
Task-based formula help Real-life examples for real-life numeric problems make powerful additions to the Help you've come to count on.
Watch window Keep track of cells and their formulas on the Watch Window toolbar, even when the cells are out of view. This moveable toolbar tracks cell properties including workbook, worksheet, name, cell, value, and formula.
Expanded AutoSum functionality The practical functionality of AutoSum has expanded to include a drop-down list of the most common functions. For example, you can click Average from the list to calculate the average of a selected range, or connect to the Function Wizard for more options.
Formula evaluator You can see the various parts of a nested formula evaluated in the order the formula is calculated by using a simple dialog box on the Formula Auditing toolbar.
Trace precedent and dependent cells with Formula Auditing Use the Formula Auditing toolbar to graphically display, or trace, the relationships between cells and formulas with blue arrows. You can trace the precedent cells or the dependent cells.
Formula error checking Like a grammar checker, Excel uses certain rules to check for problems in formulas. These rules can help find common mistakes. You can turn these rules on or off individually.
Worksheet and workbook formatting
Color-coded worksheet tabs Organize your work by adding color to your worksheet tabs.
Control automatic changes with smart tags Buttons that appear automatically on your worksheet can help you with tasks such as automatic correction options, paste options, automatic fill options, insert options, and formula error checking. With a click of a button you can choose from options related to your task without leaving the worksheet or the cells you're working on.
Unmerge on the toolbar No more searching for a way to unmerge cells. Now unmerge is conveniently located on the Format toolbar.
Retain column widths If you have worksheets with specified column widths, now you can paste information from another worksheet without losing that formatting by clicking the Paste Options button, and then clicking Keep Source Column Widths.
Border drawing A new border drawing tool allows you to outline complex borders with little effort.
More new features in Excel
Everyday tasks
Find and replace Finding and replacing data in Excel includes great new options to match formats and search an entire workbook or worksheets.
Links management Changes to the Edit Links dialog box allow you to check the status of the links in your worksheet and make changes. A new workbook option allows you to control whether to update links in your workbook automatically.
Hyperlink navigation Selecting a cell with a hyperlink is improved. Click the hyperlink once to follow it. Click and hold to select the cell.
Sending a range Sending out mid-month reports and summaries just got easier. Select a range on your worksheet, click E-mail on the Standard toolbar, type an introduction to the report, and then send it without spending extra time on the task.
Insert and delete columns while filtering You can insert and delete columns with AutoFilter turned on in Excel. You can even undo the action and preserve any applied filtering.
Speech playback An option to have a computer voice play back data after every cell entry or after a range of cells has been entered makes verifying data entry convenient and practical. You can even choose the voice the computer uses to read back your data. This feature is available in Chinese, Japanese, and English (U.S.) only.
Printing You've asked for the ability to insert graphics and file names in headers and footers, and with Excel you can. You'll also find a handy A4 paper resizing option on the International tab under Tools menu, Options command, which will scale the worksheet you formatted for A4 paper if you have letter-size paper in your printer.
Smart tags By turning on smart tags, you can type a U.S. financial symbol and use Smart Tag Actions to insert a stock quote in your worksheet, find out more about the company you're doing business with, and more. You can also type the name of someone you've recently sent an e-mail message to into a cell, and then use smart tag options to schedule a meeting or add the name to your contacts list, all without leaving your worksheet.
Item properties in PivotTables Online Analytical Processing (OLAP) is a powerful tool for aggregating numeric information, and now you can annotate your data with item properties to make your data warehouse even more valuable.
AutoRepublish Anyone who frequently publishes Excel data to the Web will appreciate additional Web publishing features that allow you to automatically republish items to Web pages whenever you save a workbook with previously published items.
Open and save XML With Excel, you can open and save Extensible Markup Language (XML) files, save entire workbooks in the XML Spreadsheet format, and create queries to XML source data.
Digital Dashboard and Web Parts Use Excel to create Web Parts to include on your company's new Digital Dashboard. For example, you might create an updateable sales chart to highlight your division's contributions to the company's bottom line.
Worksheet protection Excel adds power and flexibility to protect your data from changes to worksheets and cells. You can protect cell values and formulas, and allow the cell to be formatted. You can also ensure that only specific users are allowed to change cells.
http://office.microsoft.com/assista...CTT=1&Origin=EC010229841033&QueryID=0Bx4IZ9tE
From the Excel 2002 help file:
Key new features in Microsoft Excel 2002
Importing data
Querying data from Web pages Now it's even easier to get refreshable data from the Web into Excel for viewing and analysis. Use the new browser-like interface to visually select tables on Web pages for import into Excel, or copy data from a Web page and create a refreshable query. Web queries included with Excel provide fast, accurate information such as stock quotes for your spreadsheets. You can also create Web queries to Extensible Markup Language (XML) files.
Importing data Getting data where you need it and when you need it is as easy as choosing an option and finding your data source in the Select Data Source dialog box. If you want to import data from a remote data source, use the Data Connection Wizard to locate and import data from sources as varied as Microsoft SQL Server, Open Database Connectivity (ODBC), and Online Analytical Processing (OLAP) data sources. Microsoft Office data connection (.odc) files are shareable.
Formulas and functions
ScreenTips for function arguments Type a function in a cell and a convenient screen tip appears showing all of the arguments for the function, along with a link to the Help topic for the function.
Recommended functions in the Function Wizard Type a natural language query, such as "How do I determine the monthly payment for a car loan", and the Function Wizard returns a list of recommended functions you can use to accomplish your task.
Cut-and-paste function reference examples If you've wondered how to translate Help examples into meaningful worksheet data, you'll find the cut-and-paste function examples in Excel Help useful and time saving.
Task-based formula help Real-life examples for real-life numeric problems make powerful additions to the Help you've come to count on.
Watch window Keep track of cells and their formulas on the Watch Window toolbar, even when the cells are out of view. This moveable toolbar tracks cell properties including workbook, worksheet, name, cell, value, and formula.
Expanded AutoSum functionality The practical functionality of AutoSum has expanded to include a drop-down list of the most common functions. For example, you can click Average from the list to calculate the average of a selected range, or connect to the Function Wizard for more options.
Formula evaluator You can see the various parts of a nested formula evaluated in the order the formula is calculated by using a simple dialog box on the Formula Auditing toolbar.
Trace precedent and dependent cells with Formula Auditing Use the Formula Auditing toolbar to graphically display, or trace, the relationships between cells and formulas with blue arrows. You can trace the precedent cells or the dependent cells.
Formula error checking Like a grammar checker, Excel uses certain rules to check for problems in formulas. These rules can help find common mistakes. You can turn these rules on or off individually.
Worksheet and workbook formatting
Color-coded worksheet tabs Organize your work by adding color to your worksheet tabs.
Control automatic changes with smart tags Buttons that appear automatically on your worksheet can help you with tasks such as automatic correction options, paste options, automatic fill options, insert options, and formula error checking. With a click of a button you can choose from options related to your task without leaving the worksheet or the cells you're working on.
Unmerge on the toolbar No more searching for a way to unmerge cells. Now unmerge is conveniently located on the Format toolbar.
Retain column widths If you have worksheets with specified column widths, now you can paste information from another worksheet without losing that formatting by clicking the Paste Options button, and then clicking Keep Source Column Widths.
Border drawing A new border drawing tool allows you to outline complex borders with little effort.
More new features in Excel
Everyday tasks
Find and replace Finding and replacing data in Excel includes great new options to match formats and search an entire workbook or worksheets.
Links management Changes to the Edit Links dialog box allow you to check the status of the links in your worksheet and make changes. A new workbook option allows you to control whether to update links in your workbook automatically.
Hyperlink navigation Selecting a cell with a hyperlink is improved. Click the hyperlink once to follow it. Click and hold to select the cell.
Sending a range Sending out mid-month reports and summaries just got easier. Select a range on your worksheet, click E-mail on the Standard toolbar, type an introduction to the report, and then send it without spending extra time on the task.
Insert and delete columns while filtering You can insert and delete columns with AutoFilter turned on in Excel. You can even undo the action and preserve any applied filtering.
Speech playback An option to have a computer voice play back data after every cell entry or after a range of cells has been entered makes verifying data entry convenient and practical. You can even choose the voice the computer uses to read back your data. This feature is available in Chinese, Japanese, and English (U.S.) only.
Printing You've asked for the ability to insert graphics and file names in headers and footers, and with Excel you can. You'll also find a handy A4 paper resizing option on the International tab under Tools menu, Options command, which will scale the worksheet you formatted for A4 paper if you have letter-size paper in your printer.
Smart tags By turning on smart tags, you can type a U.S. financial symbol and use Smart Tag Actions to insert a stock quote in your worksheet, find out more about the company you're doing business with, and more. You can also type the name of someone you've recently sent an e-mail message to into a cell, and then use smart tag options to schedule a meeting or add the name to your contacts list, all without leaving your worksheet.
Item properties in PivotTables Online Analytical Processing (OLAP) is a powerful tool for aggregating numeric information, and now you can annotate your data with item properties to make your data warehouse even more valuable.
AutoRepublish Anyone who frequently publishes Excel data to the Web will appreciate additional Web publishing features that allow you to automatically republish items to Web pages whenever you save a workbook with previously published items.
Open and save XML With Excel, you can open and save Extensible Markup Language (XML) files, save entire workbooks in the XML Spreadsheet format, and create queries to XML source data.
Digital Dashboard and Web Parts Use Excel to create Web Parts to include on your company's new Digital Dashboard. For example, you might create an updateable sales chart to highlight your division's contributions to the company's bottom line.
Worksheet protection Excel adds power and flexibility to protect your data from changes to worksheets and cells. You can protect cell values and formulas, and allow the cell to be formatted. You can also ensure that only specific users are allowed to change cells.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.