Synopses & Reviews
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 Data Basics Define Your Data Enter Data Find Data Connect to Other Databases Analyze Data Automate Repetitive Database Tasks
Synopsis
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.
Synopsis
< p=""> < i=""> 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. You'll learn how to use Excel to enter, store, and analyze your data.<> < p=""> 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.<> < ul=""> < li=""> This book covers Excel 2007 and 2003.< i=""> < li=""> The author clarifies not just how to use a technique, but under what realistic scenarios.< i=""> < li=""> The text features step-by-step, how-to procedures.< i=""> < li=""> Try-it-out exercises are based on realistic sample data.< i=""> < l=""> < l="">