Managing Data with Microsoft Excel

Front Cover
Que Publishing, 2004 - Computers - 366 pages

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.


What people are saying - Write a review

We haven't found any reviews in the usual places.


Managing Extemal Data from Inside Excel
VBA Essentials Reviewed
Opening Datahases
Dealing with Secured let Databases
Opening a Secured Access Database
Creating Queries
Looking Ahead
Creating a Table and Fields Using ADO
Getting Data from Access and into Excel with ADO and DAO
Looking Ahead

Common terms and phrases

References to this book

About the author (2004)

Conrad Carlberg is president of Network Control Systems, a firm that develops event and statistical analysis software for the health care industry. He holds a doctorate from the University of Colorado and has authored nine books on Excel, including Que's Business Analysis with Excel. Carlberg lives near San Diego and would go sailing more frequently if his loved one would just take the man overboard drill again.

Bibliographic information