Free downloads − spreadsheet examples, spreadsheet tips & excel formulas

Welcome to our completely free business resource. Below we have listed free downloads with spreadsheet examples containing spreadsheet tips and excel formulas by business activity.

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.

Claims

• Mileage Claim Tool ..View

  This simple and accurate mileage claim form allows you to record your mileage for each journey and automatically calculate the mileage you are owed.

  Go To − Mileage Claim Tool ..Close

  

Cross Reference

• Cross-Reference data from two files using VLookup ..View

  The data for your presentation may need to be tied together from two different files. This tutorial shows you how.

  Go To − VLookup across files ..Close

  
• Cross-Reference data from two tables using VLookup ..View

  Pull together data from two tables and cross-reference all your records in an instant with this tutorial.

  Go To − Using VLookup to Cross-reference tables ..Close

  

Discounts

• Discount Tool - Non cumulative ..View

  Quickly give your customer an accurate price depending on their category with this multi-layered discount tool. All discounts are based on the retail price.

  Go To − Discount Tool - Non-cumulative ..Close

  
• Discount Tool - Cumulative ..View

  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 dealer price.

  Go To − Discount Tool - Cumulative ..Close

  

Inventory

• Inventory value calculated with SUMIF ..View

  Calculate your year end inventory value using SUMIF. This tutorial shows you how to get a total figure for inventory in and inventory out, leaving you with the inventory value.

  Go To − Year End Inventory Calculations using SUMIF ..Close

  

Invoices and Payments

• Flagging Late Payments using a nested IF statement ..View

  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.

  Go To − Flag Late Payments with a Nested IF statement ..Close

  

Marketing

• Emailing List (1/3) - Removing Trailing Full Stops from Email Addresses ..View

  In this first of three parts to help you prepare your emailing lists, we get rid of the trailing full stops which often cause email addresses to fail.

  Go To − Tidying a Mailing List (1/3) ..Close

  
• Emailing List (2/3) - Replacing Commas in Email Addresses ..View

  In this second of three parts to help you prepare your emailing lists, we get rid of commas in email addresses which can cause the sending to fail.

  Go To − Tidying a Mailing List (2/3) ..Close

  
• Emailing List (3/3) - Emailing List Salutations ..View

  In this third of three parts to help you prepare your emailing lists, we generate the salutation depending on the individual information you have for each recipient.

  Go To − Emailing List Salutations ..Close

  
• Extract a list of company websites from email addresses using Concatenate, Find, Length & Mid ..View

  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.

  Go To − Automate Data Entry with Text Functions ..Close

  
• Mailing List Names - Tidy with Concatenate & Trim ..View

  Always send out neat and correctly formatted names in your mailshots using Excel's in-built text functions.

  Go To − Tidying mailshot data with concatenate ..Close

  
• Markup & Margin Tool - Calculate Markup, Margin, Cost and Price. ..View

  Fast and simple tool to calculate Markup, Margin, Cost and Price.

  Go To − Markup & Margin Tool ..Close

  
• Target your prospects with the AND function ..View

  Excel gives you the tools to analyse your data against several criteria. In this example, we use the AND function to target our prospects more effectively.

  Go To − The AND Function ..Close

  

Sales Analysis

• Analysing Sales Performance with Pivot Tables ..View

  Pivot Tables allow you to analyse simple data very quickly, and in a presentable format too.

  Go To − Sales Analysis using Pivot Tables ..Close

  
• Compile Sales Data for a Presentation using SUMIF ..View

  Generate real, useful figures for your monthly sales presentation. This simple example shows how to compile the number of each product sold and at what average price.

  Go To − Compiling Data with the SUMIF function ..Close

  
• Compile Year-End Sales Figures with Pivot Tables ..View

  Generate real, useful figures for your monthly sales presentation. This simple example shows how to compile the number of each product sold and at what average price.

  Go To − Compiling Data with Pivot Tables ..Close

  
• Sales by Supplier using COUNTIF ..View

  Find out the number of product sold by supplier so that you can go into your next supply meeting with complete figures to hand.

  Go To − Sales by Supplier using Countif ..Close

  
• Sales by Supplier Tool - Showing No of Sales, Value of Sales and Average Sale. ..View

  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.

  Go To − Sales by Supplier Tool ..Close

  

Timesheets

• Timesheet - Calculate your weekly billings by hourly or daily rate. ..View

  Using Excel's HOUR and MINUTE functions along with some arithmetic, we can build a quick simple timesheet which automatically calculates our daily and weekly billings. Free download.

  Go To − The Timesheet ..Close

  

Time Savers / Spreadsheet Tricks

• Macros automate repetitive tasks ..View

  We often find ourselves repeating the same few movements when using spreadsheets. Macros can perform these tasks for us at the press of a button, time and time again.

  Go To − Automating tasks with Macros ..Close

  

VAT / Sales Tax

• VAT Calculations with two VAT rates using Excel's arithmetic functions ..View

  With Excel's in-built arithmetic functions you can make quick and accurate calculations when having to deal with two VAT rates simultaneously.

  Go To − VAT calculations with two VAT rates ..Close

  
• VAT Calculator - a free, downloadable spreadsheet from Working Data ..View

  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.

  Go To − Adding VAT and Removing VAT ..Close

  
• VAT Calculator v2.0 - Simplified & improved. ..View

  The VAT calculator version 2.0 gives you a fast and saveable method for removing VAT or adding VAT.

  Go To − VAT Calculator v2.0 − How to Add VAT & Remove VAT ..Close

  

Website Statistics

• Analysing and Presenting Web Stats with Google Analytics (1 of 3) − General ..View

  Generate a professional presentation of your Google Analytics website statistics with your free downloadable spreadsheet tool.

  Go To − Analysing and Presenting Web Stats ..Close

  
• Analysing and Presenting Web Stats with Google Analytics (2 of 3) − Referring Sites ..View

  Generate a professional presentation of your Google Analytics Referring Site statistics with your free downloadable spreadsheet tool.

  Go To − Analysing and Presenting Referring Site Stats ..Close

  
• Analysing and Presenting Web Stats with Google Analytics (3 of 3) − Keywords ..View

  Generate a professional presentation of your Google Analytics Keyword statistics with your free downloadable spreadsheet tool.

  Go To − Analysing and Presenting Keyword Stats ..Close