Excel & Data Analysis

Preview

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.

Preview

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.

Preview

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.

Preview

Rounding Functions

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

Preview

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.

Preview

Text Functions

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

Preview

Date and Time Functions

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