Microsoft Office

Courses

1. Preview

   Copy, Paste, and Format Painter

   How to do complex formatting in Microsoft Word using the Format Painter, Paste Options, and the clipboard. More than just the basics of copy-and-paste.

   • Formatting your Document
   • Microsoft Office
   • Microsoft Word
2. Preview

   Hyperlinks

   How to use hyperlinks in your Microsoft Word document. Includes how to create the links, turn purple links back to blue, edit hyperlinks to emails, and more.

   • Microsoft Office
   • Microsoft Word
3. Preview

   Find and Replace

   How to refine your searches within Microsoft Word documents, using advanced functionality of Find and Replace. Helps you find and replace exactly what you’re looking for—and nothing more.

   • Microsoft Office
   • Microsoft Word
   • Reviewing your Document
4. Preview

   Spell Check and AutoCorrect

   How to get the most out of the two tools Microsoft Word offers to help you avoid spelling mistakes.

   • Microsoft Office
   • Microsoft Word
   • Reviewing your Document
5. Preview

   Bullets and Numbered Lists

   How to use Bullets and Numbering in Microsoft Word. Includes helpful tips, such as changing the formatting for sub-levels, defining your own multi-level lists, and adjusting the indentation just how you like it.

   • Formatting your Document
   • Microsoft Office
   • Microsoft Word
6. Preview

   Printing

   Helpful bells and whistles to know about when you’re printing your document in Microsoft Word, such as how to print certain ranges of pages, and how to hide your track changes and comments.

   • Microsoft Office
   • Microsoft Word
7. Preview

   Customizing Word Just for You

   How to change your Microsoft Word settings to maximize your efficiency and optimize your individual use of Word. Includes, for example, setting up your most-used functions to be just one click away.

   • Microsoft Office
   • Microsoft Word
8. Preview

   Page Numbering

   How to format pages numbers, have different page numbering for different parts of your documents (like exhibits), and other features involving page numbering in Microsoft Word.

   • Formatting your Document
   • Microsoft Office
   • Microsoft Word
9. Preview

   Styles

   How to use Microsoft Word’s Styles tool for consistent formatting in your document. Also includes different ways to alter the formatting of a Style.

   • Formatting your Document
   • Microsoft Office
   • Microsoft Word
10. Preview

    Viewing Your Page

    The different ways you can view your page on the Microsoft Word screen, and when they’re helpful. Includes snapping two documents side by side, the “focus” view that cuts distractions from your screen, and more.

    • Microsoft Office
    • Microsoft Word
11. Preview

    Headers and Footers

    How to do what you want with your headers and footers in a Microsoft Word document. Includes, for example, how to use a different header or footer for different parts of your document—like tables of contents, exhibits, or signature pages.

    • Formatting your Document
    • Microsoft Office
    • Microsoft Word
12. Preview

    Navigating Word

    An overview of how the Microsoft Word screen is organized, giving users the lay of the land. Includes how to find the tool you need, how the tools are grouped within the ribbon, and how to take advantage of the Navigation Pane.

    • Microsoft Office
    • Microsoft Word
13. Preview

    Keyboard Shortcuts

    Keyboard shortcuts to help you move through your Microsoft Word document more efficiently.

    • Formatting your Document
    • Microsoft Office
    • Microsoft Word
    • Reviewing your Document
14. Preview

    Word Count

    How to use the Word Count tool in Microsoft Word, including counting the words in only a portion of your document, and making the Word Count stay on your screen at all times.

    • Microsoft Office
    • Microsoft Word
    • Reviewing your Document
15. Preview

    Line Spacing

    How to adjust the spacing between lines in a Microsoft Word list. Includes tips like making the spaces apply only between bullets, rather than between every line.

    • Formatting your Document
    • Microsoft Office
    • Microsoft Word
16. Preview

    Tables

    How to create and format tables in your Microsoft Word document, including auto-fitting contents, repeating column headings across pages, and more.

    • Formatting your Document
    • Microsoft Office
    • Microsoft Word
17. Preview

    Section Breaks and Page Breaks

    How to use section breaks and page breaks in your Microsoft Word document for your page-numbering, header/footer, and page separation needs.

    • Formatting your Document
    • Microsoft Office
    • Microsoft Word
18. Preview

    Redlining

    How to run a redline of your Microsoft Word documents, as well as how to email the redlines, cleans, and modified pages.

    • Microsoft Office
    • Microsoft Word
    • Reviewing your Document
19. Preview

    Removing Metadata

    How to remove metadata from a Microsoft Word document, and why it matters. Includes other tips too, like how to skip the scrub when you want to.

    • Microsoft Office
    • Microsoft Word
20. Preview

    Cross-References

    How to update the section numbers of your Microsoft Word document using the cross-references tool, rather than updating every number manually.

    • Microsoft Office
    • Microsoft Word
    • Reviewing your Document
21. Preview

    Microsoft Word Tips for Drafting a Contract

    Tips for Microsoft Word that will make drafting your contract smoother and more efficient.

    • Formatting your Document
    • Microsoft Office
    • Microsoft Word
    • Reviewing your Document
22. Preview

    Comments

    How to get the most out of working with Comments in your Microsoft Word document. Covers when to use the different views, how to show just one person’s comments, how to declutter your screen when there are too many comments, and more.

    • Microsoft Office
    • Microsoft Word
    • Reviewing your Document
23. Preview

    Track Changes

    How to use track changes to its fullest potential in your Microsoft Word document. Covers how to show only a specific person’s changes, how to hide all the formatting changes, and more.

    • Microsoft Office
    • Microsoft Word
    • Reviewing your Document
24. Preview

    Microsoft Word Tips for Writing a Brief

    Tips for maximizing your efficiency with Microsoft Word when writing a legal brief. Covers various tools you can take advantage of as you move through the brief-writing process.

    • Drafting Your Brief
    • Formatting your Document
    • Microsoft Office
    • Microsoft Word
    • Reviewing your Document
25. Preview

    Getting Started with Excel

    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.

    • Excel Basics
    • Microsoft Office
26. Preview

    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.

    • Excel Basics
    • Microsoft Office
27. Preview

    Formatting

    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.

    • Excel Basics
    • Microsoft Office
28. Preview

    Copying and Moving Data

    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.

    • Excel Basics
    • Microsoft Office
29. Preview

    Creating Charts

    How to create and format charts in Excel.

    • Excel Basics
    • Microsoft Office
30. Preview

    Printing

    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.

    • Excel Basics
    • Microsoft Office
31. Preview

    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.

    • Excel Basics
    • Microsoft Office
32. Preview

    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.

    • Excel Basics
    • Microsoft Office
33. Preview

    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.

    • Excel Basics
    • Microsoft Office
34. Preview

    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.

    • Excel Basics
    • Microsoft Office
35. Preview

    PivotTables

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

    • Excel Basics
    • Microsoft Office
36. Preview

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

    • Excel Basics
    • Microsoft Office
37. Preview

    Time-Saving Tricks: Keyboard Shortcuts, Autofill and More

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

    • Excel Basics
    • Microsoft Office
38. 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
39. 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
40. 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
41. 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
42. 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
43. Preview

    Text Functions

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

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