This registration form is for Thursday, August 8, 9:00 a.m.–12:30 p.m. ET
MCLE Credit: | 3.0 |
Live-Interactive Credit: | 3.0 (all formats) |
Join nationally acclaimed legal technology expert Barron K. Henley for this three-hour CLE with invaluable practice management training.
If you have Microsoft Office, then you have Excel. If you are like most lawyers, however, you’re either underutilizing Excel or not using it at all. In this seminar, we start with the basics and work our way up from there. You will learn powerful ways that Excel can improve your work product and make your life easier. Every sample exercise we work through during the class centers around how law offices use Excel, so you will receive very relevant use and case examples.
By the end of the seminar, you will understand how Excel can be utilized in a law office, and you will be able to set up spreadsheets on your own—even if you’ve never used it before or only used it on a very basic level.
You do not have to be computer savvy to put Excel to work for you. Learn how to use its many functions so that you can save time, be more efficient, and be more organized!
Topics include how to use Excel for:
ATTENDING IN PERSON?
The Bobzien-Gaither Education Center in Richmond/Innsbrook is our new state-of-the-art facility designed with your safety in mind. It features a Centurion air filtration system, which quickly and effectively eliminates viruses and bacteria. Additionally, the facility is thoroughly cleaned before each seminar, and face masks and hand sanitizer will be available.
COVID-19 POLICY FOR LIVE-ON-SITE ATTENDANCE
By attending a live-on-site Virginia CLE® seminar, you acknowledge the health risks associated with COVID-19 and that you MUST follow all Virginia CLE® COVID-19 policies. You may NOT attend a live-on-site program if you have tested positive for COVID-19, if you are experiencing COVID-19 symptoms, or if you are under any self-quarantine orders per CDC guidelines.
Registration Deadlines:
Webcast: | 10 minutes prior to seminar. If you register for a webcast the day of the seminar, your e-mail receipt will include a link to launch the seminar and download the materials. |
Live on Site: | Online registration ends at 11:59 p.m. the day preceding the seminar |
Cancellation Policy: Cancellation/transfer requests will be honored until 5:00 p.m. the day preceding the seminar. You will, however, be charged $60 if you cancel or transfer your registration to a different seminar after the link to the materials has been e-mailed by Virginia CLE®.
Full refunds or transfers are available up to two days after a webcast in the unlikely event that you experience technical difficulties.
Dietary Restrictions: If you have dietary restrictions and are attending the seminar in person, please email tfitzgerald@vacle.org.
Inclement Weather Policy and Updates.
MCLE Credit Caveat: The MCLE Board measures credits by the time you spend in attendance. If you enter a seminar late or leave it early, or both, you must reflect those adjustments accurately in the credits you report on your credit reporting form. A code will be given at the end of the seminar, which must be written on your MCLE form.
Can’t Attend?
E-mail distance_ed@vacle.org to be notified when/if this program is made available as an online or USB seminar.
E-mail publications@vacle.org to be notified when/if this program’s seminar materials are made available for sale.
8:30 Sign-in and Late Registrations (live-on-site seminar)
9:00 Session 1
Learn how to improve Excel’s default settings for a law office, where to find relevant Excel templates, and where to get help. We will cover important features such as how functions work, how to use AutoFill and the Fill Handle, how to get Excel tables into Word, protecting cells against editing, adding columns and rows, automatic sub and grand totals, filtering and sorting data, running balance calculations, how Excel can be used for real estate closing statements, calculating loan payments, and calculating due dates and deadlines.
10:30 Break
10:45 Session 2
Learn how to make a spreadsheet look good when printed and inserted into other things such as trial exhibits, how to create headers, footers, and page numbering, how to get your spreadsheet to print properly and “fit” on the page, how to create charts and graphs, how Excel can be used as a data course for a Word “Mail Merge,” using Excel as a list manager, using it for medical bill summaries, and how to set up “lookup” tables that pull information from one worksheet into another based upon key fields.
12:15 Questions and Answers
12:30 Adjourn
Barron K. Henley, Affinity Consulting Group / Columbus, OH
Barron K. Henley, Esq., is one of the founding partners of Affinity Consulting Group, a legal technology consulting firm focused on automating and streamlining law firms and legal departments. He earned his B.S./B.A. (marketing and economics) and J.D. from The Ohio State University and is a member of the American, Ohio, and Columbus Bar Associations, and the Worthington Estate Planning Council. He is a Fellow of the College of Law Practice Management, a Fellow of the American Bar Foundation, a member of Ohio Supreme Court Commission on Technology and the Courts, and a member of both the ABA Law Practice Management and the Real Property Trust and Estate Law (“RPTE”) Sections, Co-Chair of the Joint Law Practice Management Group, a Board Member for the ABA TECHSHOW, and a Director on the Columbus Bar Services Board.
Mr. Henley heads Affinity’s document assembly/automation and software training departments. He is also an expert in launching new law firms, overhauling existing firms, and documenting and re-engineering law firm processes.
Finally, Mr. Henley teaches continuing legal education (CLE) classes throughout the U.S. and Canada covering a wide variety of topics related to law practice management, technology, and ethics.