NYSBA: New York State Bar Association, Serving the legal profession and the community since 1876
1 Elk Communities Online Store News Center Contact Us Help
LOGINJOIN
Powered by Recommind

NYSBA Online Marketplace

MENU
  • CLE
    • Upcoming CLE Programs
    • CLE Search
    • CLE Online On-Demand
    • CLE Live Programs
      • Video Replays
    • CLE CDs & DVDs
    • All Access Pass
    • Bridging the Gap
    • Courses by Area of Practice
    • Diversity, Inclusion and Elimination of Bias CLE Programs
    • Law Practice Management CLE Programs
    • Section Meetings
    • Coursebooks
    • CLE Credit Tracker
    • CLE Order Form
    • Information & Policies
    • Contact Us
  • Events
    • CLE Programs
    • Video Replays
  • Sections & Committees
    • Sections (View List)
      • Antitrust Section
      • Business Law Section
      • Commercial & Federal Litigation Section
      • Corporate Counsel Section
      • Criminal Justice Section
      • Dispute Resolution Section
      • Elder Law and Special Needs Section
      • Entertainment, Arts & Sports Law Section
      • Environmental & Energy Law Section
      • Family Law Section
      • Food, Drug & Cosmetic Law Section
      • General Practice Section
      • Health Law Section
      • Intellectual Property Law Section
      • International Section
      • Judicial Section
      • Labor & Employment Law Section
      • Local and State Government Law Section
      • Real Property Law Section
      • Senior Lawyers Section
      • Tax Section
      • Torts, Insurance and Compensation Law Section
      • Trial Lawyers Section
      • Trusts and Estates Law Section
      • Women in Law Section
      • Young Lawyers Section
    • Section Leader Resources
    • Section Meetings
    • Section Publications (view list)
    • Committees (View List)
      • Executive Committee
      • Adminstrative Committees
      • Committee for Bar Leaders of New York State
      • Committee on Animals and the Law
      • Committee on Annual Awards
      • Committee on Attorney Professionalism
      • Committee on Cannabis Law
      • Committee on Children and the Law
      • Committee on Civil Practice Laws and Rules (CPLR)
      • Committee on Civil Rights
      • Committee on Courts of Appellate Jurisdiction
      • Committee on Continuing Legal Education
      • Committee on Disability Rights
      • Committee on Diversity and Inclusion
      • Committee on Families and the Law
      • Committee on Federal Legislative Priorities
      • Committee on Immigration Representation
      • Committee on Lawyer Referral Service
      • Committee on Lawyers in Transition
      • Committee on Law, Youth & Citizenship
      • Committee on Leadership Development
      • Committee on Legal Aid
      • Committee on Legal Education and Admission to the Bar
      • Committee on Legislative Policy
      • Committee on LGBT People and the Law
      • Committee on Mandated Representation
      • Committee on Mass Disaster Response
      • Committee on Media Law
      • Committee on Procedures for Judicial Discipline
      • Committee on Professional Discipline
      • Committee on Professional Ethics
      • Committee on Standards of Attorney Conduct
      • Committee on Technology and the Legal Profession
      • Committee on the New York State Constitution
      • Committee on Transportation Law
      • Committee on Veterans
      • Committee to Review Judicial Nominations
      • Electronic Communications Committee
      • Judicial Wellness Committee
      • Law Practice Management Committee
      • Lawyer Assistance Committee
      • Membership Committee
      • Nominating Committee
      • President's Committee on Access to Justice
      • Task Force on School to Prison Pipeline
      • Task Force on the Evaluation of Candidates for Election to Judicial Office
  • News & Publications
    • News Center
      • News Releases
      • Vital Statistics
      • Legislative Priorities
      • NYSBA in the News
      • Press Kit
      • Substantive Reports
      • Media Contacts
    • NYSBA Podcasts
    • NYSBA Blog
    • Bar Journal
    • State Bar News
    • Publication Search
    • Books and Form Products
      • Appellate
      • Business, Corporate, Tax
      • Civil Advocacy and Litigation
      • Criminal Law and Practice
      • E-Books
      • Entertainment
      • Family/Matrimonial
      • General Practice
      • Health
      • Labor/Employment
      • Law Practice Management
      • Mental and Physical Disability
      • Pathway Book
      • Real Estate
      • Trial
      • Trusts and Estates/Elder Law
      • Pubs Promo
      • LEGALEase Samples
    • EBooks
      • Appellate
      • Books and Form Products
      • Business, Corporate, Tax
      • Civil Advocacy and Litigation
      • Criminal Law and Practice
      • E-Books
      • Entertainment
      • Family/Matrimonial
      • General Practice
      • Health
      • Labor/Employment
      • Law Practice Management
      • Mental and Physical Disability
      • Real Estate
      • Trial
      • Trusts and Estates/Elder Law
    • Forms
      • Business, Corporate, Tax
      • Civil Advocacy and Litigation
      • Criminal Law and Practice
      • Entertainment
      • Family/Matrimonial
      • General Practice
      • Health
      • Real Estate
      • Trusts and Estates/Elder Law
    • Downloadable Forms
      • Arbitration
      • Best Practices in Legal Management
      • Buying and Selling a Small Business
      • Commercial Real Estate
      • Corporate and Partnership
      • Criminal Law
      • Debt Collection
      • Elder Law
      • Enforcement of Money Judgments
      • Estate Planning and Will Drafting
      • Guardianship
      • Limited Liability Companies
      • Matrimonial
      • Mechanics Liens
      • Mortgage Foreclosures
      • Mortgages
      • Power of Attorney Forms 2010
      • Probate and Administration of Decedents Estate
    • CasePrepPlus
      • CasePrepPlus Home
      • Archived Issues
      • About CasePrepPlus
      • About the Editor
    • Law Digest
      • Dynamic Version
      • NEW! Download the App
      • Archives (Member Log-In)
      • About the Editor
      • About the New York State Law Digest
      • Reprint Permission
    • LegalEase Pamphlet Series
    • Planning Ahead Guide
    • The Practice of Law in New York State
    • Section Publications (view list)
      • Antitrust Law Section Symposium
      • NY Business Law Journal
      • Commercial & Federal Litigation Section Newsletter
      • NY Litigator
      • Inside
      • New York Criminal Law Newsletter
      • New York Dispute Resolution Lawyer
      • Elder and Special Needs Law Journal
      • Entertainment, Arts & Sports Law Journal
      • The New York Environmental Lawyer
      • Family Law Review
      • One on One
      • Government, Law and Policy Journal
      • Health Law Journal
      • Bright Ideas
      • New York International Chapter News
      • International Law Practicum
      • New York International Law Review
      • Labor & Employment Law Journal
      • Municipal Lawyer
      • N.Y. Real Property Law Journal
      • The Senior Lawyer
      • Torts, Insurance and Compensation Law Journal
      • Construction and Surety Law Newsletter
      • Trial Lawyers Section Digest
      • Trusts and Estates Law Section Newsletter
      • Perspective
  • Practice Resources
    • Law Practice Management
      • Law Practice Management
      • Starting a Practice in New York
      • Managing Your Practice
      • Marketing Your Practice - Attorney Advertising, Business Development and Ethics
      • Protecting Your Practice
      • Escrow Accounts, IOLA and Ethics
      • Resources for Your Practice
      • Selling Your Practice, Closing and Retirement
      • Planning Ahead Guide
      • Law Practice Management CLE Programs
      • Mini-MBA Program for Lawyers
      • Managing Partners Conference Series
      • Contact the LPM Staff
    • Ethics Opinions
    • NYSBA Professional Services Guide
    • Pro Bono Services
      • Pro Bono Services
      • Pro Bono Honors and Awards
      • Pro Bono Newsletter
      • Events and Training
      • Free Legal Answers
      • Immigration Pro Bono Portal
      • Past Events
      • Pro Bono Opportunities Guide
      • Resources
    • Resources on Professional Standards for Attorneys
    • Fastcase - Free Legal Research
    • CasePrepPlus
    • Career Center and Job Alert Service
    • How I Practice
    • Lawyer Assistance Program
      • Attorney Recovery Stories
      • Confidentiality
      • Information for Families
      • Links of Interest
      • Personal Inventory
      • Self Help Groups
      • Suicide Prevention
      • Volunteer Opportunities
      • Contact Us
    • Solo and Small Firm Resource Center
      • Bar Associations in New York
      • Continuing Legal Education
      • Ethics Opinions
      • Fastcase
      • Free Legal Answers
      • How I Practice
      • Law Practice Management
      • Lawyer Assistance Program
      • Member Benefits and Savings Programs
      • Online Communities
  • Membership
    • Join NYSBA/Renew Your Membership
      • Membership Applications
    • Membership Dues
      • Dues Waiver Program
      • Monthly Installments
    • Member Benefits and Savings Programs
    • Sections and Committees
    • Sustaining Membership
    • NYSBA Insurance Program
    • Member Get A Member Program
    • Membership Cards
    • Law Students
    • FAQs
  • Leadership & Advocacy
    • The President's Page
      • Leadership Profiles
    • Leadership Profiles
    • Executive Committee
    • House of Delegates
    • Committee on Leadership Development
    • Governmental Relations
      • Department of Governmental Relations
      • 2017 and 2018 Legislative Memoranda
      • 2018 Federal Legislative Priorities
      • 2018 State Legislative Priorities
      • 2015 and 2016 Legislative Memoranda
      • 2013 and 2014 Legislative Memoranda
    • Substantive Reports
  • Public Resources
    • Hire a New York Attorney
      • Contact the LRIS Staff
      • Free Legal Help
      • Lawyer Referral Newsletters
      • Legal Links of Interest
      • Client's Rights and Responsibilities
      • LegalEase Pamphlet Series
    • Mock Trial
      • County Coordinators Information
      • Current Case for NYS Mock Trial
      • NYS Mock Trial Finals Information
      • MCLE Rules for Attorneys: Earning CLE Credit for Mock Trial
      • NYS Mock Trial Case Archives
      • NYS Mock Trial Finals Videos
      • NYS Mock Trial 101 Program Training Video
      • Law, Youth & Citizenship
    • Law, Youth & Citizenship
      • News and Events
      • NYS Mock Trial
      • Awards and Contests
      • Helpful Links
      • LYC Staff
    • Find a Mediator
    • 1 Elk Rentals
    • Print Services
  • Members Only
    • My NYSBA
    • LawHUB
    • Communities
    • Member Benefits and Savings Programs
    • The Bar Journal
    • CasePrepPlus
    • Fastcase - Free Legal Research
    • New York State Law Digest
    • State Bar News
  • MIRANDA Warnings
  1. Home
  2. NYSBA Online Marketplace
