NYSBA Online Marketplace

NEW MEMBER BENEFIT!
CLE Default Bundling Banner
Bundle and save up to 40% off
CLE recorded products.
0 item(s) ($0.00)
Search Products by Category
Event Details

Excel Essentials for Lawyers - Live & Webcast

Generic Event Image
Date:
Friday, December 01, 2017
Time:
9:00 AM - 12:00 PM Eastern Standard Time
Press Register button below for pricing.

 

Excel Essentials for Lawyers
Using Excel in Your Law Office

Microsoft Excel is an important tool for the modern legal practice. It can assist in supervising document reviews, calculating damages, and managing client information. Because so many business clients use Excel, spreadsheets often become evidence in their own right, and attorneys need to be able to review and understand Excel documents. In this interactive program, Ben Kusmin, a commercial litigator and the founder of Excel Esquire, will demonstrate the most important features of Microsoft Excel using concrete examples and realistic data. Attendees will have the option to download the data used in the presentation to follow along on their own computers.

Please join us for this dynamic workshop, where you will learn to increase your productivity and avoid evidentiary pitfalls. This course is also appropriate for paralegals, legal secretaries and other non-legal professionals. A minimal working knowledge of Excel is assumed, but users of all levels will learn something useful.

Navigating and Printing Spreadsheets

  ♦ Use the Zoom and Freeze Panes features to customize your display
  ♦ Save paper and headaches by printing effectively
  ♦ Add informative Headers and Footers to your printouts
  ♦ Selectively print certain parts of a spreadsheet
  ♦ Create effective motion and deposition exhibits from spreadsheets

Performing Calculations in Excel

  ♦ Use Excel as a calculator: find sums, percentages, and other metrics
  ♦ Learn to use basic built-in functions and create your own custom formulas
  ♦ Quickly copy, edit, and troubleshoot formulas with simple commands and keyboard shortcuts
  ♦ Apply best practices in writing and copying formulas
  ♦ Learn 5 ways to add up numbers 

Cleaning up and Manipulating Text

  ♦ Use Find & Replace to separate names and parse email addresses
  ♦ Quick ways to clean up imported text or metadata
  ♦ Use Concatenate to combine text from multiple cells

Analyzing Data in Excel

Use the Sort feature to rearrange data such as privilege logs, matter lists, payment data, and email metadata
  Master the Filter feature to selectively display certain rows, generate subtotals, and edit multiple cells at once
  Analyze and summarize data with Pivot Tables: group documents or clients by date, identify duplicate records, summarize expenses by department, or tally a document production by document type
  Learn to refresh, rearrange, and print filter results and pivot tables

 


Program Location and Details 

Friday, December 1, 2017
9:00 a.m. – 12:00 p.m.

Executive Conference Center
1601 Broadways at 48th | NYC

3.0 MCLE Credits
3.0 Skills

NYSBA Member: $150
Non-Member: $250


About the Featured Speaker:

  Ben J. Kusmin, Esq.
  Excel Esquire

  Ben J. Kusmin, Esq. is the founder of Excel Esquire.  He is a
  former engineer and a seasoned commercial litigator who has
  worked at several large New York City law firms. He is a veteran
   of epic privilege log battles, mammoth document reviews,
  complex redaction projects, dueling accounting experts, and
  all manner of discovery motion practice. At every turn Ben
has exploited the finer points of Excel to stay one step ahead of his adversaries and keep his
clients happy. He developed Excel Esquire to give other attorneys the skill and confidence
they need to successfully navigate in Excel.


http://www.nysba.org/assets/0/96/1620/5143/9021/11091/b7498eba-9e4f-40aa-b635-1425bc3cce3c.jpg
Follow NYSBA LPM on Twitter! @NYSBALPM
Stay informed. Be the first to hear about the latest course offerings.
To view the full list of Law Practice Management Programs, click here.


 

Additional Information: This program provides TRANSITIONAL credit to all attorneys. For information about New York MCLE requirements, visit www.nycourts.gov/attorneys/CLE
Address:
Executive Conference Center
1601 Broadway
New York, NY 10036
You must be logged in to register. After logging in your browser will return to this page.