IF statements allow you to change a spreadsheet cell’s result depending on whether something is true or false. A good example is when you want… Read More »Graduated Discounts – A Nested IF Statement Example in Excel 2013
If you claim for your mileage you will like our Mileage Claim Tool, now updated to version 2.0. It’s in Excel 2013 and we’ll walk you through how to use it, it’s really simple.
Click the button below to purchase the Mileage Claim Tool.
Upon completing your purchase via PayPal you receive the download link by email.
When you first open the Mileage Claim Tool it will look like this.Read More »Mileage Claim Tool version 2.0
For those of you who keep their hours and do a weekly invoice, this simple Excel 2013 timesheet will make keeping track of your hours as easy as pie. And it’s in the latest file version too (.xlsx).Read More »New improved simple Excel 2013 Timesheet
Missing out isn’t fun. Whether it is spending more time with family or friends, or having more time to work on growing your business, there never seems to be enough hours in the day. It can be easy to get dragged along by the latest distraction. Suddenly you wonder where the day has gone and there’s still so much to do. It can seem that this is the only way to be. Isn’t everyone else behaving the same way? Well, not everyone…Read More »What is your time worth?
This is our most up to date VAT Calculator in Excel 2013. It automatically adds and removes VAT as well as giving totals. Here’s how to use it. It’s really simple!
First things first, download this zip file which contains the VAT Calculator which is an Excel 2013 file called VatCalculator3.xlsx. It’s completely complementary Clarence.Read More »Adding and Removing VAT with VAT Calculator v3.0
They say it is easier to sell to an existing customer than to attract a new customer. Studies have shown that the cost per sale is markedly smaller when selling again to people who are already familiar with you and your products.
Cross-selling and Up-Selling to existing customers is a proven way to increase your profitability as described in this article from the people at Marketing Donut. You already have a relationship with an existing customer. You know which products they have already purchased from you and you can therefore suggest other products that could be useful to them. Sometimes they might want a certain product but didn’t know that you supplied it. As they already know you and your brand, they are more likely to stick with you and buy from you again.
You look after your customer and get the sale, and they get the items they want from a supplier they trust. It’s one of those win-win situations people crave.Read More »Keep Your Customers Happy To Grow Your Business
To turn sales data into more meaningful information for your business, make it tell you where the customer came from. You can do this with promotional codes, for instance by labelling each of your different ad placements with a separate code. Keep track of which ‘promo’ code a customer uses when making a purchase and you will build up a picture of which ads work, which products each customer likes, and which ads work for which customers for which products! That’s targeted marketing. (Click diagram below for close-up).Read More »How To use your Sales Data to drive Targeted Marketing
It may seem an obvious question! I would really recommend writing it all down though. It will really clarify what your requirements and expectations are. Getting into the detail early will help you prepare and increase the likelihood of success. When you contact potential suppliers or prospective developers it gives you a great starting point.
Once you have made your full list of requirements, separate them into ‘must-haves’ and ‘nice-to-haves’. There will be some requirements which are absolutely crucial. The sort of thing where you think, if it doesn’t do that there there’s no point.Read More »6 Questions to ask yourself before buying Business Software
In the final round we look at which tool is the better long term platform for your business as it adapts and grows.
As your business develops and grows, and your market evolves and matures, you want your business systems to have the scope and flexibility to develop and grow with you. How is this best achieved whilst ensuring that bureaucracy bloat is kept to a minimum?
[xyz-ihs snippet=”separator”]
You may need to develop more systems and processes. These will need controls and measures in place. Staff training and monitoring becomes more important.
If you were to base a growing business on a spreadsheet system you would Read More »Spreadsheets vs Database – Round 10: Ability to Adapt & Grow
In this penultimate round we look at whether spreadsheets or database are a more effective tool when you want to monitor and review your team’s performance. How do each of these bits of software help you keep on track with who is doing what, their progress, who is reaching new heights and who needs some help.
[xyz-ihs snippet=”separator”]
You could keep track of certain key measurements, such as sales, in a list and then compile these into a graph showing changes over time.Read More »Spreadsheets vs Database – Round 9: Monitor Team Performance