Managing Data with Microsoft Excel

Overview

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 ...

See more details below
Paperback
$32.92
BN.com price
(Save 17%)$39.99 List Price
Other sellers (Paperback)
  • All (19) from $1.99   
  • New (4) from $6.70   
  • Used (15) from $1.99   
Sending request ...

Overview

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.

Microsoft Excel is the #1 selling Windows spreadsheet with a user base over 10 million. This is the total package for anyone using Excel's database capabilities. There is complete coverage of List Management, Pivot Tables, Data Consolidation, and Working with External Data. Excel guru Tim Tow shares the tricks he has learned about data manipulation with Excel. CD contains examples and source code.

Read More Show Less

Product Details

  • ISBN-13: 9780789731005
  • Publisher: Que
  • Publication date: 4/22/2004
  • Series: Business Solutions Series
  • Pages: 384
  • Product dimensions: 7.32 (w) x 9.05 (h) x 0.86 (d)

Meet the Author

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.

Read More Show Less

Table of Contents

Introduction.

About Excel. How to Use This Book.

I. PITFALLS IN DATA MANAGEMENT.

1. Misusing Excel as a Database Management Tool.

Putting Data Management into Context. Overworking Functions. Transposing Rows and Columns. Using Labels Instead of Codes. Handling Variable Numbers of Records per Category. Changing Horses.

II. MANAGING DATA INSIDE EXCEL.

2. Excel's Data Management Features.

Using the Worksheet Functions: An Overview. Locating Data with OFFSET. Finding Data with INDEX. Finding Data with MATCH. Using MATCH with Other Functions. Using VLOOKUP. Rearranging Data with TRANSPOSE. Getting Data from a Pivot Table: GETPIVOTDATA. Looking Ahead.

3. Excel's Lists, Names, and Filters.

Creating Lists. Sorting Lists. Working with Names. Filtering Data with the AutoFilter. Using the Advanced Filter. Looking Ahead.

III. MANAGING EXTERNAL DATA FROM INSIDE EXCEL.

4. Importing Data: An Overview.

Getting External Data into the Workbook. Importing Data to Pivot Tables. Looking Ahead.

5. Using Microsoft Query.

Understanding "Query". Querying Multiple Tables. Joining Parent and Child Records. Using Database Queries. Handling the Data Range. Managing Boolean Fields and Check Boxes. Looking Ahead.

6. Importing Data: Further Considerations.

Understanding Pivot Tables. Preparing Data for Pivot Tables. Using Criteria with Microsoft Query. Querying Web Sites. Looking Ahead.

IV. MANAGING DATABASES FROM INSIDE EXCEL.

7. VBA Essentials Reviewed.

Using VBA to Manage Data. Establishing Subroutines. Understanding Dot Notation. Using Loops. Using With Blocks. Understanding the Macro Recorder's Code. Using Object Variables. Looking Ahead.

8. Opening Databases.

Connecting to a Database. Connecting Using ADO. Specifying the Data Source. Opening the Connection. Opening a Database Using DAO. Dealing with Secured Jet Databases. Opening a Secured Access Database. Looking Ahead.

9. Managing Database Objects.

Creating Tables. Defining Fields. Creating Queries. Looking Ahead.

10. Defining Fields and Records with ActiveX Data Objects and Data Access Objects.

Creating Databases from Excel. Creating a New Database Using DAO. Creating a Table and Fields Using ADO. Declaring and Using Recordsets. Understanding DAO Recordset Types. Understanding ADO Recordset Types. Looking Ahead.

11. Getting Data from Access and into Excel with ADO and DAO.

Using CopyFromRecordset. Building an Application. Bringing Data Back from a Parameterized Query. Returning Data from a Database to a User Form. Looking Ahead.

12. Controlling a Database from Excel Using ADO and DAO.

Using DAO to Execute Action Queries. Using ADO to Execute Action Queries and Stored Procedures. Using DAO Recordsets to Move Data from Excel to a Jet Database. Using ADO to Move Data from Excel to a Database. Looking Ahead.

Index.

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)