The Working Data Logo - specialists in high quality, affordable
				bespoke business software and bespoke databases
 
Image of a keyboard when using a database

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

Cross Reference

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

Discounts

  • Discount Tool - Non cumulative ..View
  • Discount Tool - Cumulative ..View

Inventory

  • Inventory value calculated with SUMIF ..View

Invoices and Payments

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

Marketing

  • Emailing List (1/3) - Removing Trailing Full Stops from Email Addresses ..View
  • Emailing List (2/3) - Replacing Commas in Email Addresses ..View
  • Emailing List (3/3) - Emailing List Salutations ..View
  • Extract a list of company websites from email addresses using Concatenate, Find, Length & Mid ..View
  • Mailing List Names - Tidy with Concatenate & Trim ..View
  • Markup & Margin Tool - Calculate Markup, Margin, Cost and Price. ..View
  • Target your prospects with the AND function ..View

Sales Analysis

  • Analysing Sales Performance with Pivot Tables ..View
  • Compile Sales Data for a Presentation using SUMIF ..View
  • Compile Year-End Sales Figures with Pivot Tables ..View
  • Sales by Supplier using COUNTIF ..View
  • Sales by Supplier Tool - Showing No of Sales, Value of Sales and Average Sale. ..View

Timesheets

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

Time Savers / Spreadsheet Tricks

  • Macros automate repetitive tasks ..View

VAT / Sales Tax

  • VAT Calculations with two VAT rates using Excel's arithmetic functions ..View
  • VAT Calculator - a free, downloadable spreadsheet from Working Data ..View
  • VAT Calculator v2.0 - Simplified & improved. ..View

Website Statistics

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

How To Use Excel in Business

Sign-up for our Quarterly Newsletter.
Free downloads of spreadsheet examples with spreadsheet tips and excel formulas.

Subscribe to our Newsletter

First Name

Surname

Enter Email Address

Confirm Email Address

Preferred format:

Text HTML

   

We never share your details