Apress Memorial Day

Excel as Your Database

By Paul Cornell

  • eBook Price: $24.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
  • Introducing SEO
  • Relational Database Programming
  • Using Chef with Microsoft Azure
  • DevOps on the Microsoft Stack
  • Beginning F# 4.0
  • Troubleshooting Windows Server with PowerShell
  • Dynamic SQL
  • Pro Power BI Desktop
  • Practical Maintenance Plans in SQL Server
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

If you think that you've found an error in this book, please let us know by emailing to editorial@apress.com . You will find any confirmed erratum below, so you can check if your concern has already been addressed.

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. PHP Objects, Patterns, and Practice

      $38.99

      View Book

    2. Beginning Android 3D Game Development

      $34.99

      View Book

    3. Troubleshooting Oracle Performance

      $41.99

      View Book

    4. Beginning Amazon Web Services with Node.js

      $38.99

      View Book