Excel functions, charts, and data analysis

Author: Chen Jie
Publisher:
Publish Date: 2005-10-01
Features: Comprehensive and rich, a reference book for learning and querying. Detailed and in-depth, a loyal companion for applying knowledge. Ready for use anytime, a tool treasury for Excel masters. This book is primarily aimed at users who wish to delve deeper into Excel's formulas, functions, charts, and basic data analysis, helping readers fully master Excel's functions, charts, and basic data analysis methods.
Content: Covers all aspects of Excel's 9 major workbook functions, 11 major basic charts, and basic data analysis tools such as data tables.
Examples: Classic examples from popular fields are used to explain each function, chart, and data analysis method, ensuring representativeness and general applicability.
The book introduces Excel's functions, charts, and data analysis in a step-by-step manner, from basic to advanced. It consists of 20 chapters, divided into three parts: Functions, Data Analysis, and Comprehensive Examples.
Part 1 (Chapters 1-10) covers Excel's 9 major workbook functions, including formulas, dates, times, mathematics, statistics, lookup, reference, database, text, logic, information, and finance. Each function is detailed with its expression, parameters, functions, and reference examples.
Part 2 (Chapters 11-19) covers 12 major Excel basic charts, including bar charts, line charts, pie charts, XY scatter plots, area charts, doughnut charts, radar charts, surface charts, bubble charts, and stock charts. It also includes basic data analysis tools such as data tables, pivot tables, and solver.
Part 3 (Chapter 20) introduces multiple comprehensive examples, combining the basic content covered earlier.
The book's greatest feature lies in its carefully selected examples for each section, which are highly targeted and designed to help readers master basic parameters and usage techniques, enabling them to solve practical problems more flexibly.
This book is suitable for users of all versions of Excel, office computer users, and intermediate to advanced computer enthusiasts. It can also be used as a textbook for relevant professional courses.