Typewriter by Sweeney // PerfectXL Spreadsheet Validation

PerfectXL Explore

Leave these 9 Excel frustrations behind!

Be honest with yourself, how much time does it take you to spit through an Excel file? The opportunities in Excel are endless but this comes with a downside. PerfectXL has the solution. Starting now you can gain a better understanding of your spreadsheets, to help you in improving, documenting, and cleaning up your files. Here are 9 tasks that PerfectXL Explore makes easy.

Task 1: Quickly understand unfamiliar spreadsheets

Understand a spreadsheet easily? PerfectXL Explore shows you the ‘what, why, and how’ of a file. You can instantly understand the structure of even the most complex spreadsheets.

Task 2: Easily explain and transfer Excel files to someone else

The interactive visualization in PerfectXL Explore is the perfect way to quickly explain the complexities of a spreadsheet to someone else. This visualization shows all worksheets and data and the relations between different aspects of your file. Using this software, your colleagues will easily understand your work and be able to step in right away.

Task 3: Add documentation to your Excel file

The same visualization can be saved and added to your spreadsheets. This can be shared with internal or external parties to give them an immediate understanding of the structure of your Excel file. On top of this Explore gives you all the information you need to create your own accurate documentation.

Task 4: Check for hidden/very hidden worksheets

Excel does not give you access to all hidden information, whereas Explore does! Use PerfectXL Explore to quickly check any hidden worksheets or data. This way you’ll never miss important aspects of your spreadsheet and always have a complete understanding of what’s going on.

Task 5: Gain insight into external connections

Excel files are often linked to external files, databases, websites ect. PerfectXL Explore gives you insight into all external sources and exactly where they are being used in your spreadsheet.

Task 6: Check the dataflow of your spreadsheets

The interactive visualization shows you exactly how data flows throughout your file. Use this to sperate inputs, outputs, and calculations. The arrows between worksheets will show you exactly which information is being transferred and how it’s being used.

Task 7: Check your VBA code

Macros can easily become messy and hard to understand or read. PerfectXL Explore neatly organizes and presents you with all the VBA code in one place so that you gain much needed oversight.

Task 8: Clean up unused parts of your spreadsheet

Overtime spreadsheets will collect aspects that are no longer being used. PerfectXL Explore checks defined names, external connections, and notes when these are not referenced anywhere. On top of this the tool gives you all the information you need about data validation and conditional format rules so you can quickly find and delete unneeded aspects. PerfectXL Explore also shows all Excel objects so that you can quickly see whether these are playing a role in your spreadsheet.

Task 9: Simplify and improve spreadsheets

The simpler, the better. PerfectXL Explore can help you with that! View all worksheets and see how calculations are being used and interlinking between sheets. This way you get a clear overview as to which calculations need to be adjusted especially when removing a worksheet to simplify the model.

Well there you have it, 9 ways in which PerfectXL explore makes your life easier! You can request a demo for PerfectXL Explore below. Have you already decided what you’re going to do with the time you’ll save?

  • It’s fast & easy to use
  • Get detailed insights
  • Save frustration and time

Read more about exploring Excel files

On this page you will find a step-by-step walkthrough of the PerfectXL Explore Tool. This page will give you information on how you can use explore to gain a better understanding of complex Excel files.

This is the technical page for PerfectXL Explore. Here you will find information like system requirements, release notes, and answers to most questions about our software. If you have more questions please use the form at the bottom of the page.

In this video we’ll show you how to run a quick basic check of the input sources of your Excel files 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.

When we read a book or a report or a website, we read from top to bottom and from left to right. Keep this in mind when you create an Excel file. Try your best to follow that structure both within each worksheet and between them. We advise you to distinguish separate input & output sheets as well as sheets for calculations, documentation and dashboards.

Numbers without meaning are worthless. Excel is a program for numbers, but it is only useful if it is clear to the reader or user what these numbers mean. So, make sure that you provide textual information for all data and formulas, let’s call these pieces of text information labels.

Treat transferring a spreadsheet like you would treat the process of renting your house via Airbnb. Most people realize it will stay neater if you clean it first. Mess stimulates mess, and neatness stimulates neatness. Remember that in an average spreadsheet there will be 12 different users that have to use it after you! What do you think happens when this chain starts with a messy file?

Garbage in, garbage out. So pay serious attention to cleaning your input data as it is the foundation of your spreadsheet and if possible, do it in such a way that it becomes an automated process for the next time you use the same spreadsheet.

Understanding the workings of a spreadsheet is key to correctly interpreting its results. Spreadsheet visualization is an essential feature of PerfectXL Explore. It allows you to create a graphical model of the general flow of information, which also shows of risks, input & output and data & formula flows.

Curious to see what your spreadsheet’s all about? PerfectXL Explore gives you a great starting point. An overview of worksheets, input sources and potential risks are all part of our general spreadsheet characteristics section. It also gives you an insight into the amount of formulas used in your spreadsheet.

Be honest with yourself, how much time does it take you to spit through an Excel file? The opportunities in Excel are endless but this comes with a downside. PerfectXL has the solution. Starting now you can gain a better understanding of your spreadsheets, to help you in improving, documenting, and cleaning up your files. Here are 9 tasks that PerfectXL Explore makes easy.

Request a demo

Request a demo for PerfectXL Explore, or share your questions with us, we are more than happy to help you. We will get back to you within 48 hours.