Excel and data processing

Author: Du Maokang
Publisher:
Publish Date: 2005-10-01
Features: This book comprehensively introduces the powerful functions of Excel in data organization, management, calculation, and analysis. The main content includes: basic knowledge such as Excel data input, data formatting, array formulas, chart applications, functions, references, and names; data management functions such as sorting, searching, pivot tables, filtering, and subtotals; data calculation and analysis functions such as data auditing, single-variable solving, simulation, scenario analysis, and Solver; and programming functions such as Excel's interaction with external data, macros and VBA programming, as well as forms and menus. The book is easy to understand, rich in content, and emphasizes the combination of knowledge and practicality, with corresponding exercises at the end of each chapter. The book is equipped with abundant example resources, and readers can download them by visiting http://www.hxedu.com.cn. This book can be used as a textbook for office automation courses in universities, as well as for data analysis courses in majors such as economics and management, public finance and finance, and material statistics. It can also serve as a training manual for computer applications and office automation or as a reference book for office personnel.