Application Analysis of Excel in Financial Accounting

Author: Wang Chengchun Xiao Yayun
Publisher:
Publish Date: 2005-06-01
Features: This book comprehensively introduces the application methods of Excel in financial accounting with abundant examples and detailed steps. It is divided into 11 chapters, covering topics such as accounting principles, the establishment and application of ledgers, income statements, balance sheets, bill management applications, key functions of Excel, account management, fixed asset depreciation management, sales management, payroll management, mail merge and printing, and financial management. The examples in the book are easy to understand. To help readers quickly grasp how to use Excel effectively in accounting, the book uses over 400 "original journal entries" as examples. In reality, a single worksheet can be applied to more than 8,000 or even more entries. In the examples, the original journal entries can be broken down into "ledger detail tables" for 31 accounting categories within about 2 minutes. The ledger detail tables include titles, summaries, balances, and debit/credit checks.