Part III
Analyzing Data and Sharing and Automating Workbooks
In this part of the book, you learn to analyze, manipulate, and share the workbooks you've built.
In Chapter 10, we look at how to use Excel's tables to create databases for storing information, sorting it, and filtering it to find the records you need. You also learn how to put Excel's database functions to work with tables.
In Chapter 11, we cover how to analyze your data using four powerful tools. You learn to use data tables to assess the impact of one or two variables on a calculation and scenarios to experiment with different sets of values without changing your core data. You also learn to use Goal Seek to solve single-variable problems and Solver to crack multi-variable problems. ...
Get Learn Excel 2011 for Mac 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.
