Excel For Law Firms

Microsoft Excel has been around since 1985, but many people in legal and corporate environments have yet to discover the software’s potential. We still reach for calculators to work with numbers, use graphics software to create and display charts, and employ complex database software to store related data. Microsoft Excel can do all of these things and a lot more—and most often better than the aforementioned methods. Let's take a look at some of the ways in which Excel can be used in a law firm, corporate legal department, or governmental agency. • Litigation: Trial Docket/Calendaring, Witness List Maintenance, Damages Chart Creation and Maintenance • Accounting Department: Financial Analysis Tools, Annual Budget Preparation • Human Resources: Headcount Reports, Salary Projections, Leave Tracking • IT Department: Inventory, Depreciation Schedules • Marketing: Client Satisfaction Reports, Return on Investment for Advertising As you can see, there are many “legal” uses for Excel. This book will walk you through many of the items from this list and supply useful solutions for scenarios that are common to most law firms. We've added hands-on exercises in most chapters and created a new element for this edition—a complete chapter filled with supplemental exercises (Chapter 15: Supplemental Review Exercises). The book includes a CD with exercises from the book.