Formula Navigation

It's very easy to get lost in an Excel formula. With eX-ray Navigator, you can jump straight to any reference in a formula.

Imagine your lookup formula is pulling a date from a massive list, but you're not sure if it picked the right row or column.

With Navigator, you can instantly jump to that exact cell and verify it's correct. And it's not just for lookups ‐ Navigator works for all your formulas!

It's the fastest way to understand and navigate even the most intricate spreadsheets.

• Navigate your Excel formulas and browse references with ease.
• Diagnose SUM, IF or any Excel function or formula.
• Navigate directly to the result of a VLOOKUP formula.
• Understand the result of an INDEX and MATCH formula.
• Select all the cells that match your SUMIFS and COUNTIFs formulas.

Reveal Your Spreadsheet Structure

The most common errors in Excel are easy to find using Reveal.

Press a button and instantly see the structure of your worksheet.

Are your formulas copied correctly? Have you accidentally overtyped a formula? Have you left in last month's manual adjustment?

With Reveal, you can see all of this in an instant.

Fast, intuitive, and effortless—troubleshoot Excel spreadsheets in seconds.

• Reveal mistakes in your Excel spreadsheets using our instant temporary colour filter.
• Quickly identify mistakes in what appears to be a correct data block.
• Original spreadsheet not modified.

Controls

Even small changes in hidden parts of an Excel model can have big consequences.

With eX-ray Control, you can pin critical cells to a live panel that's always visible — no matter where you are in the workbook.

If a key value changes — even offscreen — you'll see it instantly, with clear red highlighting showing the difference.

You can even save your Control panel with the file, so next time you open the spreadsheet, your critical checks are ready to go.

Stay in control of your models — and spot unexpected changes before they become expensive mistakes.

• Get an alert if the most important cell on your Excel spreadsheet changes using our Control feature.
• Easily maintain the integrity of your data.
• Get control of your spreadsheets and avoid errors.

Comparing Excel Spreadsheets

• Comparisons made easy using eX-ray Compare to find differences in two Excel spreadsheets or workbooks.
• Has somebody changed your spreadsheet but you have no idea what they changed?
• Use eX-ray Compare and you will see all the changes in a matter of a few clicks.

Colour An Entire Sheet

• Colour the entire sheet to highlight unique formulas and hard coded numbers.
• Quickly identify mistakes in what appears to be a correct data block.

Our Story

• Daniel Kelly has many years experience building and reviewing complex spreadsheets, in the City of London.
• He has teamed up with Tsemed Pitronot to encapsulate his many years of experience into our eX-ray Excel add-in.
• eX-ray will help you build and review great Excel spreadsheets, and enable you to find to errors quickly.
• Make sure that your meticulous return on investment calculations are accurate.