Using Excel and Word Together
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.
Category
Microsoft Office
Courses
-
5 min
-
8 min
Collaborating on Files
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.
-
6 min
Working with Large Data Sets
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.
-
5 min
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.
-
4 min
PivotTables
A PivotTable can be useful for summarizing and analyzing large sets of data. This course describes how to create and work with PivotTables.
-
6 min
Error Messages
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!.
-
6 min
Time-Saving Tricks: Keyboard Shortcuts, Autofill and More
Tips and tricks to help you work more efficiently in Excel.
-
6 min
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.
-
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.