Mastering Excel Charts, Formulas, and Functions: 600 Tips and Tricks

Author: Zhang Falin
Publisher:
Publish Date: 2006-02-01
Features: This book primarily introduces application techniques for Excel charts, formulas, and functions, covering 11 categories of functions, 20 types of charts, and their usage and creation methods. 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 presents function editing and logical function application techniques; Chapter 7 covers text function application techniques; Chapter 8 introduces 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 covers database and information function application techniques; Chapter 13 presents 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 illustrations for explanations. It is suitable for office personnel who have some familiarity with Excel and wish to utilize its charts, formulas, and functions to process and analyze data, thereby improving work efficiency.