Excel Spreadsheet Consolidations

We also have Free training videos on this site ( visit the Home page or the Training Page)

Excel spreadsheet consolidations made easy

Excel spreadsheet consolidations need not be a headache. With Spreadsheet Professional as an add-on, Excel spreadsheet consolidations can be handled accurately and with ease. The package features several tools which enhance the reliability of worksheets.

Errors in worksheets can be discovered and rectified within minutes. Instead of taking hours on Excel spreadsheet consolidations, auditors can use their time more productively.

Some of the useful features of the package:

• Calculating errors discovered and corrected automatically with the built-in calculation checking tool.
• Full documentation and reporting for each worksheet can be done, which include overviews, mapping, input trail documentation, translations, and results.
• Translating of calculations into English is done through the translator tool.
• Comparison of worksheets can be done for the identification of differences in input values, formulas used, and the results of the calculations.

The four main tools are discussed in more detail below to give you an indication of just how effective Spreadsheet Professional is.

Checking calculations

With the calculation tester or checker you can easily locate existing and potential worksheet errors. It works in the same way as a spell and grammar checker and as such it helps to eliminate the most common input errors quickly.

Comparison tool

Use the tool to identify differences in models regarding input, formulas and results. It is possible to compare two versions of the same worksheet or two different worksheets which used the same model.

Translating calculations

The tool is used to make complex worksheet formulas understandable for the user. Each cell can be translated to English and even the values of each element within a formula explained.

Documentation tool

The tool can produce reliable and up to date reports for all your models through a few easy to follow steps. As many as eight different reports can be generated that explain specific aspects of the worksheet model.

Using the package for Excel spreadsheet consolidations will not only save you time and money, but increases the level of accuracy and professionalism. Visit our products page to view a demo of the effectiveness of the package.