Learn how to take Excel spreadsheet solutions to the next level of productivity. Attendees are guided through intermediate and advanced techniques for using Excel to increase the types of financial data they can produce in the legal setting.


  • Explain the "lookup" feature and how to find values in lists.
  • Discuss how to distribute delimited data across cells.
  • Demonstrate how to group, filter and total large lists of data.
  • Outline how to set up reliable data validation.

Audience Statement: This session assumes that participants have 10 years of experience and/or advanced degree in field of study. Attendees should have advanced knowledge of spreadsheet applications.

  • 60 Minutes
  • Audience: Advanced
  • CLM App Management Category: Information Technology
  • CLM App Management Category -FS: Operations Management

Speaker Info

Ivan Hemmans is a Senior Manager of Technical Development at O'Melveny & Myers LLP and has extensive experience with information technology. He has worked with law firms for 18 years and computers for approximately three decades. With a background in computer programming and a Cognitive Science degree from UCLA, he offers a unique blend of experience and good-natured humor.


Seminar Information
Date Presented:
August 02, 2018 3:00 PM Eastern
1 hour
Registration Fee:
Advanced Excel Tips and Tricks
Individual topic purchase: Selected
Association of Legal Administrators
CLMSM Recertification Credit: 1.00
For other credit opportunities, please check the program description or email certification@alanet.org
You must be logged in to access ALA Subscriptions.
To continue, you need to log in to Peach New Media. If you have any questions about your account please contact us at 1-866-702-3278.
Email Address:
ALA Member Price:$109.00
Non-Member Price:$109.00