In this course, attorneys will learn how to optimize their use of Microsoft Word, a powerful tool that can streamline their work and increase productivity. They will discover tips and tricks for standardizing documents to save time and improve consistency, as well as the benefits of consistent formatting in legal documents. The course will cover keystroke shortcuts for efficient document editing, setting up a Standard Normal Template and using templates, and the importance of using templates to avoid formatting issues. Attorneys will also learn how to use Windows shortcuts to organize templates and save time, and how to collaborate with others using Tracking Changes and Blacklining. Additionally, the course will cover exporting documents as PDFs to protect against unauthorized changes and best practices for collaborating on Word documents. With this course, attorneys will be able to work more efficiently and effectively using Microsoft Word, leading to improved client satisfaction and increased productivity.

The course covers the basics of Excel, such as rows and columns, and then moves on to best practices for designing effective spreadsheets. Attendees will learn how to use Excel as a database to track legal documents, including privilege logs, witness lists, and expert witness lists. They will also learn about VLOOKUP and INDEX Array functions in Excel, which can help manage large sets of data.

The course also covers customization options, including Excel's Quick Access Toolbar, and best practices for copying and pasting data into other applications and importing data from other sources into Excel. Attendees will learn how to password-protect workbooks to ensure confidentiality and how to troubleshoot Excel formulas using built-in tools and add-ons. Pivot tables and formatting data ranges as tables will also be covered.

Overall, this course will provide legal professionals with the necessary skills to use Microsoft Excel efficiently and effectively in their practice, saving time and increasing productivity. With the knowledge gained from this course, attendees will be able to take on more complex cases and manage large sets of data with confidence.

Some of the topics include:

Microsoft Word Tips and Tricks for Lawyers
Benefits of Consistent Formatting in Legal Documents
Keystroke shortcuts for efficient document editing
Setting up a Standard Normal Template and Using Templates
The Importance of Using Templates to Avoid Formatting Issues
Using Windows Shortcuts to Organize Templates and Save Time
Collaborating with Microsoft Word using Tracking Changes and Blacklining
Track Changes and Comments
Exporting as PDF
Collaborating on Word Documents
Best practices for designing effective Excel spreadsheets for legal practice
Rows and columns in Excel
How to use Excel as a database
Examples of legal documents to track using Excel (privilege log, witnesses, expert witnesses, documents)
Vlookup and Index Array functions in Excel
Excel's Quick Access Toolbar and Customization
Best practices for copying and pasting Excel data into other applications
Best practices for importing data from other sources into Excel
Protecting confidential information stored in Excel workbooks
Tips for troubleshooting Excel formulas
Pivot tables for analyzing large amounts of data
Formatting data ranges as a table to make it easier to understand and use large amounts of data