Formula Breakdown Tutorial
When a formula becomes long and incomprehensible, it can be difficult to see if it’s still correct. In this formula breakdown tutorial we teach you how to use PerfectXL’s Formula Breakdown feature, to assist you in understanding the formulas used in your spreadsheet. By clicking a formula you can, much better than in Excel itself, discover how they work.
Break Down That Formula!
To perform a formula breakdown with PerfectXL, you start by uploading and analysing your spreadsheet in the tool. Then click on the name of your file to see its full analysis and navigate to the ‘Formula Breakdown’ tab. Here you’ll find an overview of all the formulas that are found in your spreadsheet. The overview shows you per worksheet which formula is found in what cell.
Inspect a Formula
Click a formula of choice in the overview to start the breakdown.
Keep clicking on a cell or range of an underlying formula to follow it down to the source. Formulas you have clicked on stay put, so you can always return to a previous formula by clicking it again.
Direct Risks per Formula
PerfectXL’s risk detection is integrated into the formula inspection. Direct Risks are risks that are directly related to the formula; Indirect Risks are found in underlying formulas. After all, a risk in an underlying formula could be just as important for the cell result as a risk in the formula itself.
Indirect Risks per Formula
This overview shows a list of risks that are found in underlying formulas.
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.
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
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
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