Application of Excel in Data Management and Analysis

Author: Du Maokang
Publisher:
Publish Date: 2005-03-01
Features: This book comprehensively introduces the functions of Excel in data management and data analysis. The main content includes the input, viewing, categorization, summarization, sorting, searching, auditing, pivot, and printing of Excel worksheet data; formatting of data, cells, and worksheets; formulas and functions; chart analysis; variable solving; simulation operations; scenario analysis; solver; application of the analysis toolpak; data exchange and data analysis between Excel and external databases; macros; VBA programming; data security and protection. The book emphasizes practical knowledge, with detailed content and corresponding exercises for each chapter. It can be used as a textbook for relevant courses in office automation or data analysis for majors such as business administration, financial and fiscal, material statistics, and architectural design in higher education institutions. It can also serve as a training textbook for office automation and computer applications, as well as a reference book for office personnel.