chevron-down Created with Sketch Beta.
    0

      Tech Series: 10 Excel Formulas Every Law Firm Should Know and Use [CC]

      Tech Series: 10 Excel Formulas Every Law Firm Should Know and Use [CC]
      TECH 60 min

      Tech Series: 10 Excel Formulas Every Law Firm Should Know and Use [CC]

      Many law firm leaders, managing partners, and administrative staff rely on Microsoft Excel to analyze their firm's efficiency and profitability and to share financial data and statistics in an understandable and persuadable way. From ROUNDUP to IFERROR, you'll learn the top 10 Excel formulas you need to know to take your workbooks to the next level.

      Select your state to learn more about the credit details and status of CLE application. Credit is not available for states not listed.

      1.00 total credit hours including

      • General

        Status:

        Approved

        1.00 credit hours

        Available until:

        06/12/2026

      1.00 total credit hours including

      • General

        Status:

        Available for credit

        1.00 credit hours

        Available until:

        06/12/2026

      1.00 total credit hours including

      • General

        Status:

        Available for credit

        1.00 credit hours

        Available until:

        06/12/2028

      1.00 total credit hours including

      • General

        Status:

        Approved

        1.00 credit hours

        Available until:

        06/12/2024

      1.00 total credit hours including

      • Lawyering Skills

        Status:

        Available for credit

        1.00 credit hours

        Available until:

        06/12/2026

      1.00 total credit hours including

      • General

        Status:

        Approved

        1.00 credit hours

        Available until:

        06/12/2026

      1.00 total credit hours including

      • General

        Status:

        Approved

        1.00 credit hours

        Available until:

        12/31/2025

      1.00 total credit hours including

      • General

        Status:

        Available for credit

        1.00 credit hours

        Available until:

        06/12/2026

      1.00 total credit hours including

      • General

        Status:

        Approved

        1.00 credit hours

        Available until:

        06/12/2025

      1.00 total credit hours including

      • Technology Program

        Status:

        Approved

        1.00 credit hours

        Available until:

        12/31/2024

      1.00 total credit hours including

      • General

        Status:

        Approved

        1.00 credit hours

        Available until:

        12/31/2023

      1.00 total credit hours including

      • General

        Status:

        Approved

        1.00 credit hours

        Available until:

        06/12/2026

      1.00 total credit hours including

      • General

        Status:

        Approved

        1.00 credit hours

        Available until:

        06/12/2025

      1.00 total credit hours including

      • General

        Status:

        Self apply

        1.00 credit hours

        Available until:

        06/12/2028

      1.00 total credit hours including

      • General

        Status:

        Approved

        1.00 credit hours

        Available until:

        06/12/2025

      1.00 total credit hours including

      • Non-Legal Subject

        Status:

        Approved

        1.00 credit hours

        Available until:

        12/31/2023

      1.00 total credit hours including

      • General

        Status:

        Approved

        1.00 credit hours

        Available until:

        06/12/2024

      1.00 total credit hours including

      • General

        Status:

        Approved

        1.00 credit hours

        Available until:

        06/12/2024

      1.00 total credit hours including

      • General

        Status:

        Self apply

        1.00 credit hours

        Available until:

        06/30/2024

      1.00 total credit hours including

      • General

        Status:

        Self apply

        1.00 credit hours

        Available until:

        06/12/2024

      1.00 total credit hours including

      • General

        Status:

        Approved

        1.00 credit hours

        Available until:

        06/12/2025

      1.00 total credit hours including

      • General

        Status:

        Approved

        1.00 credit hours

        Available until:

        06/12/2025

      1.00 total credit hours including

      • General

        Status:

        Approved

        1.00 credit hours

        Available until:

        06/12/2026

      1.20 total credit hours including

      • General

        Status:

        Available for credit

        1.20 credit hours

        Available until:

        06/12/2028

      1.00 total credit hours including

      • General

        Status:

        Self apply

        1.00 credit hours

        Available until:

        06/12/2026

      1.00 total credit hours including

      • Professional Responsibility

        Status:

        Self apply

        1.00 credit hours

        Available until:

        06/12/2025

      1.00 total credit hours including

      • General

        Status:

        Approved

        1.00 credit hours

        Available until:

        12/31/2026

      1.00 total credit hours including

      • Law Office Management

        Status:

        Available for credit

        1.00 credit hours

        Available until:

        06/12/2026

      1.20 total credit hours including

      • General

        Status:

        Reciprocity

        1.20 credit hours

        Available until:

        06/12/2026

      1.00 total credit hours including

      • General

        Status:

        Approved

        1.00 credit hours

        Available until:

        06/12/2028

      1.00 total credit hours including

      • Skills

        Status:

        Approved

        1.00 credit hours

        Available until:

        06/12/2026

      1.00 total credit hours including

      • General

        Status:

        Approved

        1.00 credit hours

        Available until:

        12/31/2023

      1.00 total credit hours including

      • General

        Status:

        Approved

        1.00 credit hours

        Available until:

        06/12/2026

      1.00 total credit hours including

      • General

        Status:

        Approved

        1.00 credit hours

        Available until:

        06/12/2026

      1.00 total credit hours including

      • General

        Status:

        Approved

        1.00 credit hours

        Available until:

        12/31/2023

      1.00 total credit hours including

      • General

        Status:

        Approved

        1.00 credit hours

        Available until:

        06/12/2026

      1.00 total credit hours including

      • Professionalism (General)

        Status:

        Available for credit

        1.00 credit hours

        Available until:

        06/12/2026

      1.00 total credit hours including

      • Practical Skills

        Status:

        Approved

        1.00 credit hours

        Available until:

        06/12/2026

      1.00 total credit hours including

      • General

        Status:

        Approved

        1.00 credit hours

        Available until:

        06/12/2025

      1.00 total credit hours including

      • General

        Status:

        Approved

        1.00 credit hours

        Available until:

        06/12/2025

      1.00 total credit hours including

      • General

        Status:

        Available for credit

        1.00 credit hours

        Available until:

        06/12/2026

      1.00 total credit hours including

      • Ethics

        Status:

        Self apply

        1.00 credit hours

        Available until:

        06/12/2026

      1.00 total credit hours including

      • General

        Status:

        Approved

        1.00 credit hours

        Available until:

        12/31/2023

      1.00 total credit hours including

      • General

        Status:

        Approved

        1.00 credit hours

        Available until:

        06/12/2024

      1.00 total credit hours including

      • General

        Status:

        Approved

        1.00 credit hours

        Available until:

        05/31/2024

      1.00 total credit hours including

      • General

        Status:

        Applied for

        1.00 credit hours

        Available until:

        06/12/2026

      1.00 total credit hours including

      • General

        Status:

        Approved

        1.00 credit hours

        Available until:

        06/12/2026

      1.20 total credit hours including

      • Technology Programming

        Status:

        Approved

        1.20 credit hours

        Available until:

        06/12/2026

      1.00 total credit hours including

      • Other-Office Management

        Status:

        Approved

        1.00 credit hours

        Available until:

        06/12/2028

      1.20 total credit hours including

      • Office Management

        Status:

        Approved

        1.20 credit hours

        Available until:

        06/12/2026

      1.00 total credit hours including

      • General

        Status:

        Approved

        1.00 credit hours

        Available until:

        06/12/2024

      1.00 total credit hours including

      • General

        Status:

        Self apply

        1.00 credit hours

        Available until:

        06/12/2026

      $00
      NON-MEMBERS
      $00
      MEMBERS
      $00
      YOUR PRICE
      *Additional discounts may apply at checkout

      Log In to view your rate

      Unlock the discounted member rate

      Join first as a member, and then purchase this product at special member pricing
      Join Now

      Closed Captioned.

      Mastering the basics of Excel formulas is critical for owners, managing partners, and law firm administrators. You'll spend this session exploring formulas - the cornerstone of any reasonably advanced Excel workbook.

      Objectives:

      • Describe cell references, relative and absolute
      • Assess how cell formatting can affect mathematical accuracy
      • Demonstrate how to use AutoFill to automate formula creation
      • Recognize how to inspect formulas visually
      • Employ copy and paste special (value)
      • Demonstrate status bar calculations

      Product Details

      Panelists

      Anne Elizabeth Collier, Ivan Hemmans III

      Sponsors

      Law Practice Division

      Product Code

      EP2306TEFOLC

      Duration

      60

      Related Products

      Related Events