O'Reilly logo

Learn Excel 2011 for Mac by Guy Hart-Davis

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required