Excel 2002 Advanced Applications: Financial and Accounting

Author: Wang Xiaomin
Publisher:
Publish Date: 2003-04-01
Features: This book introduces the advanced features of Excel 2002 and their applications in the financial and economic fields. The book is divided into three parts, with a total of 16 chapters. The first part provides a concise introduction to the Excel 2002 software and fundamental knowledge of finance and economics. The second part elaborates in detail on six advanced features of Excel 2002, namely data processing, reports and charts, hypothesis analysis, statistical analysis, forecasting techniques, and macros and programming. The third part covers six specialized topics on the application of Excel 2002 in finance and economics, including general financial calculations, investment analysis principles, stock investment, bond investment, financial analysis and decision-making, and corporate operations management. The book emphasizes the general principles of broad financial calculations and decision analysis, moving beyond narrow accounting concepts and focusing on uncovering some overlooked financial analysis methods and tools in Excel. The content is somewhat ahead of its time. This book is aimed at various types of managers and individual readers, rather than professional financial personnel. It is suitable for reading by managers in various fields within enterprises and also provides some help for personal financial management. At the same time, it can also serve as teaching material and reference books for training and advanced courses for managers in various fields.