- 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
- Data Basics
- Define Your Data
- Enter Data
- Find Data
- Connect to Other Databases
- Analyze Data
- Automate Repetitive Database Tasks
- Source Code/Downloads
- Errata
-
If you think that you've found an error in this book, please let us know about it. 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)"
Your Cart
You don't have any books in your shopping cart yet!
Companion eBooks
Why limit yourself to one format? If you’ve purchased the print edition of most Apress titles then we’re happy to offer you the eBook edition for just $10.
User Group Program
Register your user group with Apress to take advantage of discounts on books, receive review copies, door prizes, and much, much more…
Academic Resources
Let Apress assist in the development of your academic programs and coursework.
Bulk Sales Discount
Bulk discounts apply when you buy ten or more copies of individual Apress or Friends of ED titles in either hard copy or eBook format.