Tutorial Spreadsheet Risks & Suggestions
To be able to trust a spreadsheet, a thorough check for errors and mistakes is essential. In this tutorial we show you how to let PerfectXL analyse your spreadsheet for 29 kinds of risks and where to find suggestions for improvement.
Analyse your Spreadsheet for Risks
Start with uploading and analysing your spreadsheet into your PerfectXL account. Then click the name of your file to see the full analysis and choose the tab ‘Risks & Suggestions’.
Summary of Detected Risks
Risks & Suggestions starts with a summary of all findings. The overview is divided into 6 subcategories of risks:
For each possible risk the tool tells you how many incidents were detected and wether these incidents are considered high, medium or low risks.
Risk Details & Location
Once you know that your spreadsheet contains risks, of course you want to inspect these incidents and solve them if necessary. PerfectXL helps you with these two steps as well. First you click on the risk category or a specific type of risk you want to inspect.
Next you will find an overview with specific details of all the incidents found: worksheet, cell, type of risk, level and formula.
Use the filter options to find a specific incident or click on a column header to sort the table by this characteristic.
Suggestions for Improvement
Click on a detected risk to find more information about what’s going on and suggestions to solve it. Note: PerfectXL won’t solve it for you: the final decision to modify your spreadsheet is always up to you.
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 calculationsHow 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 ExcelHow 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