Mastering Microsoft Excel in the Law Office - Webcast
August 2018
Mastering Microsoft Excel in the Law Office
Become More Efficient and Make Microsoft Tools Work for You!
Featuring one of the nation’s best legal technology teachers - Barron K. Henley
You’ll learn to structure data and utilize worksheets and graphs in Microsoft Excel, including:
- Using ribbons, buttons, and conquering interface issues
- Making worksheets look good and print correctly
- Summarizing data with sums and pivot tables
And so much more!
Bring your laptop if you’d like to follow along!
- Seminar will be taught in Office 2016 (which is the same as Office 365). The course manual works for Office 2007, 2010, and 2013.
- Are you a Mac user? Please let us know ahead of time; We can send you a Word for Mac 2011/Word for Mac 2016 manual so you can follow along. Word for Windows and Word for Mac have different interfaces, although they’re capable of most of the same things with some exceptions. Likewise, while there is not a separate Mac manual for Excel and Outlook, the interfaces are similar enough that Mac participants can easily follow along.
What previous Colorado CLE attendees have said about Barron Henley:
"Best CLE I have ever been to. All law offices need to have him come in for a seminar for all employees who use Word. I wish I took this years ago. The materials and the book were worth the price of admission!"
“Just "WOW!" This class is probably the most useful CLE I have ever attended! Thank you!"
“Other than the fact that this is fabulous information, Mr. Henley's presentation makes it a great and engaging class."
“Great materials and very informative. Barron made the topic fun. This will be directly beneficial to my work."
“The entire program was outstanding.”
“Speaker - Amazing. Deliver - Amazing. Content - Amazing! Bring Barron back every year!"
Meet Your Presenter
Barron K. Henley, Esq.
Affinity Consulting Group, LLC
Barron K. Henley is one of the most popular Colorado CLE instructors and a national expert on technology solutions for lawyers. He is one of the managing partners of Affinity Consulting Group LLC in Columbus, Ohio, which has provided legal technology consulting to more than 500 law firms nationwide. He is an attorney with over 18 years' experience in legal technology and one of the most renowned experts on Microsoft Word, Adobe Acrobat and Hot Docs. He is a member of the ABA Law Practice Management Section and the Technology Committee, and a frequent continuing legal education speaker on legal-specific technology issues.
Agenda
FRIDAY, AUGUST 10, 2018
Mastering Microsoft Excel in the Law Office
Become More Efficient and Make Microsoft Tools Work for You!
8:30 am
Registration (Continental Breakfast Provided)
9:00 am
Excel Basics
- Ribbons, buttons, and interface issues
- Recommended default setting changes
Structuring Data and Using Formulas/Functions
- Navigation
- Editing cells
- Formulas/functions
- Copying/replicating formulas
- Creating a probate inventory and appraisal
- Medical bill summaries with running totals
- Real estate settlement statements with auto-calculating subtotals and totals
- Calculating loan payments based upon varying loan amounts, interest rates, terms, and number of payments per year
- Using formulas to calculate dates and deadlines
10:30 am
Refreshment/Networking Break
10:45 am
Formatting Cells and Worksheets
- Formatting to cells, rows and columns
- Making worksheets look good
- Sorting, filtering and conditional formatting
Getting the Worksheet to Print the Way You Want
- Headers and footers
- Printing options
- Gridlines
- Row and/or column headings
- Row and/or column labels (titles)
- Fitting text on a page when printing
- Scaling to fit/zoom
Creating Graphs
- Creating and customizing bar graphs
- Creating and customizing pie charts
Advanced Topics
- Using Excel for Mail Merges in Word
- Naming and nesting formulas
- Formulas to manipulate text instead of numbers
- Using tables to manipulate large data sets
- Combining data using VLOOKUP
- Summarizing data: sums and pivot tables
12:00 — 1:00 pm
Lunch (on your own)
Registration Fees
| Non Member | $269.00 |
| CBA Member | $239.00 |
| Paralegal/Legal Support Staff | $199.00 |
| New Lawyer Edge Partner | $119.50 |
| Basic Pass holder | $49.00 |
| CLE ELITE Pass Holder | $0.00 |
- General Credits: 3.00
- Ethics Credits: 0.00
- EDI Credits:
To join the CBA or add a Section to your membership click
Sponsor Information
You'll learn easier and quicker document creation and complex formatting, including:
- Drafting complex legal documents more easily and more accurately, with less hassle
- Mastering Microsoft’s styles feature to completely control complex legal formatting
- Using macros and AutoText to automate your legal document drafting
- Table of Contents and Table of Authorities
- Tips for legal-specific formatting issues
- Automatic paragraph numbering
- And more!