EXCEL2002 Advanced Applications -- Financial and Accounting

Author: Wang Xiaomin
Publisher:
Publish Date: 2003-04-01
Features: This book introduces the advanced functions of Excel 2002 and their applications in the financial and economic field. 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 the fundamental knowledge of finance and economics. The second part elaborates in detail on six advanced functions of Excel 2002, namely data processing, reports and charts, hypothesis analysis, statistical analysis, forecasting techniques, and optimization 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. This book emphasizes the general principles of broad financial calculations and decision-making analysis, moving beyond narrow accounting concepts and focusing on uncovering some overlooked financial analysis methods and tools in Excel. The content is designed to be somewhat ahead of its time. This book is aimed at various 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 in personal financial management. At the same time, it can also serve as a teaching material and reference book for training and advanced courses for managers in various fields.