PerfectXL
Risk Finder

Circular references in Excel can be annoying, as Excel alerts you to their presence but not always their location. In a large file, it can take a lot of time to find the source of the problem. PerfectXL saves you this effort by showing you the exact path of the circular reference, helping you identify and resolve the issue.

When there’s a rush to deliver or review a model, there’s not enough time to manually check all data and calculations. Still, you need some level of assurance. With PerfectXL, you can quickly check for major risks, such as broken formula sequences, incomplete references, and whether External sources are properly used.

If a spreadsheet is filled with error messages, you can’t confidently share it with a client or colleague. Manually identifying each error is time-consuming and often a task to avoid. PerfectXL shows you where the error messages are, which cells they refer to, and their risk level, making it easy to resolve them quickly.

Many will know of formal or informal guidelines for good Excel modeling. Things like FAST, ICAEW Principles, and many more are in place to encourage good practices in Excel, but reminding yourself and others to keep to them can be strenuous. Being able to automatically check your model against principles helps to quickly evaluate quality.

Hardcoded numbers in formulas should be avoided, as it’s often unclear what they represent, and when variables in the model change, hardcoded number are often overlooked. PerfectXL helps you identify risky hardcoded numbers in your model, excluding common constants like 10, 100, and 1000.

Excel offers various ways to hide information, which can be useful but problematic if you need to make adjustments and you are not aware of hidden information. PerfectXL quickly notifies you and allows you to reveal all hidden information, even ‘very hidden’ worksheets, so you’re aware of what’s happening.

Before delivering a model to a client, you often want to ensure they can only edit and see what they’re allowed to. With PerfectXL, you can easily mark unlocked cells to verify whether or not the form works correctly. Then, check the visual overview to confirm that all information not relevant to the user is appropriately hidden or removed.

An auditor’s assessment of a model’s quality, accuracy, transferability, and structure is critical and requires thorough examination. The PerfectXL Suite facilitates a systematic review of all aspects of your model, ensuring you don’t overlook any potential issues.