Excel (2000/2002/2003) Function Application Secrets

Author: Wang Chengchun / Xiao Yayun (editors)
Publisher:
Publish Date: 2005-01-01
Features: This book features: 12 categories, 340+ function examples discussed; practical and applied design of custom functions; examples illustrated with graphics and text; basic framework of Office VBA application; clear index classification for easy reference. Excel is a spreadsheet software with a wide range of applications and is an indispensable tool in daily use. The new Excel 2003 provides over 340 functions, covering various application areas including statistics, finance, information, engineering, logic, database, lookup and reference, date and time, text, and mathematical and trigonometric functions. This book introduces functions by category, with examples and illustrations to facilitate learning and application. In addition to the detailed introduction of each function through examples, it also covers knowledge related to custom functions and simple VBA. The content of this book is comprehensive, making it a necessary reference for office applications.