A few days ago my wife asked me to help her with some research data she is collecting that she has in an excel spreadsheet.
What I saw amazed me. It repeated all the headers within the table so that when she was scrolling around she could still enter data. She was in the process of averaging some columns etc.
So first thing I deleted all the text. Then I formatted the table. Next I showed Lora how to filter data based on columns and asked he what kind of info she needed.
So I showed her how to create a Pivot Table. In Excel 2007 mere mortals can create Pivot Tables, they don't need a Ph.D.
Anyway, today I showed her how to create a complex pivot table. When I was done she almost cried.
I asked her how she did this sort of thing before. She said she didn't want to talk about it
. I assume that means manually.
Ouch.
They should teach people how to use Pivot Tables in college.
Anyway, I think Lora is pretty darned happy with this new knowledge.
Of course, I learned how to create Pivot Tables from the master, Dick Craddock.