Generating reports from an Excel 2002 worksheet
 

I'm a total newbie to Excel (and without a manual), and my boss has asked me
to generate commission reports based on an Excel worksheet. Can any one tell
me how to generate reports? I have Excel 20002.

Generating reports from an Excel 2002 worksheet
 

If that is all the direction your boss was able to provide, I think you should
start looking for a new place of employment or a new boss.

If you were a plumber's apprentice you would expect your boss to describe how to
chase a snake down a toilet before sending you out to do it.

I guess to begin you could load the Report Manager add-in which last shipped
with version 2002.

ToolsAdd-insReport Manager

Then learn how to create reports based upon the data layout.

Not much more to give you based on the lack of detail.


Gord Dibben MS Excel MVP


On Wed, 30 Apr 2008 12:32:00 -0700, marionh
wrote:

I'm a total newbie to Excel (and without a manual), and my boss has asked me
to generate commission reports based on an Excel worksheet. Can any one tell
me how to generate reports? I have Excel 20002.

Generating reports from an Excel 2002 worksheet
 

For sure Gord!

Well now you have an opportunity to shine.
Have a look here
http://office.microsoft.com/en-us/ex...119871033.aspx

And post back if need more help with details, not a 'how-do-I-do-all-this' request.
Don't forget you can Google, or use your own fav search client for a lot of help for more general questions.
Also a visit to your local library - there are many books on Excel (XL) - may prove enlightening.

Tools you will need to have / learn
Formulas to know = Vlookup, IF, Sumproduct, Sumif, Countif, Offset, Index, Match (others many insist on a few more). The 'IF' formula is the main one - get to know it inside out!
Try to get familiar with Charting and Add-Inns, and hopefully not Pivot tables but its really good if you can. :)


Regards
Robert McCurdy
"Gord Dibben" <gorddibbATshawDOTca wrote in message ...
If that is all the direction your boss was able to provide, I think you should
start looking for a new place of employment or a new boss.

If you were a plumber's apprentice you would expect your boss to describe how to
chase a snake down a toilet before sending you out to do it.

I guess to begin you could load the Report Manager add-in which last shipped
with version 2002.

ToolsAdd-insReport Manager

Then learn how to create reports based upon the data layout.

Not much more to give you based on the lack of detail.


Gord Dibben MS Excel MVP


On Wed, 30 Apr 2008 12:32:00 -0700, marionh
wrote:

I'm a total newbie to Excel (and without a manual), and my boss has asked me
to generate commission reports based on an Excel worksheet. Can any one tell
me how to generate reports? I have Excel 20002.