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.

Contents

Using WBA to Managedata
161
Establishing Subroutines
168
Usingloops
175
Using with Blods
182
Using ObjectWariables
190
Specifying the DataSource
197
Managing Database objects
227
Defining Fields and Records with ActiveXDataObjects and Data
257
Getting Data from Access and into Excel with AD0 and
289
Returning Data from a Database to a User Form
302
lookingAhead
323
Using AD0 to Execute Action Queries and Stored Procedures
332
Using DAORecordsets to Move Data from Excel to a Jet Database
338
lookingAhead
344
Copyright

Common terms and phrases

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