Designing a filter by setting an objective
You could set your certain gain and frequency you want to achieve.  Then, you would either set the value of a resistor, capacitor, or inductor depending on what type of filters you are trying to achieve.  If it is a first-order system with only a resistor and either a capacitor or an inductor, you can pick typical resistor values and enter them in a column.  Plug the numbers in for the specific type of filter you want and the capacitor value will be given to you.  

You will have to design the spreadsheet so that you have low-pass filter, high-pass filter, bandpass filter, and bandstop filter equations.

You would have to be more specific about exactly which program you are trying to use to achieve this.  But Excel can work very well to calculate those numbers.  Then simply reproduce in PSPICE, MatLab, or elsewhere.