TeachExcel.com
Video Tutorials, Macros, Shortcuts, and More...
TE
TeachExcel HD Video Tutorials for Microsoft Office Consulting Services Excel Help Now Contact Us
Excel Tips Excel Video Tutorials HD Video Tutorials for Excel Free Excel Macros
Video Tutorials
  • Free Macros
  • Excel 2007 Resources
  • Keyboard Shortcuts
  • Contact/About
  • New Excel Interface & Features
  • Getting Started with Excel 2007
  • Intro. to Formulas and Functions
  • Intermediate Formulas/Functions
  • Printing - Formatting - Saving
  • Sorting, Filtering, & Tables
  • Data Consolidation & Retrieval
  • Security in Excel 2007
Tutorials: Data Analysis
Featured Tutorial
Dynamically Update Drop-Dowm Menus in Excel
Featured Macro
Delete Empty Rows in Excel

Goal Seek Feature in Excel

Bookmark and Share
View all of our Excel Video Tutorials on our New YouTube Channel HERE.

The goal seek tool in Microsoft Excel allows you to use excel to figure out what value you need for x in order to get the desired value for y. This works by having linked cells and can be done by changing only one cell at a time. This tool is especially good for financial and production analysis. I will explain how to use the tool and also a good example of where you might want to use it.
   Topics Covered
How to use Goal Seek in Excel
Goal Seek to Find Desired Net Income Value on an Income Statement
Automatically changing a cell to achieve a desired result
   Difficulty:         Intermediate
   Video:               Yes
   Spreadsheet:     No    
Got a Question? Ask it Here in the Forum.
Contact | Privacy Policy | Disclaimer
Copyright© 2009 TeachExcel.com