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?


Top Tip for Google Classroom with Lara

I’m going to show you a Google classroom tip. In this media management classroom that I in, this is actually a student view so this is Clumsy Smurf here and this is an assignment that Clumsy has been allocated by his teacher.

VIEW POST

Scratch 3.0 – What’s new?

Scratch 3.0 is available to try in beta version and it has some awesome new features. I’ll show you a couple of them in this video. If you’ve never used Scratch before or are an old pro you’ll be delighted by how much computational thinking can be developed in this user friendly system to design games, animations and stories.

VIEW POST
Outclassed Podcast

Fake News and Getting Google Search to Work For You Ep 27

Get Notified Of Future Episodes: Apple Podcasts | Spotify | Google Podcast | Stitcher | TuneIn + Alex | Podcast Addict | Podchaser | Deezer | Listen Notes In this Episode: To see all the OutClassed episodes go to utb.fyi/outclassed Podcast Episode Highlights: Coming Resources and links mentioned: Transcript: Mike

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

Download your skills checklist to see how you score...

 

Sign Up Now
To Get The Latest Updates

 

Holiday Rescue Maker Camp

Student to agree to and tick:
Guardian to agree to and tick: