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