Generating reports from an Excel 2002 worksheet

[marionh]

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.

 

[Gord Dibben]

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.

Tools>Add-ins>Report 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

 

[Robert McCurdy]

For sure Gord!

Well now you have an opportunity to shine.
Have a look here>
http://office.microsoft.com/en-us/excel/HA011119871033.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