Excel as Your Database

Excel As Your Database guides those of you who need to manage facts and figures, yet have little experience, budget, or need for a full-scale relational database management system. Youll learn how to use Excel to enter, store, and analyze your data.

This book is written and organized in a way that assumes you have some familiarity with Excel, but not with databases. The book features quick-start solutions, practice exercises, troubleshooting tips, and best practices.

Table of Contents

1. Data Basics
2. Define Your Data
3. Enter Data
4. Find Data
5. Connect to Other Databases
6. Analyze Data
7. Automate Repetitive Database Tasks