Excel Solutions for Accountants: Book 1
Publisher: Bookboon.com
Published: 2015
ISBN-13: 9788740310320
Table of contents: title: Content; title: 1. Introduction; title: 2. Accountant Specific 1; title: 2.1. Custom Formatting: I didn’t know it could do THAT!; title: 2.2. Goal Seek Car Loan; title: 2.3. Countif And Countifs; title: 2.4. Shopping List; title: 2.5. Monthly Financial Ratios; title: 2.6. Piece Work Analysis; title: 2.7. How to Highlight the Y Axis?; title: 3. Tables; title: 3.1. Definitions; title: 3.2. Lists; title: 3.3. Let’s Use Lists; title: 3.4. Creating Excel Tables; title: 4. Depreciation; title: 4.1. Definitions; title: 4.2. Depreciation Methods and Calculations; title: 5. Ratio Analysis 1; title: 5.1. Template Approach; title: 5.2. The Financial Statements and their Source; title: 5.3. The Ratios: formulas/definitions; title: 5.4. Template Part 1: layout and fundamentals; title: 5.5. Template Part 2: the ratios; title: 5.6. data_working; title: 5.7. ratios_change; title: 5.8. common_size; title: 5.9. Income Statement; title: 5.10. Balance Sheet; title: 5.11. Statement of Cash Flow; title: 5.12. Graphics; title: 5.13. XY Scatter Graph; title: 6. Graphs 1; title: 6.1. Basic Graphs; title: 6.2. Multi Category Axis Chart; title: 6.3. Graphs Linked to an Excel Table; title: 6.4. Histograms; title: 6.5. Same Data Different View; title: 6.6. Pareto Graph; title: 6.7. Combo Box Controls your Graphs; title: 6.8. Sparklines; title: 7. Pivot Tables 1; title: 7.1. Definition; title: 7.2. Start with a List; title: 7.3. Create a Pivot Table; title: 7.4. Formatting a Pivot Table; title: 7.5. Layout of a Pivot Table; title: 7.6. Subtotals; title: 7.7. FILTERS (Page Fields) and Pivot Table Layout; title: 7.8. Let’s Improve: FILTERS; title: 7.9. Add More Fields