Mastering Microsoft Excel 2013 for Lawyers Training Tutorial
- 44 mins on-demand video
- 1 downloadable resource
- Full lifetime access
- Access on mobile and TV
- Certificate of Completion
Get your team access to 4,000+ top Udemy courses anytime, anywhere.Try Udemy for Business
- Video Lessons
- Includes Printable Instruction Manual
- How to Use Legal Templates
- Legal Business Functions
- Simple IOLTA Management
- Microsoft Excel is recommended for practice
When it comes to Microsoft Office programs, law firms have unique needs. This Excel training course includes training specific to the practice of law. You will learn how to effectively use legal templates, legal business functions (such as the Pv and Fv functions) and simple IOLTA management. Mastering Excel for Lawyers Made Easy features 13 video lessons. Watch, listen and learn as your expert instructor guides you through each lesson step-by-step. During this media-rich learning experience, you will see each function performed just as if your instructor were there with you. Reinforce your learning with the text of our printable classroom instruction manual, additional images and practice exercises.
- Those who practice law
- Law Firms
Microsoft Excel allows you to download templates from Office.com if you are using Microsoft Excel on an internet-connected computer. There are many templates available for legal professionals that allow you to manage and record time, record consulting on projects, and many other useful things. In this lesson we will examine how you can connect to Office.com to search for templates that you can download and save to your computer for use within your law firm. Learn this and more during this lecture.
You can then save a downloaded template to the templates folder within your computer so you will not need to download it again in the future. To do this, ensure the template is displayed onscreen and then click the “File” tab within the Ribbon. Then click the “Save As” command shown at the left side of the backstage view within the template file. If using Excel 2013, then click the “Computer” choice to the right of the command list. Then click the “Browse” button that appears in the area to the right. Learn this and more during this lecture.
In the last lecture within this section, you learned how to save a template to your computer. In this lecture, you will learn how to create a new workbook from the template that you saved to your computer. To create a new workbook from a saved template, select the “File” tab in the Ribbon and then click the “New” command at the left side of the backstage view. Learn this and more during this lecture.
In this section we will review the various law firm templates that are provided within this product. These templates are provided within this product within the “Templates” folder when browsing the content of the product that you purchased from TeachUcomp, Inc. You can also open the Excel templates within this folder by using the handy hyperlinks embedded within the Excel CLE interface and then save them to your computer. Learn this and more during this lecture.
Let’s examine the structure and usage of the “Law Firm Financial Analysis Worksheet.” This workbook allows you to enter detailed financial information about your law firm, so that you can analyze the results in order to make better business decisions. You should first note that there are seven color-coded worksheets shown on the tabs at the bottom of the workbook. Learn this and more during this lecture.
We will now review using the “Law Firm Project Tracker” workbook. This workbook is very similar in nature to the “Law Firm Financial Analysis Worksheet.” The layout of information is almost identical, however the analysis generated from the data tends to emphasize the tracking of the project billing versus the financial aspect. Learn this and more during this lecture.
We will now review using the “Law Firm Project Plan” workbook. This workbook is almost identical to the “Law Firm Project Tracker,” however the information entered into the “Law Firm Project Plan” workbook does not feature any tracking of actuals versus estimates. This workbook is simply used to record the initial project plan data. Learn this and more during this lecture.
Most of the functions that a lawyer needs to know assist them in business and financial computations. These functions can be used both for the law firm as well as its clients- for example figuring out the future value of a purchased asset is often useful for both parties. In this section we will discuss some of the most commonly used functions that legal professionals should know how to use. Learn this and more during this lecture.
As a lawyer, you will probably handle many different types of projects or matters. It can be useful to know which types of projects are the most profitable for you to pursue. One way of determining this is by using the IRR function within Excel to determine the internal rate of return on projects. The internal rate of return is simply a number that shows you the profitability of a project. The larger the IRR number, the more profitable the project. IRR finds this number by examining the flow of cash that you input into cells within an Excel worksheet. Learn this and more during this lecture.
In this section, we will learn how to perform simple IOLTA management within an Excel workbook. An IOLTA, or Interest on Lawyer’s Trust Account, is used to hold client funds separately from the funds of a law firm or individual lawyer. An IOLTA account is an interest-bearing checking account. The interest earned from all IOLTA accounts within a state is pooled together to assist low-income individuals to afford legal aid. Learn this and more during this lecture.
If allowed by your state, you can use Excel to track the balance in an IOLTA account as well as create individual client ledgers that list all IOLTA transactions. This information can then be copied to a new workbook and modified as needed in order to comply with many state’s IOLTA reporting requirements. Learn this and more during this lecture.
In this lecture, we will examine using the simple IOLTA template that can be found in the “Templates” folder within this product. This workbook allows you to record the basic accounting information needed for IOLTA management. The template initially contains four worksheets: the “Firm Journal” and three “Client Name Journals.” The basic structure shown within each worksheet is a basic checking register. Within these worksheets, you will record all IOLTA transactions into the appropriate ledgers as they occur. Learn this and more during this lecture.