Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel novice seeking guidance
I'm in need of some general advice on use of Excel. I have a
Worksheet that contains a list of names in column A as row headings and a list of dates across the top as column headings. The dates are each Monday for an entire year. There are several columns with formulas to the right of the data. I'm looking for ideas on what I can do to make this a more usable report. I can't see any way to make a pivot table out of it because of the way the data is set up on the sheet. I tried using Outline and Grouping to allow easily viewing the data in quarters but couldn't figure out how to make those work. Any suggestions would be appreciated. Thanks in advance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel novice seeking guidance
What data is it recording and what do the formulae do?
"Arch" wrote: I'm in need of some general advice on use of Excel. I have a Worksheet that contains a list of names in column A as row headings and a list of dates across the top as column headings. The dates are each Monday for an entire year. There are several columns with formulas to the right of the data. I'm looking for ideas on what I can do to make this a more usable report. I can't see any way to make a pivot table out of it because of the way the data is set up on the sheet. I tried using Outline and Grouping to allow easily viewing the data in quarters but couldn't figure out how to make those work. Any suggestions would be appreciated. Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MS Excel Expert Certification Guidance | Excel Discussion (Misc queries) | |||
Excel functions - need some guidance. | Excel Discussion (Misc queries) | |||
Please help! Excel Novice here | Excel Worksheet Functions | |||
seeking way to expire excel documents after certain date in Office | Excel Discussion (Misc queries) | |||
Incorrect Japanese guidance with Excel 2003 | Excel Worksheet Functions |