Notices
Computer & Technology Related Post here for help and discussion of computing and related technology. Internet, TVs, phones, consoles, computers, tablets and any other gadgets.

Excel 2007 - what's your opinion ??

Thread Tools
 
Search this Thread
 
Old 22 October 2009, 07:17 AM
  #1  
velohead66
Scooby Regular
Thread Starter
 
velohead66's Avatar
 
Join Date: Oct 2002
Location: ex UK [SE], now Sunshine State [QLD,AUS]
Posts: 565
Likes: 0
Received 1 Like on 1 Post
Question Excel 2007 - what's your opinion ??

Any users of Excel 2007 out there.

Just wondering.......
...what your view of it is,
...what level of user you are.

I'll save my feedback on Excel 2007 for later, dont want to put my words in other peoples mouths.

Thx.
Old 22 October 2009, 08:57 AM
  #2  
[-(o)-]
Scooby Regular
iTrader: (1)
 
[-(o)-]'s Avatar
 
Join Date: Jul 2007
Location: Between a speed bump and a pot hole
Posts: 519
Likes: 0
Received 0 Likes on 0 Posts
Default

Its taken some getting used to, been using it for about six months now. Still can't find half the old functionality and not really happy with the ribbon. Seems slower and full of bugs as well, but this may be down to some of our third party add-ins.

Yes it can handle a lot more data and there are additional functions that are nice, pivot tables are much improved etc. We're going through business change, so Excel is filling a reporting gap for the time being. This is enough to justify it for me, but if we could I'd go back to 2003 tbh.

Advanced (2003 anyway!) user by the way.
Old 22 October 2009, 09:27 AM
  #3  
ChefDude
Scooby Regular
 
ChefDude's Avatar
 
Join Date: Aug 2005
Posts: 4,290
Likes: 0
Received 0 Likes on 0 Posts
Default

http://office.microsoft.com/en-us/tr...295841033.aspx
Old 22 October 2009, 09:41 AM
  #4  
urban
Scooby Regular
iTrader: (1)
 
urban's Avatar
 
Join Date: Mar 2002
Location: Never you mind
Posts: 12,566
Received 1 Like on 1 Post
Default

2007 is good for the business Intelligence/analysis side of things

Once you find your way around it then its not so bad - I don't really use it so much, more so from an activeX point of view and integrating with it via code.
Old 22 October 2009, 11:22 AM
  #5  
michaelro
Scooby Regular
 
michaelro's Avatar
 
Join Date: Jan 2006
Posts: 897
Likes: 0
Received 0 Likes on 0 Posts
Default

Originally Posted by urban
2007 is good for the business Intelligence/analysis side of things
Is it?

A partner Organisation recently had a Microsoft demo of Performance Point / Sharepoint trying to get them to use their tools.
His main selling point was that everyone uses Excel so why not have it as your main BI Tool

I use excel (advanced user, can write VBA etc) but consider excel only as somewhere to occaisionally dump and manipulate data, not a BI Tool.

As for 2007, I don't like the ribbon (Isn't there a Classic menu add in??) which puts me off using it extensively.
Fortunately I still use 2003 at work
Old 22 October 2009, 11:31 AM
  #6  
banny sti
Scooby Senior
iTrader: (68)
 
banny sti's Avatar
 
Join Date: Oct 2004
Location: Type R
Posts: 16,598
Received 22 Likes on 16 Posts
Default

So prefer 2003 and wish we could roll it back.

Banny
Old 22 October 2009, 01:20 PM
  #7  
mart360
Scooby Regular
 
mart360's Avatar
 
Join Date: Jul 2005
Posts: 12,329
Likes: 0
Received 0 Likes on 0 Posts
Default

Dont like it!

all the menu,s are illogical...

Where has chart wizard gone???

it takes twice as long now to navigate as before

Mart
Old 22 October 2009, 01:58 PM
  #8  
boxst
Scooby Regular
 
boxst's Avatar
 
Join Date: Nov 1998
Posts: 11,905
Likes: 0
Received 0 Likes on 0 Posts
Default

Once I've got over the initial "Where on EARTH is that" then I prefer 2007. I still have 2003 on my work laptop and it seems antiquated when using it.

With 2007 you can make very pretty charts that hopefully distract from the actual numbers ...

Steve
Old 22 October 2009, 02:17 PM
  #9  
eightballboy
Scooby Newbie
 
eightballboy's Avatar
 
Join Date: Oct 2009
Location: Chelmsford, Essex
Posts: 14
Likes: 0
Received 0 Likes on 0 Posts
Default

My skill and knowledge of excel is fairly basic but i personally hate 2007 in fact i think all the office 2007 programs are worse than their previous 2003 versions i found 2003 much easier to use.
My partner who uses these programs on a daily basis for work and is a fairly advanced user thinks excel 2007 is better.
Old 22 October 2009, 02:34 PM
  #10  
ScoobyJawa
Scooby Regular
 
ScoobyJawa's Avatar
 
