Managing Data with Microsoft Excel

Front Cover
Que Publishing, 2004 - Computers - 366 pages

Even experienced Excel users have never learned how to manage data efficiently, and there are few books that provide this information for people who use Excel to do their jobs. Within Excel, efficient management includes designing the layout of data on the worksheet and knowing which functions to use to take advantage of that layout.

When users need data that's maintained elsewhere (e.g., a database with G/L information or HR management software) they frequently resort to copying from the source and pasting to an Excel worksheet. There are more effective ways to move data. This book provides advice on using Excel's data management to get the results readers want. This is the only book that focuses on managing data in Excel. Covers Excel 97 - 2003.

The Business Solution series was created to provide professionals with books that are focused on a specific use or application of a software product. They don't want general software information, but need specific features and functions related to their particular productivity use. This series is for those who need to go farther with the software to specifically solve complex applications and uses. They want a book that addresses their immediate needs, and is likely to answer any additional questions they might have in the future.

 

What people are saying - Write a review

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

Contents

Managing Data with Excel Publisher
4
Misusing Excel as a Database Management Tool
9
žusiness solutions II Managing Data Inside Excel
17
Excels Data Management Features
27
Excels Lists Names and Filters 27
55
Managing External Data from Inside Excel
83
An Overview
85
Using Microsoft Query
113
Managing Database Objects
227
Managing Database Objects
244
Defining Fields and Records with ActiveX Data Objects and Data Access Objects
257
Getting Data from Access and into Excel with ADO and
289
Controlling a Database from Excel Using ADO and
325
Index
338
257
345
325
348

Further Considerations 85 113 139 Managing Data with
146
Microsoft Excel
152
Managing Databases from Inside Excel
159
VBA Essentials Reviewed
161
Opening Databases
193
185
356
197
364
East 96th Street Indianapolis Indiana 46240
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