It can be a time consuming task to audit or troubleshoot Microsoft Excel spreadsheets.  The majority of the time you can discover problems quickly by reviewing the cell content.  This custom report provides a nice matrix for easy reviewing.  User can choose which cell attributes to include in the report.  This report is especially useful when working with large amounts of data or several linked workbooks.  Below is the screen shot of this utility.

JEM Plus (Add-in) is a must-have software for individuals that work with Microsoft Excel Spreadsheets.   and discover cool new tools and functionality that will have a tremendous impact on your productivity.  Contains several robust utilities and 207 additional worksheet functions (mostly financial).  JEM Plus provides professionals and everyday users the power to get the most out of their Microsoft Excel Spreadsheets.

This is a great tool for auditing or troubleshooting dates.  It allows users to identify errors or inconsistencies quickly.  If there is a problem with a date; run and scan this report and most likely the problem will be easy to identify.  User can choose which cell attributes to review which also saves time.  This report is especially useful when working with large amounts of data or several workbooks.  Below is the screen shot of this utility.

JEM Plus (Add-in) is a must-have software for individuals that work with Microsoft Excel Spreadsheets.   and discover cool new tools and functionality that will have a tremendous impact on your productivity.  Contains several robust utilities and 207 additional worksheet functions (mostly financial).  JEM Plus provides professionals and everyday users the power to get the most out of their Microsoft Excel Spreadsheets.

 

If you require an easy to read report that contain workbook attributes for one or more Microsoft Excel Workbooks, then use this special report utility.  Simply select the workbook and workbook attributes to review on the report and off you go.  It is a great management tool.  Below is the screen shot of this utility.

JEM Plus (Add-in) is a must-have software for individuals that work with Microsoft Excel Spreadsheets.   and discover cool new tools and functionality that will have a tremendous impact on your productivity.  Contains several robust utilities and 207 additional worksheet functions (mostly financial).  JEM Plus provides professionals and everyday users the power to get the most out of their Microsoft Excel Spreadsheets.

The Worksheet Summary report is a great way to review and manage workbooks.  For instance, a high number of data inputs versus formulas might mean the user or developer of the workbook is not really using Microsoft Excel as intended.  In addition, if a formula is available to replace data inputs, then one would choose the cell formula to protect the integrity of the worksheet.  This reporting tool provides insight to the design for various worksheets.  Below is the screen shot of this utility.

JEM Plus (Add-in) is a must-have software for individuals that work with Microsoft Excel Spreadsheets.   and discover cool new tools and functionality that will have a tremendous impact on your productivity.  Contains several robust utilities and 207 additional worksheet functions (mostly financial).  JEM Plus provides professionals and everyday users the power to get the most out of their Microsoft Excel Spreadsheets.