Constants

The feature ‘Constants’ summarizes all the constants in your spreadsheet, including the exact locations and where in your spreadsheet references are made to these constants. This overview helps you determine which numbers are fundamental to your results and to verify the assumptions of your spreadsheet.

Overview of Constants

In the overview of constants you find a table that lists all the constants that PerfectXL detects in your spreadsheet. The first column shows in which worksheet the constant was found, the second column shows you the exact cell within that worksheet. In the last column you’ll find where in your spreadsheet the constant is used or referred to.

Tutorial Constants :: PerfectXL Spreadsheet Validation Tool

You can sort the table by clicking the column-name:

Tutorial Constants - Sorting Columns :: PerfectXL Spreadsheet Validation Tool

Formulas Referring to the Constant

Select and click a row in the table, to find all instances where the constant is used. The pop-up that appears shows you each location and the referring formula(s).

Tutorial Constants - Referring Formulas :: PerfectXL Spreadsheet Validation Tool

Filter Options

Using the filters in the upper left corner of the table allows you to restrict the list of constants to certain worksheets only, or to enter a minimum and/or maximum value to formulate a certain range of constants.

Tutorial Constants - Worksheet Filter :: PerfectXL Spreadsheet Validation Tool

 

Tutorial Constants - Cell Value Range :: PerfectXL Spreadsheet Validation Tool

Watch our Video Tutorials

In the video’s below, several features and possibilities of PerfectXL are described and demonstrated thoroughly. In time we will add more video tutorials.

Video Tutorial: Tracing Problems in Spreadsheet Calculations :: PerfectXL

Tracing Problems in Calculations

When spreadsheets contain inconsistencies or suspected miscalculations, it takes great effort to find the problem manually. In this video we’ll show you how to use PerfectXL’s Formula Breakdown feature to locate and fix the problems in spreadsheet calculations within a matter of minutes. 

Learn how to trace problems in spreadsheet calculations

Video Tutorial: How to Check Your Input Source in Excel :: PerfectXL

How to Check Your Input Sources in Excel

In this video we’ll show you how to run a quick basic check of the input sources of your spreadsheet and how to determine if there is any unknown input. We’ll also show you a powerful way to visualize your spreadsheet’s information flow to help determine the function and dependability of each worksheet.

Learn how to check your input sources in Excel

Video Tutorial: How to Quickly Validate Your Spreadsheet :: PerfectXL

How to Quickly Validate your Spreadsheet

88% of spreadsheets contain hidden issues. These issues can be a serious risk to the outcome of your spreadsheet. This video shows you how PerfectXL helps you to quickly validate your spreadsheet on 29 types of risk, without having to check every cell manually.

Learn how to validate your spreadsheet