Excel for Lawyers Tutorial Course
Course Description
When it comes to Microsoft Office programs, law firms have unique needs. This Excel for lawyers tutorial course includes a training module 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. In addition, you’ll receive our complete Excel curriculum. Learn Microsoft Excel with this comprehensive course from TeachUcomp, Inc. Mastering Excel Made Easy features 224 video lessons with over 12 hours of introductory through advanced instruction. Watch, listen and learn as your expert instructor guides you through each lesson stepbystep. During this mediarich 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 (479 pages), additional images and practice exercises. You will learn how to effectively create and format spreadsheets, charts, pivot tables and much more.
Whether you are completely new to Excel or upgrading from an older version, this course will empower you with the knowledge and skills necessary to be a proficient user. We have incorporated years of classroom training experience and teaching techniques to develop an easytouse course that you can customize to meet your personal learning needs. Simply launch the easytouse interface, click to start a video lesson or open one of the manuals and you’re on your way to mastering Excel.
Course Syllabus & Sample Lessons
Select any of the video lessons markedto view them in a new window.
To view a sample of the instruction manuals in PDF, click here: Sample Excel for Lawyers Manual
LEGAL EDUCATION CURRICULUM:  
CHAPTER 1  Using Online Templates  
Lesson 1.1  Downloading Online Templates  
Lesson 1.2  Saving a Template  
Lesson 1.3  Creating New Workbooks from Saved Templates  
CHAPTER 2  Legal Templates  
Lesson 2.1  Chapter Overview  
Lesson 2.2  Using the Law Firm Financial Analysis Worksheet  
Lesson 2.3  Using the Law Firm Project Tracker  
Lesson 2.4  Using the Law Firm Project Plan  
CHAPTER 3  Legal Business Functions  
Lesson 3.1  The Pv Function  
Lesson 3.2  The Fv Function  
Lesson 3.3  The IRR and XIRR Functions  
CHAPTER 4  Simple IOLTA Management  
Lesson 4.1  IOLTA Basics  
Lesson 4.2  Using Excel for Simple IOLTA Management  
Lesson 4.3  Using the Simple IOLTA Template  
COMPLETE EXCEL CURRICULUM INCLUDED:  
CHAPTER 1 
Excel Tutorial: Getting Acquainted with Excel 

Lesson 1.1  About Excel  
Lesson 1.2  The Excel Environment  
Lesson 1.3  The Title Bar  
Lesson 1.4  The Ribbon  
Lesson 1.5  The “File” Tab and Backstage View  
Lesson 1.6  Scroll Bars  
Lesson 1.7  The Quick Access Toolbar  
Lesson 1.8  Touch Mode  
Lesson 1.9  The Formula Bar  
Lesson 1.10  The Workbook Window  
Lesson 1.11  The Status Bar  
Lesson 1.12  The Workbook View Buttons  
Lesson 1.13  The Zoom Slider  
Lesson 1.14  The Mini Toolbar  
Lesson 1.15  Keyboard Shortcuts  
CHAPTER 2 
Excel Tutorial: File Management 

Lesson 2.1  Creating New Workbooks  
Lesson 2.2  Saving Workbooks  
Lesson 2.3  Closing Workbooks  
Lesson 2.4  Opening Workbooks  
Lesson 2.5  Recovering Unsaved Workbooks  
Lesson 2.6  Opening a Workbook in a New Window  
Lesson 2.7  Arranging Open Workbook Windows  
Lesson 2.8  Freeze Panes  
Lesson 2.9  Split Panes  
Lesson 2.10  Hiding and Unhiding Workbook Windows  
Lesson 2.11  Comparing Open Workbooks  
Lesson 2.12  Switching Open Workbooks  
Lesson 2.13  Switching to Full Screen View  
Lesson 2.14  Working With Excel File Formats  
Lesson 2.15  AutoSave Online Workbooks  
CHAPTER 3 
Excel Tutorial: Data Entry 

