Deputy Travis Costume

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".

Zoolights Invitation Text

Excel 2010 Top football matches

are available in columns A: D filing a list of football matches taking place on first day championship. As we can see below, in chronological order is not respected in this list.

The objective is to obtain the list on the right, where the chronological order has been complied with and where, for each day, we respect the order of the initial classification.

The trick that we found - to alleviate the formulas - is to use column G, hidden above, in which it calculates the line number to use for the game pursued. Here are the original formulas for this model:

F5 = SMALL ($ A $ 5: $ A $ 14; line () -4)

G5 = MATCH (F5, A: A, 0)

G6: = if (F6 = F5; equiv (F6; OFFSET ($ A $ 1; G5, 0): $ A $ 14, 0 ) + G5; equiv (F6; A: A, 0))

H5: = index (B $ 1: B $ 14, $ G5)

The only formula requiring some thought is the G6 ...
We leave you the pleasure of shelling to understand the principle.

Hindi Astra 28.2 Channels

The walls ...

Top starting at 9 am equipped with our "little walking sandals," we are left for 3 or 4 hours walking around ... Indeed, there are 12 km of walls, apparently as much as Saint-Malo ... where we never went ... check! The view over the old city is quite different when one is high on the ramparts, and we discovered other beautiful places.

Between the birth of Cartagena de Indias in 1533 and the Declaration of Independence in 1811, he spent three centuries ... During this period, the Crown of Spain made this city the hub of the Americas with the gold trade, previously plundered the Indians, and unfortunately with that of slaves. Coveted by the English, French and other pirates, Cartagena was besieged, looted or destroyed many times. But never surrendered the city and its people have mentioned them in this new world. Cartagena de Indias, after this important work of fortifications made over the centuries by the English military empire, became the largest fortified city of the 3 Americas.

Four districts are inside the walls: Centro, San Diego, and Matunas Getsemani. The Centro and San Diego are the neighborhoods most frequented by tourists, as museums, churches, shops, restaurants are there. The other 2 neighborhoods have remained more popular, but not without charm and originality.

del Fuerte Pastillo - On the inside

Baluarte del Reducto - Baluarte de San Francisco

Baluarte de Santo Domingo - On the ramparts

Landside, Plaza de la Artilleria - Callejon de los Estribos

Baluarte de la Cruz (destroyed by the French in 1697) - Las Bovedas

Fuerte de la tenaz - India Catalina India captured by Pedro de Heredia, to serve as guide and interpreter, thus becoming the "peacemaker" between English troops and Indian populations

Denise Milani Wallpaper High Definition

Cartagena ... Day

restaurante Tipico - Casa de la Aduana

First

house have been restored in el centro

Palacio de la Inquisicion - this is the Ventana Denuncia as "heretics" were denounced!

Calle San Juan de Dios - statue of Fernando Botero, famous Colombian painter and sculptor alive (born in 1932 in Medellin), internationally known for his round and voluptuous shapes

Plaza San Pedro Claver - What rhythm!

One of the great restaurants in Cartagena - Parts of the Museo de Arte Moderno out in the street

And that joke ... even sculptures!

Convento de San Pedro Claver, "Esclavo Esclavos para siempre de los"

Haitian Painting - Beautiful wooden sculpture Afro-Caribbean