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.
Short, practical videos with quizzes and summaries.
See all 359Excel 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.
Cap tables and pro forma cap tables are used before, during and after a deal. This course uses Excel examples to explain their structure, content and uses.
How to draft an engaging, effective preliminary statement, including what to include and how to make it persuasive.
A framework for understanding your private equity client’s business in order to help protect their interests. This course discusses what PE clients are concerned with during three stages of an investment—the acquisition phase, the holding period, and the divestment phase. It looks at valuing a target, maximizing returns, operational improvements, and exit strategies.
A review of the common ancillary documents in a typical loan transaction, including corporate certificates, legal opinions, and documents related to collateral in secured deals.
A practical course on creating effective prompts for large language models, with a focus on legal applications. It covers the principles of effective prompts, including general rules, common pitfalls, and best practices.
Curated course lists for self-paced learning, with CLE available in most MCLE states.
See all 65This track introduces the main documents involved in commercial lending deals. It includes walk throughs of the documents and their main provisions, covers key legal and business points, as well as strategic considerations for drafting, reviewing, and filing the documents. Documents covered include commitment letters and other preliminary documents, UCC-1 financing statements, UCC-3s, payoff letters, security agreements, and credit agreements.
Explains key concepts in financial reporting and accounting, such as accrual accounting, revenue recognition, and depreciation and amortization. This track also covers the roles in a finance department; the processes of accounting, financial reporting, and audits; and how to analyze a company’s annual report and financials.
Rules, procedures, tips and strategic considerations for taking and defending expert depositions. This track covers qualifying as an expert, expert and rebuttal reports, witness prep, questioning techniques, attorney-client privilege, and more.
This track explores how private equity deals are financed, how management incentives are structured, and the strategies funds use to create value.
This program teaches lawyers about various aspects of two advanced M&A concepts found in acquisition agreements – materiality scrapes and sandbagging. It covers drafting and negotiating tips and buyer and seller perspectives.
Explains the main documents and key provisions in M&A deals, and provides an overview of the M&A deal process from start to finish. This track also explains the structures of M&A deals including asset and stock sales, direct mergers, and forward and reverse triangular mergers.