Excel as Your Database

Front Cover
Apress, Apr 1, 2007 - Computers - 226 pages

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.

 

Contents

Introduction
1
Data Basics
9
Define Your Data
35
Enter Data
47
Find Data
95
Connect to Other Databases
117
Analyze Data
137
Automate Repetitive Database Tasks
189
Index
213
Copyright

Other editions - View all

Common terms and phrases

About the author (2007)

Paul Cornell works at Microsoft on the documentation team for Microsoft Visual Studio Tools for the Microsoft Office system. He worked as an editor, writer, and columnist on the MSDN Office Developer Center and edited the Microsoft Office Visual Basic Language Reference. Cornell also founded the Power User Corner, on Microsoft Office Online, where he was a frequent contributor.

Bibliographic information