Mastering Excel Chart Formula Function Tricks: 600 Tips

Author: Zhang Falin
Publisher:
Publish Date: 2006-02-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 diagram editing techniques; Chapter 5 introduces Excel formula editing techniques; Chapter 6 discusses function editing and the application of logical functions; Chapter 7 presents text function application techniques; Chapter 8 covers time and date function application techniques; Chapter 9 introduces mathematical and trigonometric function application techniques; Chapter 10 discusses financial function application techniques; Chapter 11 covers statistical function application techniques; Chapter 12 introduces database and information function application techniques; Chapter 13 presents application techniques for other commonly used functions (including lookup functions and engineering functions, etc.). The book is well-organized and highly practical, using a combination of text and visuals for explanations. It is suitable for office personnel who have some familiarity with Excel and wish to use its charts, formulas, and functions to process and analyze data, thereby improving work efficiency.