Excel Solutions for Accountants: Book 3
Publisher: Bookboon.com
Published: 2015
ISBN-13: 9788740310344
Table of contents: title: Content; title: 1. Introduction; title: 2. Accountant Specific 3; title: 2.1. To Merge or not to Merge?; title: 2.2. Creating a Population Pyramid Style Chart; title: 2.3. Solving Simultaneous Equations with Excel; title: 2.4. Three Ways of Solving Simultaneous Equations; title: 2.5. SOLVER and the Scenario Manager Again?; title: 3. Dashboarding; title: 3.1. PPP: paper, pencil, plan; title: 3.2. Dashboard One; title: 3.3. Dashboard Two; title: 3.4. Hyperlinks; title: 3.5. Dashboard Three; title: 4. Pivot Tables 3; title: 4.1. Slicers; title: 4.2. Timelines; title: 4.3. Combine Slicer and Timeline; title: 4.4. Conditional Formatting; title: 4.5. Pivot Charts; title: 5. Forecasting; title: 5.1. Forecasting Costs; title: 5.2. Statistical Forecasting; title: 6. Budgeting; title: 6.1. Definition; title: 6.2. Budget One; title: 6.3. Budget Two; title: 6.4. Budget Three; title: 6.5. Budget Four; title: 6.6. Budget Five; title: 6.7. Budget Six; title: 6.8. Autocorrelation, Bias and Outliers; title: 6.9. The Budget; title: 7. Aggregate, Offset, Solver; title: 7.1. Aggregate Function Templates; title: 7.2. The Offset function; title: 7.3. The OFFSET Function in Action; title: 7.4. Further OFFSET() Examples; title: 7.5. Solver