• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Digital Answers

How to tech tutorials in simple words

  • Home
  • About Us
  • Disclaimer
  • Privacy Policy

excel 2011

How to use Goal Seek in Excel

October 12, 2014 by Admin Leave a Comment

Microsoft Excel has a Goal Seek feature which can be used to derive value of a cell based on the result set for the cell containing a formula. Let us see this with an example that does a simple addition. In the below screenshot, you should notice that the sum of A3 to E3 is calculated in F3.

Simple Addition Formula in Excel

Now let us say that you want the final result in F3 as “350000” and this should be achieved by changing the value of C3. For this scenario we can use Goal Seek feature to find out the value to be entered in C3.

In Excel 2011 for Mac, Goal Seek can be accessed from Tools menu.

Goal Seek in Excel 2011 for Mac

Enter the Set cell to the cell containing formula i.e F3

Goal Seek Screen in Excel

Then enter the final result that you need to arrive in “To value” field i.e 350000

Goal Seek To Value

Click Ok button after entering the cell that needs to be changed to get final result. The following Goal Seek Status screen will be displayed with “found a solution” message.

Goal Seek Status screen in Excel

Though we have taken a simple problem do explain Goal Seek feature. This feature will be quite handy when you are working with complex formulas and want to try out different values.

Filed Under: Excel, MS Office Tagged With: excel 2011, Goal Seek

How to password protect workbook in Excel Mac 2011

September 29, 2011 by Admin 1 Comment

Excel for Mac 2011 users can password protect the workbook using the option provided as part of the File menu. Click the File menu and select Passwords from the displayed menu list.

201109292051.jpg

This would display the following File Passwords window with different password option.

201109292054.jpg

You can set a password for opening the excel workbook using the Password to open field. Similarly to set a password for modifying the content in the excel workbook, you can use the Password to modify. If you want to make the workbook as readonly then mark the check box labelled as Read-only recommended.

Filed Under: Excel, Mac, Technical Tagged With: excel 2011, Mac, Password, Protect, Workbook

Primary Sidebar

Recent Posts

  • Streamline your Excel spreadsheets with these easy steps to hide rows and columns
  • Effortlessly Convert Text Cases in Excel with These Methods
  • A Guide to Using the MAX and MIN Functions in Excel
  • How to display fractions in Excel
  • How to Separate a Person’s First and Last Name in Excel

blogmines.com Copyright © 2023