gradient circle (purple) gradient circle (green)

Excel Essentials For Lawyers 2017

Excel Essentials For Lawyers 2017

 
Total Credits: 3.0 Skills
 

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.

 

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

 

 
Speaker:
Ben J. Kusmin, Esq. He is the founder of Excel Esquire.  Also a former engineer and a seasoned commercial litigator who has worked at several large New York City law firms.
Format:
  • DVD+MP3
Product Code:
  • FEX44
Law Practice Management Credit(s):
  • 3.0
Total Credit(s):
  • 3.0
Non-Member Pricing: $175.00

You May Also Be Interested In

Professional Group

Bridging The Gap – July 2020 (Webinar)

The Bridging the Gap continuing legal education program offers 16.0 total credits. Newly admitted attorneys can satisfy all of their annual MCLE requirements by attending…

Previous
Next
EffectiveEngagementLettersRetainerAgreementsAndManagingClientPayments_675x250

Effective Engagement Letters, Retainer Agreements And Managing Client Payments: Turning Leads Into Clients (Webinar)

Leona Krasner, successful founder of a small firm, will address how to identify sources for leads, effective research to find promising leads, and the steps…

Previous
Next
Professional Group

Bridging The Gap – August 2020 (Webinar)

The Bridging the Gap continuing legal education program offers 16.0 total credits. Newly admitted attorneys can satisfy all of their annual MCLE requirements by attending…

Previous
Next
VirtualMeetingPlatforms_675x250

Virtual Meeting Platforms: Discovery, Evidentiary, Privacy & Cybersecurity Issues (Webinar)

oin us for this program, when we will discuss the legal significance of the data created by virtual meeting platforms, what lawyers need to know…

Previous
Next
HowtoCreateaMarketingPlanThatWorksforYou_Social_web_675X250

How To Create A Realistic And Effective Marketing Plan Despite COVID-19 (Webinar)

In this webinar we will discuss how to mix research and dreams with a dose of reality and come up with a “bespoke” marketing plan…

Previous
Next
PresentingYourselftoPotentialClients_Social_web_675x250

Presenting Your Best “You” To Your Best Prospects (Webinar)

Building on the August 4th webinar, we will discuss how to prospect for clients, colleagues and resources that fit the parameters of your marketing plan.

Previous
Next
Hitting the Next Legal Reserach Gear_Social_web_675X250

Hitting The Next Legal Research Gear: How Trellis Analytics Can Improve Your Litigation Strategy For New York State Court Litigation (Webinar)

Join us for an engaging Trellis Product Briefing Webinar on the most powerful state court legal research and analytics platform, now available for New York…

Previous
Next
DoYourClientsKnowYouCare_Social_web_675X250

Do Your Clients Know You Care? (Webinar)

In this webinar we will discuss the strategies for connecting with clients.

Previous
Next
BeyondTheTrashBin_675x250

Beyond The Trash Bin: Proper Disposal Of Electronic Data

Beyond the Trash Bin: Proper Disposal of Electronic Data

Previous
Next
Previous
Next