reports
 

still waiting for some pro to teach me how to do a report in Excel 2002

with a brief like that, what can we be thinking?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"herbzee" wrote in message
news:i%NUd.66504$8a6.43117@trndny09...
still waiting for some pro to teach me how to do a report in Excel 2002

http://office.microsoft.com/en-ca/as...346581033.aspx


Gord Dibben Excel MVP

On Mon, 28 Feb 2005 23:42:06 GMT, herbzee wrote:

still waiting for some pro to teach me how to do a report in Excel 2002

I'm so accustomed to doing reports in Works 4.5 for years and find
nothing similar in Excl. I wandered onto a thing called pivot tables and
got as far as being able to isolate one column that had the data I
wanted to extract, but when I chose a range of dates for it to use
(greater than or equal to, and less that or equal to), it returned a
blank page. With that I can't go any further in preparing a printable
report.
Isn't there a step by step tutorial or help page somewhere. One didn't
have to be a rocket scientist to figure it out in MS Works,
but this ????

cheers-Herb.

Bob Phillips wrote:
with a brief like that, what can we be thinking?

Try Jon Peltier's site for Pivot Tables basics and not so basics.

http://peltiertech.com/Excel/Pivots/pivotstart.htm

Also Debra Dalgleish's site.

http://www.contextures.on.ca/tiptech.html

See "P" for pivot.


Gord Dibben Excel MVP


On Tue, 01 Mar 2005 00:40:05 GMT, herbzee wrote:

I'm so accustomed to doing reports in Works 4.5 for years and find
nothing similar in Excl. I wandered onto a thing called pivot tables and
got as far as being able to isolate one column that had the data I
wanted to extract, but when I chose a range of dates for it to use
(greater than or equal to, and less that or equal to), it returned a
blank page. With that I can't go any further in preparing a printable
report.
Isn't there a step by step tutorial or help page somewhere. One didn't
have to be a rocket scientist to figure it out in MS Works,
but this ????

cheers-Herb.

Bob Phillips wrote:
with a brief like that, what can we be thinking?

HI Gord, thanks for the link to the Report add-in for Excel; I'll check
it out as soon as the Medics give me some time-
cheers-Herb.

Gord Dibben wrote:
http://office.microsoft.com/en-ca/as...346581033.aspx


Gord Dibben Excel MVP

On Mon, 28 Feb 2005 23:42:06 GMT, herbzee wrote:


still waiting for some pro to teach me how to do a report in Excel 2002