Spreadsheet Characteristics Tutorial

This spreadsheet characteristics tutorial teaches you how to find the key characteristics of your spreadsheet in one simple overview. In addition to an overview of worksheets you can find information about cells, formulas and external sources that are used.

Overview of Workbook Characteristics

The characteristics overview summarizes the details of your spreadsheets, such as file size, creation date, last modification date and number of references. It also shows the number of non-empty cells, unique formulas and risks per sheet in the workbook and whether it is visible or hidden.

Spreadsheet Characteristics Tutorial :: PerfectXL

A. If a worksheet is hidden in Excel, this will be shown here; B. Assign a category to a worksheet.

If you want to learn more about the risks and high risks mentioned in this overview, please read the tutorial Risks & Suggestions.

Cells, Formulas and External Sources

The second part of the spreadsheet characteristics overview summarizes important information about cells & formulas within your spreadsheet and a list with all external sources (spreadsheets) referred to from your spreadsheet.

Spreadsheet Characteristics Tutorial :: PerfectXL

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