Success!

An email was just sent to confirm your subscription. Please find the email now and click 'Confirm Follow' to start subscribing.

Oops!

You have already subscribed to this site. Please check your inbox.
You can manage your preferences at subscribe.wordpress.com

Excel Goal Seek (Part 4 of 5: Essential Excel Skills Every Controller Should Know)

October 29, 2018 | New View Strategies

So far in Essential Excel Skills Every Controller Should Know, we’ve covered sharing a workbook with your team and using special features like Conditional Formatting and Sparklines to provide more depth to our reports. Now, let’s focus on some analytical functions.

Microsoft has included What-If Analysis tools - Scenario Manager, Goal Seek, and Data Table. Scenario Manager and Data Table use sets of input values to determine possible results. Alternatively, the Goal Seek function will take a result and determines possible input values to produce that result.

Let’s assume we are introducing a new product and are looking to determine the sales required to reach a certain Gross Profit target. In the example below, my target is $200,000 in Gross Profit. The new product has an estimated 25% Gross Profit.

Excel Picture

In this scenario, I want to set the Total Gross Profit to my target of $200K by changing the Revenue for the new product. To use Goal Seek, navigate to the Data tab, find the Forecast group and click on What-If Analysis. Set the criteria for each parameter in the Goal Seek formula box.

Excel will churn through the calculations necessary to determine the value you are looking for, very quickly.

Read the last part of this series now: Excel VLOOKUP and HLOOKUP (Part 5 of 5: Essential Excel Skills Every Controller Should Know)

Subscribe to our RSS Feed

Subscribe to Blog Updates

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 68 other subscribers

You can unsubscribe at any time. To view our Privacy Policy click here.

Leave a Reply

Your email address will not be published. Required fields are marked *

The experts at New View Strategies are experienced Dynamics NAV and Business Central trainers and business process consultants who have walked in your shoes as former Corporate Controllers, Directors of IT, and Solution Architects, and believe increased utilization of your business systems is critical to the continued success of your company.
SUBSCRIBE TO OUR NEWSLETTER
Subscribe to our newsletter and keep up to date with classes, special registration discounts, and other NVS news

You can unsubscribe at any time. To view our Privacy Policy click here.

| Website Proudly Designed by Phoenix3 Marketing
Call Us!
cross
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram
%d bloggers like this: