Excel Sales SpreadSheet

I'm a student, i currently have a project which i requires help from the community.

I'm being task to do Sales in the business function/department.

I have to do 4 - 6 spreadsheets and i'm not sure what kind of spreadsheet does the SALES business department do. Advise please.

THIS IS MY SCENARIO

\1

MY PROJECT SPECIFICATION

\1


I'm not sure what kind of spreadsheet to create for the SALES department, help and advise please.

For the project specification, can someone help me by suggestion when to use the formula etcs, and what additional formulas to use.

If anyone has a template of Sales spreadsheet, it would be better.

THANKS !

Welcome to the forum.

First, please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Second, we don't do homework. If you have a specific question, then ask.

oh ok. I'm just stuck with how to start spreadsheet with regards to SALES in a company.

We would help if you make a start

The summary workbook download here might help

http://excel-it.com/workbook_downloads.htm

thanks! but it does not show how the formulas are bring used.

what formulas are being used in it ?

cause i get bonus point for using special formulas.