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 LawyersBenefits of Consistent Formatting in Legal DocumentsKeystroke shortcuts for efficient document editingSetting up a Standard Normal Template and Using TemplatesThe Importance of Using Templates to Avoid Formatting IssuesUsing Windows Shortcuts to Organize Templates and Save TimeCollaborating with Microsoft Word using Tracking Changes and BlackliningTrack Changes and CommentsExporting as PDFCollaborating on Word DocumentsBest practices for designing effective Excel spreadsheets for legal practiceRows and columns in ExcelHow to use Excel as a databaseExamples of legal documents to track using Excel (privilege log, witnesses, expert witnesses, documents)Vlookup and Index Array functions in ExcelExcel's Quick Access Toolbar and CustomizationBest practices for copying and pasting Excel data into other applicationsBest practices for importing data from other sources into ExcelProtecting confidential information stored in Excel workbooksTips for troubleshooting Excel formulasPivot tables for analyzing large amounts of dataFormatting data ranges as a table to make it easier to understand and use large amounts of data.