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.
- VLookup 2003 Spreadsheet Example – Cross Reference Data using VLookup (2000, 2002, 2003, .xls version)
- VLookup 2013 Spreadsheet Example – Cross Reference Data using VLookup (2007, 2010, 2013, .xlsx version)
- Discount (Cumulative) Tool
- Discount (Simple) Tool
- Emailing List Salutations Spreadsheet Example
- Flagging Late Payments Spreadsheet Example
- Mailing List Preparation Spreadsheet Example
- Markup & Margin Tool
- Mileage Claim Tool
- Nested IF Statements Spreadsheet Example
- Sales Analysis using Pivot tables Spreadsheet Example
- Sales By Supplier Spreadsheet Example
- Timesheet Tool
- VAT Calculator Tool
Click to go to our GDPR-compliant Mailchimp sign-up form
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.
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.
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.
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.
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.
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.
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.
This spreadsheet example demonstrates how to quickly give your customer a price depending on their category.
Or go to the Simple Discount Tip.
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.
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.
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.
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.
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.
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.