Home > Store > Computer Software > Business Office Software > Spreadsheet Software > Microsoft Excel
Managing Data with Excel
- By Conrad Carlberg
- Published May 10, 2004 by Que. Part of the Business Solutions series.
- Register your product - get bonus material or coupon.
- Book
- ISBN-10: 0-7897-3100-2
- ISBN-13: 978-0-7897-3100-5
You have learned the methods to the madness of Excel. Formulas and functions are friends instead of foes. Yet you know there's something missing that could make your job even easier. That "something" is efficient and effective data management. Managing Data with Excel is the only book on the market that focuses on just that. Learn how to efficiently move data, automate data storage and import data into worksheets and pivot tables. Case studies are included in each chapter to illustrate real-world applications of these functions. Invest your time in learning this now so that you can stop wasting your time figuring out how to work around problems.
Downloads
All the samples developed for the book in one convenient file for download - 358 kb -- Samples.zip
|
8 of 9 people found the following review helpful
No Sample Files or data, By
Amazon Verified Purchase(What's this?)
This review is from: Managing Data with Excel (Paperback)
This book covers an important topic that other Excel authors skim or omit. It is just a shame that there is no CD or download for the examples presented in the book. I wrote the publisher and was sent a zip file with a couple of files, but not nearly enough to be able to practice or try out the techniques described in the book. Otherwise, I would have given it 5 stars.
5 of 5 people found the following review helpful
Indispensable Analytical Resource, By
This review is from: Managing Data With Excel (Business Computer Library) (Paperback)
As a health care analyst, I do lots of research using Excel. I stumbled across this text at a discount book sale and have used it constantly since then as a resource. A large portion of the book deals with pivot tables, one of the truly powerful Excel functions. But it covers much more than just this. Several of my MBA friends have browsed through the book and lamented they did not have this resource when they were in B-school. It's unfortunate that it is out of print.
5 of 5 people found the following review helpful
Amazing resource for Excel power users,
By A Customer
This review is from: Managing Data With Excel (Business Computer Library) (Paperback)
I waited 3 months for this book (which was out of print) and it has been well worth the wait. This book provides all the bells and whistles plus a whole bunch of other advanced functions which you wouldn't have thought of in dealing with data lists in Excel. Admitted, managing data with Excel isn't recommended in a lot of circumstances, but sometimes you have no choice. You might have too few data for using a full-fledged database; or, more likely, people tend to avoid using database programs for managing their data, with the result that you often get raw data entered with Excel - and you have to return a certain output to the original source in Excel format. My work involved quite a lot of this, and this book has offered wonderful solutions for almost all of my work needs. If you think you know a thing or two about using Excel, especially in data management, this book will make you think again - and help you become more productive than ever.
|
Online Sample Chapters
Excel's Lists, Names, and Filters
Excel's Lists, Names, and Filters
Table of Contents
Introduction.
I. PITFALLS IN DATA MANAGEMENT.
II. MANAGING DATA INSIDE EXCEL.
III. MANAGING EXTERNAL DATA FROM INSIDE EXCEL.
IV. MANAGING DATABASES FROM INSIDE EXCEL.
This book includes free shipping!
This book includes free shipping!
eBook (Adobe DRM)
$27.99
$22.39
This eBook requires the free Adobe® Digital Editions software.
Before downloading this DRM-encrypted PDF, be sure to:
- Install the free Adobe Digital Editions software on your machine. Adobe Digital Editions only works on Macintosh and Windows, and requires the Adobe Flash Player. Please see the official system requirements.
- Authorize your copy of Adobe Digital Editions using your Adobe ID. If you don't already have an Adobe ID, you can create one here.
- Request an Instructor or Media review copy
- Corporate, Academic, and Employee Purchases
- International Buying Options
Get access to thousands of books and training videos about technology, professional development and digital media from more than 40 leading publishers, including Addison-Wesley, Prentice Hall, Cisco Press, IBM Press, O'Reilly Media, Wrox, Apress, and many more. If you continue your subscription after your 30-day trial, you can receive 30% off a monthly subscription to the Safari Library for up to 12 months. That's a total savings of $199.
