ARTICLES (BLOG POSTS)

How a £500 Spreadsheet Saved a Salary

How a £500 Spreadsheet Saved a Salary I was telling someone this story, and they suggested that I put this into a blog, so here it is. I went in to see a client, in order to deliver their custom-made spreadsheet, and show then how to use it. After I had explained how...

read more

How Spreadsheets Help Franchises

How Spreadsheets Help FranchisesThis article is about how spreadsheets can be used to help franchises, but the same principal can also be used for other circumstances. If you need various people (staff, sub-contractors, clients, associates, etc) to be using the same...

read more

Why You Should Outsource Your Spreadsheet Creation

Why You Should Outsource Your Spreadsheet Creation Before I tell you why you should outsource your spreadsheet creation, there are times that you should do it yourself. Those times are few and far between but, if either of these criteria are met, even I would say that...

read more

Get More Out of Your Data

Get More Out of Your Data What do I mean when I say “get more out of your data”? I’m not necessarily talking about analysing exported data (although I do make spreadsheets for that), I’m talking about getting more out of the data that you tirelessly enter....

read more

Using Spreadsheets to Collect Staff Hours

Using Spreadsheets to Collect Staff Hours You may have some tremendous software that does all of your work for you, but many businesses want a solution to do the work the way they want it done and, very often, a spreadsheet is the answer. Some think...

read more

How secure are your spreadsheets?

How secure are your spreadsheets? Before I start this blog, I need to make it clear what I am talking about. Spreadsheets are merely documents, so their overall security is mostly dependant on where they are hosted. I’m not talking about that. I’m talking...

read more

Eight Concerns I Have About Hiring a Marketing Company

Eight Concerns I Have About Hiring a Marketing Company Before I get started, let me explain why I am writing such an obscure blog post, considering the nature of my business. I have seen a few posts by marketing businesses, wondering how to get the right...

read more

Processes, Results, and Spreadsheets

Processes, Results, and Spreadsheets In this post I want to show you how changing your processes can see you gain desired results, and how spreadsheets can help with this. Many of us know what results we want, but our processes don’t accommodate such...

read more

Using Spreadsheets with Making Tax Digital

Using Spreadsheets with Making Tax Digital What is Making Tax Digital?Making Tax Digital (or MTD) is an initiative by HMRC to make the entire process of VAT returns (and later Tax returns) electronic. They want to eliminate careless human error, and make...

read more

How is Your LinkedIn Contact List Growing?

How is Your LinkedIn Contact List Growing? I have been actively growing my LinkedIn contact list for a while now, and I was curious to know how I have done. Which months were the most successful at gaining new contacts? How much better was last year than...

read more

Amazon Sellers and Your Wealth of Data

Amazon Sellers and Your Wealth of Data If your business involves selling on Amazon, I have some good news for you. Now, we do not sell on Amazon, but we have some clients who do. We kept getting requests to create spreadsheets to automatically analyse all...

read more

Top 5 Downloads of 2018

Top 5 Downloads of 2018 Well 2018 is over, and pretty much forgotten, and we are all now heavily into 2019. I have reviewed the downloads from this website during 2018 and have discovered which spreadsheets have been the most popular. This may not sound...

read more

Forget Big Data, Understand Your Little Data

Forget Big Data, Understand Your Little Data There seems to be a trend at the moment about 'big data', but do you actually know what that is? Why is it such a trend, and is there anything that you could be doing about it? Take a look below, as I will try...

read more

Spreadsheets – Jack of All Trades, Master of None?

Spreadsheets – Jack of All Trades, Master of None? I saw a comment on a social media post stating that spreadsheets are not the ideal solution in any situation, but can provide an adequate solution in almost any situation. As you can imagine, this got my...

read more

Spreadsheets and the HR Industry

Spreadsheets and the HR Industry You may be wondering why I am writing about HR, and the answer is simple. Many of my clients happen to be HR consultants or HR managers. After a few years of trading, I had a look at my past clients, to see if there were...

