Courses

In-depth look at effective deposition questioning, including open versus closed questions, the funnel approach, strategies for getting admissions, cross-examination, and testing case theories.

Strategies and tips for asking questions and getting testimony that is clear and usable after the deposition.

A look at common missteps when taking a deposition, and how to avoid those mistakes in your questioning.

Rules about correcting the transcript, the format and content of an errata sheet, and procedure for preparing an errata sheet and signing the deposition transcript.

Strategies, rules, and procedures when taking a corporate deposition, and obtaining information responsive to a deposition topic.

Examination of a corporate deposition notice and drafting tips.

Discussion of different requirements in protective orders for confidentiality designations in deposition transcripts and the process of reviewing a transcript and designating material confidential.

Discussion of the process of reviewing and selecting documents for depositions.

Procedure for proper marking of exhibits, useful questions about exhibits, strategies for selecting documents to mark as exhibits, and common mistakes with exhibits.

Procedure for noticing or subpoenaing a deposition, examples of a deposition notice and subpoena, and the process of scheduling depositions.

Rules and tips for selecting the corporate witness; how a corporate witness’s role differs from a fact witness; assembling materials for corporate witness prep; reviewing the topics with the witness; and tips for reviewing the topics and practicing Q&A with a corporate witness.

Detailed how-to of the process of drafting a deposition outline, with practical tips and examination of examples.

How to respond to a corporate deposition notice, including the different objections, coordinating a response with your client, and how to handle the meet-and-confer process with opposing counsel.

If you’re new to Excel, start here. This course introduces the concepts of cells, rows and columns, shows how to navigate Excel 2016 for Windows, and describes the basics of entering data and doing calculations.

The true power of Excel is its ability to perform calculations. This course explains how calculations work and introduces concepts such as formulas and relative and absolute cell references.

The formatting tools available in Excel that can make worksheets clean and easy to follow. Includes text wrapping, cell alignment, and formatting numbers and dates.

Copying and moving data in Excel is similar to how it works in Word, but there are some differences. This course focuses on features that are particular to Excel, including inserting cells, rows and columns and moving and deleting worksheets.

How to create and format charts in Excel.

This course covers the main things to know about printing in Excel. Includes selecting the print area, repeating rows and columns, adding headers and footers and fitting data onto a single page.

Sometimes it’s more efficient to use Excel and Word together than it is to use Word on its own. This course explains when and how, including when working with charts and tables.

An explanation of the tools available in Excel that make collaborating on an Excel file secure and efficient, including using comments, protecting files and hiding data.

Lawyers often have to deal with large sets of data when working on a litigation or transaction. This course covers the Excel features that make it easier to work with large data sets, including filtering and sorting data, freezing panes and splitting the window.

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.

A PivotTable can be useful for summarizing and analyzing large sets of data. This course describes how to create and work with PivotTables.

A summary of common error messages in Excel and how to find and fix errors. Includes descriptions of #VALUE!, #######, #DIV/0!, #NULL!, #N/A, #NAME? and #REF!.

Tips and tricks to help you work more efficiently in Excel.

An explanation of how to use IF functions to perform calculations based on specified criteria, with a practice example based on a cap table.

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.

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.

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