Skip to main content

Topic

Excel & Data Analysis

Courses

  1. still frame from Getting Started with Excel 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 Calculations 8 min

    Calculations

    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 Formatting 10 min

    Formatting

    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 Copying and Moving Data 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.

  6. still frame from Printing 6 min

    Printing

    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.

  7. still frame from Using Excel and Word Together 5 min

    Using Excel and Word Together

    Sometimes it’s more efficient to use Excel and Word together than it is to use Word on its own. This course explains when and how, including when working with charts and tables.

  8. still frame from Collaborating on Files 8 min

    Collaborating on Files

    An explanation of the tools available in Excel that make collaborating on an Excel file secure and efficient, including using comments, protecting files and hiding data.

  9. still frame from Working with Large Data Sets 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.

  10. still frame from Functions 5 min

    Functions

    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.

  11. still frame from PivotTables 4 min

    PivotTables

    A PivotTable can be useful for summarizing and analyzing large sets of data. This course describes how to create and work with PivotTables.

  12. still frame from Error Messages 6 min

    Error Messages

    A summary of common error messages in Excel and how to find and fix errors. Includes descriptions of #VALUE!, #######, #DIV/0!, #NULL!, #N/A, #NAME? and #REF!.

  14. still frame from IF Functions 6 min

    IF Functions

    An explanation of how to use IF functions to perform calculations based on specified criteria, with a practice example based on a cap table.

  15. still frame from VLOOKUP 2 min

    VLOOKUP

    An explanation of how to use the VLOOKUP function, which can be useful when working with large sets of data in a litigation or transaction.

  16. still frame from MIN and MAX Functions 3 min

    MIN and MAX Functions

    How to use the MIN and MAX functions to easily find the smallest or largest number in a set of values, with a practice example based on a company’s cap table.

  17. still frame from Rounding Functions 4 min

    Rounding Functions

    An explanation of how to use the ROUND, ROUNDUP and ROUNDDOWN functions, with a practice example based on a financing round.

  18. still frame from SUM and AVERAGE Functions 6 min

    SUM and AVERAGE Functions

    An overview of the SUM and AVERAGE functions, with a practice example based on a 280G analysis in an M&A deal.

  19. still frame from Text Functions 3 min

    Text Functions

    An explanation of how to use text functions to clean and normalize text in Excel.

  21. still frame from Date and Time Functions 3 min

    Date and Time Functions

    An overview of the various date and time functions that are most useful in legal practice.

  22. still frame from Financial Modeling 12 min

    Financial Modeling

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

  23. still frame from Introduction to Statistics 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.

  24. still frame from Data Visualization 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.