In this second in the series of three tips to help you tidy your e-mailing lists, we look at a quick but useful method to replace the most common typing error in email addresses. Often when people fill in their email address, they type in a comma rather t ...
How to remove trailing full stops from email addresses
It is important that we communicate effectively with potential and existing clients. One of the increasingly popular methods for doing this is through e-communications, such as blogs and newsletters. Our clients often ask for assistance in tidying e-maili ...
How to flag late invoice payments in an Excel Spreadsheet
A paid and unpaid formula in Excel shows you late invoice payments and will help you with the cash-flow which is crucial to all businesses. If you have an Excel spreadsheet of your invoices, wouldn't it be great to have a column which automatically showed ...
How to do Inventory Year End Calculations
Keeping check on inventory; how much has gone out, how much has come in, what value goes down on my tax return? At this time of year, it is a question that your accountant will want the answer to. In this month's spreadsheet tip, we show you how to get th ...
How to calculate cumulative discount
In this month's spreadsheet tip, we look at how to apply discounts cumulatively to your price list. This allows you to apply percentage reductions to different categories of customers across your whole product range, in an instant. Purchase Cumulative ...
How to calculate simple discount
We can set up a Discount Tool in Excel by using arithmetic functions. Follow the steps below to build your own discount spreadsheet, or if you'd prefer, take advantage of the time we've already spent preparing ours! Purchase the Simple Discount Spread ...
How to cross reference spreadsheet data using VLOOKUP in Excel
Need to cross-reference two lists but there's too many to do manually?Excel can help with the vLookup function. Want to add a cross-reference to your own spreadsheet with vlookup? We'll walk you through an example!Imagine you have two lists. The ...
A Simple Excel Mileage Claim Spreadsheet.
If you travel for your work you will need to keep a track of your mileage. Then you can claim expenses or deduct it from your tax return. The Simple Excel Mileage Claim Form will help you. This easy-to-use, clean, neat & printable mileage claim for ...
