What is the difference between Microsoft 2007 and Microsoft 2010?

Answer 1

There are many differences between Excel 2003 and Excel 2007. Some of the changes in Excel 2007 are improvements. Some are strongly disliked by users of past releases of Excel. The following are some of our major findings when we compared Excel 2003 to Excel 2007.

We do recommend that if you have Excel 2003, that you do a custom install of Excel 2007 and tell it to keep all prior versions. This will allow you to use your prior version if you need it. The default installation of Excel 2007 automatically removes all prior versions. We think having the prior versions around is a good thing.

Why should you upgrade to 2007? There are a number of good reasons:

• Number of rows increased from 65,536 to 1,048,576.
• Number of columns increased from 256 to 16,384.
• You do a lot of graphics work and need the new graphics tools and options (although some complain about the built in defaults and data)
• You do a lot of pivot table work and need the new pivot table features in 2007
• You are receiving workbooks that are Excel 2007 workbooks
• Maximum number of function arguments increases from 30 to 255
• Formula length increases from 1000 to 8000 characters
• Nesting levels for formulae increased from 7 to 64
• Unlimited cell-conditioning formats
• 64 sort levels
• Office XML Formats allow for better data integration between documents and back-end systems. Also, with Excel XML Formats, you can reduce file sizes, improve data recovery, and increase the interoperability of your spreadsheets with other data sources such as line-of-business systems.
• Business dashboards can be easily created from spreadsheets to track key performance indicator.
• You can import external data into a spreadsheet by using pre-configured external sources of business information
• Developers can use the Office Excel 2007 calculation engine in other applications, such as a Web-based mortgage calculator or an options pricing model.

Why should you stay with Excel 2003 (or an earlier version)

• The Excel 2007 interface is harder to use. More functions are visible on the new menu system but the lists of functions are longer so regular functions are more difficult to find.
• You are used to using Excel 2003. You will find that using Excel 2007 takes longer to do many of the tasks you used to do. This is part experience and part design. The first can be overcome, but it will take time. If you have used Excel 2003 for years.
• New file formats and file name suffixes
• Files are larger
• No Lotus123 support or conversion to versions before Excel v4
• Pre-Excel 2007 versions need additional drivers to read Excel 2007 files
• No change to any statistical functions between Excel 2003 and Excel 2007
• Macro recording of chart macros works very poorly in Excel 2007.

What options do you have to overcome the above three problems?

• A number of companies sell products that add back the classic Excel menus to Excel 2007. In all cases, you do not get all the menu items as some have disappeared. And new features are not found on the new menus.
• If you do chart macros, you can always use Excel 2003 to record a macro and then copy it to Excel 2007. Some modifications may be necessary however to get the code to work correctly.
• If you are very statistically minded, see the review of Excel 2007 in "Computational Statistics and Data Analysis 52 (2008) 4568-4606" (www.elsevier.com/locate/csda), "On the accuracy of statistical procedures in Microsoft Excel 2007", McCullough and Heiser.

Answer 2

Word is meant for Word Processing, while Excel is meant for spreadsheets, charts and graphs. If you're still confused by the difference you can watch these bundles for beginners with Word 2007 and Excel 2007. Beginners Guide to Work 2007: http://www.woopid.com/gvideos.php?gid=110 Beginners Guide to Excel 2007: http://www.woopid.com/gvideos.php?gid=91

Answer 3

MS Office 2010 has a few cosmetic differences and a few more functions. In MS Word 2010, there are more templates, a slightly better looking and more functional user interface, more security options and more capable and compatible file types can be incorporated within them. MS Word 2010 has also made it that other programs can interact with them.

Answer 4

what are the major difference between MS-Excel 2000 and MS-Excel 2007?

Answer 5

About three years.... Other than that, there really isn't any difference other than the layout of the menus and options...

Answer 6

enviroment diffrence, direct to sending to mail

Answer 7

Microsoft Excel 2010 has a fully updated interface, along with numerous updates to calculations and how to perform formulas, over the older 2003 version of the program.

Answer 8

help me