Attention:
Card image cap

Excel for Legal


Level: Intermediate
Runtime: 62 minutes
Recorded Date: September 26, 2019
Click here to share this program
Printer-Friendly Version
Closed Caption

$75

Archived
Unavailable for Purchase

Agenda

- 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
        -SUMIF
        -PMT
        -EDATE
- Running Totals
- Grand Totals
- Sorting
- Filtering

Runtime: 1 hour 2 minutes
Recorded: September 26, 2019
For NY - Difficulty Level: Both newly admitted and experienced attorneys

Description

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

Panelists

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.

CLE CREDITS

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

$65

Add to Cart

12 Credit States

More Details
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.

Legalweek

$65

Add to Cart

12 Credit States

More Details
Card image cap
63 minutes
40 Years of Data: What the Data on the Industry Says About Its Future
For 40 years, The American Lawyer, its affiliate publications and ALM Intelligence’s Legal Compass have been collecting data on law firms, clients and providers. What does the data tell us about where the industry is headed? We will take a deep dive into our data and others’ to assess the state of the industry and its future.

Legalweek

$65

Add to Cart

11 Credit States

More Details
Card image cap
58 minutes
5 Ways Agreement AI Can Enhance Performance and Reduce Risk for Your Legal Team
In high growth companies, contracting pain points can make your organization less competitive. Fortunately, your legal team has access to world-class, robust AI solutions that can help enhance performance of the legal team and avoid common business pitfalls. If deployed correctly, contract AI can be a legal team’s best friend - shrinking the knowledge gap across years and silos, acting as a digital assistant to automate repetitive tasks, and arming lawyers with tools that help them be proactive rather than responsive.

Legalweek

$65

Add to Cart

12 Credit States

More Details
Previous Next