Excel 2002 Formulas and Functions Application Bible

Author: Wayne Winston
Publisher:
Publish Date: 2002-07-01
Features: This book discusses one of the most powerful tools in Excel 2002: formulas. The author uses numerous examples and in-depth analysis during the explanation, allowing readers to personally experience the methods and techniques of using formulas. To further demonstrate the excellent performance of formulas, the book includes two chapters showcasing their capabilities in financial processing. The book provides detailed introductions to various techniques such as handling dates, performing table lookups, and creating array formulas. This in-depth guidance will help you master advanced Excel techniques and become an Excel expert. Excel 2002 is one of the components of Office XP and is Microsoft's latest spreadsheet software. This book introduces the new version of Excel 2002 and the most powerful tool in spreadsheets—formulas. It focuses on explaining various formulas and functions that can be used in spreadsheets, including formulas for processing data and text, logical formulas, financial formulas, array formulas, charts and pivot tables, macros, and custom functions created with VBA. It also covers methods and tools for debugging formulas. The book includes numerous examples to help readers understand the application of these formulas and techniques. Through studying this book, you can master the essence of Excel, create beautiful and practical spreadsheets, and become an Excel expert. Target Audience: Excel software users, office computer users, and intermediate to advanced computer enthusiasts.