Excel and Data Processing (Second Edition)

Author: Du Maokang, Liu Yanbing, Yuan Hao (editors)
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 subtotaling of worksheet data;
Data calculation and analysis functions such as data auditing, single-variable solving, simulation, scenario analysis, and solver;
Program design functions such as Excel's interaction with external data, macros and VBA programming, as well as forms and menus.
This book is easy to understand, rich in content, emphasizing 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 a textbook 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.