Hi Fellow Excel Addict,

Welcome to another edition of "Spreadsheet Tips From An Excel Addict." I hope you're having a fantastic week.

I am looking forward to a great weekend. We are just two days away from our big soccer tournament for the season. Our town is hosting the tournament. We have 10 teams from all over Newfoundland coming and everyone, including me, is really excited.

I hope you find my tips this week helpful and I'll see you again next week. As always, I appreciate suggestions and comments so please feel free to write me anytime you want.

Have a productive week.

Keep on Excelling,
Francis J Hayes (The Excel Addict)

P.S. VERY IMPORTANT Please remember to include "TheExcelAddict" in the Subject line of any email you send me. This will help it stand out in the flood of junk email I have been receiving lately.

DISCOVER NEWFOUNDLAND AND LABRADOR, CANADA:
This is where I grew up: http://www.brigus.net/
This is where I now live: http://www.conceptionbaysouth.ca/
This is my beautiful province: http://www.gov.nf.ca/tourism/

Do you have a wheel mouse? Did you know you can use it to Zoom your worksheet. Just hold down the CTRL key while rolling the wheel. You'll notice that you can not zoom higher than 100% with the wheel. This also works with Print Preview.

Jim Rohn's Weekly E-Zine is a free weekly publication dedicated to providing valuable insights and information that can help empower and improve both your business and personal life. Find out more at http://www.TheExcelAddict.com/rd/jimrohn.htm.

There are times when you know the result you want from a formula but what you need to determine is the input value that will give you that result. Fortunately Excel has a great tool for this that is simple to use. It's called Goal Seek.

Anytime you need to produce a given result in one formula cell by adjusting the value of another cell, Goal Seek can save you a lot to trial and error.

To demonstrate this, let's use a simple example.

Say you have written two of three exams. On the first exam your mark was 67 and on the second it was 85. You have one more exam to write and you want to know what mark you'll need on your last exam to achieve a final mark of 80. Cell A1=67, cell A2=85, and cell A4 contains the formula =AVERAGE(A1:A3). Currently your average mark is 76 (i.e. the average of 67 and 85). Your final mark will be recorded in cell A3.

1. From the Tools menu select Goal Seek.
2. In the Set cell box, enter (or select) the cell that contains the formula that you want to generate a specific result (i.e. in this example A4).
3. In the To value box, enter the result you want (i.e. in this example 80).
4. In the By changing cell box, enter (or select) the cell that contains the value you want to adjust (i.e. in this example A3).
5. You will be presented with a dialog box that allows you to either accept the solution found by Goal Seek and input the value into the By changing cell or Cancel and leave the value unchanged.

The Set cell must be a cell that contains a formula, function or cell reference.
• The By changing cell must be a number or a blank cell. It cannot contain a formula, function or cell reference
• The Set cell must be referenced by formula to the By changing cell.

There are tens of millions of other Microsoft Excel users all over the world. The vast majority of them have a very limited knowledge of Excel's capabilities. My goal is to share this information with everyone I possibly can and help them to benefit from Excel's amazing capabilities.

Please help me spread the word about my newsletter. If you know other Excel users, please tell them about "Spreadsheet Tips From An Excel Addict". I'm sure they'll appreciate it.

Maybe you know someone who supervises or employs many Excel users. That's where your referral could have a big impact.

VERY IMPORTANT: Please refer only people you know personally, who use Microsoft Excel and would benefit from this newsletter.

Need quick access to a calendar? Just double-click the clock on the bottom-right corner of your screen. You can change the month and year but remember to click Cancel rather than OK when you're finished.