NEW MEMBER BENEFIT!
CLE Default Bundling Banner
Bundle and save up to 40% off
CLE recorded products.
Click here to learn more
 
View Cart
Place Your Order
+ Show
- Hide
0 item(s) ($0.00)
Your cart is empty.
{1}
##LOC[OK]##
{1}
##LOC[OK]## ##LOC[Cancel]##
{1}
##LOC[OK]## ##LOC[Cancel]##
Dues
1. Renew your Membership
2. Join the Association
3. Join a Section
4. Donate to the Bar Foundation
Search for:
Calendar of Events
CLE Search
Search Products by Category
1. CLE Audio Online
2. CLE Video Online
3. CLE on CD
4. CLE on DVD
5. Coursebooks
6. Books
7. MCLE Coursebooks
8. Forms
9. Pamphlets
CLE Books
CLE CourseBooks
CLE Disks
CLE on DVD
CLE On-Line Programs
CLE Supplement
CLE Video
Component Kit Items
MCLE Audio on CD
Miscellaneous
Pamphlets & Publications
Product Details

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.
Product Code:
VEX44
Recorded/Publication Date:
December 01, 2017
Media:
Video Online
Duration/Pages:
155:44
Available for Immediate Download
Member Price:
$75.00
Non-Member Price:
$175.00
Your Price (must be logged in):
$175.00
↑/↓ Full Details
Info URL
Is a Kit
False
Is a Stock Item
False
Is Taxable
False
Price Rules Exist
False
Product Major
VEX44
Product Minor
Product Type Code
SALES
Promote Product
False
Thumbnail URL
Weight
0
Kit Items


Online Store
Online Store
  • NYSBA Online Marketplace
  • Books and Form Products
  • Downloadable Forms
  • CLE On Demand - Audio and Video
Public Resources
Public Resources
  • Hire a New York Attorney
  • Find a Mediator
  • Client's Rights and Responsibilities
  • Free Legal Answers
  • Guide to Attorney Discipline
  • Mock Trial
About NYSBA
About NYSBA
  • History and Structure of the Association
  • Bylaws
  • Diversity and Inclusion
  • Leadership Profiles
  • NYSBA Awards and Competitions
Contact Us
Contact Us
  • NYSBA Staff
  • NYSBA Account Assistance
  • Employment at NYSBA
  • Advertise with NYSBA
Connect with NYSBA
  • Site Map
  • COPYRIGHT
  • PRIVACY POLICY
  • TERMS OF USE
  • Contact Us
  • How Do I ...
NYSBA
One Elk Street, Albany , NY 12207
Phone: 518-463-3200   Secure Fax: 518.463.5993
© 2019 New York State Bar Association