Excel Corporation Data Management and Analysis

Author: Hengshengjie Information
Publisher:
Publish Date: 2006-12-01
Features: The book consists of 18 chapters. The first three chapters introduce the basic knowledge of Excel 2003, the fundamentals of formulas and functions in Excel 2003, and the charting capabilities in Excel 2003. From the 4th to the 18th chapters, various methods and techniques for data processing, data statistics, and data analysis using Excel are introduced through typical examples. The book focuses on the basic operations and advanced applications of creating various charts using the Chart Wizard, covering 14 standard chart types and some custom charts. Through step-by-step operations in the examples, readers can master the powerful functions of charts. Functions and formulas are also one of the highlights of this book. Readers can use the rich functions in Excel to solve many calculation problems, and these functions are categorized by functionality, making it easy for readers to find the functions they need to learn and apply. Additionally, the book provides detailed analysis of practical techniques for data analysis tools such as PivotCharts, the Analysis ToolPak, Goal Seek, Data Tables, Scenario Analysis, and Solver.