Excel 2007 finally happened to me. Its not that I’ve never though of moving to Excel 2007 from the 2003 avatar of Excel, but you see, yours truly has never been accused of being an early adopter in the past, no sir never, and I’ve got a duty to protect that reputation. I bought my first phone after it had been on the market for a few years, bought my first car after it had been on road for a few thousand kilometers and got married more than two decades after I was born. Today I add to this illustrious set of accomplishments by taking my first look at Excel 2007, something that comes at a time when others are busy writing books on the next release. In marketing terms, they call people like me “late adopters” – people who may not necessarily be risk averse but their trade-off thresholds are higher than most others. To be honest, guys like me like to move on to new things (a new car, or say a new wife, once in a while perhaps – if you please). However we would like to be a bit certain about the outcome and rather not bring home a surprise (“the clutch you see sir, isn’t broken yet and may actually go on for a few more months”).
Ok so for whatever its worth, I am putting pen in the ink and here we go.
Ummmmm….aaaaa…..Ok……this is cool ! The Interface in Excel 2007
That’s what comes to mind when you opened your first worksheet in Excel 2007. The Ummmm and the aaaaaa parts come from the realization that something that looks this good can’t really be that bad (but hey, wait a minute ….. I thought the same way before I got married). After having been ridiculed, lampooned and crucified at every review, I was nearly hoping this was going to be really really bad. You see, people like me get a certain sense of satisfaction, nay, pleasure when we see rushing foolhardily into things and then coming back with a sulk and a hurt ego. But Excel 2007’s interface is different, it looks good and was actually useful in a few…. ok…. many ways. The everyday poor practitioners like me will be let down by the menu options not responding in tandem with the shortcut keys and the reduction of the screen space occupied by the ribbon though the later can be reduced to occupy less.
Now I am not saying that I like all of it, no good heavens no, its just that if somebody like my dad had a installation of this thing done on his laptop, he could actually be able to write his first formula and probably even create a chart or two of his own. He created me a few years back so I have reason to believe he is capable of producing things that are world class (ok change that to “in a class of their own”). So Excel 2005 gets 3 stars (that *** many stars, for any numerically challenged people reading this article) on this front.
Formulas in Excel 2007
Let’s change gears, shall we. (ok ok say we just pressed the clutch a little. Refer clutch above.) The first thing I did was to open a spreadsheet and write myself a brand new formula. Yesssir, we did. At first, with my concentration solely on entering the right keys on the keyboard, I didn’t notice anything. I was about to pass this off as a missed opportunity, hey presto…there they were – all the wonderful formula helpers floating around the cursor telling me what I could’ve done more after having written a part of the formula. The makers have also inserted a few useful formulas like AVERAGEIF (If and AVERAGE rolled in to one) and SUMIFS. I have reason to believe that they have introduced some 51 new functions in Excel 2007 Neat eh!
So that gets another 4 stars from us (that’s **** stars). We are now getting to a point where the brunette in the kitchen can also begin to write a few on her own. (Though I doubt she will ever be able to get over her Solitaire fixation)
Charts … they kick a** (mine and everybody else’s who thought that charts in Excel suck)
Charts were great in Excel 2003 and all the previous versions. The problem was that people were just not willing to put in the extra few hours required for format them properly and getting them right. Sometimes people are like that – you give them a perfectly good set of tools and they will not use it simply because it takes a bit of an effort.
However the most impressive part of Excel 2007, ladies and gentlemen, is ….hold your breath…..
…..hold it a bit more…….
Charting has been taken to another level, look wise, in Excel 2007. You can now pick and choose a chart type from all the available types from a single window. Hopefully, this simple step will go a long way in improving the lives of people on this planet – lesser pies.
However the biggest let down was in copy pasting the charts from Excel 2007 to 2003. The good looking chart that you created in 2007 version when copy pasted in 2007 gets pasted as an image. However the other steps for creating a chart were easier than 2003 (if you take out the “how dare they change everything that I’ve learnt” part out of it). I struggled with adding a title to the chart but I found it staring right at me under the “Layout” -> “Chart Title” ribbon. The default colors have been worked and the charts look so much the better for it. I mean now I can create all those wonderful 3-D charts in 50 different colors that everyone likes…yipeee!
Double-clicking on the charts in Excel 2007 opens up the relevant ribbon that I would guess might be useful to some of us.
Pivot Tables in Excel 2007
Pivot tables in Excel 2007 have remained more or less the same. However the ribbon has bought forth many features that otherwise would have remained hidden below multi-level menu options. The most promising part is actually the reworked Pivot Table Field List that allows users to move fields around and see the impact right away. Now this is one feature that even the seasoned professionals will love to play with. Another feature that has been to light is the conditional formatting for pivot table data.
(coming soon – Part II of this article)