Skip to main content


Excel & Data Analysis

Categories covered in this topic:
Data Analysis
Excel Basics
Excel Functions
Microsoft Office


  1. still frame from Entering Data 5 min

    Getting Started with Excel

    If you’re new to Excel, start here. This course introduces the concepts of cells, rows and columns, shows how to navigate Excel 2016 for Windows, and describes the basics of entering data and doing calculations.

  2. still frame from Copying Formulas/Relative and Absolute Cell References 8 min


    The true power of Excel is its ability to perform calculations. This course explains how calculations work and introduces concepts such as formulas and relative and absolute cell references.

  3. still frame from Borders and Shading 10 min


    The formatting tools available in Excel that can make worksheets clean and easy to follow. Includes text wrapping, cell alignment, and formatting numbers and dates.

  4. still frame from Inserting Cells, Rows and Columns 6 min

    Copying and Moving Data

    Copying and moving data in Excel is similar to how it works in Word, but there are some differences. This course focuses on features that are particular to Excel, including inserting cells, rows and columns and moving and deleting worksheets.

  5. still frame from Fitting Data on One Page 6 min


    This course covers the main things to know about printing in Excel. Includes selecting the print area, repeating rows and columns, adding headers and footers and fitting data onto a single page.

  6. still frame from Filtering and Sorting Data 6 min

    Working with Large Data Sets

    Lawyers often have to deal with large sets of data when working on a litigation or transaction. This course covers the Excel features that make it easier to work with large data sets, including filtering and sorting data, freezing panes and splitting the window.

  7. still frame from The Elements of a Function 5 min


    Excel functions are preset formulas that make it easy to perform specific calculations. Here's a summary of some useful functions for lawyers, and a description of how functions are structured.

  8. still frame from Example Model: M&A Valuation 12 min

    Financial Modeling

    This course introduces the fundamentals of financial modeling and discusses how it’s relevant to lawyers.

  9. still frame from Sampling, Margin of Error and Confidence Intervals 11 min

    Introduction to Statistics

    This course provides an overview of key statistical concepts that are relevant to legal practice, including averages, sampling and distribution curves.

  10. still frame from Interactive Data Visualizations 7 min

    Data Visualization

    An overview of charts and other data visualization techniques used in business and finance. Covers concepts such as line and bar charts, histograms, scatter plots and heat maps.