Custom Excel Spreadsheets

Although our Excel template development service is available to members, there are probably times you need a more specific custom spreadsheet service... those are the times the team at SpreadsheetsByEmail can help!

SpreadsheetsByEmail is headed up by Glen Feechan ACA, a qualified Chartered Accountant that understands your needs. Glen has presented numerous courses on custom reporting using Pivot Tables, and has extended his services with custom excel spreadsheet services.

So what do you get as a member?

SpreadsheetsByEmail will provide all of our members with their Introduction to Pivot Tables video training course when any spreadsheet work is undertaken!

Introduction to Pivot Tables

The training course consists of:

5 tutorial videos
28-page supporting manual
15 minute video interview discussing real world application

and you will learn:

How to create a basic pivot table to manipulate large chunks of data;
How to modify your pivot table to present and summarise the data however you want;
How to add information from outside the pivot table/source data;
How to provide more detailed analysis of your data;
Invaluable insights into real world applications from an experienced consultant.

In addition to this, when undertaking custom spreadsheet work with SpreadsheetsByEmail our Platinum Members will receive the Advanced Pivot Tables video training course, plus a 10% discount on all custom spreadsheet services!

Advanced Pivot Tables

The training course consists of:

5 tutorial videos
24-page supporting manual
Example spreadsheets
20 minute video interview discussing real world application

and you will learn:

How to use lookup formulae to combine data from multiple sources for your pivot table;
How to use calculated fields and items;
How to manipulate the layout of a pivot table;
How to use Pivot Charts;
How to extract information from pivot tables to populate complex reports, including a method of reducing management accounts production from trial balance to two clicks of the mouse;
Invaluable insights into real world applications from an experienced consultant.