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

By Sue Hughes
December 21, 2009

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.

Read These Next
New York's Latest Cybersecurity Commitment Image

On Aug. 9, 2023, Gov. Kathy Hochul introduced New York's inaugural comprehensive cybersecurity strategy. In sum, the plan aims to update government networks, bolster county-level digital defenses, and regulate critical infrastructure.

The Bankruptcy Hotline Image

Recent cases of importance to your practice.

Law Firms are Reducing Redundant Real Estate by Bringing Support Services Back to the Office Image

A trend analysis of the benefits and challenges of bringing back administrative, word processing and billing services to law offices.

How AI Has Affected PR Image

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.

The DOJ's Corporate Enforcement Policy: One Year Later Image

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.