As New Year's resolution, I finally decided to try Excel 2010. I gave myself, as usual, some time carefully so that the most annoying bugs of this release have had time to be fixed:)
In this first article, we will first quickly review the main innovations of Excel 2010.
The File
menu "File" is one of the most visible changes made to the Excel 2010 version.
Phew! Finish button "Office ! We will return to this menu in the second part of this article ... Anyway, this first novel deserves to be greeted with kindness ...
Ribbon Home
The only visible change tape "Home" is the greatest place taken by the commands "Wrap automatically" and "Merge and Center." It is unfortunate to occupy so much space for the first two commands used infrequently (and may be accessed via the command
"Alignment") and the second, cell fusion, is for me the worst order ever imagined in Excel. Indeed, the strength of the spreadsheet as a working tool is that the rows, columns and cells are all independent of their peers: this beautiful independence is destroyed in the first cell fusion (
For you convincing, check out my article "Do not ever merge your cells!" of November 17, 2005. One of the first articles of this blog, and it is not by chance.
Ribbon Insertion
Note a small change in the Ribbon "Insert", a change that is actually a regression: the command "Table Pivot »Excel 2007 is renamed" TblCroiséDynamique, "which represents the double disadvantage of occupying more space in length and be less legible ... However, bravo for the development of Block" sparkline Charts - there at least a novelty really useful - and block "filter" with its unique control "Segment". We will discuss these two new another day.
Ribbon "Layout"
We noted one change in the Ribbon "Layout", the deployment Last Block - Organize - with the display of all associated controls.
Ribbon "Formulas"
In the new tape "Formulas", I do not see the point of blocking a few inches of tape with all the families of functions (Finance, Logic, Text , ...). However, the making visible the controls really "Show Formulas", "Error Checking" and
"Evaluation Form" is much more useful, even for the last two commands, "Calculate Now" and "Calculate sheet .
Tapes "Data", "Revision" and "View"
No significant change in the ribbons "Data", "Revision" or
"View", if not the deployment of certain commands that were previously represented by icons that sometimes very explicit ...
The File menu
The File menu is a complete novelty: there were none in Excel 2007 and the look was quite different in Excel 2003, where he There were roughly the same commands (except "Recent" and "Save and send") but without the right now not only present but also of substantial size:
Note also the presence of the command " options "that has nothing to do with the theme of the menu" File ", but he had to stay somewhere, this command returns as the button" Excel Options "available in Excel 2007 via the button Office.
A first conclusion ...
Passage Excel 2003 and Excel 2007 had caused some trauma to most users of Excel, the software ergonomics have been so completely changed.
The passage of the 2007 version to the 2010 version is much easier, most of the news - such as the ability to customize the ribbon - are either invisible at first glance, be discrete, for example the presence of Block "filter".
0 comments:
Post a Comment