pivot table primer course

R

roger_home

I have a long complicated file that I use for work which I print out
everyday for the production people...they complain it has too much info
on it and want to see just what affects them. I figure a pivot table
would narrow down the info for them, but I don't know anything about
pivot tables. Can someone point me in the right direction for a intro
into pivot tables?

Thanks
 
D

Dave Peterson

I'm not sure how a pivottable would apply. Those are for creating summary
reports based on categories--totals, averages, kind of thing.

But maybe applying data|filter|autofilter
and only showing the rows that you want would work.

You could filter by date or by project or by department or by any column that
you want.
 
D

Dave Peterson

If you want to read more about pivottables...

Here are a few links:

Debra Dalgleish's pictures at Jon Peltier's site:
http://peltiertech.com/Excel/Pivots/pivottables.htm
And Debra's own site:
http://www.contextures.com/xlPivot01.html

John Walkenbach also has some at:
http://j-walk.com/ss/excel/files/general.htm
(look for Tony Gwynn's Hit Database)

Chip Pearson keeps Harald Staff's notes at:
http://www.cpearson.com/excel/pivots.htm

MS has some at (xl2000 and xl2002):
http://office.microsoft.com/downloads/2000/XCrtPiv.aspx
http://office.microsoft.com/assistance/2002/articles/xlconPT101.aspx
 
R

roger_home

Dave,

You are probably right...data/filter/autofilter would probably work
better than a pivot table. Question: after selecting whole database,
how do you turn certain columns off?
 
D

Dave Peterson

I'm not sure what you mean by turn columns off.

If you want to get rid of the dropdown arrows, you'd need some code to hide
those. But this isn't really necessary. You can just ignore those dropdowns
(or use them when you need them).

If you mean how you can see the data again, you can use the each filtered
dropdown arrow and choose All. You can also use data|Filter|show all to see all
the data without going to each arrow.

If you mean not see the columns, you can always select the columns you don't
want to see and Edit|Format|column|Hide--but this isn't using autofilter.
 
Top