Category Archives: Uncategorized

Analyze Matter Data with Pivot Tables

In this post I’ll explain how to use one of the most powerful data analysis tools in Excel – the Pivot Table.  My example involves a list of new pro bono matters, but pivot tables are also an effective way … Continue reading

Posted in Uncategorized | 2 Comments

Reverse Names with Find & Replace

In a recent post I explained how to count the number of pages in a list of Bates ranges.  Today I’ll discuss a common text formatting issue. Suppose you have a long list of names of the form “Cook, Mary” … Continue reading

Posted in Uncategorized | Tagged , , | Leave a comment