Excel as Your Database

By Paul Cornell

Excel as Your Database Cover Image

Excel As Your Database is ideal if you need to manage facts and figures, yet have little need for a full-scale relational database management system. You'll learn how to use Excel to enter, store, and analyze your data. This book assumes some exposure to Excel, but no prior experience with databases.

Full Description

  • ISBN13: 978-1-59059-751-4
  • 250 Pages
  • User Level: Beginner to Advanced
  • Publication Date: January 30, 2007
  • Available eBook Formats: PDF
  • Print Book Price: $34.99
  • eBook Price: $24.99
Buy eBook Buy Print Book Add to Wishlist

Related Titles

Full Description

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.

What you’ll learn

  • This book covers Excel 2007 and 2003.
  • The author clarifies not just how to use a technique, but under what realistic scenarios.
  • The text features step-by-step, how-to procedures.
  • Try-it-out exercises are based on realistic sample data.

Table of Contents

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
Source Code/Downloads

Downloads are available to accompany this book.

Your operating system can likely extract zipped downloads automatically, but you may require software such as WinZip for PC, or StuffIt on a Mac.

Errata

Please Login to submit errata.

On page 95:
Last sentence in the definition of RELATIVE CELL REFERENCE. "Absolute cell references take the format RowColumn (E12, for example)" should be "Relative cell references take the format RowColumn (E12, for example)"