Welcome to our completely free business
resource. Below we have listed free downloads with spreadsheet
examples containing spreadsheet tips and excel formulas by business
If you are routinely using spreadsheets to run your business or help you get round
the limitations of your current software, you may be interested
in finding out more about bespoke software and
bespoke software pricing.
Join our mailing list to receive updates when new free downloads are added. Fill in the sign-up box on the
right hand side of this page. If the topic or
situation you are concerned with is not listed in the
table, please contact
us to suggest it as a future topic.
Quickly give your customer an accurate price depending
on their category with this multi-layered discount tool.
Discounts are calculated from the previous band of discount, i.e.
the distributor price is a percentage reduction on the
Flagging Late Payments using a nested IF statement
A nested IF statement, is an IF statement within an IF statement. This allows you
to query your data by several criteria. In this example, we look at a list of sales
orders and flag up those which are late on being paid.
Extract a list of company websites from email addresses using Concatenate, Find, Length & Mid
Automate data entry by using Excel's in-built text functions. This tutorial
shows you how to extract company website addresses from email addresses using
Concatenate, Find, Length & Mid. If you have a lot of these to do, this
tutorial can save you days.
Sales by Supplier Tool - Showing No of Sales, Value of Sales and Average Sale.
In this free download allows you enter Supplier and Product Information
along with sales figures and it calculates No of Sales, Value of Sales and Average Sale
by supplier for you. Ideal information to have when preparing for a review
with a supplier.
VAT Calculator - a free, downloadable spreadsheet from Working Data
The VAT calculator allows you to precisely calculate prices before and after VAT
with two different VAT rates for thousands of records, all in one go. The VAT
calculator is a free, downloadable spreadsheet from Working Data.