Download

Business Excel Tools & Spreadsheet Examples

DISCLAIMER: The files contained in these downloads are for illustration purposes only. In no event shall Working Data be liable for any special, incidental, indirect or consequential damages of any kind, or any damages whatsoever, including, without limitation, those resulting from loss of use, data or profits, whether or not advised of the possibility of damage, and on any theory of liability, arising out of or in connection with the use or performance of these files or other files which are referenced by or linked to this file. You should not assume that any of these files is error-free or that it will be suitable for the particular purpose which you have in mind when using it. We cannot guarantee that any files are free from computer viruses and no warranty is given that files downloaded or accessed from the Working Data website are free of computer viruses. We recommend scanning any file before opening it.

Markup & Margin Tool

Compare and contrast prices with different levels of markup and margin to see which is best for you. Click the button below to download the tool –

Or go to the Markup & Margin Spreadsheet Tip.

VAT Calculator Tool

The latest version 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 an Excel Tool you can save on your PC –

Or go to the VAT Calculator v2.0 Spreadsheet Tip.

Sales By Supplier Tool

This Excel Tool will calculate No of Orders, Total Order Value and Average Order Value for you based on simple inputs –

Or go to the Sales By Supplier Spreadsheet Tip.

Flagging Late Payments Spreadsheet Example

This spreadsheet example contains the sample data and formula for using nested IF statements to flag up late payments –

Or go to the Flagging Late Payments Spreadsheet Tip.

Sales Analysis using Pivot Tables Spreadsheet Example

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

Or go to the Sales Analysis using Pivot Tables Spreadsheet Tip.

Mailing List Preparation Spreadsheet Example 

This spreadsheet contains the formula for removing full stops at the end of email addresses, in the context of preparing an e-mailing list.

Or go to the Mailing List Preparation Tip.

Emailing List Salutations Spreadsheet Example

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.

Or go to the Email List Salutations Tip.

Simple (Non-cumulative) Discount Spreadsheet Example

This spreadsheet example demonstrates how to quickly give your customer a price depending on their category.

Or go to the Simple Discount Tip.

Cumulative Discount Spreadsheet Example

This spreadsheet example 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.

Or go to the Cumulative Discount Tip.

VLookup 2003 Spreadsheet Example (2000, 2002, 2003, .xls version)

This spreadsheet example contains an Excel discount tool which allows you to quickly give your customer a price depending on their category.

Or go to the Excel 2003 VLookup Tip.

VLookup 2013 Spreadsheet Example (2007, 2010, 2013, .xlsx version)

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.

Or go to the Excel 2013 Vlookup Tip.

VAT Calculator Tool

This Excel Tool contains the latest version of our famous VAT Calculator.  Add or Remove VAT with automatic totalling too.

Or go to the VAT Calculator Tip.

Timesheet Tool

Auto calculates your weekly billing from your hourly rate and your start and finish times.  New section takes lunch minutes into consideration, plus new totals for your convenience.

Or go to the Timesheet Version 2.0 Tip.

Mileage Claim Tool

Auto calculates your mileage claim for single or multiple journies.  New cleaner, clearer version optimised for latest Excel version.

Or go to the Mileage Claim Tool Excel 2013 Tip.

Nested IF Statement Spreadsheet Example

The IF function allows you to ask Excel to consider if something is true or false and then act upon it. You can ‘nest’ these together so that Excel will look at several things in succession. In this example we look at automatically applying different percentages of discount depending on the quantity bought.

Or go to the Nested IF Statement Tip.

Subscribe to our newsletter – Get 50% discount on all online purchases

* indicates required