Balance or Scale // PerfectXL Spreadsheet Validation
PerfectXL Risk Eliminator

PerfectXL Risk Eliminator walkthrough

On this page you will find a step-by-step walkthrough of the PerfectXL Risk Eliminator. This walkthrough leads you through the basic functionality and use case of the software. Contact us at the bottom of the page to get a live demo yourself.

  • In depth risk analysis
  • Improvement tips
  • Smart Reporting

How to start?

To get started you will first need to login. Simply fill in your username and password to get started.

PerfectXL Risk Eliminator walkthrough // Login screen

Once you’re logged in you will need to upload a spreadsheet which will then start be analyzed by the server:

PerfectXL Risk Eliminator walkthrough // Spreadsheet portfolio

Risk Overview

PerfectXL Risk Eliminator walkthrough // Risks overview

Once you’ve uploaded the spreadsheet you can click over to the Risk Overview tab to see all the risks we’ve found in the spreadsheet. These are separated into different groups which classify the type of risk, and then the risk is defined as: High, Low, or Observation.

PerfectXL Risk Eliminator walkthrough // Risk details

For example, there is a High risk in Calculation doubts called “Sum includes subtotal.” This means there is a situation in which a sum function has included a subtotal somewhere in the range, meaning some parts of the range have been calculate twice. You can also click on the risk to see a description, the location, and an improvement suggestion:

Export to Excel

PerfectXL Risk Eliminator walkthrough // Report

If you prefer to work in a familiar environment you can also export risks & suggestions back to Excel. If you go to the ‘Report‘ tab you can create list reports in Excel which creates a copy of your Excel file, with an extra tab containing all the risks found.

PerfectXL Risk Eliminator walkthrough // Export to Excel

These risks are presented in a table in Excel which can be adjust, it automatically links to the risk locations, and you can filter/add comments to work through the risks methodically. For many users this is a preferred method of validating their spreadsheets.

  • In depth risk analysis
  • Improvement tips
  • Smart Reporting

Read more about risk elimination in spreadsheets

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

VLOOKUP and the combination of INDEX and MATCH are well known ways to search in Excel, and to our great frustration, VLOOKUP is used a lot more often.

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

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

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.

(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.

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.

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

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

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.

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.

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.

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.

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.

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.

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

How can PerfectXL help you?

Share your questions with us, we are more than happy to help you. We will get back to you within 48 hours.