Find Excel spreadsheet errors fast with Rainbow Analyst spreadsheet audit tools

Rainbow Analyst is a spreadsheet auditing and visualisation add-in for Microsoft Excel™ that has been ranked #1 in an independent study and is in regular use by one of the UK’s largest accounting firms and other major organisations.

For a 4-minute introduction to spreadsheet auditing with Rainbow Pro, using a real-life financial model, click the video link shown here or watch on YouTube. And then click the Download button below to install your 30-day free trial copy of Rainbow Pro and check it out for yourself!

Rainbow Analyst Professional 11, our flagship product for Excel versions from 2007 to 2019.

(Note: Because Rainbow Analyst is not a commonly-used application, Windows SmartScreen may report the download file as an “unrecognised application” and stop it running. If this happens, just click “More info” in the SmartScreen message, then click the “Run anyway” button.)

Manage your corporate inventory of Excel spreadsheets with Rainbow Governance

While Rainbow Pro provides industry-leading tools for auditing individual spreadsheets, we recognise that there is often a need to manage spreadsheet use across the entire organisation. So we have teamed up with our colleagues at Diligence for Excel to create Rainbow Governance, a new version of Rainbow which (in addition to all the functionality of Rainbow Pro) offers a tried-and-tested solution for monitoring quality and tracking changes across your entire inventory of spreadsheets.

In Rainbow Governance, the Rainbow tab contains an additional Governance group of functions. These enable you to add an automatically-generated Table of Contents sheet at the front of each spreadsheet, which Rainbow Governance uses to register your spreadsheet, keep track of changes, and alert you to structural and design issues. And at any time Rainbow can generate a Governance report listing your entire inventory of registered spreadsheets, so that you can see at a glance the state of health of your organisation’s spreadsheet use. Click the Download button below to install your 30-day free trial copy of Rainbow Governance and test it for yourself!

Rainbow Governance 11, our premium product for managing Excel spreadsheets across your enterprise.

Reviewing and auditing

With the issue-flagging and collaborative messaging features introduced in Rainbow Pro 9.2, systematic Excel spreadsheet audit and review can now be as easy as 1-2-3, using the first 3 functions on the Rainbow tab (shown above): Run the Summary Report function to get a high-level overview of the spreadsheet. Decide what action is required to address any problems highlighted on the report,… [more]

Comparing differences

One of our customers told us Rainbow was worth buying for its comparison function alone, and another customer found an unexpected use for it in resolving version conflicts. Rainbow's Comparison Toolbox function provides you with a whole toolbox of different options, allowing you to compare different workbooks, worksheets or ranges. And at the same time Rainbow lets you choose whether you want … [more]

Cleaning up errors

Have you come across that annoying "Too many different cell formats" error message? This often occurs as a result of copying or importing worksheets from one workbook into another, as described in our earlier news item, and it can be very difficult to eliminate manually. Fortunately, as you can see from the composite screenshot above, Rainbow Pro comes with a function called Clean Up For… [more]

Checking data flows

With Excel increasingly used for Business Information (BI) projects, it's essential to keep track of the sources of data in your spreadsheet. Unlike most other spreadsheet utilities, Rainbow gives you a number of tools to help with this, and the most important of these is probably the Data Explorer, which gives you a pair of linked reports showing: All the pivot tables, query tables and … [more]

Sitemap

Find Excel spreadsheet errors fast with Rainbow Analyst spreadsheet audit tools

Manage your corporate inventory of Excel spreadsheets with Rainbow Governance

Reviewing and auditing

Comparing differences

Cleaning up errors

Checking data flows

Corporate integration in Rainbow 11.3.1

Quickly undo changes with Rainbow 11.2

Fix merged cell problems with Rainbow 11.1

Manage all your spreadsheets with Rainbow 11.0

Find more hidden errors with Rainbow 10.1

Rainbow 10.0 adds perpetual licence