Managing Data with Excel

bull; Author is an Excel data management expert who provides tips users can't find elsewhere. bull; Teaches data management features and functions in Excel including moving data and automating data storage. bull; Explains how to be efficient in importing data into worksheets and pivot tables. bull; Each chapter includes a case study illustrating the topics for real world use.

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.

Introduction: About Excel How to Use This Book
Pitfalls in Data Management
Misusing Excel as a Database Management ToolPutting Data Management into ContextOverworking FunctionsTransposing Rows and ColumnsUsing Labels Instead of CodesHandling Variable Numbers of Records per CategoryChanging Horses
Managing Data Inside Excel
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
Excel's Lists, Names, and Filters
Creating Lists
Sorting Lists
Working with Names
Filtering Data with the AutoFilter
Using the Advanced Filter
Looking Ahead
Managing External Data from Inside Excel
Importing Data: An Overview
Getting External Data into the Workbook
Importing Data to Pivot Tables
Looking Ahead
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
Importing Data: Further Considerations
Understanding Pivot Tables
Preparing Data for Pivot Tables
Using Criteria with Microsoft Query
Querying Web Sites
Looking Ahead
Managing Databases from Inside Excel
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
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
Managing Database Objects
Creating Tables
Defining Fields
Creating Queries
Looking Ahead
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
Getting Data from Access and into Excel with ADO and DAO
Using Copy From Recordset
Building an Application
Bringing Data Back from a Parameterized Query
Returning Data from a Database to a User Form
Looking Ahead
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.
Table of Contents provided by Publisher. All Rights Reserved.

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

FREE SHIPPING

Amazon no longer offers textbook rentals. We do!

Managing Data with Excel

Summary

Author Biography

Table of Contents

Supplemental Materials