(KH1783) Excel Functions and Charts

Author: Li Chao
Publisher:
Publish Date: 2006-11-01
Features: Many readers find that the Excel applications they truly need in actual work are far more complex than what introductory books describe. They must master advanced tools like Excel functions, charts, and others. However, in further learning, they discover it's difficult to find example books specifically dedicated to advanced Excel functions, charts, and analysis tools. This book is written to address these frustrations. It consists of three major themes. The first part covers formulas in Excel 2003, as well as expressions, parameters, functions, and practical applications of nine built-in function categories: date and time, math, statistics, lookup and reference, database, text, logical, information, and financial. The second part provides detailed explanations of techniques, applications, and analysis of 12 major Excel 2003 chart types, including bar charts, column charts, line charts, pie charts, XY scatter charts, area charts, doughnut charts, radar charts, surface charts, bubble charts, and stock charts. The third part focuses on the comprehensive application of functions and charts. At the end of each chapter and the final chapter of the book, comprehensive examples are arranged, making them the best choice for Excel beginners to improve their application skills.