BXL Integrity Checks Add-In

Add "the Holy Grail" of Integrity Checks effortlessly

by Craig Hatmaker
IT Executive and author of Ribbon Recipes: Beginner's Guide to Creating Excel Menus available on AmazonFollow 10

2 reviews508 views|Start the discussion!|Bookmark Add to cart - $10.00

Description
Help customers succeed. Save time. Save your career.

"The concept of highlighting error cells themselves is obviously the holy grail – but for a variety of reasons is very hard / impossible to do." - Andrew Berg

We made the impossible, possible. Download the PDF (free) to see how.

https://www.dropbox.com/s/bcuklqx6nsi12e2/BXL%20Checks.pdf?dl=0

The PDF shows how to do achieve world class integrity checks manually - without the aid of BXL Integrity Checks. It includes:

1) Integrity checks best practices keys including:
* Add test formulas
* Keep them in a central repository
* Make problem areas obvious
* Make problems anywhere visible everywhere
* Hyperlink to issue locations
* Make alerts actionable

2) A catalog of things to test including technical errors, model errors, financial ratios, KPIs and more.
3) Instructions on how to write test formulas that do not fail
4) A catalog of formulas to use for various tests
5) Instructions on how to add conditional formatting to achieve 'the holy grail' of integrity checks.

But it also contains the add-in's user guide. The add-in makes adding world class integrity checks to our work quick and easy.

Make Doing-the-Right-Thing Easy
We all want to do the right thing but adding best-practice integrity checks manually is cumbersome. BXL Integrity Checks makes doing the right thing easy.

This Best Practice includes
1 Excel Add-in (Windows version)