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.
Conrad Carlberg is president of Network Control Systems, Inc., a consulting firm specializing in the development of quality control and forecasting tools. He is a multiple recipient of Microsoft's Excel's Most Valuable Professional award and the author of Business Analysis: Microsoft Excel 2010 and Excel Sales Forecasting for Dummies. He lives in Carlsbad, California.