Excel for accountants - Carlberg, Conrad George (CPA911 Pub., 2007)
Includes index
Accounting professionals learn how to get the information they need fast with this guide to Excel features that 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
Using lists in Excel -- Pivot tables -- Common sizing using worksheets -- Charting -- Tools for accountants -- Scenarios in Excel -- Payment functions -- Excel's depreciation functions -- Excel and QuickBooks -- Appendix A : From the web to Excel