Lesson 3.1  Selecting Cells  
Lesson 3.2  Entering Text into Cells  
Lesson 3.3  Entering Numbers into Cells  
Lesson 3.4  AutoComplete  
Lesson 3.5  Pick from DropDown List  
Lesson 3.6  Flash Fill  
Lesson 3.7  Selecting Ranges  
Lesson 3.8  Ranged Data Entry  
Lesson 3.9  Using AutoFill  
CHAPTER 4 
Excel Tutorial: Creating Formulas 

Lesson 4.1  Ranged Formula Syntax  
Lesson 4.2  Simple Formula Syntax  
Lesson 4.3  Writing Formulas  
Lesson 4.4  Using AutoSum  
Lesson 4.5  Inserting Functions  
Lesson 4.6  Editing a Range  
Lesson 4.7  Formula AutoCorrect  
Lesson 4.8  AutoCalculate  
Lesson 4.9  Function Compatibility  
CHAPTER 5 
Excel Tutorial: Copying & Pasting Formulas 

Lesson 5.1  Relative References and Absolute References  
Lesson 5.2  Cutting, Copying, and Pasting Data  
Lesson 5.3  AutoFilling Cells  
Lesson 5.4  The Undo Button  
Lesson 5.5  The Redo Button  
CHAPTER 6 
Excel Tutorial: Columns & Rows 

Lesson 6.1  Selecting Columns & Rows  
Lesson 6.2  Adjusting Column Width and Row Height  
Lesson 6.3  Hiding and Unhiding Columns and Rows  
Lesson 6.4  Inserting and Deleting Columns and Rows  
CHAPTER 7 
Excel Tutorial: Formatting Worksheets 

Lesson 7.1  Formatting Cells  
Lesson 7.2  The Format Cells Dialog Box  
Lesson 7.3  Clearing All Formatting from Cells  
Lesson 7.4  Copying All Formatting from Cells to Another Area  
CHAPTER 8 
Excel Tutorial: Worksheet Tools 

Lesson 8.1  Inserting and Deleting Worksheets  
Lesson 8.2  Selecting Multiple Worksheets  
Lesson 8.3  Navigating Worksheets  
Lesson 8.4  Renaming Worksheets  
Lesson 8.5  Coloring Worksheet Tabs  
Lesson 8.6  Copying or Moving Worksheets  
CHAPTER 9 
Excel Tutorial: Setting Worksheet Layout 

Lesson 9.1  Using Page Break Preview  
Lesson 9.2  Using The Page Layout View  
Lesson 9.3  Opening the Page Setup Dialog Box  
Lesson 9.4  Page Settings  
Lesson 9.5  Setting Margins  
Lesson 9.6  Creating Headers and Footers  
Lesson 9.7  Sheet Settings  
CHAPTER 10 
Excel Tutorial: Printing Worksheets 

Lesson 10.1  Previewing and Printing Worksheets  
CHAPTER 11 
Excel Tutorial: Helping Yourself 

Lesson 11.1  Using Excel Help  
Lesson 11.2  The Tell Me Bar  
Lesson 11.3  Smart Lookup  
CHAPTER 12 
Excel Tutorial: Creating 3D Formulas 

Lesson 12.1  Creating 3D Formulas  
Lesson 12.2  3D Formula Syntax  
Lesson 12.3  Creating 3D Range References  
CHAPTER 13 
Excel Tutorial: Named Ranges 

Lesson 13.1  Naming Ranges  
Lesson 13.2  Creating Names from Headings  
Lesson 13.3  Moving to a Named Range  
Lesson 13.4  Using Named Ranges in Formulas  
Lesson 13.5  Naming 3D Ranges  
Lesson 13.6  Deleting Named Ranges  
CHAPTER 14 
Excel Tutorial: Conditional Formatting and Cell Styles 

Lesson 14.1  Conditional Formatting  
Lesson 14.2  Finding Cells with Conditional Formatting  
Lesson 14.3  Clearing Conditional Formatting  
Lesson 14.4  Using Table and Cell Styles  
CHAPTER 15 
Excel Tutorial: Paste Special 

Lesson 15.1  Using Paste Special  
Lesson 15.2  Pasting Links  
CHAPTER 16 
Excel Tutorial: Sharing Workbooks 

