Sample Excel and Microsoft Word Efficiency Track

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.

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.

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.

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

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

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.

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.

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.

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.

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.

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.

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.

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

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

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.

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.

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

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.