Summary

In this chapter, you learned how to use Excel's tables to create a database in which you can store information, sort it, and apply filtering to find the records you need. You also learned how to use Excel's database functions with tables.

In the next chapter, I'll show you how to solve business questions using what-if analysis, the Goal Seek feature, and the Solver add-in. Turn the page when you're ready to start.

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.