Spreadsheet Solutions

Call Directions Website

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

We don't think we're that scary, but some folk are hesitant to get in contact with us, purely because they don't know wh...
07/10/2026

We don't think we're that scary, but some folk are hesitant to get in contact with us, purely because they don't know what to expect.

They may feel that they need better spreadsheets, and they may believe that we can provide them, but they're just not sure what to expect when getting in touch.

If that sounds like you, here is the process we normally follow - https://spreadsheetsolutions.biz/what-to-expect/


Visualisation Options for Dashboards!Part 12 of 12 - Conclusion.There you have it, some of the tactics and methods I use...
23/09/2026

Visualisation Options for Dashboards!

Part 12 of 12 - Conclusion.

There you have it, some of the tactics and methods I use to display information from data on a dashboard. The idea of the dashboard is to quickly and easily relay important information, so making it exciting, different, informative, graphical, is really important. These will vary from project to project, as it all depends what we will show on your dashboard, and the best way of doing so. Do you need a spreadsheet with a custom dashboard? Get in touch and let’s make you one.

View the full blog post here - https://spreadsheetsolutions.biz/blog/visualisation-options-for-dashboards/

For all posts in this series:

Visualisation Options for Dashboards!Part 11 of 12 - Data Representation.This is something I do which is similar to bar ...
16/09/2026

Visualisation Options for Dashboards!

Part 11 of 12 - Data Representation.

This is something I do which is similar to bar graphs, but uses little emojis instead. So, in this case I have used burgers to represent food stock. The more stock, the more burgers. I’ve even done one before using squares to represent boxes, and not only done them in bars, but along a ‘conveyor belt’ to show where they were in the process. These kind of data visualisation tactics would depend on how suitable they are for the project.

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

For all posts in this series:

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:

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