Excel Advanced Financial and Accounting Applications

Author: Lü Zhiming
Publisher:
Publish Date: 2007-01-01
Features: This book includes 10 chapters. Chapter 1 provides a comprehensive and in-depth introduction to Excel fundamentals, with examples highlighting key functions, data management features, hypothetical analysis features, and dynamic charting features for designing financial models. Chapter 2 introduces the basic knowledge of VBA and explains its application in model design through a complete example. VBA knowledge is essential for designing flexible and practical financial models, and readers can selectively study it based on their needs. Chapters 3 to 10, building on the previous chapters, detail the design of common financial models such as payroll management models, financial analysis models, investment decision models, working capital management models, financing decision models, financial forecasting models, financial budgeting models, financial analysis models, and profit planning models. In terms of depth, this book can serve as a textbook for graduate, undergraduate, and vocational courses. In terms of breadth, it is not only suitable for accounting and financial management majors but also for management and economics majors, and can also be used as a training textbook for follow-up education for financial professionals. The VBA knowledge in this book is specifically tailored for accounting informatization majors, and places involving VBA in model design will be marked with an asterisk (). Other majors can selectively study it based on their actual situation.