An edition of Excel Solutions for Accountants: Book 3
(2015)
Excel Solutions for Accountants: Book 3
by Duncan Williamson
- 1 Want to read
Share
×Close
Last edited by Alice Kirk
July 2, 2015 | History
This is the third in a series of three books with the title of Excel Solutions for Accountants: written after a career in the world of accounting, education and training: in which we have seen first hand what accountants know, what they think they know and what they don’t know.
You can download the book via the link below.
Publish Date
2015
Publisher
Bookboon.com
Check nearby libraries
Buy this book
| Edition | Availability |
|---|---|
1
|
aaaa
|
Book Details
Table of Contents
Content
1. Introduction
2. Accountant Specific 3
2.1. To Merge or not to Merge?
2.2. Creating a Population Pyramid Style Chart
2.3. Solving Simultaneous Equations with Excel
2.4. Three Ways of Solving Simultaneous Equations
2.5. SOLVER and the Scenario Manager Again?
3. Dashboarding
3.1. PPP: paper, pencil, plan
3.2. Dashboard One
3.3. Dashboard Two
3.4. Hyperlinks
3.5. Dashboard Three
4. Pivot Tables 3
4.1. Slicers
4.2. Timelines
4.3. Combine Slicer and Timeline
4.4. Conditional Formatting
4.5. Pivot Charts
5. Forecasting
5.1. Forecasting Costs
5.2. Statistical Forecasting
6. Budgeting
6.1. Definition
6.2. Budget One
6.3. Budget Two
6.4. Budget Three
6.5. Budget Four
6.6. Budget Five
6.7. Budget Six
6.8. Autocorrelation, Bias and Outliers
6.9. The Budget
7. Aggregate, Offset, Solver
7.1. Aggregate Function Templates
7.2. The Offset function
7.3. The OFFSET Function in Action
7.4. Further OFFSET() Examples
7.5. Solver
Edition Identifiers
Work Identifiers
Links outside Open Library
Community Reviews (0)
| July 2, 2015 | Edited by Alice Kirk | Edited without comment. |
| July 2, 2015 | Created by Alice Kirk | Added new book. |