Excel 101 for Attorneys

$195.00

CLE credits earned: 2 GENERAL (or 2 OTHER for WA state)

In this webinar, we start with the basics and work our way up from there. Learn fundamental Excel concepts with real life examples, including fiduciary accountings, amortization schedules, real estate closing statements, disbursement schedules, and medical bill summaries.

Key topics to be discussed:

•   Familiarize yourself with Excel, its interface, and its terminology
•   Learn how to present data whatever way you want
•   Understand how to make Excel do the math for you, literally

Date / Time: October 21, 2020

•   2:00 pm – 4:00 pm Eastern
•   1:00 pm – 3:00 pm Central
•   12:00 pm – 2:00 pm Mountain
•   11:00 am – 1:00 pm Pacific

Choose a format:

•   Live Video Broadcast/Re-Broadcast: Watch Program “live” in real-time, must sign-in and watch program on date and time set above. May ask questions during presentation via chat box. Qualifies for “live” CLE credit.
•   On-Demand Video: Access CLE 24/7 via on-demand library and watch program anytime. Qualifies for self-study CLE credit. On-demand versions are made available 7 business days after the original recording date and are view-able for up to one year.

Select your state to see if this class is approved for CLE credit.

Choose the format you want.

Clear

Original Broadcast Date: April 20, 2020

Jeffrey R. Schoenberger, Esq. is an attorney and senior consultant for Affinity Consulting Group. Prior to joining Affinity, Jeffrey practiced law as an Equal Justice Works / AmeriCorps Legal Fellow for the Legal Aid Society of Southwest Ohio. His practice focused on representing homeowners in foreclosure cases, tenants in eviction actions, and individuals in divorce actions. While with Legal Aid, Jeffrey worked with over 130 distressed homeowners in their counseling and litigation activities and represented over 90 tenants in eviction and living conditions advocacy. Finally, he led seminars training non-profit housing counselors on the rapidly-evolving government and private sector foreclosure prevention programs.

At Affinity, Jeffrey specializes in practice management advisory services for bar associations, including content development, CLE presentations, and one-on-one member consultations. He is also Affinity’s designated “Apple/Mac/iOS” expert, knowledgeable in all areas Apple-related. Jeffrey received a B.A. in History from Yale University and J.D. from the University of Virginia. He became a member of the Ohio Bar in 2008. He is a member of the Ohio State Bar Association, Columbus Bar Association, and Cincinnati Bar Association.

Accreditation Policy
myLawCLE seeks accreditation for all programs in all states. (Accreditation for paralegals sought thru NALA and NFPA paralegal associations.) Each attending attorney/paralegal will receive a certificate of completion following the close of the CLE program as proof of attendance. In required states, myLawCLE records attorney/paralegals attendance, in all other states attorney/paralegal is provided with the approved CLE certificate to submit to their state bar or governing association.

    Automatic MCLE Approvals

All myLawCLE CLE programs are accredited automatically either directly or via reciprocity in the following states: AK, AR, CA, CT, FL, HI, IL, MO, MT, ND, NH, NM, NJ, NY, and VT. (AZ does not approve CLE programs, but accepts our certificates for CLE credit.)

    Live Video Broadcasts

Live video broadcasts are new live CLE programs being streamed and recorded for the first time. All of these programs qualify for “Live” CLE credit in all states except NV, OH, MS, IN, UT, PA, GA, and LA —these states require in-person attendance to qualify for “Live” CLE credit.

    “Live” Re-Broadcasts

“Live” Re-broadcasts are replays of previously recorded CLE programs, set on a specific date and time and where the original presenting speakers calls in live at the end of the event to answer questions. This “live” element allows for “live” Re-broadcast CLEs to qualify for “Live” CLE credits in most states. [The following states DO NOT allow for “live” CLE credits on re-broadcast CLEs: NV, OH, MS, IN, UT, PA, GA, and LA]

Reciprocity
Many states allow for credit to be granted on a 1:1 reciprocal basis for courses approved in another mandatory CLE jurisdiction state. This is known as a reciprocity provision and includes the following states: AK, AR, HI, CT, FL, ME, MO, MT, ND, NH, NM, VT, NJ, and NY. myLawCLE does not seek direct accreditation of live webinars or teleconferences in these states.

Section I. Excel Terminology

Section II. Excel File Types

Section III. Navigating Excel

Section IV. Data Entry, Classification, and Formatting

Section V. Formulas

Section VI. Autofill

Section VII. Naming Cells, Tables, and Getting Data into Microsoft Word

Section VIII. Cell References, Simple Math, and Sorting

Section IX. Dates

Section X. Conditional Formatting

Section XI. Headers, Footers, and Printing

Section XII. Charts, Graphs

Section XIII. Mail Merge