3/1/2021: Excel DSUM formulaExcel’s DSUM formula is a useful alternative to VLOOKUP. It will read the column headings of an array of data, and return the sum based on criteria …
Sean O’Shea: Tips for Paralegals and Litigation Support Professionals – March 2021 Read More »
2/1/2021: Editing ppsx In Windows 10, if you want to edit a PowerPoint .ppsx file, you can select it in Windows Explorer and click on ‘New’ instead of ‘Show’. 2/2/2021: …
Sean O’Shea: Tips for Paralegals and Litigation Support Professionals – February 2021 Read More »
1/1/2021: Checking FASP Connection for RelativityOne In order to see if a network is configured to transmit data to a fully qualified domain name via the FASP port run this …
Sean O’Shea: Tips for Paralegals and Litigation Support Professionals – January 2021 Read More »
12/1/2020: Compare Excel spreadsheets for differencesMacro to see if two worksheets in the same Excel file have any text that differs. 12/2/2020: Tracking the Origin of an EmailYou can use …
Sean O’Shea: Tips for Paralegals and Litigation Support Professionals – December 2020 Read More »
11/1/2020: National Practitioner Data Bank The Department of Health and Human Services maintains the National Practitioner Data Bank (NPDB), a database which records restrictions placed on physicians’ privileges to practice, …
Sean O’Shea: Tips for Paralegals and Litigation Support Professionals – November 2020 Read More »
9/1/2020: FedRAMP 3PAOsMake sure that your CSP is evaluated by a third party assessment organization approved by FedRAMP. 9/2/2020: Courtroom Technology in the District of MinnesotaThe ELMO should have a …
Sean O’Shea: Tips for Paralegals and Litigation Support Professionals – September 2020 Read More »
8/1/2020: Maryland Court of Appeals on Social Media AuthenticationIn Griffin v. State, 419 Md. 343 (2011), the Maryland Court of Appeals found social media evidence must be shown to have not …
Sean O’Shea: Tips for Paralegals and Litigation Support Professionals – August 2020 Read More »
7/1/2020: Regex to Remove Relativity Numbering on Downloaded PDFs([0-9]{1}_|[0-9]{2}_|[0-9]{3}_)(.*) 7/2/2020: UPDATE – How to Automate the Insertion of Hyperlinks in MS WordThis macro can be edited so that the full …
Sean O’Shea: Tips for Paralegals and Litigation Support Professionals – July 2020 Read More »
6/1/2020: When to use – ; – ; or —A hyphen – to separate words. An en dash – to separate ranges. An em dash — in place of a …
Sean O’Shea: Tips for Paralegals and Litigation Support Professionals – June 2020 Read More »
5/1/2020: (California Styling)The California style is distinguished by enclosing citations in parentheses and putting the venue and year between the case name and reporter cite. 5/2/2020: Predicting the number of …
Sean O’Shea: Tips for Paralegals and Litigation Support Professionals – May 2020 Read More »