read more

Comparing Your Data with Spreadsheets

Comparing Your Data with Spreadsheets Can spreadsheets do this?Believe it or not, I am seeing an increasing demand for spreadsheets to check, compare, and then report on data sets. This is probably due to most software systems exporting data to CSV, but...

read more

Analysing Your Sales Figures

Analysing Your Sales Figures Do you even do it? Do you analyse your sales figures? Dare I say that most people don’t. If the money is in the bank, then does it really matter how it got there? This is the attitude of most business owners, and this is a very...

read more

Pipeline Management & Sales Projection

Pipeline Management & Sales Projection I have seen a rise in requests to manage sales pipelines of late. What is this all about? Well, it is monitoring how many leads are successful, how long a sale takes, how much an average sale is worth, and then...

read more

Why You Need to Monitor Your Website Analytics

Why You Need to Monitor Your Website Analytics I’m sure you won’t be surprised that I monitor my website analytics often. Having a business called Spreadsheet Solutions would indicate that I love analytics, graphs, and the like. I monitor all sorts of...

read more

My 5 Most Popular Spreadsheets This Year

My 5 Most Popular Spreadsheets This Year I have had a look at the downloads from the website over the last 7 months, in order to see which of the spreadsheets are the most popular, and here are the various winners in each category. Hopefully it will show...

read more

Spreadsheet Not Refreshing?

Spreadsheet Not Refreshing? I have received a few calls of late from my clients, who say that their spreadsheets are not refreshing. They type data in, and it does not change the relevant cells which it should. They then save the workbook, and the changes...

read more

How Me Making Games Can Help Your Business

How Me Making Games Can Help Your Business This title could seem misleading, or even wrong, but I can assure you that there is a link. I create custom spreadsheets (mainly in Excel) for businesses, not just for financial applications, but for all sorts of...

read more

6 Reasons Why You Should Buy From a Small Business

6 Reasons Why You Should Buy From a Small Business I’m sure you’re beginning to read this article with one of three mindsets. You’re either looking for reasons to confirm what you believe (if you like supporting small businesses, or have one), you disagree...

read more

How Spreadsheets Help the Market Leaders

How Spreadsheets Help the Market Leaders You may be reading this with a sense of scepticism, and I don’t blame you. A few years ago I would have been the same, except now I have had the pleasure of working with some market leaders in their field, and I have seen...

read more

Are Spreadsheets GDPR Compliant?

Are Spreadsheets GDPR Compliant? I have been asked a few times if my spreadsheets are GDPR compliant. Instead of explaining this again, I thought I’d rather write this post instead. So, if you’re wondering if spreadsheets are GDPR compliant, read on. I think this...

read more

Excel and Mapping Your Project Progress

Excel and Mapping Your Project Progress In the last few months, I have received many requests to create a solution for managing people’s project process. If you received a new project, you would obviously tackle that in stages, so most people break it down...

read more

5 Things I’ve Learned About Face to Face Networking

5 Things I’ve Learned About Face to Face Networking When I started Spreadsheet Solutions in 2013, I had never done face to face networking before, and I was thrown in the deep end when I went to the first one. The first networking even was a bust, and at...

read more

Excel and Large Businesses

Excel and Large Businesses People often associate the use of Excel with small and medium sized businesses, because they see it as a 'cheap' version if you can't afford software, but that is not the case. Yes it is an affordable alternative to custom...

read more

Bespoke software, exclusive for you to refer.

Bespoke software, exclusive for you to refer. As you may or may not know, I have two main avenues of my business, and I have now combined the two to bring you a new exciting opportunity. If you have been intrigued by the title, read on, and I will explain what this...

read more

Why My Clients Use Custom Spreadsheets Over CRM Software

Why my clients use custom spreadsheets over CRM software I have been asked the question, "Why use your spreadsheets instead of CRM software?". Now I can go on all day why I use Excel, but I am an Excel fanatic, so it would probably be a biased view. I also have...

read more

Do You Have a Database of Contacts to Refer, if Asked?

Do you have a database of contacts to refer, if asked? I have been talking to a few people since I wrote a post about referrals, and I have discovered that many people do not have a database of people to refer when asked. If you do a lot of networking like I do, or if...

read more

Analysing Your CSV Files

Analysing Your CSV Files Most of us find that we will need to analyse a CSV file at some point, as many software packages and websites will export them. Whether you are exporting your social media statistics, your website analytics, your plugin statistics or details...

read more

Custom CRM Solution – Spreadsheet Style

Custom CRM Solution - Spreadsheet Style CRM Systems, love them or hate them, are extremely useful. Most businesses either do benefit from them, or would if they had them. Why is that? You see productivity relies on process - it is about being organised, having a...

read more

Why Most SMEs Don’t Have Proper Processes in Place

Why Most SMEs Don't Have Proper Processes in Place Before we start, what is a business system? The online dictionary says the following: A methodical procedure or process that is used as a delivery mechanism for providing specific goods or services to customers. The...

read more

How Important are Your Business Processes?

How Important are Your Business Processes? There are many aspects to business, and I am not about to suggest that the process is the most important part, but it is vital we get it right. Many people don’t even realise what their process is, let alone acknowledge how...

read more

Using Excel to Analyse Data

Using Excel to Analyse Data This month I have used Excel in a number of ways, all to analyse data. Excel is brilliant for doing just this, and recently I have used it for all sorts of applications from 360 Staff Appraisals to Web Form Analysis. People spend a fortune...

read more

Excel, Helpful to Businesses of All Sizes

Excel, Helpful to Businesses of All Sizes I usually try and market to companies containing between 1 and 10 employees. The reason for this is that the product I supply is ideally suited for companies that have expanded beyond a one man band and now have a few people...

read more

Pivot Table v Formulas

Pivot Table v Formulas One of Excel’s major strengths is analysing data, that is why most people use it. They have data which they have been capturing, and now they need Excel to analyse that data and give them relevant information and statistics that they can use....

read more

Why Excel is Still the Best Spreadsheet Platform

Why Excel is Still the Best Spreadsheet Platform I have been using Excel in since business since 1996, and that was not because Excel was only available from then, that was because I only started working in 1996 after finishing school. Now I hear that there were other...

read more

Excel at Marketing (Part 2)

Excel at Marketing (Part 2) As a former investment analyst I am no stranger to using Excel. In the past I generally concentrated on creating financial models and using Excel to forecast revenues, cash flows and profits. Since setting up BuzzSmart, a business solutions...

read more

Excel at Marketing (Part 1)

Excel at Marketing (Part 1) Excel is known to be versatile, and those of us that have the skills to use it beyond making a few columns, can use it for just about anything. I was having coffee and a discussion with a marketing expert the other day, and I have been...

read more

Excel and Your Company Sales

Excel and Your Company Sales Here is an article that I wrote for Vector Resources, as a guest writer on their blog: Although most people associate Microsoft Excel with accounts and financial planning, it is far more versatile than that, and it is ideal for keeping...

read more

Excel is for Everyone

Excel is for Everyone Often when I am speaking to people at networking events, or other business owners who are trying to find out about my business, they ask me a question that is not easily answered. They ask me who my target market is. My answer is usually, “Anyone...

read more

5 Misconceptions of Microsoft Excel

5 Misconceptions of Microsoft Excel Excel is just for spreadsheets. This is probably the most common misconception that I come up against, and it is complete rubbish. Most of the points of the article are going to contain one thing in common, and here it is – This is...

read more

How Your SME Could Perform Like a Large Company

How Your SME Could Perform Like a Large Company I have worked for small, medium and large businesses throughout my career and have found one fundamental difference between them. Obviously there are advantages and disadvantages to each category, but I have found that...

read more

Excel, More Than Just Figures

