Excel as Your Database

By Paul Cornell

  • eBook Price: $24.99
  • Print Book Price: $34.99
Buy eBook Buy Print Book

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

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

Related Titles

  • Moving to Office 365
  • Develop on Yammer
  • Custom SharePoint Solutions with HTML and JavaScript
  • File Management Made Simple, Windows Edition
  • Microsoft Azure
  • Beginning Windows 10
  • Introducing SQL Server
  • Expert SQL Server in-Memory OLTP
  • Beginning Big Data with Power BI and Excel 2013
  • Extending SSIS with .NET Scripting
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)"

Best-Sellers

    1. Beginning Power BI with Excel 2013

      $27.99

      View Details

    2. Pro Office 365 Development

      $34.99

      View Details

    3. Beginning Microsoft Office Live

      $17.99

      View Details

    4. Definitive Guide to Excel VBA

      $38.99

      View Details