ARTICLES (BLOG POSTS)
Pros and Cons of Using Spreadsheets
Pros and Cons of Using SpreadsheetsIf you’re thinking about using a spreadsheet for your business, there are a few things to consider before doing so. As much as I love making spreadsheets, and as...
5 Reasons You May Need Better Spreadsheets
5 Reasons You May Need Better SpreadsheetsSoftware companies often bad-mouth spreadsheets, in order to scare people into buying their software, by telling you all the ‘horror’ stories from using...
The Pros and Cons of Who Makes Your Spreadsheets
The Pros and Cons of Who Makes Your SpreadsheetsI recently conducted a poll on LinkedIn, to see who people would ask to make a spreadsheet if they needed one for their business. The results were not...
How much should I charge per hour?
How much should I charge per hour?Before you start reading this blog, you can download a free spreadsheet template to help you calculate your hourly rate. It is in £ but as there is no conversion...
What Makes Me Good at Making Spreadsheets (It not what you may think)
What Makes Me Good at Making SpreadsheetsBefore you start thinking that I am a narcissistic idiot for writing that title, let me explain. I often get people saying that I must know all the...
Could a Spreadsheet be Used to Securely Store Passwords?
Could a Spreadsheet be Used to Securely Store Passwords?I recently posted a post on LinkedIn, which generated a brief frenzy of activity and comments. This included some nasty direct messages,...
Our Solutions to 10 Reasons Given for Not Using Spreadsheets
Our Solutions to 10 Reasons Given for Not Using SpreadsheetsI love making spreadsheets, and use them for just about anything, but many people don’t use spreadsheets. I set out on a mission to find...
Being Creative with Excel
Being Creative with ExcelWhen most people make spreadsheets they are boring, bland, uninspiring, and mundane. You know the type - rows and columns of data, void of any colour, and only the AutoSum...
5 Ways to Monitor the ROI of Your Website
5 Ways to Monitor the ROI of Your WebsiteAfter doing a live YouTube broadcast with Richard Wraith from Wesh UK, I have thought more about how people can monitor the success of their website, in...
Why Your Business Needs a Bespoke Spreadsheet
Why Your Business Needs a Bespoke Spreadsheet I often meet people who ask me which industry or business type my ideal client falls into. This is a good question to ask yourself, as it makes your...
Types of Solutions We Do Often
Types of Solutions We Do OftenWe often get people saying, "If only we knew you did that, we would have come to you first." That is because people tend to limit us to what they have already done...
Analysing CSV Files with Spreadsheets
Analysing CSV Files with SpreadsheetsData is becoming more and more abundant as everything moves online, and we are all collecting our fair share of business data. The key is understanding your...
What I Learned with 3 Months of Marketing Data
What I Learned with 3 Months of Marketing Data You've probably heard the saying that you can't keep on doing the same thing, and expect different results. The big problem is understanding what...
How a £500 Spreadsheet Saved a Salary
How a £500 Spreadsheet Saved a SalaryI 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...
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...
Surveys, Appraisals, Questionnaires, and Feedback using Excel
Surveys, Appraisals, Questionnaires, and Feedback using Excel You may use a ready-made survey tool, or some other way of gathering responses in order to create a report, but often the...
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...
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...
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...
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...
Why a Software Package Isn’t Necessarily Better Than Your Spreadsheet
Why a Software Package Isn’t Necessarily Better Than Your Spreadsheet OK, before I get every software developer and salesperson on my back, let me just put in a disclaimer. There is...
Management Dashboards – Traffic Lights for Your Business
Management Dashboards – Traffic Lights for Your Business No matter what type of business you run, and how big or small it is, we all have one thing in common. We need to know how they...
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...
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...
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...
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...
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...