Excel as Your Database

Excel as Your Database

by Paul Cornell
     
 

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

…  See more details below

Overview

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

Product Details

ISBN-13:
9781590597514
Publisher:
Apress
Publication date:
01/30/2007
Series:
Expert's Voice Series
Edition description:
2007
Pages:
250
Product dimensions:
7.00(w) x 9.25(h) x 0.62(d)

Related Subjects

Meet 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.

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >