Beginning Excel What-If Data Analysis Tools

Getting Started with Goal Seek, Data Tables, Scenarios, and Solver
1. Auflage 2005
ISBN: 978-1-59059-591-6
Verlag: Apress

Buch, Englisch, 192 Seiten, Format (B × H): 179 mm x 235 mm, Gewicht: 422 g

Excels what-if data analysis tools let you experiment with your data to project future results. In turn, these predictions will lead to better decision making and unlock the mystery of many business analysis scenarios. For example, what-if data analysis tools will enable you to forecast how lowering the price per unitwhile increasing projected unit salesmight affect your profit margins.

Beginning Excel What-If Data Analysis Tools explores the use of Goal Seek, Data Tables, Scenarios, and Solver to help you get insight on your data. This book is focused and to the point, and it provides tutorial treatment of what-if tools in a practical, hands-on manner.

Zielgruppe

Popular/general

Autoren/Hrsg.

Cornell, Paul

Fachgebiete

• Mathematik | Informatik EDV | Informatik Business Application Tabellenkalkulation Microsoft Excel

Inhaltsverzeichnis

1. Goal Seek
2. Data Tables
3. Scenarios
4. Solver
5. Case Study: Using Excel What-If Tools

Über Autor(innen)

Paul Cornell works at Microsoft on the documentation team for Microsoft Visual Studio Tools for the Microsoft Office system. He worked as an editor, writer, and columnist on the MSDN Office Developer Center and edited the Microsoft Office Visual Basic Language Reference. Cornell also founded the Power User Corner, on Microsoft Office Online, where he was a frequent contributor.