Excel for Accountants, Second Edition

With updated content on Excel 2007 and 2010 as well as new features on QuickBooks, this guide makes it easy for accounting professionals to manipulate and sort financial data. Comprehensive but concise chapters explain how to automate the entry of common business formulas; how to use pivot tables to extract details; how to develop inventory, depreciation, and financial summaries; and how to set up other standard financial calculations required for business plans, pro-formas, and complicated tax issues. Providing accountants with advanced skills to better serve their clients, this accessible reference also includes details on Excel lists, worksheets, and charts.