Find Excel spreadsheet errors fast with Rainbow Analyst spreadsheet audit tools
It can pay for its cost within weeks, as a recent customer told us: “Rainbow Pro has paid for itself already when it was able to remove 150,000 named ranges (most of them nonsensical) from a very large file that ran out of resources using conventional means”.
For a 4-minute introduction to spreadsheet auditing with Rainbow Pro, press F11 (in most browsers) to switch to full-screen, then click the video link above, and then you can just click the screen to start or pause. You can also view the video on the YouTube website, and you can download the example financial model that we used for this demo and follow the steps for yourself with a free trial copy of Rainbow Pro.
Click the button above to get your 30-day free trial of Rainbow Analyst Professional (Rainbow Pro); simply double-click the downloaded file and follow the instructions to install Rainbow for your copy of Excel. And if you’ve any questions, just visit our Installation page or send us an email.
Excel spreadsheet audit or review – as easy as 1-2-3
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, particularly any red highlights.
Run the Formula Scan function, with formula checking and issue flagging turned on. Visually inspect the resulting colour map of formula groups, and investigate any obvious inconsistencies or isolated formulas.
Use the Issue Tracker (F10) to work systematically through issues that Rainbow has identified and flagged, and record the results. And use the Cell Inspector (ALT+F10) to check the logic of any suspicious formulas.
Save time and costs in auditing or comparing Excel spreadsheets
And if you’re less interested in spreadsheet auditing than in tracking changes between spreadsheet versions, then Rainbow’s Comparison Toolbox may be the solution for you. As one customer told us, “I tried it out on 2 large files and I have bought it for the comparisons alone!”
As you can see from the screenshots further up the page and above, Rainbow Pro offers you two different ribbon menus (Standard and Advanced), and there is also a Personal version of Rainbow Analyst which still offers many of Rainbow’s core functions. Click the buttons below to check out either version of Rainbow:
And if you think that you don’t need a tool like Rainbow Analyst because you can find the errors in your spreadsheets by manual inspection, then try the “Rainbow test” on our Why Rainbow page.