Enter Goal Seek and the Solver add-in, two tools that let Excel do the heavy ... use Goal Seek in Excel for multiple cells at once, this is it. It takes one goal variable and adjusts a number ...

select "Excel Add-Ins" from the "Tools" menu. You can create a regression output using the Data Analysis ToolPak in just a few clicks. The independent variable in Excel goes in the X range.