Lesson 16.1  About Coauthoring and Sharing Workbooks  
Lesson 16.2  Coauthoring Workbooks  
Lesson 16.3  Adding Shared Workbook Buttons in Excel  
Lesson 16.4  Traditional Workbook Sharing  
Lesson 16.5  Highlighting Changes  
Lesson 16.6  Reviewing Changes  
Lesson 16.7  Using Comments and Notes  
Lesson 16.8  Compare and Merge Workbooks  
CHAPTER 17 
Excel Tutorial: Auditing Worksheets 

Lesson 17.1  Auditing Worksheets  
Lesson 17.2  Tracing Precedent and Dependent Cells  
Lesson 17.3  Tracing Errors  
Lesson 17.4  Error Checking  
Lesson 17.5  Using the Watch Window  
Lesson 17.6  Cell Validation  
CHAPTER 18 
Excel Tutorial: Outlining Worksheets 

Lesson 18.1  Using Outlines  
Lesson 18.2  Applying and Removing Outlines  
Lesson 18.3  Applying Subtotals  
CHAPTER 19 
Excel Tutorial: Consolidating Worksheets 

Lesson 19.1  Consolidating Data  
CHAPTER 20 
Excel Tutorial: Tables 

Lesson 20.1  Creating a Table  
Lesson 20.2  Adding and Editing Records  
Lesson 20.3  Inserting Records and Fields  
Lesson 20.4  Deleting Records and Fields  
CHAPTER 21 
Excel Tutorial: Sorting Data 

Lesson 21.1  Sorting Data  
Lesson 21.2  Custom Sort Orders  
CHAPTER 22 
Excel Tutorial: Filtering Data 

Lesson 22.1  Using AutoFilters  
Lesson 22.2  Using the Top 10 AutoFilter  
Lesson 22.3  Applying a Custom AutoFilter  
Lesson 22.4  Creating Advanced Filters  
Lesson 22.5  Applying Multiple Criteria  
Lesson 22.6  Using Complex Criteria  
Lesson 22.7  Copying Filter Results to a New Location  
Lesson 22.8  Using Database Functions  
CHAPTER 23 
Excel Tutorial: WhatIf Analysis and Forecasts 

Lesson 23.1  Using Data Tables  
Lesson 23.2  Using Scenario Manager  
Lesson 23.3  Using Goal Seek  
Lesson 23.4  Forecast Sheets  
CHAPTER 24 
Excel Tutorial: TableRelated Functions 

Lesson 24.1  The Hlookup and Vlookup Functions  
Lesson 24.2  Using the IF, AND, and OR Functions  
Lesson 24.3  The IFS Function  
CHAPTER 25 
Excel Tutorial: Sparklines 

Lesson 25.1  Inserting and Deleting Sparklines  
Lesson 25.2  Modifying Sparklines  
CHAPTER 26 
Excel Tutorial: Creating Charts In Excel 

Lesson 26.1  Creating Charts  
Lesson 26.2  Selecting Charts and Chart Elements  
Lesson 26.3  Adding Chart Elements  
Lesson 26.4  Moving and Resizing Charts  
Lesson 26.5  Changing the Chart Type  
Lesson 26.6  Changing the Data Range  
Lesson 26.7  Switching Column and Row Data  
Lesson 26.8  Choosing a Chart Layout  
Lesson 26.9  Choosing a Chart Style  
Lesson 26.10  Changing Color Schemes  
Lesson 26.11  Printing Charts  
Lesson 26.12  Deleting Charts  
CHAPTER 27 
Excel Tutorial: Formatting Charts in Excel 

Lesson 27.1  Formatting Chart Objects  
Lesson 27.2  Inserting Objects into a Chart  
Lesson 27.3  Formatting Axes  
Lesson 27.4  Formatting Axis Titles  
Lesson 27.5  Formatting a Chart Title  
Lesson 27.6  Formatting Data Labels  
Lesson 27.7  Formatting a Data Table  
Lesson 27.8  Formatting Error Bars  
Lesson 27.9  Formatting Gridlines  
Lesson 27.10  Formatting a Legend  
Lesson 27.11  Formatting Drop and HighLow Lines  
Lesson 27.12  Formatting Trendlines  
Lesson 27.13  Formatting Up/Down Bars  
Lesson 27.14  Formatting the Chart and Plot Areas  
Lesson 27.15  Naming Charts  
Lesson 27.16  Applying Shape Styles  
Lesson 27.17  Applying WordArt Styles  
Lesson 27.18  Saving Custom Chart Templates  
CHAPTER 28 
Excel Tutorial: Data Models 

