Excel Solutions for Accountants: Book 2
Publisher: Bookboon.com
Published: 2015
ISBN-13: 9788740310337
Table of contents: title: Content; title: 1. Introduction; title: 2. Accountant Specific 2; title: 2.1. SUMPRODUCT v SUMIFS; title: 2.2. IFERROR(); title: 2.3. Trial Balance Using a Pivot Table; title: 2.4. Setting up the Pivot Table; title: 2.5. Preparing Financial Statements using Pivot Tables; title: 3. Compound Interest and Discounting: the time value of money; title: 3.1. Definitions; title: 3.2. Simple Interest Calculations; title: 3.3. Compound Interest Calculations; title: 3.4. Data Tables; title: 3.5. Let’s use the Compound Interest Factors; title: 3.6. Compounding Monthly or Weekly or Daily…Anything but Annually; title: 3.7. Excel’s Built in Finance Functions; title: 3.8. The True Cost of Giving and Receiving Credit: Annual Percentage Rate; title: 4. Data Validation and Form Controls; title: 4.1. Data Validation; title: 4.2. Linking your Lists; title: 4.3. Other Examples of Data Validation; title: 4.4. Form Controls; title: 4.5. Combo Box; title: 4.6. Scroll Bar; title: 4.7. List Box; title: 4.8. List Boxes Control and Instructions; title: 4.9. Check Box Control and Instructions; title: 5. Ratio Analysis 2: Statistical Analysis; title: 5.1. Reorganise some data; title: 5.2. Generate what are Called Descriptive Statistics; title: 5.3. Trendline Analysis; title: 5.4. Review the Function of a Straight Line in the Form Y = a + bX; title: 5.5. Consider Correlation Analysis; title: 6. Graphs 2; title: 6.1. Sparklines; title: 6.2. Panel Graphs; title: 6.3. Quadrant Graph; title: 6.4. Quadrant Graph with Scroll Bars; title: 6.5. Gantt Chart; title: 6.6. Waterfall Graph: Values; title: 6.7. Waterfall Graph %; title: 7. Pivot Tables 2; title: 7.1. Review; title: 7.2. Sales Report; title: 7.3. StDev #DIV/0!; title: 7.4. Profit Report; title: 7.5. Ratio Analysis: calculated fields; title: 7.6. Any Calculated Field you Like; title: 7.7. Value As; title: 7.8. Running Totals; title: 7.9. Difference From; title: 7.10. Grouping Data in a Pivot Table