For quite some time now, Microsoft Excel has been one of the most popular components of the company's office suite. There are few programs able to reproduce its ability to gather a large amount of data and transform it into easily readable graphic organizers including pie graphs and spreadsheets. As with any computer program that hopes to remain relevant and profitable, Excel's developers periodically update it in order to take care of customer concerns as well as improve the performance of its features. Recently, Microsoft underwent some changes from its 2007 version to the 2010 model. Here are some of the main differences between Microsoft Excel 2007 and Microsoft Excel 2010.
One of the most recognized and utilized features of Excel are the macros. On the 2007 version of the program, the recording feature was absent. It is present on the 2010 version, and although some users do not bother with recording, many did and this caused much consternation for 2007 users. In addition, Excel 2010 is able to perform calculations much more quickly than 2007; however, this is likely to go unnoticed by a large number of users. The faster calculations will certainly be appreciated when performing computationally heavy functions like the Monte Carlo methods. Excel 2007 did not handle these operations well.
Microsoft Excel 2010 also outgains 2007 in capacity. The amount of rows and columns that it allows is larger, and this is an upgrade that many of the successive versions of Excel have been endowed with over previous versions. Occasionally, a rather large number of data points requires extensive modeling. Excel 2007 placed a limit on data points at 32,000, whereas 2010 places a limit on points relative to available memory. This allows for many more data points when creating charts, assuming there is enough memory available of course.
Fill patterns were removed for the 2007 edition of Microsoft Excel, but enough people made their voices heard for its inclusion on the 2010 version. Additionally, users who performed a good amount of conditional formatting were left frustrated when these operations often pushed Excel 2007 past its capabilities. 2010 has little trouble in this function. Small charts known as sparklines have been added to Excel 2010 for quick reference. 2010 also provides more accurate statistical and mathematical operations than 2007 due to the new algorithm featured in the upgrade.
There were a large number of differences between Microsoft Excel 2003 and 2007, and though there are not nearly as many between 2007 and 2010, there are enough to make an obvious improvement in Excel 2010. Many will be happy with the larger overall capacity and the improved computational accuracy. 2010 also moves things along quickly with parallel data functions. These changes will likely please a great many who choose to upgrade to Microsoft Excel 2010.
One of the most recognized and utilized features of Excel are the macros. On the 2007 version of the program, the recording feature was absent. It is present on the 2010 version, and although some users do not bother with recording, many did and this caused much consternation for 2007 users. In addition, Excel 2010 is able to perform calculations much more quickly than 2007; however, this is likely to go unnoticed by a large number of users. The faster calculations will certainly be appreciated when performing computationally heavy functions like the Monte Carlo methods. Excel 2007 did not handle these operations well.
Microsoft Excel 2010 also outgains 2007 in capacity. The amount of rows and columns that it allows is larger, and this is an upgrade that many of the successive versions of Excel have been endowed with over previous versions. Occasionally, a rather large number of data points requires extensive modeling. Excel 2007 placed a limit on data points at 32,000, whereas 2010 places a limit on points relative to available memory. This allows for many more data points when creating charts, assuming there is enough memory available of course.
Fill patterns were removed for the 2007 edition of Microsoft Excel, but enough people made their voices heard for its inclusion on the 2010 version. Additionally, users who performed a good amount of conditional formatting were left frustrated when these operations often pushed Excel 2007 past its capabilities. 2010 has little trouble in this function. Small charts known as sparklines have been added to Excel 2010 for quick reference. 2010 also provides more accurate statistical and mathematical operations than 2007 due to the new algorithm featured in the upgrade.
There were a large number of differences between Microsoft Excel 2003 and 2007, and though there are not nearly as many between 2007 and 2010, there are enough to make an obvious improvement in Excel 2010. Many will be happy with the larger overall capacity and the improved computational accuracy. 2010 also moves things along quickly with parallel data functions. These changes will likely please a great many who choose to upgrade to Microsoft Excel 2010.
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.