Validating the Inner Structure of your Spreadsheet
PerfectXL offers a number of tools to get a clear view of the inner structure of your spreadsheet. With Spreadsheet Visualization, you can get a schematic overview that easily shows the flow of information and the internal structure. Other ways to validate your spreadsheet is by letting PerfectXL break down your spreadsheet in a summary of characteristics, such as the amount of worksheets, cells and external sources.
Spreadsheet Risk Validation Excel
Risk Validation is a feature of PerfectXL that lets you automatically inspect your spreadsheet for any types of risk and Excel mistakes. The feature produces a list of all risks found within the spreadsheet, along with locations of all the cells where these risks are present. PerfectXL currently covers 21 distinct risk types.
Checking Formulas and Constants
The longer a formula within a spreadsheet becomes, the less clear it is to see if the formula still checks out. The feature Formula Breakdown lets you inspect the formulas that have been used in your spreadsheet. The formulas are listed by Formula Breakdown, allowing you to check them out individually. Formula Breakdown also applies its own system for Excel formula validation and risk detection. Besides formulas, PerfectXL also provides a list on constants that are in use within your spreadsheet.
Share and Review Validation Results
Knowing the structure of your spreadsheet is nice. Letting other users know that structure is even better. With PerfectXL, you can compile a report on your spreadsheet that clearly explains all characteristics, formulas and constants. In addition to this information, you can also provide a list of present risks. This report can be easily shared with colleagues by downloading it as a PDF file.
How to Video's
How to Check your Input Sources - Case: are the spreadsheet results based on complete and up-to-date information?
How to Quickly Validate your Spreadsheet - Case: preclude abnormalities before passing the spreadsheet to a client