Home > Store > Computer Software > Business Office Software > Spreadsheet Software > Microsoft Excel

Managing Data with Excel

Register your product to gain access to bonus material or receive a coupon.

Managing Data with Excel

Best Value Purchase

Book + eBook Bundle

  • Your Price: $41.79
  • List Price: $67.98
  • About Adobe DRM eBooks
  • This eBook requires the free Adobe® Digital Editions software.

    Before downloading this DRM-encrypted PDF, be sure to:


    • Install the free Adobe Digital Editions software on your machine. Adobe Digital Editions only works on Macintosh and Windows, and requires the Adobe Flash Player. Please see the official system requirements.
    • Authorize your copy of Adobe Digital Editions using your Adobe ID (select AdobeID as the eBook vendor). If you don't already have an Adobe ID, you can create one here.

More Purchase Options

Book

  • Your Price: $31.99
  • List Price: $39.99
  • Usually ships in 24 hours.

eBook (Adobe DRM)

  • Your Price: $22.39
  • List Price: $27.99
  • About Adobe DRM eBooks
  • This eBook requires the free Adobe® Digital Editions software.

    Before downloading this DRM-encrypted PDF, be sure to:


    • Install the free Adobe Digital Editions software on your machine. Adobe Digital Editions only works on Macintosh and Windows, and requires the Adobe Flash Player. Please see the official system requirements.
    • Authorize your copy of Adobe Digital Editions using your Adobe ID (select AdobeID as the eBook vendor). If you don't already have an Adobe ID, you can create one here.

Description

  • Copyright 2004
  • Dimensions: 7-3/8" x 9-1/8"
  • Pages: 384
  • Edition: 1st
  • Book
  • ISBN-10: 0-7897-3100-2
  • ISBN-13: 978-0-7897-3100-5
  • eBook (Adobe DRM)
  • ISBN-10: 0-7686-6572-8
  • ISBN-13: 978-0-7686-6572-7

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.

Downloads

Downloads

All the samples developed for the book in one convenient file for download - 358 kb -- Samples.zip

Sample Content

Online Sample Chapters

Excel's Lists, Names, and Filters

Excel's Lists, Names, and Filters

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.

Updates

Submit Errata

More Information

ONE MONTH ACCESS!

WITH PURCHASE


Get unlimited 30-day access to thousands of Books & Training Videos about technology, professional development and digital media If you continue your subscription after your 30-day trial, you can receive 30% off a monthly subscription to the Safari Library for up to 12 months.