Managing Data with Microsoft Excel

Front Cover
Que Publishing, 2004 - Computers - 366 pages
0 Reviews

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.

Contents

Managing Extemal Data from Inside Excel
85
VBA Essentials Reviewed
161
Opening Datahases
193
Dealing with Secured let Databases
210
Opening a Secured Access Database
223
Creating Queries
244
Looking Ahead
256
Creating a Table and Fields Using ADO
272
Getting Data from Access and into Excel with ADO and DAO
289
Looking Ahead
323
Copyright

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