Comparing Lists of Values in Microsoft Excel

This blog post lists all Excel formulas used to compare lists and provides examples of each one. This is useful for many reasons, such as comparing lists of case numbers, phone numbers, suspects, etc.

June 17, 2011


Redact your Microsoft Word Bulletins with this Free Add-In

The Word 2007 Redaction Tool can be used to hide text within Microsoft Office Word documents. You can mark text to redact and then create a new, redacted version of the document in which the marked text is replaced with a black bar that cannot be converted back to the original text. Visit: for […]

June 8, 2011


View Analysts Notebook Charts for Free

Download the free ChartReader application from here:–services/analysis-product-line/chartreader to view charts creating using i2’s Analysts’s Notebook.

October 19, 2010


List of State and Local Government Agencies

A website list of agencies by state that you may find helpful:

October 5, 2010


Google Alerts – Receive Email Updates of Relevant Google Results

Google Alerts are email updates of the latest relevant Google results (web, news, etc.) based on your choice of query or topic. Google Alerts uses the Google search function to locate recent content based on your chosen search terms and then sends that content to your e-mail. The search terms can include advanced search functions, […]

August 5, 2010


Rounded Time and Range

If you have a time in Excel and want a time range that respects 24-hour format time, here is a custom function. Tested in Excel 2000 and 2003. if you need help adding the code to Excel, please see the related article here: Rem TimeRange – return a time +/- the number of hours […]

January 7, 2010


Link Your Addresses

Whenever you are publishing a bulletin, sending an email, making a brochure, why not include a map? Consider these examples: An invitation to a meeting: the address of the meeting location is formatted as a hyperlink. Clicking the address opens a map showing that location. An intelligence bulletin: the offender’s address is a hyperlink. Clicking […]

November 18, 2009


Automatically Delay Sending Bulletins with Outlook Rules

Ever send out an email (or specifically, a bulletin) to the entire department, only to discover that you forgot a key piece of information? using the Rules feature of Outlook, you can mitigate this issue. Go to Tools – Rules. Set up a new, blank rule with the following choices: Apply this rule after I […]

October 20, 2009


Add a Picture to MS Excel Comments (Pop-Up)

A MS Excel comment is a pop-up box that appears when you hover over the cell with your mouse. Cells containing comments are indicated by a red triangle in the upper right corner. Right-click the cell where you want to add the comment/photo and select “Insert Comment”. Make sure the comment block is blank (i.e. […]

September 21, 2009

Tip – FREE Search Tool is another great & FREE people search engine.

September 17, 2009

Refer a Colleague

Let your colleagues know about the benefits of the IACA!