Office 2010

[bluedragon2]

I am getting ready to purchase Office 2010. Does anyone have any pros/cons for it?

Thanks

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[GlennUK]

What version are you migrating from?



Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[bluedragon2]

I have nothing at home at this time, using 2003 at work. Very little time spent on 2007.

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[GlennUK]

I've heard that 2010 is much better than 2010 ( especially PivotTables ), and is also less buggy than 2007. I'd go for 2010 given the choice.

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[fumei]

If the choice is 2010 or 2007 definitely go for 2010.

That being said, I am hugely negative about both. I understand Excel is superior, and that is all well and good, but as a serious professional user of Word, I think they made Word far far far far worse. I am a Word MVP (using Word from its first DOS version) and love it, but now I feel cheated. They ruined one of their best products.


unknown

 

[bluedragon2]

I am starting a new degree program online and will be using it for my school work. I like 2003, but really have no experience with 07 or 10.

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[fumei]

Have fun with that darn Ribbon.


unknown

 

[byundt]

I have Excel 97, 2000, 2002, 2003, 2007, 2010 (Windows) and 2004, 2008 and 2011 (Macintosh) installed on my laptop. Excel 2003 had been my favorite, but now Excel 2010 is the one I always use--unless answering a forum question that demands one of the other versions. Reasons include:
***Usable on-line help for VBA (though still not as good as Excel 2003 with its examples and related search terms). Microsoft appears to have gone through the help text in 2010 and improved it in many cases.
***Statistically sound stat functions (Microsoft hired an outside firm to fix the problems that gave their stat functions a bad reputation)
***More powerful Solver
***Sharp corners beginning to wear off on the ribbon
***Faster calculation engine
***You can record chart macros (unlike Excel 2007)
***Useful new functions (IFERROR, SUMIFS, COUNTIFS) in 2007 and later
***Analysis ToolPak functions are always available (i.e. no longer optional)
The only specification limits you are still run into are the length of a cell formula added by VBA (255 characters) and height of a row (409.5 points), both of which are unchanged. All the old limits that people used to kvetch about are far increased (number of rows and columns, number of parameters in a function, amount of text displayed in a cell, number of conditional formats, level of nesting in a formula, inability to use entire columns in an array formula, number of unique styles/formats in a workbook)

I have also found Outlook 2010 to be more reliable than Outlook 2007 (which often drove me crazy while I waited for it to let me open the next email or start typing).

Brad

 

[cmeagan656]

I use the keyboard shortcuts as much as possible since they have remained the same through all versions of Office.

As for the ribbon, you can get around that by highly customizing the Quick Access Toolbar.

Hope this helps.

Please help us help you. Read Tek-Tips posting polices before posting.
Canadian members check out Tek-Tips in Canada for socializing, networking, and anything non-technical.

 

[bluedragon2]

Thanks for the information and opinions. Not sure what you are referring to with the ribbon, I will look it up. I haven't contributed to much to this forum in the past year (mainly to busy after my promotion) and have not kept up on too many of the updates of 07 and 10. I have seen information on sum and count ifs (which is making my FAQ obsolete

I just researched and I can get the MS Office Academic 2010 for $80 with the student discount.

Again, thanks for the information...

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[fumei]

Like I stated, I understand Excel is superior.

Yes, using keyboard is effective. However, having easily customized menu - and MULTIPLE menus easily done - seems vastly superior to the Ribbon.

Outlook 2010 is much better.


unknown

 

[Nifrabar]

to be able to use the new features of excel2010 together with the ease of classic menus iso or combined with the ribbon have a look at thread68-1626716
-Bart