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
- Data Basics
- Define Your Data
- Enter Data
- Find Data
- Connect to Other Databases
- Analyze Data
- Automate Repetitive Database Tasks