Hi Johnty and welcome to the forum,

Good news. Read this and then click on their tutorial. I think this is the exact tool you need.

http://www.solver.com/welcome-mac-us...ded-excel-2011