Join Date: Aug 2001
Location: Hampshire
Posts: 10,954
Likes: 0
Received 0 Likes on 0 Posts
Default

Took some getting used to but as per Steve, with work lappy I've got 2003 and it seems really ancient............
Old 22 October 2009, 02:52 PM
  #11  
urban
Scooby Regular
iTrader: (1)
 
urban's Avatar
 
Join Date: Mar 2002
Location: Never you mind
Posts: 12,566
Received 1 Like on 1 Post
Default

Originally Posted by michaelro
Is it?

A partner Organisation recently had a Microsoft demo of Performance Point / Sharepoint trying to get them to use their tools.
His main selling point was that everyone uses Excel so why not have it as your main BI Tool

OK, for free (assuming you already have it that it)
I forgot the for free bit

If you want proper BI, then you certainly won't use excel2007.
SSAS/Cubes
DI diver - great product(although it was lacking behind a wee bit last year on dashboards when I looked at it)
Old 22 October 2009, 07:50 PM
  #12  
michaelro
Scooby Regular
 
michaelro's Avatar
 
Join Date: Jan 2006
Posts: 897
Likes: 0
Received 0 Likes on 0 Posts
Default

Originally Posted by urban
OK, for free (assuming you already have it that it)
I forgot the for free bit

If you want proper BI, then you certainly won't use excel2007.
SSAS/Cubes
DI diver - great product(although it was lacking behind a wee bit last year on dashboards when I looked at it)
I'll let you off then

We use SSRS, Cubes and Business Objects.

Excel is only any good because everyone can use it and it comes with Window's.
Open Source software (Logixml etc) is better but doesn't have the market share.

Dashboards? Are you in middle management...
Old 22 October 2009, 08:34 PM
  #13  
StickyMicky
Scooby Regular
 
StickyMicky's Avatar
 
Join Date: Feb 2003
Location: Zed Ess Won Hay Tee
Posts: 21,611
Likes: 0
Received 0 Likes on 0 Posts
Default

I am still using Excel 2002

Mainly because my old man had a copy and i acquired it from him a while ago
It is used every single day to do my daily returns!
Old 22 October 2009, 11:32 PM
  #14  
velohead66
Scooby Regular
Thread Starter
 
velohead66's Avatar
 
Join Date: Oct 2002
Location: ex UK [SE], now Sunshine State [QLD,AUS]
Posts: 565
Likes: 0
Received 1 Like on 1 Post
Angry

I've used Excel daily for the last 15 years, and can write VB scripts.
I also use access where my datasets were bigger than the 65,000 rows of excel 2003.
Any lack of functionality in 2003 I could make up for with VB.

Been using Excel 2007 for 2 months now, and had a particularly bad day yesterday with macros running (or not running) from password protected suite of 20 workbooks.
I go through phases were "I feel it's ok and I just need to accept the change", to days like yesterday where "I think the whole navigation thing is a bag of sh** and has reduced my productivity."

Fortunately I use Excel 2007 on my work pc (on the network) but also got IT to create a citrix login so that I can use Excel 2003 on the same network. Needless to say I only use 2007 when I have to, and vastly prefer the feel of Excel 2003.

Unfortunately my ODBC links dont work on citrix. D'oh! So I have to use 2007 there.



I hope MS revert back to sensible menu systems in the next version of excel.
Old 23 October 2009, 01:40 PM
  #15  
urban
Scooby Regular
iTrader: (1)
 
urban's Avatar
 
Join Date: Mar 2002
Location: Never you mind
Posts: 12,566
Received 1 Like on 1 Post
Default

Originally Posted by michaelro
I'll let you off then

We use SSRS, Cubes and Business Objects.

Excel is only any good because everyone can use it and it comes with Window's.
Open Source software (Logixml etc) is better but doesn't have the market share.

Dashboards? Are you in middle management...
Product manger for a software solutions company.
Customers love "Dashboards"

Business objects - don't know what you do with it exactly, but I'd be inclined to source an alternative

SSRS & Cubes - good.
SSAS too?

Last edited by urban; 23 October 2009 at 01:43 PM.
Old 23 October 2009, 03:56 PM
  #16  
StickyMicky
Scooby Regular
 
StickyMicky's Avatar
 
Join Date: Feb 2003
Location: Zed Ess Won Hay Tee
Posts: 21,611
Likes: 0
Received 0 Likes on 0 Posts
Default

Anybody tried OpenOffice as an alternative?

I actually downloaded it last night as a test and forgot to install it
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
KAS35RSTI
Subaru
27
04 November 2021 07:12 PM
Mattybr5@MB Developments
Full Cars Breaking For Spares
28
28 December 2015 11:07 PM
Mattybr5@MB Developments
Full Cars Breaking For Spares
12
18 November 2015 07:03 AM
leg200
Subaru Parts
5
07 October 2015 07:31 AM
MightyArsenal
Wheels, Tyres & Brakes
6
25 September 2015 08:31 PM



Quick Reply: Excel 2007 - what's your opinion ??



All times are GMT +1. The time now is 04:44 PM.