Excel as Your Database

This book shows beginning users how to manage their data using one of the world’s most popular programs – Excel ― without investing time and money in complex databases such as Access. We’ve written and organized the book for readers who know something about Excel but nothing about databases. We provide quick start solutions, step-by-step exercises, try-it-out sections, troubleshooting, and best practices solutions.

Table of Contents

Chapter 1 Data Basics

Chapter 2 Define Your Data

Chapter 3 Enter Data

Chapter 4 Find Data

Chapter 5 Connect to Other Databases

Chapter 6 Analyze Data

Chapter 7 Automate Repetitive Database Tasks

About the Author

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.