Free Downloads of Business Spreadsheet Examples

• Discount Tool - Cumulative
• Discount Tool - Non Cumulative
• Emailing List Salutations
• Flagging Late Payments
• Google Analytics Spreadsheet Tool
• Mailing List Preparation
• Mileage Claim Tool
• Sales Analysis using Pivot tables
• Sales By Supplier
• Timesheet
• VAT Calculator
• VAT Calculator v2.0

-- Remember to virus-scan all files you download from the internet --

VAT Calculator v2.0

Version 2 of the VAT Calculator is simplified and streamlined making it even faster and easier to add or remove VAT from several figures simultaneously and in a spreadsheet you can save on your PC.
Download VAT Calculator v2.0. Or go to the VAT Calculator v2.0 Spreadsheet Tip.

Sales By Supplier Spreadsheet

This spreadsheet will calculate No of Orders, Total Order Value and Average Order Value for you based on simple inputs.
Download the Sales By Supplier Spreadsheet. Or go to the Sales By Supplier Spreadsheet Tip.

Mileage Claim Tool

This spreadsheet is a simple and accurate way to record and calculate your mileage claim.
Download the Mileage Claim Tool. Or go to the Mile Claim Tool Spreadsheet Tip.

Flagging Late Payments using Nested IF statements.

This spreadsheet contains the sample data and formula for using nested IF statements to flag up late payments..
Download the Flagging Late Payments Spreadsheet. Or go to the Flagging Late Payments Spreadsheet Tip.

Sales Analysis using Pivot Tables

This spreadsheet contains the sample data and Pivot Table used in the Spreadsheet Tip entitled Sales Analysis using Pivot Tables.
Download the Sales Analysis using Pivot Tables spreadsheet. Or go to the Sales Analysis using Pivot Tables Spreadsheet Tip.

VAT Calculator

This spreadsheet contains two tabs. One for Adding VAT and one for Removing VAT. The example used for Adding VAT, is to show the difference in a trade price (business to business) when the VAT rate changes from 15% to 17.5%. The example used for Removing VAT is to see how the prices without VAT change in a VAT rate change, when you want the same final price. Download the VAT Calculator Spreadsheet. Or go to the VAT Calculator Spreadsheet Tip

Google Analytics Spreadsheet Tool

The spreadsheet is colour coded. Sheets which have green tabs are where we paste in data from Google Analytics. The sheets with blue tabs show the automatically produced charts displaying the compiled information. The last five tabs in dark grey contain some background information it is best to leave alone. The tutorial below will take you through how to use each section. (If you are using a version of Excel which does not support coloured tabs, the first three tabs after the 'Welcome' page are for data entry and are named 'visitor_data', 'keyword_data' and 'referrer_data').

There are a few macros contained within the spreadsheet which support some of the automation. Within Excel, you can set whether to enable or disable these macros. If the push buttons on the data entry sheets are not working, the macro security level is set to high. If you reset it to medium (Tools menu > Macro > Security) and re-open the spreadsheet, you will then be given the choice of whether to enable or disable the macros.
Click here to download the Google Analytics Tool.

Mailing List Preparation

This spreadsheet contains the formula for removing full stops at the end of email addresses, in the context of preparing an e-mailing list.
Click here to download the Mailing List Preparation Tool.

Emailing List Salutations

This spreadsheet contains the formula generating salutations whether there is a first name or not. First names are used if possible, otherwise the more formal salutation is used, e.g. Mr Smith.
Click here to download the Emailing List Salutations Tool.

Timesheet

This spreadsheet contains a simple Excel timesheet which allows you to calculate your weekly billings whether you use an hourly or daily rate.
Click here to download the Timesheet.

Discount Tool - Non-Cumulative

This spreadsheet contains an Excel discount tool which allows you to quickly give your customer a price depending on their category.
Click here to download the Discount Tool (Non-Cumulative).

Discount Tool - Cumulative

This spreadsheet contains an Excel discount tool which allows you to quickly give your customer a price depending on their category. Discounts are applied cumulatively across multiple bands of discount, e.g. Dealer and Distributor.
Click here to download the Discount Tool (Cumulative).