Microsoft Excel for Legal Professionals

Microsoft Excel is a powerful tool for analyzing and transforming data. Whether the data is exported from your accounting system or tracked manually, Excel can you better understand it. Don’t let the endless possibilities in Excel get you down — Microsoft Excel for Legal Professionals is here to help.

Written by lawyers for legal professionals, Microsoft Excel for Legal Professionals is filled with examples of how legal professionals like yourself use Excel to analyze and transform their data. From understanding how Excel understands data (that’s more important than you might think) to PivotTables and charts, Microsoft Excel for Legal Professionals has you covered.

• Learn how to let Excel do the work for you without ever writing a formula with tricks like autofill, flash fill, and tables.
• See common functions in action for calculating totals, subtotals, running totals, due dates, loan payments, and more.
• Set your future self up for success with cell references, cell names, and data validation. Protect your formulas from accidentally being overwritten with worksheet protection.

Whether you’re using 2010, 2013, 2016, 2019, or Microsoft 365, this manual is for you. Differences between the versions are explained throughout.

Microsoft Excel for Legal Professionals combines over 40 years of experience from partner Barron Henley, senior consultant John Federico, and senior consultant Danielle DavisRoe. Each of them practiced law prior to coming to Affinity. They are passionate about Excel and helping legal professionals like you get the job done faster.

Check out the table of contents below and read a free chapter before you commit to the entire manual. Just click on the link below to view sample content.

Purchase the Individual Users License for a single copy of this professional manual or purchase the Site License for sharing across an entire firm.

Microsoft Excel for Legal Professionals Table of Contents

• Introduction
• New File Types and Issues for Law Offices
• “Fluent User” Interface
• Excel Basics for Law Firms
• Entering Data Into a Workbook
• Reviewing and Protecting Worksheets
• Law Firm Applications of Excel
•  Formatting Workbooks
• Headers, Footers and Printing
• Producing Charts and Graphs
• Excel as a Mail Merge Data Source
• Other Miscellaneous Tips and Formulas

CLICK TO VIEW A SAMPLE CHAPTER AND THE COMPLETE TABLE OF CONTENTS