Link to home
Start Free TrialLog in
Avatar of brothertruffle880
brothertruffle880Flag for United States of America

asked on

Excel 2010 - Tables - Are they worth the Fuss?

I'd like to get some links on whether setting up a spreadsheet as a table is really necessary to get a particular job done.  Almost everything I've seen done within the confines of a table can be done without defining a table.  AND, tables use special syntax for calculating row values, (i.e. the "@") and having the table given a unique name "TABLE1"
I'm just not seeing the value.  Or am I totally wrong here?
ASKER CERTIFIED SOLUTION
Avatar of barry houdini
barry houdini
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Whilst most things can be done without using a table, many things are easier with one. You didn't say what the specific job was, so it's impossible to answer that part of your question.
FWIW, I think tables are a very useful new feature.
>...I think tables are a very useful new feature.

New? Tables are available in Excel2002!
No, they are not. I suspect you are thinking of Data Tables? Tables were introduced with 2007, as an empowered version of the Lists added in 2003.
Yep, Data Tables
Yeah, totally different thing. I think I've used data tables once before. :)
brothertruffle880 - Thanks for the points - Patrick