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 learn to use 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 ...