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

Visualisation Options for Dashboards!Part 10 of 12 - Graphics.Sometimes I get asked for graphics that can change based o...
09/09/2026

Visualisation Options for Dashboards!

Part 10 of 12 - Graphics.

Sometimes I get asked for graphics that can change based on the data. In the case pictured, I have used graphs to create a ‘speedometer’ graphic. As the score improves, the needle moves up! I’ve created analogue clocks using a similar method, and other graphics using graphs, text, conditional formatting, and other means.

What we can offer you - https://spreadsheetsolutions.biz/

For all posts in this series:

Visualisation Options for Dashboards!Part 9 of 12 - Alerts.I use these often, usually for missing or incorrect data on v...
02/09/2026

Visualisation Options for Dashboards!

Part 9 of 12 - Alerts.

I use these often, usually for missing or incorrect data on various tabs. So, I list the tabs of the spreadsheet, and then each one either has a green alert (all OK), a yellow alert (missing data) and or a red alert (incorrect data). These are tremendously helpful, as you can see at a glance which tabs require data input or data correction. These types of ‘pop up’ alerts can be used for many things.

What we can offer you - https://spreadsheetsolutions.biz/

For all posts in this series:

Visualisation Options for Dashboards!Part 8 of 12 - Check Lists.Sometimes the old ways are best. Some prefer simple to-d...
26/08/2026

Visualisation Options for Dashboards!

Part 8 of 12 - Check Lists.

Sometimes the old ways are best. Some prefer simple to-do-lists instead of graphics. These can be focussed on one thing (like invoices due) but can also be a combination of different tasks. I’ve even done some lists where it includes various kinds of tasks, sorts them by urgency, and then displays a list of the next few tasks until complete.

What we can offer you - https://spreadsheetsolutions.biz/

For all posts in this series:

Visualisation Options for Dashboards!Part 7 of 12 - Heat Maps.Heat maps are very useful when the the reports lend themse...
19/08/2026

Visualisation Options for Dashboards!

Part 7 of 12 - Heat Maps.

Heat maps are very useful when the the reports lend themselves to it. When there are comparisons of data, or even locations in a room for example, I can create heat maps such as this one, either showing the numbers or not. These are very useful to spot trends, location, movement, etc. They can’t be used for everything, but when they are useful, they are very useful.

What we can offer you - https://spreadsheetsolutions.biz/

For all posts in this series:

Visualisation Options for Dashboards!Part 6 of 12 - Symbols.Many struggle with symbols like this, because they use the a...
12/08/2026

Visualisation Options for Dashboards!

Part 6 of 12 - Symbols.

Many struggle with symbols like this, because they use the available conditional formatting symbols, so are restricted to those. By using emojis or special characters, and then using conditional formatting to determine the colour, I can do many different symbol types and colours to easily display important information from data sets.

What we can offer you - https://spreadsheetsolutions.biz/

For all posts in this series:

Visualisation Options for Dashboards!Part 5 of 12 - Maps.This is an interesting one that I have done, which is to plot d...
05/08/2026

Visualisation Options for Dashboards!

Part 5 of 12 - Maps.

This is an interesting one that I have done, which is to plot data on a static map. These can be expanding ‘bubbles’ or different coloured dots, and the map can be changed for your desired area. This needs to be a static graph, and it’s not 100% accurate, because it’s not actually a map at all. It’s a combination of a graph and an image of a map! Very useful if location plays a part in your reporting.

What we can offer you - https://spreadsheetsolutions.biz/

For all posts in this series:

Visualisation Options for Dashboards!Part 4 of 12 - Conditional Formatting.This is a widely used option, simple conditio...
29/07/2026

Visualisation Options for Dashboards!

Part 4 of 12 - Conditional Formatting.

This is a widely used option, simple conditional formatting, except it’s often used badly. The idea is to see what goes with the theme of the spreadsheet and also how urgent the alert is. I usually use these to show trends or strength of scores, so don’t make it too bold. I often use the corporate theme. I usually leave bold ‘alert’ colours like red and yellow for urgent alerts. That way your eye is drawn to that when there is an issue.

What we can offer you - https://spreadsheetsolutions.biz/

For all posts in this series:

Visualisation Options for Dashboards!Part 3 of 12 - LeagueTables.This is a surprisingly popular choice. Especially when ...
22/07/2026

Visualisation Options for Dashboards!

Part 3 of 12 - LeagueTables.

This is a surprisingly popular choice. Especially when clients, staff, products, or anything else needs to be ranked. Showing a small league table can be very useful. I can even let you toggle between tables (1 to 10, then 11 to 20 for example). I’ve even made tables with medal or trophy images.

What we can offer you - https://spreadsheetsolutions.biz/

For all posts in this series:

16/07/2026

Stop fighting with broken formulas and confusing grids. 🤯

​Building the perfect business spreadsheet from scratch is exhausting. You simply don't have the time to sit there troubleshooting errors, designing dashboards, or fixing broken formulas when you should be running your business.

​Skip the frustration. At Spreadsheet Solutions, we’ve already done the heavy lifting for you.

​We offer over 100 professionally designed, ready-made Excel templates built to work instantly and upgrade your business today.
​Why Spreadsheet Solutions?

​No Forced Subscriptions: Pay once, own it forever. No recurring monthly fees.

​Plug & Play: Professionally formatted, beautiful dashboards ready for your data.

​Try For Free: Grab a free sample directly from our store to test-drive before you buy.

​Built for Every Need: Templates for project management, finance, staff tracking, and even personal use.

​Stop wasting hours in Excel. Get your business back on track. 📊

​👉 Browse the store & download your free sample now: https://spreadsheetsolutions.biz/store/

Address

London

Opening Hours

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

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