Excel Solutions for Accountants Series
Practical Toolbox Approach
These series of books with chosen topics that are of direct interest and relevance to accountants. The books are a general series aimed at accountants who know that Excel can be made to do a lot more than it does but they just doesn’t know what that might be.
These will give you straightforward examples based on real world but non complex data so that you come to learn the techniques and functions rather than worrying about the complexity of the data and the solution.
Book One: Excel Tables, Depreciation, Ratio Analysis 1, Graphs 1, Pivot Tables 1
Book Two: Compound Interest and Discounting: the time value of money, Data Validation and Form Controls, Ratio Analysis 2, Graphs 2, Pivot Tables 2
Book Three: Dashboarding, Pivot Tables 3, Forecasting, Budgeting, Aggregate, OFFSET and SOLVER
Book Four: Graphs 4, Compound Interest 2, Data and Time Functions, Forecasting 2, Functions, New Functions, Pivot Tables 4 Power Query and Power Pivot, Statistics: explanatory models
An easy-to-follow guide on how to improve productivity using Excel Solutions, Techniques, Functions and Templates may be bundled with live workshops.