Excel for Accountants: Tips, Tricks, & Techniques

Description

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.

CONTENTS:

Chapter 1: Using Lists in Excel
Chapter 2: Pivot Tables
Chapter 3: Common Sizing Using Worksheets
Chapter 4: Charting
Chapter 5: Tools for Accountants
Chapter 6: Scenarios in Excel
Chapter 7: Payment Functions
Chapter 8: Excel's Depreciation Functions
Chapter 9: Excel and QuickBooks
Appendix A: From the Web to Excel
Index