Generating reports from an Excel 2002 worksheet

  • Thread starter Thread starter marionh
  • Start date Start date
M

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.
 
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
 
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
 
Back
Top