Card image cap

Excel for Legal

Level: Intermediate
Runtime: 62 minutes
Recorded Date: September 26, 2019
Click here to share this program
Download PDF
Closed Caption


- Navigation
- Entering Data
- Order of Operations
- AutoFill
        - Data
        - Formula
- Read in data from another location
- Naming Cells
- Paste into Word
- Protecting Cells
- Commenting
- Relative/Absolute Cell References
- Formulas
- Running Totals
- Grand Totals
- Sorting
- Filtering

Runtime: 1 hour 2 minutes
Recorded: September 26, 2019


Most firms have the full Microsoft Office Suite, yet are woefully underutilizing it, to the detriment of their firm. In this session, Affinity Consultant and Microsoft Excel expert Cyara Hotopp will teach you the ins and outs of Microsoft Excel for the law firm. You'll learn about specific features that are most commonly used and gain more intermediate skills, both of which will make an immediate impact on your daily use of Microsoft Excel. Learn how to set and change equations in cells Get the basics of formatting and color coding a spreadsheet to make the information more palatable for presenting to court, jury, client, or internally

This program was recorded on September 26th, 2019.

Provided By

American Bar Association
Card image cap


Card image cap

Cyara Hotopp

Consultant, Document Automation
Affinity Consulting Group, LLC

Cyara Hotopp is a Consultant at Affinity Consulting Group, LLC. She earned her JD at The Ohio State University Moritz College of Law in 2016.

Card image cap

Similar Courses

Card image cap
64 minutes
"I Am Not a Cat" Proceedings in a Virtual World
Besides becoming a pop-culture catchphrase, how has the shift to a virtual environment impacted proceedings over the last year, and what changes do you believe are here to stay? Our panel of experts will examine some of the greatest challenges, faux pas, and successes in virtual proceedings over the course of this transformative time.

Women, Influence & Power in Law Conference


Add to Cart
Card image cap
63 minutes
2021: The Year of the ELM
Panelists will clarify what constitutes an ELM platform, examine its unique and compelling capabilities, and discuss its strategic and tactical advantages, particularly those stemming from data-driven insights and machine-driven decision making. Attendees will gain a clear understanding of the significance of the emergence of ELM solutions, what firms and law departments can achieve with ELM platform, and practical and ethical considerations related to adopting an ELM solution.



Add to Cart
Card image cap
97 minutes
26 Words that Created the Internet - Basics of the Communications Decency Act Section 230 Safe Harbor
This program will examine the basics of CDA 230 and its day to day affect for those who advise internet businesses as well as those who litigate against them. It will give practical guidance as to what extend internet companies can or should edit or censor the information their users contribute to their sites and to what extent those users will actually be liable.

New Media Rights


Add to Cart
Card image cap
63 minutes
360-Degree View on How to Navigate a Crisis
During this session, our panel of experts will explore the following topics to arm you with a plan to protect the company and minimize long-term problems: - Building a crisis management team and understanding each person’s unique role -Preparedness – advance planning and assessing potential risk areas - First Response – responding in the critical first hours and days to minimize the long-term impact - Resolution Strategy – managing various actions stemming from the crisis to enable the best resolution for the company.

Women, Influence & Power in Law Conference


Add to Cart
Previous Next