Upgrade to Excel 2007

[Domski]

Hi,

Excel 2007 has been about for some time now and I've still to get my hands on it. The main reason for this is we won't be getting it at work for at least another 12 months and I'm finding it hard to justify the cost for what little use I would get out of the additional features at home.

I just wondered what other Mr Excel'ers thought of the new features after using them for a while and at what stage of the upgrade process they were at.

Dom

 

[Domski]

I just found out I can get office 2007 for £30 through my Uni course so guess I'll be upgrading sooner rather than later.

Deep joy.

 

[powderider86]

I use Office '07 at home on Vista, and '07 at work on XP... but some of my co-workers are still on Office '03. The only problems I have is if I forget to save files I share with co-workers in the correct formatting... and extra 2 secs to fix. It took a day to get use to the new '07 layout, but after a week with it, '07 is way better, not only with Excel, but Word, Access, and Powerpoint as well.

 

[Richard Schollar]

It took a day to get use to the new '07 layout

Only a day!? It's still taking me time to get to grips with

 

[powderider86]

I use office almost 365 days a year... I am finishing up my status as a full-time student, but have been a full-time employee for some time... as pathetic as it is I feel like I was born with office because i've been using and learning on it since i can remember

 

[Domski]

As long as they haven't messed with the shortcut keys too much I'm pretty sure I won't have too much difficulty get used to it although I'm interested to see what 'The Ribbon' is like to work with. Generally really good at picking up new stuff so fingers crossed.

 

[SydneyGeek]

Most of the shortcut keys work just fine. The hassle I have is when I want to build a list, using (for example) weekdays. I haven't found where some of those features have gone in the new version.

Still, mostly I am pretty happy with it. And if you really struggle, there's a banner ad on the Board with a Classic menu for Excel 2007. (I haven't used it -- prefer to occasionally swear at Office and find it in the new layout).

Denis

 

[Domski]

The hassle I have is when I want to build a list, using (for example) weekdays.

Do you mean the old Fill...Series command? Does the old right click and drag not still work?

 

[powderider86]

All you have to do is type "Monday" then click the cross in the bottom right of the cell and drag it... booyah kasha

 

[erik.van.geit]

All you have to do is type "Monday" then click the cross in the bottom right of the cell and drag it... booyah kasha

Hello,

To my sense the question was were these lists are stored. Do you know that?

kind regards,
Erik

 

[SydneyGeek]

No, what I was getting at was Edit > Fill > Series. You can type in a date, select a range, Edit > Fill > Series, and select Weekdays.
You get a list of dates that automatically excludes weekends. Very useful for creating monthly timesheets, for example, without entering formulas. I don't know where to find the equivalent in 2007.

Denis