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.
Category
Excel Functions
Courses
-
6 min
-
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.
-
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.
-
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.
-
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.
-
3 min
Text Functions
An explanation of how to use text functions to clean and normalize text in Excel.
-
5 min
Present and Future Value Functions
An introduction to the most commonly used functions for present and future value: PV, FV and NPV.
-
3 min
Date and Time Functions
An overview of the various date and time functions that are most useful in legal practice.