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.

Objectives:

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

Length:

1 hour

ALA Member Price:

$109.00

Non-Member Price:

$129.00

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

Subscription

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.

Cookies are small pieces of information that are stored by your browser on your computer’s hard drive.
This website uses cookies to enhance the convenience and use of the site, and has placed cookies already.
You can delete or block cookies within your browser settings.
Should you opt to do this, some parts of our site may not work.

By using this site, you agree to our use of cookies.

For more information, including instructions on how to remove the cookies that have been placed,
see our Privacy Policy.