Excel PivotTables have been around for more than 10 years. Yet, so few law firms utilize them effectively. Their usefulness exists for data analysis in litigation cases and financial analysis for partners. For anyone who works in Excel, PivotTables can literally save you hours of time every day. They allow you to adjust how you view data on the fly in seconds with just a few mouse clicks. Best of all, creating a PivotTable is so much easier than you might think. Once you learn how to do it, your Excel world will be changed forever. This session will demonstrate practical examples of when PivotTables are useful and the basics of how to create one.

Objectives:

  • Explain how to create a PivotTable, as well as how to convert a traditional Excel table into one.

  • Discover the potential of reporting financial and statistical data to your partners through PivotTables in real time.

  • Summarize thousands of records with a few mouse clicks.

  • Create a pivot chart that is user responsive based on predefined filters.

John Federico is an attorney and Senior Consultant with Affinity Consulting Group. Prior to joining Affinity, he practiced law for nine years, litigating personal injury cases, insurance cases and numerous appeals. Federico is also a licensed patent attorney with degrees in electrical and computer engineering. A member of the Ohio State and Columbus Bar Associations, Federico now specializes in HotDocs document assembly software and software training, including integrations with case management systems such as LawBase, Amicus Attorney, Time Matters, Actionstep and PracticeMaster.

 

 

 

CLM® Application Credit: 1 hour in Information Technology

CLM® Application Credit for Functional Specialists: 1hour in the subject area of Operations Management (OM) towards the additional hours required of some Functional Specialists to fulfill the CLM application.

CLM® Recertification Credit: 1 hour in the subject area of Operations Management (OM)

 

 

 

Seminar Information
Date Presented:
December 07, 2017 3:00 PM Eastern
Length:
1 hour
ALA Member Price:
$109.00
Non-Member Price:
$129.00
Analyze Data Quicker and Easier Than Ever Before with Excel PivotTables
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.
Email Address:
Password:
Products
On-Demand
ALA Member Price:$109.00
Non-Member Price:$129.00