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 10, 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.)

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 Rainbow's Standard menu (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… [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

Reviewing and auditing

Comparing differences

Cleaning up errors

Checking data flows

Find more hidden errors with Rainbow 10.1

Rainbow 10.0 adds perpetual licence

Rainbow 9.2 saves time for your team

Sniff out spreadsheet “smells” with new Rainbow 9.0

New Rainbow Pro 8.2 more intuitive than ever

Stop “Too many different cell formats” errors