Check nearby libraries
Buy this book
Last edited by Alice Kirk
July 1, 2015 | History
This is the second 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
Showing 1 featured edition. View all 1 editions?
Edition | Availability |
---|---|
1 |
aaaa
Libraries near you:
WorldCat
|
Book Details
Table of Contents
Content
1. Introduction
2. Accountant Specific 2
2.1. SUMPRODUCT v SUMIFS
2.2. IFERROR()
2.3. Trial Balance Using a Pivot Table
2.4. Setting up the Pivot Table
2.5. Preparing Financial Statements using Pivot Tables
3. Compound Interest and Discounting: the time value of money
3.1. Definitions
3.2. Simple Interest Calculations
3.3. Compound Interest Calculations
3.4. Data Tables
3.5. Let’s use the Compound Interest Factors
3.6. Compounding Monthly or Weekly or Daily…Anything but Annually
3.7. Excel’s Built in Finance Functions
3.8. The True Cost of Giving and Receiving Credit: Annual Percentage Rate
4. Data Validation and Form Controls
4.1. Data Validation
4.2. Linking your Lists
4.3. Other Examples of Data Validation
4.4. Form Controls
4.5. Combo Box
4.6. Scroll Bar
4.7. List Box
4.8. List Boxes Control and Instructions
4.9. Check Box Control and Instructions
5. Ratio Analysis 2: Statistical Analysis
5.1. Reorganise some data
5.2. Generate what are Called Descriptive Statistics
5.3. Trendline Analysis
5.4. Review the Function of a Straight Line in the Form Y = a + bX
5.5. Consider Correlation Analysis
6. Graphs 2
6.1. Sparklines
6.2. Panel Graphs
6.3. Quadrant Graph
6.4. Quadrant Graph with Scroll Bars
6.5. Gantt Chart
6.6. Waterfall Graph: Values
6.7. Waterfall Graph %
7. Pivot Tables 2
7.1. Review
7.2. Sales Report
7.3. StDev #DIV/0!
7.4. Profit Report
7.5. Ratio Analysis: calculated fields
7.6. Any Calculated Field you Like
7.7. Value As
7.8. Running Totals
7.9. Difference From
7.10. Grouping Data in a Pivot Table
ID Numbers
Links outside Open Library
Community Reviews (0)
Feedback?July 1, 2015 | Edited by Alice Kirk | Edited without comment. |
July 1, 2015 | Created by Alice Kirk | Added new book. |