BARRON HENLEY’S BEST TIPS AND SHORTCUTS FOR WORD, OUTLOOK AND EXCEL
Online Replay Seminar
ITEM #:  2548942502   |   EVENT CODE:  516271
MEMBER PRICE
$295.00
STANDARD PRICE
$345.00
MSBA MEMBER, NEW LAWYER, AND OTHER DISCOUNTS, IF APPLICABLE, WILL BE APPLIED DURING CHECKOUT.

ONLINE

Tuesday, December 3, 2024

9:00 AM - 4:15 PM

Barron Henley’s Best Tips and Shortcuts for Word, Outlook and Excel


Don’t work harder, work smarter!
Learn how to use the latest tech tools and strategies to save time, save money, and provide an excellent, modern client experience that clients expect. Experience interactive, advanced trainings that help you master Word, Outlook and Excel and save time! Plus, receive dozens of tips and shortcuts you can implement right away!

About Barron K. Henley
Barron Henley is an attorney, a founding partner of Affinity Consulting Group, a nationally recognized speaker, and an expert in law practice automation. Mr. Henley has been teaching CLE classes since 1993 throughout the U.S. and Canada covering a wide variety of topics related to law practice management and legal technology.

8:30 – 9:00 a.m.
CHECK-IN & CONTINENTAL BREAKFAST


9:00 – 9:05 a.m.
WELCOME & INTRODUCTION


9:05 – 10:35 a.m.
How to Fix, Customize and Control Word’s Default Settings and Formatting So It’s Easier to Use Every Day

  • Stop Random Formatting Changes: Tired of the formatting shifting while you edit for no reason? It’s caused by a document’s underlying default formatting. You’ll learn how to identify and fix a document’s default formatting (which is almost always not what the author wants).
  • Customize the Interface: Learn how to improve Word’s interface for legal users.
  • Fix Word’s Programmatical Defaults to Work Better for Legal Users: These changes make Word easier to use, less annoying, and actually helpful.
  • Clause Libraries: Learn how to store and easily deposit into any document common clauses, phrases, acknowledgments, captions, and signature blocks (using AutoText and AutoCorrect).


10:35 – 10:50 a.m.
BREAK


10:50 – 11:35 a.m.
How to Master Paragraph Formatting to Improve Your Drafting Speed

  • Advanced Paragraph Formatting: Little known (arguably hidden) paragraph formatting techniques that will significantly improve your drafting speed.
  • Copy and Paste Conundrum: We’ll show you how to get the formatting you want when you copy and paste from one document to another.


11:35 a.m. – 12:20 p.m.
How to Simplify Numbering to Make Drafting Documents Easier

  • Headers, Footers and Page Numbering: Tips for headers, footers and page numbering including how to turn page numbering on and off anywhere in a document, start over at 1 (even though you’re not on page 1 overall), change formats (e.g., from Romanettes to Arabic), and how to not number the first page, but number the second and subsequent pages.
  • Automatic Paragraph Numbering: Learn how to set up and control automatic paragraph numbering (single or multiple levels).


12:20 – 1:00 p.m.
LUNCH BREAK (on your own)


1:00 – 2:30 p.m.
Help! I’m Bogged Down by My E-Mail – How to Use Outlook More Efficiently

  • Fix Outlook’s Programmatical Default Settings: Learn how to adjust Outlook’s programmatical default settings to work better for legal users (including the default font and point size used for new email).
  • Fix Outlook’s Interface: Learn how to clean up the interface and display as many emails on the screen at once as possible.
  • Avoid Email Overload: Tips and features for tracking and managing high volume email without getting overwhelmed.
  • Rules and Alerts: How to use Outlook’s Rules and Alerts feature to automatically file email into folders, and create special notifications when certain important people email you.
  • Archiving and Sharing Email Internally: How to efficiently store important client email exchanges so that others can find them if necessary.


2:30 – 2:45 p.m.
BREAK


2:45 – 3:45 p.m.
Excel for Lawyers: The Basics and Beyond – It’s Not Just for Accountants

  • How Law Offices Can Use Spreadsheets: We’ll demonstrate ways in which law offices use Excel and all of the exercises we’ll do in class are legal-specific examples. As you’ll see, Excel isn’t only good for accountants and engineers.
  • Fix Excel’s Default Settings: We’ll cover Excel default settings you will want to modify (and explain why).
  • How to Start: Learn how to set up a spreadsheet from scratch and decide what should appear in the rows and columns.
  • Find Appropriate Formulas: Excel users often know what they want to calculate, but don’t know which formulas might help. We’ll show you how to find formulas/functions when you’re unsure what to use.
  • Formulas: Once you’ve found an appropriate formula, we’ll show you how to use them (covering the insert function wizard, and how “arguments” work).
  • Get It to Print Correctly: Users often complain about the difficulty of getting spreadsheets to print properly. We’ll show you how to control how a spreadsheet prints and get it to fit on a page if it is otherwise too big (wide or tall).


3:45 – 4:15 p.m.
How to Use Excel to Organize Your Legal Practice

  • Mail Merge in Word: Learn how to use Excel as a data source for mail merging in Word (generate documents, labels, envelopes and/or emails in mass).
  • Managing Lists: We will show you how to use Excel as a list manager.

LIVE IN-PERSON
Thursday, November 7, 2024
Minnesota CLE Conference Center
600 Nicollet Mall, Suite 370
Seventh Street & Nicollet Mall, Third Floor City Center
Minneapolis, Minnesota

ONLINE REPLAYS
Tuesday, November 19, 2024
Tuesday, December 3, 2024
Attend online
A moderator will be available to answer questions by email.

$295 MSBA members / $295 paralegals / $345 standard rate

Other discounts that may apply:

Scholarships available!
Need-based scholarships are available for in-person and online seminars. For further information or to obtain a scholarship application, contact us at 800-759-8840 or customerservice@minncle.org.

Minnesota CLE is applying to the Minnesota State Board of CLE for 6.0 standard CLE credits. The maximum number of total credits attendees may claim for this program is 6.0 credits.

MEMBER PRICE
$295.00
STANDARD PRICE
$345.00
MSBA MEMBER, NEW LAWYER, AND OTHER DISCOUNTS, IF APPLICABLE, WILL BE APPLIED DURING CHECKOUT.
ADDITIONAL RECOMMENDATIONS FOR YOU (8 items):