is it possible for excel to store info like this or am i looking for more of a database

HI THERE I RECENTLY STARTED A NEW JOB AND HAVE BEEN ASKED TO DESIGN AND OPERATE A SPREADSHEET OF SOME KIND TO KEEP AN EYE ON QUOTES WE COMPLETE AND HOW MANY JOBS WE ARE ACTUALLY GETTING.

I MANAGED TO DO THIS BUT NOW THE BAR HAS BEEN RAISED.
I NOW NEED TO BE ABLE TO COMPARE THE ABOVE, PLUS WHAT MONTH THE QUOTE WAS COMPLETED TO WHEN WE WERE AWARDED THE JOB, THE VALUE OF THE JOB, WHICH COMPANIES ARE WE GETTING THE MOST JOBS FROM AND WHETHER OR NOT ITS WORTH CONTINUING COMPLETING QUOTES FOR SOME OF THESE COMPANIES.

i UNDERSTAND I COULD JUST WRITE IT ALL DOWN IN A STANDARD SPREADSHEET BUT IM LOOKING TO DO SOMETHING A BIT BETTER THAN THAT.

WERE ITS A BIT MORE ORGANISED AND CAN BE SEARCHED ALMOST LIKE A DATABASE BASED ON A FEW FACTORS.
I AM NOT ASKING FOR SOMEONE TO DO THIS FOR ME. JUST IF IT IS POSSIBLE TO CREATE SOMETHING LIKE THIS (IF SO BE POINTED IN THE RIGHT DIRECTION) OR IF I SHOULD BE LOOKING AT SOME OTHER PROGRAM TO ACHEIVE THIS.

tHANKS SO MUCH IN ADVANCE FOR ANY HELP.!!

Hi DonaghyJJNR and welcome to the forum,

I think you need to look at Tables and Pivot Tables ... See:

http://office.microsoft.com/en-us/ex...101806958.aspx
http://www.excel-2010.com/tables-in-excel-2010/