Excel, More Than Just Figures In Excel 2013, there are no fewer than 46 functions relating to text or lookup and reference. This means that all of those functions don’t actually require any figures to be relevant. Most of these relate to text and text strings. The...

read more

How We Save Companies Money

  How We Save Companies Money So many people understand that Excel is a powerful tool, and they realise that it can help their business, but they don’t realise how it helps. They don’t realise how it can save them money. I will try and explain here why it is a...

read more

Yet 5 Further Ways Businesses Struggle & How Excel Can Help

Yet 5 Further Ways Businesses Struggle & How Excel Can Help Firstly I would like to say that this is the fourth part of the series, the first three can be found here, here and here. If you haven’t read them and this post interests you, I suggest that you read the...

read more

5 Further Ways Businesses Struggle and How Excel Can Help

5 Further Ways Businesses Struggle and How Excel Can Help Firstly I would like to say that this is the third part of the series, the first two can be found here and here. If you haven’t read them and this post interests you, I suggest that you read the others too. The...

read more

Why I Love Spreadsheets

Why I Love Spreadsheets You’re probably thinking that it is not at all strange that someone who owns a company called Spreadsheet Solutions has written a post about why they love spreadsheets, but I wish to explain why I love them. I mean, what is so exciting about a...

read more

Using Excel as Business Software

Using Excel as Business Software I love using Excel. I have created business software with it on numerous occasions, as well as custom spreadsheets and even games and quizzes! Most people that I come across are under-using it. Not because Excel can’t do more, just...

read more

Why Using Excel is Good for Business

Why Using Excel is Good for Business It seems more and more obvious to me that business people mostly have Excel on their computers, and some of them use it, however very few use it to its potential. Those that use it have a few columns of amounts, and they use Excel...

read more

5 More Ways Businesses Struggle & How Excel Can Help

5 More Ways Businesses Struggle & How Excel Can Help Firstly I would like to say that this is the second part of a two part post, the first one is entitled ‘5 Ways Businesses Struggle and How Excel Can Help‘. If you haven’t read it and this post interests you, I...

read more

5 Ways Businesses Struggle and How Excel can Help

5 Ways Businesses Struggle and How Excel can Help Having been in business for many years, I have often found myself in the situation where I have had to create an Excel document or two to help companies improve their processes. I have come across many different issues...

read more

Improve Your (Small) Business

Improve Your (Small) Business Having started my own small business, I have picked up a few ideas to help improve yours. This article is not only about Excel (which is my main area of expertise), but consists of a few ideas that has helped my business, and can probably...

read more

Are You Getting the Most out of Excel?

Are You Getting the Most out of Excel? I have been to see quite a few Excel spreadsheets that companies have created to help their businesses, and quite frankly, it scares me a little. Most people realise the flexibility and control that Excel offers but they can only...

read more

10 Excel Functions to Help Your Business

10 Excel Functions to Help Your Business I have heard a few people say that using Excel is risky as there are always errors and it is difficult to use. Well, when there are mistakes in Excel, 99 out of 100 are human errors, and the other one is probably not entirely...

read more

Message From the Director

Message From the Director If you think spreadsheets are just for basic calculations, or to store data, think again!  There are countless ways that the right tailor-made spreadsheet can enhance your business and save you time, money and effort. This is in fact why I...

read more

How Your Business Can Benefit from Excel

How Your Business Can Benefit from Excel When I tell people that Microsoft Excel can help their business, they often make a comment like, “Oh, you mean for accounts?” My answer is usually something about the fact that I very seldom use it for accounts. Excel, in the...

read more

10 Things You Did Not Know Excel Can Do

10 Things You Did Not Know Excel Can Do Here are ten things that you may not know Excel can do. Take a look and see what you can learn. 1. Image distribution – You can have a single picture in one location, and have various cells programmed to show that picture. So if...

read more

Thanks for taking a look at our blog posts, please click on the button when you’re done, to return to our home page.

We hope that you are sufficiently inspired.