Excel Functions

Courses

1. 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.

   • Excel Functions
   • Microsoft Office
2. 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.

   • Excel Functions
   • Microsoft Office
3. 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.

   • Excel Functions
   • Microsoft Office
4. Preview

   Rounding Functions

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

   • Excel Functions
   • Microsoft Office
5. 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.

   • Excel Functions
   • Microsoft Office
6. Preview

   Text Functions

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

   • Excel Functions
   • Microsoft Office
7. Preview

   Present and Future Value Functions

   An introduction to the most commonly used functions for present and future value: PV, FV and NPV.

   • Excel Functions
   • Microsoft Office
8. Preview

   Date and Time Functions

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

   • Excel Functions
   • Microsoft Office