LF logo
by learnformula
search
Log in
search
Courses/Law/Technology Training

MS Word, Excel, and Outlook Skills and Shortcuts for Lawyers

Maximizing Efficiency and Productivity in Legal Document Creation and Collaboration.

Created bySylvia Moritz
4.6
(363 reviews)
BeginnerUpdated Mar 19, 2024
MS Word, Excel, and Outlook Skills and Shortcuts for Lawyers

What You'll Learn

check_circleTo understand the importance of consistent formatting in legal documents and how it can improve client satisfaction, reduce errors, and save time and effort in document editing.
check_circleTo learn practical tips and tricks for using Microsoft Word to streamline work processes, including keystroke shortcuts, templates, and the "show/hide" feature for identifying formatting inconsistencies.
check_circleTo become familiar with collaboration tools in Microsoft Word, such as Tracking Changes and Blacklining, and how to use them effectively to facilitate collaboration and revision in legal documents.
check_circleUnderstand the basic features and functions of Microsoft Excel, including how to create, format, and organize spreadsheets for legal practice.
check_circleLearn best practices for designing and managing effective Excel spreadsheets for legal practice, including how to use Excel as a database for legal documents and information, how to import data from other sources, and how to troubleshoot common issues.
check_circleExplore advanced features of Excel, including Vlookup and Index Array functions, Quick Access Toolbar customization, and pivot tables, and how they can be used to efficiently manage large amounts of data and analyze information for legal practice.

About This Course

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

Your Instructors

Sylvia Moritz
Sylvia Moritz

IT Learning and Technology Specialist at Fross Zelnick Lehrman & Zissu, P.C.

menu_book1 courses
star363 reviews

Sylvia Moritz is an IT Learning and Technology Specialist at Fross Zelnick Lehrman & Zissu, P.C., where she provides technical training and development. She has been preparing for this position for over 25 years. Sylvia is experienced in developing high-level training for MS Office products, Litera products, and team building. She has provided technical training to help attorneys, paralegals and staff become more knowledgeable, productive and efficient. Sylvia has also worked as a System Coordinator at New York Presbyterian Hospital, where she supported managers and helped them run their departments more effectively. In addition, Sylvia has experience as a Training & Development (Capabilities Development Management)/Marketing and Special Projects Coordinator at Cowan, Liebowitz& Latman, P.C., where she developed and provided technical training resulting in a 25% increase in attorney technical proficiency and a 15% increase in staff proficiency. She has also facilitated the firm-wide upgrade from MS WORD 2003 to a matter-centric document management system and MS OFFICE 2007, including needs assessments, skills assessments, and training programs. Sylvia has a Bachelor of Science in Information Systems from the University of Phoenix and an MBA in Marketing from The Johns Hopkins University - Carey Business School. Sylvia is skilled in computer literacy, Microsoft Excel, Microsoft PowerPoint, Microsoft Word, win-win vendor relationship development, practical and sustainable problem solutions, Softwise/Innova Administrator, and web management using Wordpress.

Nicole Pettes
Nicole Pettes

PODCAST HOST | LEARNFORMULA

Nicole Pettes is a highly experienced podcast host known for her engaging interview style and ability to draw out the best in her guests. She has hosted a diverse range of podcasts and video interviews that explore a wide variety of topics. Currently, Nicole is a Video Podcast Host with Learn Formula, where she contributes to their professional education series. She also hosts the Anxious & Ambitious podcast, which explores personal growth and mental health, and co-hosts the Podcast Guesting For Profit, which helps entrepreneurs and podcasters succeed as podcast guests.

Credit Information

What Students Are Saying

4.6
Student's Choice
363 reviews

Frequently Asked Questions

We are a registered provider with 327+ associations and regulatory bodies worldwide. We operate across 29 global markets including Canada, the US, Australia, and the UK. Every course page clearly displays its specific accreditations. Upon completion, you receive a professional certificate that can be validated online. Our certificates include all necessary accreditation details, credit hours, and completion dates, and are formatted specifically to meet the submission requirements of most global regulatory bodies.