SEMINAR: Excel Tips and Tricks

August 24, 2017
12:00 PM to 1:30 PM
 Add to Calendar

O'Melveny & Myers LLP
2765 Sand Hill Road
Menlo Park, CA 94025

Advanced Excel Tips and Tricks

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.

RSVP: Please use the REGISTER link below, no later than August 21, 2017.

If questions or to cancel a reservation, contact to avoid being charged.

Cost (includes lunch):  *Bring your check made payable to ALA Silicon Valley Chapter or pay by credit card here

ALA Members: No Charge
Business Partners: 
No Charge
Business Partners: $20 *
Non-ALA Members:  $20 *


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.

Sponsored by: 




We appreciate the generous support of our chapter sponsors. Thank you!

Be sure to meet all of our distinguished Chapter Business Partners -- building a positive business relationship and understanding their services is advantageous when you need a product or service at a moment's notice. Business partners are an important resource for legal management professionals to perform their jobs, plan for the future, and build their knowledge about changes and trends in products and services for the success of their firms.

Education Credit:

  CLMSM App Credit:
  1 hour in the subject area of Information Technology
  CLMSM App Credit for Functional Specialists: 
  1 hour in the subject area of Operations Management (OM) towards the additional hours required of some Functional Specialists to fulfill the CLM application.
  CLMSM Recertification Credit:
  1 hour in the subject area of Operations Management (OM)

 ALASVC seminars are typically scheduled on the 3rd Thursday of the month