Excel Functions and Charts: A Practical Guide

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, it can be difficult to find example books specifically dedicated to advanced Excel tools such as functions, charts, and analysis on the market. 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 for 12 major Excel 2003 chart types, including column charts, bar 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.