![]() When you create a formula or function in Excel, you put various parts together to calculate a result. PART 1: Goal Seek and Scenario Manager What is Goal Seek? This feature can help you experiment and answer questions with your data, even when the data is incomplete. When you change values in cells in a systematic manner and observe the effects on specific formula cells, you’re performing a type of what-if analysis.Įxcel includes many powerful tools to perform complex mathematical calculations, including what-if analysis. A dynamic model uses formulas that instantly recalculate when you change values in cells that are used by the formulas. One of the most appealing aspects of Excel is its ability to create dynamic models.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |