Chapter 20. Analyzing data

Chapter at a glance

Use

Use Goal Seek to determine the optimum value needed to solve a problem, Performing what-if analyses

image with no caption

Track

Track changing values with the Scenario Manager, Set Up

image with no caption

Apply

Apply an appropriate function to selected data using the Quick Analysis tools, ???

image with no caption

Examine

Examine your data in new ways with PivotTables, Creating a PivotTable

IN THIS CHAPTER, YOU WILL LEARN HOW TO

  • Perform goal-seeking operations and manage multiple ...

Get Microsoft Office Home and Student 2013: Step by Step now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.