Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add Mastering Excel 2016 for Lawyers Training Tutorial to your Wishlist.

Add to Wishlist

Mastering Excel 2016 for Lawyers Training Tutorial

Specifically designed for legal professionals
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
27 students enrolled
Last updated 1/2016
English
$10 $20 50% off
4 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 33 mins on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
Description

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.

Who is the target audience?
  • Attorneys
  • Legal Professionals
  • Secretaries
  • Law Students
Students Who Viewed This Course Also Viewed
What Will I Learn?
Learn How to Use Legal Templates
Discover Legal Functions in Excel
View Curriculum
Requirements
  • Basic Knowledge of Microsoft Excel
Curriculum For This Course
Expand All 16 Lectures Collapse All 16 Lectures 01:02:53
+
Course Introduction
1 Lecture 00:39

This lecture provides a brief summary of the topics covered throughout the course and offers suggestions for further reading and learning materials.

Preview 00:39
+
Using Online Templates
3 Lectures 03:47

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. Learn this and more during this lecture.

Preview 01:20

You can 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. Learn this and more during this lecture.
Preview 01:40

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. Learn this and more during this lecture.

Preview 00:47
+
Legal Templates
4 Lectures 11:25

In this section we will review the various law firm templates. Learn this and more during this lecture.

Preview 00:48

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 you can analyze the results to make better business decisions. Learn this and more during this lecture.

Preview 04:20

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.

Preview 03:47

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.

Using the Law Firm Project Plan
02:30
+
Legal Business Functions
3 Lectures 09:43
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. Learn this and more during this lecture.
The Pv Function
03:15

The next function that we will be learning about is the Fv function. The Fv function assists you in determining the future value of an investment based on periodic but constant payments with a constant interest rate. Learn this and more during this lecture.

The Fv Function
02:27

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. Learn this and more during this lecture.

The IRR and XIRR Functions
04:01
+
Simple IOLTA Management
3 Lectures 06:46

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. Learn this and more during this lecture.

IOLTA Basics
02:04

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.

Using Excel for Simple IOLTA Management
00:54

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. Learn this and more during this lecture.

Using the Simple IOLTA Template
03:48
+
Course Conclusion
1 Lecture 00:33

This lecture provides a brief summary of the topics covered throughout the course and offers suggestions for further reading and learning materials.

Course Conclusion
00:33
+
Excel for Lawyers Manual
1 Lecture 00:00

Excel for Lawyers Manual. Plus practice exercises and keyboard shortcuts.

Excel for Lawyers Manual
30 pages
About the Instructor
4.2 Average rating
1,996 Reviews
94,467 Students
66 Courses
Quality Software Training

Founded in 2001, TeachUcomp, Inc. began as a licensed software training center in Holt, Michigan - providing instructor-led, classroom-style instruction in over 85 different classes, including Microsoft Office, QuickBooks, Peachtree and web design, teaching staff at organizations such as the American Red Cross, Public School Systems and the Small Business Association.

At TeachUcomp, Inc., we realize that small business software can be confusing, to say the least. However, finding quality training can be a challenge. TeachUcomp, Inc. has changed all that. As the industry leader in training small business software, TeachUcomp, Inc. has revolutionized computer training and will teach you the skills to become a powerful and proficient user.

In 2002, responding to the demand for high-quality training materials that provide more flexibility than classroom training, TeachUcomp, Inc. launched our first product - Mastering QuickBooks Made Easy. The enormous success of our first tutorial led to an ever-expanding product line. TeachUcomp, Inc. now proudly serves customers in over 80 different countries world-wide including individuals, small businesses, non-profits and many others. Clients include the Transportation Security Administration, NASA, Smithsonian Institution, University of Michigan, Merrill Lynch, Sprint, U.S. Army, Oracle Corporation, Hewlett-Packard and the U.S. Senate.

Our full-time staff of software training professionals have developed a product line that is the perfect solution for busy individuals. Our comprehensive tutorials cover all of the same material as our classroom trainings. Broken into individual lessons, you can target your training to meet your needs - choosing just the lessons you want (and having the option to watch them all if you like). Our tutorials are also incredibly easy to use.

You will listen and watch as our expert instructors walk you through each lesson step-by-step. Our tutorials also feature the same instruction manuals (in PDF) that our classroom students receive - and include practice exercises and keyboard shortcuts. You will see each function performed just as if the instructor were at your computer. After the lesson has finished, you then "toggle" into the application and practice what you've learned - making it the most effective interactive training solution to learn on your own.

Report Abuse