Using the Goal Seek Add-On in Google Sheets

There are times when you need to find the best solution for a problem. It may be the selling price of an item and the number of items you need to sell to make a profit. Goal Seek, which is an add-on in Google Sheets will help to find the optimal solution. This is a powerful tool that enables you to set the output you want and then the sheet will work out what value you need to get you there. Goal Seek does this in a matter of seconds compared to manually trying to find the best solution.

Goal Seek in #GoogleSheets will help you find the optimal solution to a scenario. Click To Tweet

 

When I taught maths we would do this manually as part of an optimisation project and every time that you changed a value, you would manually recalculate the output, or adjust your chart to show the best solution. Goal Seek will test the different scenarios until you reach your goal. An example of this may be when you want to know the number of items you need to sell at a certain price to make a profit. The spreadsheet may look like this:

Become more efficient in finding solutions in #GoogleSheets by using Goal Seek. Click To Tweet

 

Goal Seek will adjust any value to meet that goal. You may want to change the selling price, or the variable cost of the item and run a series of ‘what if’ scenarios.

Watch this video to learn how to use Goal Seek in your Google Sheets.

So there you have it. A great way to further add functionality to Google Sheets by using Goal Seek. If you want to learn more tips on using G Suite tools, why not try one of our online courses?


FRIDAY FUNNY – PHONES IN SCHOOL

Some teachers are all for allowing students to have their phones in school.  They use them as learning devices and manage the possible distractions that come with having your phone on in class. On the other hand some schools have a strict no phones in school policy, confiscating any phone

VIEW POST

One Of My Favourite Quotes

  You could be standing in the midst of greatness… One of my favourite quotes is: Individuals from this generation will surface as leaders in every field.  During this lifetime the future will be shaped by someone – no one knows who it is going to be – so you

VIEW POST

Top tips for working from home by a remote working team

  With Google Drawings a lot of people don’t realise that it actually sits inside Google Docs. Inside Google Docs you actually have the Google Drawings tool. Under insert you’ve got Drawings and now there are two places that you can get a Drawing from. The ‘New’ is going to

VIEW POST

Here’s What
Our Clients Say

PR Industrya

Client

In 2018, Using Technology Better designed and delivered a two phase post-migration training program for this New Zealand based graphic design firm. The initial goal of the training program was to reduce frustration with G Suite, with the long term aim of facilitating a change in culture and collaboration that can lead to transformative practices