Flylib.com
Managing Data with Microsoft Excel
Managing Data with Microsoft Excel
ISBN: 789731002
EAN: N/A
Year: 2003
Pages: 134
BUY ON AMAZON
Managing Data with Microsoft Excel
Table of Contents
Copyright
About the Author
Acknowledgments
We Want to Hear from You
Introduction
About Excel
How to Use This Book
Part I: Pitfalls in Data Management
Chapter 1. Misusing Excel as a Database Management Tool
Putting Data Management into Context
CASE STUDY Overworking Functions
Transposing Rows and Columns
Using Labels Instead of Codes
Handling Variable Numbers of Records per Category
Changing Horses
Part II: Managing Data Inside Excel
Chapter 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
Chapter 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
Part III: Managing External Data from Inside Excel
Chapter 4. Importing Data: An Overview
Getting External Data into the Workbook
CASE STUDY
Importing Data to Pivot Tables
Looking Ahead
Chapter 5. Using Microsoft Query
Understanding
Querying Multiple Tables
CASE STUDY
Joining Parent and Child Records
Using Database Queries
Handling the Data Range
Managing Boolean Fields and Check Boxes
Looking Ahead
Chapter 6. Importing Data: Further Considerations
Understanding Pivot Tables
Preparing Data for Pivot Tables
Using Criteria with Microsoft Query
Querying Web Sites
Looking Ahead
Part IV: Managing Databases from Inside Excel
Chapter 7. VBA Essentials Reviewed
Using VBA to Manage Data
Establishing Subroutines
Understanding Dot Notation
Using Loops
CASE STUDY
Using With Blocks
Understanding the Macro Recorder s Code
Using Object Variables
Looking Ahead
Chapter 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
Chapter 9. Managing Database Objects
Creating Tables
Defining Fields
Creating Queries
CASE STUDY
CASE STUDY
Looking Ahead
Chapter 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
CASE STUDY
Declaring and Using Recordsets
Understanding DAO Recordset Types
Understanding ADO Recordset Types
Looking Ahead
Chapter 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
Chapter 12. Controlling a Database from Excel Using ADO and DAO
Using DAO to Execute Action Queries
CASE STUDY
Using ADO to Execute Action Queries and Stored Procedures
CASE STUDY
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
index_SYMBOL
index_A
index_B
index_C
index_D
index_E
index_F
index_G
index_H
index_I
index_J
index_K
index_L
index_M
index_N
index_O
index_P
index_Q
index_R
index_S
index_T
index_U
index_V
index_W
index_X
Managing Data with Microsoft Excel
ISBN: 789731002
EAN: N/A
Year: 2003
Pages: 134
BUY ON AMAZON
VBScript Programmers Reference
What VBScript Is and Isn™t!
Server-Side Web Scripting
Appendix A VBScript Functions and Keywords
Appendix G The Windows Script Host Object Model
Appendix J VBA Features not in VBScript
Information Dashboard Design: The Effective Visual Communication of Data
Typical Dashboard Data
Understanding the Limits of Short-Term Memory
Eloquence Through Simplicity
Design for Use as a Launch Pad
Sample Sales Dashboard
AutoCAD 2005 and AutoCAD LT 2005. No Experience Required
Getting to Know AutoCAD
Basic Commands to Get Started
Controlling Text in a Drawing
Using Layouts to Set Up a Print
Printing an AutoCAD Drawing
802.11 Wireless Networks: The Definitive Guide, Second Edition
11 Nomenclature and Design
Association
Differential Phase Shift Keying (DPSK)
Windows Computer Authentication
Authentication and Access Control
Lean Six Sigma for Service : How to Use Lean Speed and Six Sigma Quality to Improve Services and Transactions
Success Story #3 Fort Wayne, Indiana From 0 to 60 in nothing flat
Success Story #4 Stanford Hospital and Clinics At the forefront of the quality revolution
Phase 3 Mobilization
First Wave Service Projects
Raising the Stakes in Service Process Improvement
Comparing, Designing, and Deploying VPNs
L2TPv3 Pseudowire Operation
Designing QoS for IPsec VPNs
Designing and Building SSL Remote Access VPNs (WebVPN)
Using Clientless SSL Remote Access VPNs (WebVPN) on the Cisco VPN 3000 Concentrator
Strengthening SSL Remote Access VPNs Security by Implementing Cisco Secure Desktop
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies