In December of 2008, the Chancellor of the Exchequer reduced VAT from 17.5% to 15%. This created a lot of work for IT people, but didn't seem to do much else. They must know something we don't. At least, it would be better if that were true. In any case, ...
How to sort data with a macro
As we spend more and more time at the PC nowadays, it makes sense to put it to the best use possible. Computers are very good at doing repetitive tasks, very quickly. Using macros allows you to tap into this without learning any programming. They, essenti ...
A Simple Excel Timesheet
If you sell your time by the day or by the hour you need a simple and quick way to record your hours and wages. Working Data have developed a simple-to-use, clear and neat Excel spreadsheet timesheet that you can download and re-use forever. It contains ...
How to find number of sales, sales value and average sale by supplier
Want to know which of your suppliers products you are selling the most of? If you've got a long list of sales in your spreadsheet, it might seem obvious how to pull out that information. But, it is very useful information. Just copy and paste your supplie ...
How to find sales by product
Faced with a long sales ledger with a month's worth of sales, it can be daunting to find a way to compile the data and get some meaningful feedback. In this month's spreadsheet tips we look at the SUMIF function which is used to add things together depend ...
How to analyse sales using pivot tables
Pivot Tables are a very fast, neat way of analysing sales data like this:If you would like a formatted example of how it works, you can download our surprisingle inexpensive spreadsheet: When you swap in your own data, don't forget to refresh the Pivot Ta ...
Simple Excel Markup and Margin Tool
A simple Excel tool to help you with Markup calculationsand Margin calculations. Want to get a handle on Pricing, Markup and Margin?Are you not sure which method to use for your pricing structures? How would they compare?Markup and Margin are often used ...
How to tidy mailout data
When you want to do a mailshot to your client list, it is important that you get the information right first time. Any improper formatting immediately makes your communication seem at worst suspect, and at least, amateurish. Often when you receive client ...
