Law.com Subscribers SAVE 30%
Call 855-808-4530 or email [email protected] to receive your discount on a new subscription.
How to Manage Excel Lists
Excel is a good tool for managing lists at the end-user desk. Short of working with a full-fledged database (way beyond the scope of this column), Excel provides the ability to sort, filter, subtotal, parse, join (concatenate) and change the letter casing of your information for easier data handling and reporting.
This is particularly useful when receiving what is commonly referred to as an “ad-hoc” list. These lists often come when requesting data from an outside database, be it from client or opposing counsel, Accounting, Marketing, Billing, Time Reporting, or a Web site. The list is rarely, if ever, formatted in a way that can be easily managed, such as a .txt file format.
The DOJ's Corporate Enforcement Policy: One Year Later
The DOJ's Criminal Division issued three declinations since the issuance of the revised CEP a year ago. Review of these cases gives insight into DOJ's implementation of the new policy in practice.
Use of Deferred Prosecution Agreements In White Collar Investigations
This article discusses the practical and policy reasons for the use of DPAs and NPAs in white-collar criminal investigations, and considers the NDAA's new reporting provision and its relationship with other efforts to enhance transparency in DOJ decision-making.
The DOJ's New Parameters for Evaluating Corporate Compliance Programs
The parameters set forth in the DOJ's memorandum have implications not only for the government's evaluation of compliance programs in the context of criminal charging decisions, but also for how defense counsel structure their conference-room advocacy seeking declinations or lesser sanctions in both criminal and civil investigations.
How AI Has Affected PR
When we consider how the use of AI affects legal PR and communications, we have to look at it as an industrywide global phenomenon. A recent online conference provided an overview of the latest AI trends in public relations, and specifically, the impact of AI on communications. Here are some of the key points and takeaways from several of the speakers, who provided current best practices, tips, concerns and case studies.