Excel for Legal

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


- 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


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.

Similar Courses

Card image cap
65 minutes
#MeToo - Media Frenzy, New Era in Sexual Harassment, or Both?
Sexual harassment claims against celebrities and high-profile men continue to dominate media coverage in 2018. There is no question that employers are legally required to investigate complaints of harassment in the workplace and take action to punish employees who commit acts of harassment.

American Bar Association


Add to Cart
Card image cap
92 minutes
#MeToo: Empowering Employees and Employers to Address Workplace Sexual Harassment & Violence
Join our expert attorneys as they discuss how employers can work to prevent and eliminate sexual harassment and violence in their workplace, and create an environment in which employees are able to respond to and report incidents without fear of retaliation. Not only is there a deep moral imperative to rectify sexual harassment in the workplace and promote an equitable work environment, but also there is significant monetary liability as a potential consequence for employers who fail to address harassment in the workplace.

American Bar Association


Add to Cart
Card image cap
77 minutes
§ 363 Sale Issues
Dive into Section 363 sales issues, including whether there are limits to “free and clear”; the GM conflict between Sections 365(h) and 363(f) (“lease-stripping”); sales free and clear of leasehold interests, restrictive covenants and override royalties; being free and clear of successorships in CBAs; selling free and clear of environmental liabilities (La Paloma, Exide); and loan-to-own strategies.

American Bankruptcy Institute


Add to Cart
Card image cap
63 minutes
2018 CA Consumer Privacy Act: The Big Tail Wagging the U.S.
In this session, two leading information governance attorneys will share why you need to and how you can be ready.



Add to Cart
Previous Next