Mastering Excel 2003 Data Management (Chinese Version)

Author: (USA) Carl
Publisher:
Publish Date: 2005-09-01
Features: Excel is an excellent analysis and correction engine, but it is not a database management program. True databases provide good methods for storing and retrieving data, but they are relatively weak in analysis and graphical display. "Excel 2003 Data Management (Chinese Edition)" will demonstrate how to balance these two aspects. If you want to store data in Excel, you will see how to create your own worksheets to fully utilize Excel's functions, pivot tables, charts, and list management tools. However, many types of data are not suitable for storage in Excel, so external data sources are often required. This book will guide you step-by-step through the entire process of importing data into Excel—where its tools can be fully leveraged—allowing you to see the patterns and relationships revealed by the raw data. You will also learn how to manage data in external databases—moving it from Excel to the database, editing it within the database, and returning it from the database—all within the Excel platform.
· Effective worksheet layout
· Worksheet functions for data management
· Using list filtering and sorting to manage data
· Importing and refreshing data from external data sources
· Microsoft Query VBA tips
· Building database tables and queries
· Creating external databases from Excel
· Using ADO and DAO to exchange data between Excel and databases
This book is aimed at intermediate readers with some foundation in Excel and database operations. Its purpose is to provide users with the necessary tools to help them decide how to store their data—whether to use Excel or a database management system like Access—and how to make the best choice. The book is written in clear and easy-to-understand language, supplemented by numerous examples and case studies. Through this book, readers will be able to manage their data more effectively.