Excel Tools

PerfectXL Risk Eliminator

Would you like to avoid painful mistakes and hidden defects in your Excel files? Follow the example of many other Excel users and start using PerfectXL Risk Eliminator today.

  • Avoid >70 types of risks
  • Improvement suggestions
  • Quality reports

Heading for
Reliable Spreadsheets

A full report about the quality of any spreadsheet in under a minute? We know it sounds impossible, but not anymore. The PerfectXL Risk Eliminator offers clarification on more than 70 risks, mistakes and errors your spreadsheet might contain and even provides you with extensive improvement suggestions. Any Excel user can improve Excel files with our intuitive software.

Avoid risks in all shapes and sizes

The PerfectXL Risk Eliminator scans for risks in the following categories:

  • Calculation doubts
  • Structure issues
  • Range issues
  • Hidden info
  • Complex formulas
  • Vulnerable functions
  • VBA Issues

And you are in
good company

PerfectXL serves clients from different industries. The tool has proven its value to accountants, consultants and financial experts as well as professionals from high tech, energy, logistics and transport industries.

“This system helps users to develop outstanding models. This toolkit finds everything. Hard-coded numbers, external links, inconsistent formulas and far beyond. I will be using this for years to come. It is a brilliant system!”

Evan Mudd, Rock Associates

  • Avoid >70 types of risks
  • Improvement suggestions
  • Quality reports

Read more about risk elimination in spreadsheets

On this page you will find a step-by-step walkthrough of the PerfectXL Risk Eliminator.

Here you will find information like system requirements, release notes, and answers to most questions about our software.

Do you wish to refine PerfectXL Risk Eliminator’s analysis to cater for your specific requirements? PerfectXL allows for full customization of your user interface.

Long ago, Excel was not as clever and advanced as today, but the so-called array functions have been around for a long time. However, most people do not know about them, and do not understand them.

Whenever possible, keep your Excel formulas short and simple. Avoid long formulas; they are harder to read, harder to understand, difficult to check and tough to improve.

Sometimes, you need to use the exact same formula, based on the same numbers, in several other formulas. You might be tempted to calculate this formula twice, but resist the temptation. Make sure that you calculate your formulas only once!

It is so tempting to merge cells in Excel so that they form a header above two or more columns. Yes, we must admit, it looks nice, but resist the temptation because it can be dangerous!

It’s a bad idea to leave standard Excel errors in your workbook. Take the time to clean up, because after a while, you no longer know whether you left a mistake consciously or if there is something wrong with your spreadsheet.

(Hidden) circular references occur when Excel tries to compute a result of a cell that’s already been visited during the calculation round. Excel doesn’t warn us of conditional circular references.

Sometimes a formula can spill over onto 2 or 3 lines making the standard 1 line formula bar too small to read. So how can you make formulas readable?

Among the infinite number of settings in Excel, one innocent looking option fundamentally changes the way Excel calculates formula results. It goes by the name Iterative calculation. This little known feature has its uses, but it doesn’t come without risk.

Place a formula close to its input variables. You reduce the chance of mistakes, you make optimal use of Excel’s support, and your spreadsheet becomes easier to carry over to someone else.

The use of hard coded numbers is a bad idea. A future user will not know where the number came from, and hard coded numbers don’t change automatically, and thus might be overlooked when a change is made.

Excel horror stories are often related to accidentally changing, shifting or changing units or number formats.

VLOOKUP is used a lot more often than INDEX and MATCH, while the latter combination is ultimately much better. The combination of INDEX and MATCH is less error prone and a lot more efficient.

Reporting is an integral part of Excel. Reports are generated in Excel, reports are built in Excel, and in many cases reports are a form of documentation required to properly use certain models in Excel.

Our software inspects spreadsheets on all kinds of spreadsheet risk. Read more about some of the risks we detect in spreadsheets here.

To be able to trust a spreadsheet, a thorough check for errors and mistakes is essential. There are lots of different ways a simple mistake can destroy the validity of a spreadsheet.

Do not hide anything except some sheets. Excel has too many attractive options that look good but may be risky in the long run.

Good, error-free spreadsheets are essential for using them reliably in business. This is why risk detection is an important aspect of spreadsheet validation.

Excel is a powerful tool. And when it can’t do what you need, VBA can fill the gap. Unfortunately, using VBA can lead to unpredictable behaviour, slow performance, and corrupt Excel files.

How can PerfectXL help you?

Share your questions about our products. We will be
in touch with you in the next 48 hours.

Other PerfectXL tools

PerfectXL Highlighter

The PerfectXL Highlighter is what’s been missing from Excel. Understanding your Excel files has never been this easy.

Read more here

PerfectXL Explore

Formulas, external sources, pivot tables and graphs can now be visualized easily. PerfectXL Explore provides you with a comprehensible blueprint of your spreadsheet within seconds.

Read more here

PerfectXL Compare

Our new Excel compare tool is fast, reliable, and easy to use. Compare two Excel sheets now and see for yourself!

Read more here