Find Excel spreadsheet errors fast with Rainbow Analyst spreadsheet audit tools

Spreadsheet Auditing in 3 StepsRainbow 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!

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

(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 new 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!

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

Reviewing and auditing

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

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

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

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]

Fix merged cell problems with Rainbow 11.1

July 30, 2018
Fix merged cell problems with Rainbow 11.1
If you ask any professional Excel developer about merged cells, they will almost certainly say somet… [more]

Manage all your spreadsheets with Rainbow 11.0

December 4, 2017
Manage all your spreadsheets with Rainbow 11.0
You may have already noticed that with the release of Rainbow version 11.0 there are now two edition… [more]

Find more hidden errors with Rainbow 10.1

January 12, 2017
Find more hidden errors with Rainbow 10.1
Rainbow has always been about finding hidden errors, and version 10.1 introduces a new analysis opti… [more]

Rainbow 10.0 adds perpetual licence

April 5, 2016
Rainbow 10.0 adds perpetual licence
For Rainbow 10, we've responded to requests from a number of users for Rainbow to include a perpetua… [more]

Rainbow 9.2 saves time for your team

July 12, 2015
Rainbow 9.2 saves time for your team
With Rainbow 9.2 we've built on the behind-the-scenes changes in version 9.0 to deliver significant … [more]

Sniff out spreadsheet “smells” with new Rainbow 9.0

April 17, 2015
Sniff out spreadsheet “smells” with new Rainbow 9.0
Today we're proud to release version 9.0 of Rainbow Pro, representing perhaps the most significant u… [more]
Back to topAdministration

Copyright © 2018 Mike Shallcross and TheModelAnswer