May 7, 2022 – Excel array formula to check when all columns match, but ignore blanks Tonight’s tip of the night explains how you can use an array formula in […]
Tips for Paralegals and Litigation Support Professionals – May 2022 Read More »
APRIL 2, 2022: Checking for overlapping deposition designations If you have a list of page and line deposition designations and want to see not only where they match marked page
Tips for Paralegals and Litigation Support Professionals – April 2022 Read More »
MARCH 5, 2022: Finding which PDFs are not text searchable If you have a very large set of PDFs, and you’re uncertain about which files have searchable text, you can
Tips for Paralegals and Litigation Support Professionals – March 2022 Read More »
2/5/2022: Spreadsheet to Track Time Used for Each Party and for Each Examination The Tip of the Night for September 4, 2021 discussed how to use the SUMIF formula in
Tips for Paralegals and Litigation Support Professionals – February 2022 Read More »
Speeding up Chrome – January 8, 2022 There are some simple steps you can take to make sure that your Google Chrome browser is operating at optimum speed so you
Sean O’Shea: Tips for Paralegals and Litigation Support Professionals – January 2022 Read More »
12/1/2021:Number of Examples to Use for CategorizationRelativity suggests that a minimum of 5 to 20 documents be used for any one category, and that as many as 15,000 documents can
Sean O’Shea: Tips for Paralegals and Litigation Support Professionals – December 2021 Read More »
Click on the headings for more detail on each tip. 11/1/2021: Hot key for absolute referenceIn Excel, if you want to automatically convert a cell reference to an absolute reference
Sean O’Shea: Tips for Paralegals and Litigation Support Professionals – November 2021 Read More »
Click on the headings for more detail on each tip. 10/1/2021: Get rid of XE codesYou can also run a simple find and replace search to remove all of the
Sean O’Shea: Tips for Paralegals and Litigation Support Professionals – October 2021 Read More »
9/1/2021: The Quantum Computing Threat to VPNsThe National Institute of Standards and Technology (NIST) has initiated a program to develop encryption strong to provide protection for when quantum computers are
Sean O’Shea: Tips for Paralegals and Litigation Support Professionals – September 2021 Read More »
8/1/2021: Translate any objectOne of the neat things the Google Translate app does is to superimpose a translation into English over writing shown on some object you point your camera
Sean O’Shea: Tips for Paralegals and Litigation Support Professionals – August 2021 Read More »
