keyboard shortcut for goal seek mac excel

Keyboard Shortcut For Goal Seek Excel How To Control Cookies

The Goal Seek command is useful in analyses when you want the outcome to be a certain way and you need to know which raw numbers will produce the outcome you want.

The worksheet determines that the monthly payment on a 250,000 loan with an interest rate of 6.5 percent to be paid over a 30-year period is 1,580.17.

Suppose, however, that the person who calculated this monthly payment determined that he or she could pay more than 1,580.17 per month Suppose that the person could pay 1,750 or 2,000 per month.

Instead of an outcome of 1,580.17, the person wants to know how much he or she could borrow if monthly payments the outcome of the formula were increased to 1,750 or 2,000.

This command lets you experiment with the arguments in a formula to achieve the results you want.

In the case of this worksheet, you can use the Goal Seek command to change the argument in cell C3, the total amount you can borrow, given the outcome you want in cell C6, 1,750 or 2,000, the monthly payment on the total amount.

In the example worksheet, you can borrow 316,422 at 6.5 percent, not 250,000, by raising your monthly mortgage payments from 1,580.17 to 2,000.

You can use these tips and tricks on any spreadsheet you want.

I want it to feel like when Harry first gets to Hogwarts, and he sees all the different witches and wizards using their magical skills except youre the witch or wizard and your boss is Harry Potter in this scenario.

So lets talk about the things you can use Excel for to make your life easier keyboard shortcut.

They mean that when youre working on something, you never have to take your hands away from the keyboard you can always just keep typing like a machine.

Some keyboard shortcuts might take a little while to wrap your mind around, but trust me, the investment is worth it in the end.

Keyboard Shortcut For Goal Seek Excel How To Control Cookies

To find out more, including how to control cookies, see here.

Keyboard Shortcut For Goal Seek Mac Excel