Tables in 2007

  • Thread starter Thread starter Confused
  • Start date Start date
C

Confused

What are the advantages to converting a list to a table in 2007? Why does
the table have a name?

I did read in help that you can post a 2007 table to sharpoint services.
What does that mean?
 
Hi,
Go to the excel help and type Tables then open the one that says Demo:
Organize your data by using an Excel table, and then in How to do it, click
on Overview of Excel Tables

if this helps please click yes, thanks
 
Hi,
the name is equivalent to an absolute reference this is why you add the
offset formula to make it dinamic
 
Hi

If you convert a range of data to a Table, then it automatically becomes
dynamic.
You do not need to add any formulae to it at all.

Debra's reference to creating Dynamic Ranges is for versions of Excel that
do not have Table as an option, i.e. prior to XL2007.
If you click on her link on that page
http://www.contextures.com/xlExcelTable01.html
that takes you to a page discussing Tables.

Having done Insert tab>Table, whilst on the Insert tab there is then an
Option to report with a Pivot Table.
This will use the Table you have created as the source.
Any new data you add to your table will then automatically be inserted in
your Pivot Table, when you right click on the PT and choose Refresh
 
Back
Top