10. Analyzing Excel Data
In this chapter, you’ll learn about various ways to analyze your Excel data, including using data tables, Goal Seek, scenarios, and the Solver add-in.
→ Understanding what-if analysis
→ Setting up one- and two-input data tables
→ Solving problems with Goal Seek
→ Saving model input values as scenarios
→ Optimally solving problems with Solver
At times, it’s not enough to simply enter data in a worksheet, build a few formulas, and add a little formatting to make things presentable. You’re often called on to divine some inner meaning from the jumble of numbers and formula results that litter your workbooks. In other words, ...
Get My Office 2013 RT now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
