Where could you put this to use in your office? Let me know what you think! Congratulations, Power Users!Ĭongratulations to our newest Power Users! For the full gallery, and more information about the WSU Microsoft Office Power User Program, please visit: wichita. In the pop up that appears either press OK to accept the change, or Cancel to go back to the original numbers.

One quick note, all these cells are rounding to the next whole number, so figures are not exact (we can’t recruit a percent of a student after all). Microsoft Excel 2016 for Mac is the tool belonging to Microsoft Office to deal with large volumes of numerical data with great comfort and. And each college’s appropriate rate is lined out with their needed increases. 8/10 (152 votes) - Download Microsoft Excel Mac Free. Interesting! It looks like enrollment will need to increase by 24%. Basically, we are saying we want to see what the percent increase would need to be for our goal of 3000 students to be reached.Įxcel should work out our calculation from here… I am using Excel 2016, But it is also compatible for Excel 2003, 2007, 2010 and Later.By Changing Cell: select cell F1 (next to Increase Enrollment By) or type F1 in the space provided.To Value: this is our enrollment goal, which was 3000, so change that to 3000.Set Cell should already read C6, since that was the selected cell.In this example, we'll find the interest rate for a 100,000. Go to the Data tab, Forecast group, and select What If Analysis. This wikiHow teaches you how to use Goal Seek in Microsoft Excel to find the value you'll need for a formula to get a certain result.You would like to figure out how large of a percent increase would be required to raise total enrollment (C6) to 3000.

That formula is nice, but your real hope is to Goal Seek. So an increase of 5% would mean all enrollment figures would increase as shown. What happens To column C if you type 5 into F1? FY19 enrollment headcount is in column B, and you would like to calculate goal enrollment for FY20 in column C.Ĭolumn C contains formulas that will calculate an increase in percent based on what you input into cell F1. What are we looking at here? These are recruitment numbers for some fictional colleges on campus. If you would like to follow along, here is the exercise file: GoalSeekExercise Scenario

In other words, if you know what number you would like to attain in one cell, but don’t know what input value is needed in a related cell to reach that number, this is the tool for you. Goal Seek allows you to work with related figures and determine how much one value would need to change in order for another to meet a goal. The feature we are going to examine today is called Goal Seek. Excel has several built-in forecasting features that can be excellent tools for planning and strategizing.

Goal seek on excel for mac