Excel Solutions for Accountants: Book 3

  • 1 Want to read
  • 0 Currently reading
  • 0 Have read
Not in Library

My Reading Lists:

Create a new list

Check-In

×Close
Add an optional check-in date. Check-in dates are used to track yearly reading goals.
Today

  • 1 Want to read
  • 0 Currently reading
  • 0 Have read

Buy this book

Last edited by ISBNbot2
August 22, 2020 | History

Excel Solutions for Accountants: Book 3

  • 1 Want to read
  • 0 Currently reading
  • 0 Have read

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
Publisher
Bookboon.com

Buy this book

Edition Availability
Cover of: Excel Solutions for Accountants: Book 3
Excel Solutions for Accountants: Book 3
2015, Bookboon.com

Add another edition?

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

ID Numbers

Open Library
OL25706980M
ISBN 13
9788740310344

Links outside Open Library

Community Reviews (0)

Feedback?
No community reviews have been submitted for this work.

Lists

This work does not appear on any lists.

History

Download catalog record: RDF / JSON / OPDS | Wikipedia citation
August 22, 2020 Edited by ISBNbot2 normalize ISBN
July 2, 2015 Edited by Alice Kirk Edited without comment.
July 2, 2015 Edited by Alice Kirk Added new cover
July 2, 2015 Created by Alice Kirk Added new book.