Mastering Excel Chart Formulas and Functions: 600 Tips and Tricks

Author: Zhang Falin (Compiler)
Publisher:
Publish Date: 2006-01-01
Features: This book primarily introduces application techniques for Excel charts, formulas, and functions, covering 11 types of functions and the usage and creation methods of 20 types of charts. The book consists of 13 chapters. Chapters 1 and 2 introduce chart editing and operation techniques; Chapters 3 and 4 cover PivotTable, PivotChart, and chart editing techniques; Chapter 5 discusses Excel formula editing techniques; Chapter 6 covers function editing and logical function application techniques; Chapter 7 introduces text function application techniques; Chapter 8 presents time and date function application techniques; Chapter 9 discusses mathematical and trigonometric function application techniques; Chapter 10 covers financial function application techniques; Chapter 11 introduces statistical function application techniques; Chapter 12 discusses database and information function application techniques; Chapter 13 covers other commonly used function application techniques (including lookup functions and engineering functions, etc.). The book is well-organized, practical, and uses a (illustrated) format for explanations. It is suitable for office personnel who have some familiarity with Excel and wish to use Excel charts, formulas, and functions to process and analyze data, thereby improving work efficiency.