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.
Short, practical videos with quizzes and summaries.
See all 379How 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.
A discussion of guaranties, including the key provisions in a guaranty agreement and the different types of guaranties that can be given, such as payment vs. performance guaranties and down-stream vs. upstream guaranties.
A round-up of the most common investment strategies used by the managers of hedge funds to generate excess returns, such as “equity focus” and “global macro”. The course also includes a discussion of short selling and the impact of high-frequency trading and quants.
How to read and interpret Companies House filings to assess a company's structure, compliance, ownership, and financial health. Covers what the register can and cannot tell you, how to identify red flags in filing histories, what PSC and financial disclosures reveal, and the governance signals that warrant further investigation.
An examination of confidentiality agreements and their use in private M&A deals. The course includes a detailed walkthrough of a sample NDA, explaining each provision’s importance and how it impacts the respective parties.
How to calculate the conversion of a convertible note into preferred stock when the note has a discount, a valuation cap or both.
Curated course lists for self-paced learning, with CLE available in most MCLE states.
See all 75Explains the main documents involved in venture financing deals, including key legal and business points and considerations for drafting and reviewing the documents. Documents covered include amended and restated certificates of incorporation, stock purchase agreements, voting agreements, convertible notes, and more.
This program covers the ethical use of AI across core areas of legal practice, helping lawyers understand both the opportunities and the ethical considerations of these powerful tools. The program covers AI’s role in transactional work and litigation, guidance on prompting large language models, and the ethical and professional responsibility issues that arise when using AI in legal practice. Lawyers will gain practical knowledge to use AI tools effectively and responsibly in real-world settings
An introduction to different types of securities and securities offerings, including an overview of the IPO process, greenshoe options, follow-on offerings, and shelf registrations and takedowns.
This program teaches lawyers about various aspects of two advanced M&A concepts found in acquisition agreements – Claims ‘If True’ provisions and the concept of indemnifiable losses (with a focus on the definition of “Loss”). It covers drafting and negotiating tips and buyer and seller perspectives.
This program covers strategies, rules, and procedures specific to the taking of a corporate deposition, as well as some common mistakes made when taking a deposition and tips for effective deposition prep. It also includes tips for drafting a corporate deposition notice, strategies for taking the deposition such that information responsive to the deposition topic is obtained, and tips for asking questions that will garner clear and usable testimony after the deposition.
An introduction to the discovery process in civil litigation, including discovery requests, written responses and objections, interrogatories, requests for admission, depositions, and e-discovery.