Business Spreadsheet Tips

Below is a completely free business resource showing hints, tips and examples of best practice for Excel in business. Each month a new entry is added to the table. These business spreadsheet tips are distributed in Working Data's monthly newsletter.

If you would like to join the mailing list for the newsletter and have the spreadsheet tips sent directly to you, 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.

Get Excel Help − Spreadsheet Tip Archive

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
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 the SUMIF function ..Close
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
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
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
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
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
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
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
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
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