Spreadsheet Solutions

Spreadsheet Solutions Spreadsheet Solutions (https://spreadsheetsolutions.biz) creates cost effective, bespoke/custom software in Excel, to help companies increase productivity.

We offer various solutions for business of all shapes and sizes. Here are a few of the options on our website:

* Custom-made spreadsheets, problem-specific solutions made for your business.
* Ready-made, comprehensive solutions to tackle various business issues.
* A basic range of spreadsheets, to tackle basic tasks, at a really affordable price.
* Excel based administrative support. We make the

spreadsheets, and then use them for you.
* Collaborations with other professionals in order to bring you a more comprehensive solution.
* Bespoke, one-on-one training, if you want us to show you how to complete a specific project.
* Free resources such as DIY training videos, free spreadsheet downloads, and other useful items. Come and take a look at our website, and see how we can help you - https://spreadsheetsolutions.biz

20 features for better spreadsheetsPart 21 of 22 - Separate dashboardWhat’s the difference between a report and a dashbo...
10/06/2026

20 features for better spreadsheets

Part 21 of 22 - Separate dashboard

What’s the difference between a report and a dashboard? No, this isn’t a joke. A report is a detailed dive into the data. A dashboard is a high-level view of KPIs that lead you to know what to address or to report on. Many just morph these two into a weird combination of a mess. Keep the two separate and keep them doing what they should be. A dashboard should be to look at the spot key issues, and a report should be to analyse what has taken place and to help make key decisions. If you combine these two, it could render them both ineffective.

Please visit https://spreadsheetsolutions.biz/contact-us if you wish to get in touch with us for a new spreadsheet.


20 features for better spreadsheetsPart 20 of 22 - Dynamic reportingDynamic reporting means that you use filter data bef...
03/06/2026

20 features for better spreadsheets

Part 20 of 22 - Dynamic reporting

Dynamic reporting means that you use filter data before it reaches the report. Think about one element here as an example. You have 10 staff, and there are 12 months in the year. So, if you made a graph per staff per month, that’s 120 reports (130 if you include all the staff each month). I’ve seen reports with this much data. However, if you have a filter to select the desired month (from a drop-down) and the desired staff member (from a drop-down), then you can have one graph that could show your desired data. If you leave the staff selection blank, it could include all staff together. This allows for much more compact, but far more versatile reports.

Please visit https://spreadsheetsolutions.biz/contact-us if you wish to get in touch with us for a new spreadsheet.


20 features for better spreadsheetsPart 19 of 22 - Freeze panesSome don’t even know you can do this. Freeze pains, so th...
27/05/2026

20 features for better spreadsheets

Part 19 of 22 - Freeze panes

Some don’t even know you can do this. Freeze pains, so that you can scroll without data disappearing. So, you have important data n the first 3 columns, and then loads of columns after that. Freeze the first 3 columns, so the rest go behind those 3, so you can always see them as you scroll to the right. This is another reason why data layout is key. Also, don’t start in the first row. Start further down, so you can put headers at the top. This way, you can scroll right and down, without losing sight of the headers, totals, or important columns.

Please visit https://spreadsheetsolutions.biz/contact-us if you wish to get in touch with us for a new spreadsheet.


20 features for better spreadsheetsPart 18 of 22 - Locked worksheets and workbookIf you are using a spreadsheet, rather ...
20/05/2026

20 features for better spreadsheets

Part 18 of 22 - Locked worksheets and workbook

If you are using a spreadsheet, rather than making a spreadsheet, it should be locked. Unlocking data entry cells, and the protecting the workbook, is a basic requirement. Yes, this means you can’t over-write formulas, but that is the point. I even lock the spreadsheets I make which only I use. It is so easy to over-write something you shouldn’t, so lock your spreadsheets.

Please visit https://spreadsheetsolutions.biz/contact-us if you wish to get in touch with us for a new spreadsheet.


20 features for better spreadsheetsPart 17 of 22 - Adjustable 12 month periodsI so often see spreadsheets created for a ...
13/05/2026

20 features for better spreadsheets

Part 17 of 22 - Adjustable 12 month periods

I so often see spreadsheets created for a 12-month period, which makes complete sense. But then come the end of that period, and people are trying to make a new template for the new year, adjusting all the headers and dates. At very least you should be able to open a new template of the spreadsheet, change the old year to the new year in ONE place, and have the rest update. If you really want to be adventurous, why not have a rolling 12-month period, so that you always have 12 months of data to view. Both are possible, and I usually use whichever is best for each case.

Please visit https://spreadsheetsolutions.biz/contact-us if you wish to get in touch with us for a new spreadsheet.


20 features for better spreadsheetsPart 16 of 22 - Hidden calculationsI often see spreadsheets with 32 columns, when onl...
06/05/2026

20 features for better spreadsheets

Part 16 of 22 - Hidden calculations

I often see spreadsheets with 32 columns, when only 5 of them are data entry, and 5 of them are useful to know. The other 22 columns are simply helper columns for workings. No harm in that whatsoever. The issue comes in when they are all in one messy lump. I’ve spoken about separating the data entry and formulated cells, but then keep the workings separate and hide them. Showing those only confuses the user. These columns don’t need to be in a logical order to follow the flow of the formula, but rather a logical order for the data entry and viewing.

Please visit https://spreadsheetsolutions.biz/contact-us if you wish to get in touch with us for a new spreadsheet.


20 features for better spreadsheetsPart 15 of 22 - Dynamic drop-down options or calculation over-rideThis is tricky to e...
29/04/2026

20 features for better spreadsheets

Part 15 of 22 - Dynamic drop-down options or calculation over-ride

This is tricky to explain but I will try. Let’s say you have a value column, which is 99% always the same value (or calculated value) but in the odd occasion it might need to be changed. If you make it a data entry cell, you’re always entering it, even when it should be automated. If you make it a formulated cell, you can’t change it when you need to. There are 2 options here. Either use a drop-down list to show you the calculated value, with the option to over-ride, so you simply select the correct value as default. Or, have an ‘Over-ride’ column, which you only complete if it differs to the norm. Then you can calculate the norm as default, unless an over-ride is entered.

Please visit https://spreadsheetsolutions.biz/contact-us if you wish to get in touch with us for a new spreadsheet.


20 features for better spreadsheetsPart 14 of 22 - Editable cells rather than hard-coded formulasHard coding means to ty...
22/04/2026

20 features for better spreadsheets

Part 14 of 22 - Editable cells rather than hard-coded formulas

Hard coding means to type a number directly into a formula. For example, VAT on £100. At the time of writing this, VAT is at 20%. So, 100*20% would give you the VAT on £100. However, it may not stay at 20%. So, instead of then having to go through your entire spreadsheet trying to find all the VAT references, make a VAT Rate cell (on another tab even). Then reference all formulas to that cell. Then if it changes, simply change one cell and all the references to that cell update.

Please visit https://spreadsheetsolutions.biz/contact-us if you wish to get in touch with us for a new spreadsheet.


20 features for better spreadsheetsPart 13 of 22 - Comparable data setsI’ve said before that you need to try and consoli...
15/04/2026

20 features for better spreadsheets

Part 13 of 22 - Comparable data sets

I’ve said before that you need to try and consolidate data into one data set. However, sometimes you need two. For example, you have a list of clients, one row per client, but each client could have a few jobs. So, you have a client list for the unique clients, and then you have a job list for all the jobs. Make sure that the client list feeds the client column in the job list. Make sure it’s on a drop-down list to keep it accurate. That means that you can use the unique client name to cross-compare both sets of data.

Please visit https://spreadsheetsolutions.biz/contact-us if you wish to get in touch with us for a new spreadsheet.


Happy birthday to us!Spreadsheet Solutions is 13 years old today!
09/04/2026

Happy birthday to us!

Spreadsheet Solutions is 13 years old today!


Address

London

Opening Hours

Monday 9am - 5pm
Tuesday 9am - 5pm
Wednesday 9am - 5pm
Thursday 9am - 5pm
Friday 9am - 4pm

Telephone

+44 (0)75 042 70579

Website

Alerts

Be the first to know and let us send you an email when Spreadsheet Solutions posts news and promotions. Your email address will not be used for any other purpose, and you can unsubscribe at any time.

Shortcuts

Share

Category