Dictionary of Excel Functions and Formulas

Author: (Japan) Hiromiko Hikari
Publisher:
Publish Date: 2007-02-01
Features: Functions are an important feature in Excel, but many people are unaware of the specific functions and usage of functions, or only have a superficial understanding. This book aims to unveil the mystery of functions and help you use functions to solve problems in work and study. It also enables you to master the powerful capabilities of functions in practical applications across various fields. The book is categorized by function functionality and includes many functions that are often overlooked. Whether you are a beginner or an expert who frequently uses Excel, this book can serve as an excellent reference for effectively applying Excel functions, addressing various questions you may encounter while learning functions.
The book is divided into 12 parts, providing a thorough explanation of 344 functions categorized by functionality. It includes 11 of the most frequently used function categories. However, it does not simply explain knowledge points; instead, it combines function knowledge with classic examples from various fields such as administration, engineering, finance, and statistics. This allows readers not only to learn how to operate functions but also to improve their ability to process, analyze, and manage data using functions. Additionally, the book includes more than 500 function reverse lookup techniques.
The book provides step-by-step learning with illustrations to facilitate gradual understanding, ensuring that beginners can learn smoothly. For intermediate and advanced readers who frequently use functions—such as business managers, data analysts, financial professionals, statisticians, and marketers—the book covers almost all functions, enabling them to learn functions more comprehensively and apply them in a more integrated manner.