Excel data processing and analysis

Author: Li Jibing
Publisher:
Publish Date: 2006-01-01
Features: This book is designed to closely integrate its content with the actual work of decision-makers in enterprises, economic management, and engineering management personnel. It is suitable for multiple versions of Excel 2000/2002/2003. Authored by a renowned domestic Excel expert, the book provides a detailed explanation of Excel functions and various methods and techniques for editing, querying, categorizing, summarizing, analyzing, processing, and formatting data in different fields. The book's features include: clear organization, illustrated content, covering basic knowledge, common cases, comprehensive applications, and practical techniques. By comprehensively utilizing Excel's functions, it delves into different methods and techniques for data analysis and processing. The data processing methods and demonstration examples cited are derived from real-world work and have high practical value. The content is easy to understand and can be learned effortlessly even without prior knowledge of Excel spreadsheets and related software. The accompanying CD-ROM includes chapter example materials, final effect files, and answers to chapter exercises, as well as Excel templates, upgrade patches, and related reference materials to help readers learn more efficiently. This book is meticulously planned by a renowned domestic Excel application and training expert, specifically written for users who wish to delve deeper into Excel functions, formulas, macros, VBA, and other features. It presents Excel's efficient application methods in different fields from a fresh perspective, serving as an excellent example of combining theory with practical work. The book's unique feature is that it enables readers who may lack systematic knowledge of mathematics, statistics, engineering management, or econometrics, or who have not received computer programming training, to conveniently analyze data from their daily work and visually express complex economic and engineering problems using Excel's graphics.