# 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.

## 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 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