Lesson 28.1  Creating a Data Model from External Relational Data  
Lesson 28.2  Creating a Data Model from Excel Tables  
Lesson 28.3  Enabling Legacy Data Connections  
Lesson 28.4  Relating Tables in a Data Model  
Lesson 28.5  Managing a Data Model  
CHAPTER 29 
Excel Tutorial: PivotTables and PivotCharts 

Lesson 29.1  Creating Recommended PivotTables  
Lesson 29.2  Manually Creating a PivotTable  
Lesson 29.3  Creating a PivotChart  
Lesson 29.4  Manipulating a PivotTable or PivotChart  
Lesson 29.5  Changing Calculated Value Fields  
Lesson 29.6  Formatting PivotTables  
Lesson 29.7  Formatting PivotCharts  
Lesson 29.8  Setting PivotTable Options  
Lesson 29.9  Sorting and Filtering Using Field Headers  
CHAPTER 30 
Excel Tutorial: Power Pivot 

Lesson 30.1  Starting Power Pivot  
Lesson 30.2  Managing the Data Model  
Lesson 30.3  Calculated Columns  
Lesson 30.4  Measures  
Lesson 30.5  Creating KPIs  
Lesson 30.6  Creating and Managing Perspectives  
Lesson 30.7  Power Pivot PivotTables and PivotCharts  
CHAPTER 31 
Excel Tutorial: 3D Maps 

Lesson 31.1  Enabling 3D Maps  
Lesson 31.2  Creating a New 3D Maps Tour  
Lesson 31.3  Editing a 3D Maps Tour  
Lesson 31.4  Managing Layers in a 3D Maps Tour  
Lesson 31.5  Filtering Layers  
Lesson 31.6  Setting Layer Options  
Lesson 31.7  Managing Scenes  
Lesson 31.8  Custom 3D Maps  
Lesson 31.9  Custom Regions  
Lesson 31.10  World Map Options  
Lesson 31.11  Inserting 3D Map Objects  
Lesson 31.12  Previewing a Scene  
Lesson 31.13  Playing a 3D Maps Tour  
Lesson 31.14  Creating a Video of a 3D Maps Tour  
Lesson 31.15  3D Maps Options  
CHAPTER 32 
Excel Tutorial: Slicers and Timelines 

Lesson 32.1  Inserting and Deleting Slicers  
Lesson 32.2  Modifying Slicers  
Lesson 32.3  Inserting and Deleting Timelines  
Lesson 32.4  Modifying Timelines  
CHAPTER 33 
Excel Tutorial: Security Features 

Lesson 33.1  Unlocking Cells  
Lesson 33.2  Worksheet Protection  
Lesson 33.3  Workbook Protection  
Lesson 33.4  Password Protecting Excel Files  
CHAPTER 34 
Excel Tutorial: Making Macros 

Lesson 34.1  Recording Macros  
Lesson 34.2  Running and Deleting Recorded Macros  
Lesson 34.3  The Personal Macro Workbook 
Microsoft Excel for Lawyers Training Course Overview
Microsoft Excel is the most popular commercial spreadsheet software program on the market today. During this 12 hour Excel video training course, our expert instructor will show you how to effectively create and format spreadsheets, charts, pivot tables and much more. This Excel tutorial covers the same material as our threeday classroom training and was designed to provide a solid foundation in Excel and includes a training module 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.
Course includes video lessons, printable instruction manuals, a practice exam with evaluative feedback (find out why your answers are right or wrong), your final exam submission, and a course certificate of completion.
At TeachUcomp, Inc., you choose how you want your Excel training delivered.
Online subscriptions offer the most flexibility and value. With online training, you can access your courses anytime and anywhere you have an internet connection (including all new releases and updates). Your subscription grants you instant access to ALL of our courses for one low price. There are no contracts and you can cancel at any time. You may choose between a monthly or annual plan.
Courses are also available individually via digital download and online for a onetime charge.