Spreadsheets are very useful and flexible…
They help us when our business is starting out…
…and we are still getting our processes and procedures sorted out.
As your business team continues to grow…
You have more data and spreadsheets start to fail…
…They just aren’t designed to deal with all that information in a useful way.
Spreadsheets don’t really expand, any user can screw them up…
…spreadsheets will eventually trip up your business.
So, what is your next step?
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 to calculate how much discount to give a customer depending on how many items they have bought. e.g. If my customer is buying more than ten of a particular product I will give them a 10% discount, if not, then there’s no discount.
You can follow the tutorial below which will explain how to build the example or you can save time and purchase the Nested IF Statement Spreadsheet Example that we have prepared already.
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.
Purchase the Mileage Claim Tool
Click the button below to purchase the Mileage Claim Tool.
Upon completing your purchase via PayPal you receive the download link by email.
Entering your mileage allowance
When you first open the Mileage Claim Tool it will look like this. ..read more
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
You never get time back…
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
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, ..read more
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
Capture and analyse sales data
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
1. What do I need and want the software to do?
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
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?
Round 10: Ability to Adapt & Grow
As a business grows and becomes more complex its systems need to help keep you on top of this.
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