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.

• 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