Excel For Microsoft 365 For Lawyers Made Easy Training

A Complete Beginner's Guide to Excel for Lawyers

What you'll learn

Create both basic and advanced spreadsheets

Create complex formulas

Chart and graph data

Create PivotTables and PivotCharts

Audit worksheets

Manage security features

Learn How to Use Legal Templates

Discover Legal Functions in Excel

Learn Simple IOLTA Management

Much more!

Requirements

Good command of operating system

Basic Microsoft Office skills helpful (Especially Word)

Description

Unlock the Power of Microsoft Excel for Lawyers with Our Comprehensive Tutorial!Discover the world of Excel for Microsoft 365 like never before with "Mastering Excel Made Easy for Lawyers," your go-to learning resource from TeachUcomp, Inc.What Awaits You:224 in-depth video lessonsOver 9.5 hours of comprehensive instructionSuitable for beginners to advanced usersOur experienced instructor will be your guide as you embark on a step-by-step journey through each chapter and lesson. Learn effortlessly by watching and listening, as if your instructor is right there beside you.Your Learning Arsenal:A detailed, 363-page printable classroom instruction manualLoaded with additional images and practice exercises for hands-on learningWhen it comes to Microsoft Office programs, law firms have unique needs. This Excel for lawyers tutorial course includes our entire Excel curriculum plus training modules 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. Uncover the art of creating and formatting spreadsheets, crafting stunning charts, and mastering pivot tables, and much more. Each Excel function and feature comes to life during this media-rich learning experience.The TeachUcomp Advantage:Built on years of classroom training experience and teaching expertiseCrafted for ease of use and understandingTailorable to your unique learning preferencesWhether you're a complete Excel novice or making the leap from an older version, our Excel tutorial equips you with the knowledge and skills to become a proficient user. It's like having a personal Excel mentor at your disposal.Ready to Excel:With just a click, your journey to Excel mastery begins. Dive into our complete Excel tutorial or explore the manual, and you'll be well on your way to becoming an Excel pro!Experience the convenience of learning and unleash your Excel potential – enroll in "Mastering Excel Made Easy for Lawyers" today!

Overview

Section 1: Course Introduction

Lecture 1 Course Introduction

Section 2: Getting Acquainted with Excel

Lecture 2 About Excel

Lecture 3 The Excel Environment

Lecture 4 The Title Bar

Lecture 5 The Ribbon

Lecture 6 The “File” Tab and Backstage View

Lecture 7 Scroll Bars

Lecture 8 The Quick Access Toolbar

Lecture 9 Touch Mode

Lecture 10 The Formula Bar

Lecture 11 The Workbook Window

Lecture 12 The Status Bar

Lecture 13 The Workbook View Buttons

Lecture 14 The Zoom Slider

Lecture 15 The Mini Toolbar

Lecture 16 Keyboard Shortcuts

Section 3: File Management

Lecture 17 Creating New Workbooks

Lecture 18 Saving Workbooks

Lecture 19 Closing Workbooks

Lecture 20 Opening Workbooks

Lecture 21 Recovering Unsaved Workbooks

Lecture 22 Opening a Workbook in a New Window

Lecture 23 Arranging Open Workbook Windows

Lecture 24 Freeze Panes

Lecture 25 Split Panes

Lecture 26 Hiding and Unhiding Workbook Windows

Lecture 27 Comparing Open Workbooks

Lecture 28 Switching Open Workbooks

Lecture 29 Switching to Full Screen Mode

Lecture 30 Working with Excel File Formats

Lecture 31 AutoSave Online Workbooks

Section 4: Data Entry

Lecture 32 Selecting Cells

Lecture 33 Entering Text into Cells

Lecture 34 Entering Numbers into Cells

Lecture 35 AutoComplete

Lecture 36 Pick from Drop-Down List

Lecture 37 Flash Fill

Lecture 38 Selecting Ranges

Lecture 39 Ranged Data Entry

Lecture 40 Using AutoFill

Section 5: Creating Formulas

Lecture 41 Ranged Formula Syntax

Lecture 42 Simple Formula Syntax

Lecture 43 Writing Formulas

Lecture 44 Using AutoSum

Lecture 45 Inserting Functions

Lecture 46 Editing a Range

Lecture 47 Formula AutoCorrect

Lecture 48 AutoCalculate

Lecture 49 Function Compatibility

Section 6: Copying and Pasting Formulas

Lecture 50 Relative References and Absolute References

Lecture 51 Cutting, Copying, and Pasting Data

Lecture 52 AutoFilling Cells

Lecture 53 The Undo Button

Lecture 54 The Redo Button

Section 7: Columns and Rows

Lecture 55 Selecting Columns and Rows

Lecture 56 Adjusting Column Width and Row Height

Lecture 57 Hiding and Unhiding Columns and Rows

Lecture 58 Inserting and Deleting Columns and Rows

Section 8: Formatting Worksheets

Lecture 59 Formatting Cells

Lecture 60 The Format Cells Dialog Box

Lecture 61 Clearing All Formatting from Cells

Lecture 62 Copying All Formatting from Cells to Another Area

Section 9: Worksheet Tools

Lecture 63 Inserting and Deleting Worksheets

Lecture 64 Selecting Multiple Worksheets

Lecture 65 Navigating Worksheets

Lecture 66 Renaming Worksheets

Lecture 67 Coloring Worksheet Tabs

Lecture 68 Copying or Moving Worksheets

Section 10: Setting Worksheet Layout

Lecture 69 Using Page Break Preview

Lecture 70 Using the Page Layout View

Lecture 71 Opening the Page Setup Dialog Box

Lecture 72 Page Settings

Lecture 73 Setting Margins

Lecture 74 Creating Headers and Footers

Lecture 75 Sheet Settings

Section 11: Printing Worksheets

Lecture 76 Previewing and Printing Worksheets

Section 12: Helping Yourself

Lecture 77 Using Excel Help

Lecture 78 Microsoft Search in Excel

Lecture 79 Smart Lookup

Section 13: 3D Formulas

Lecture 80 Creating 3D Formulas

Lecture 81 3D Formula Syntax

Lecture 82 Creating 3D Range References

Section 14: Named Ranges

Lecture 83 Naming Ranges

Lecture 84 Creating Names from Headings

Lecture 85 Moving to a Named Range

Lecture 86 Using Named Ranges in Formulas

Lecture 87 Naming 3D Ranges

Lecture 88 Deleting Named Ranges

Section 15: Conditional Formatting and Cell Styles

Lecture 89 Conditional Formatting

Lecture 90 Finding Cells with Conditional Formatting

Lecture 91 Clearing Conditional Formatting

Lecture 92 Using Table and Cell Styles

Section 16: Paste Special

Lecture 93 Using Paste Special

Lecture 94 Pasting Links

Section 17: Sharing Workbooks

Lecture 95 About Co-authoring and Sharing Workbooks

Lecture 96 Co-authoring Workbooks

Lecture 97 Adding Shared Workbook Buttons in Excel

Lecture 98 Traditional Workbook Sharing

Lecture 99 Highlighting Changes

Lecture 100 Reviewing Changes

Lecture 101 Using Comments and Notes

Lecture 102 Compare and Merge Workbooks

Section 18: Auditing Worksheets

Lecture 103 Auditing Worksheets

Lecture 104 Tracing Precedent and Dependent Cells

Lecture 105 Tracing Errors

Lecture 106 Error Checking

Lecture 107 Using the Watch Window

Lecture 108 Cell Validation

Section 19: Outlining Worksheets

Lecture 109 Using Outlines

Lecture 110 Applying and Removing Outlines

Lecture 111 Applying Subtotals

Section 20: Consolidating Worksheets

Lecture 112 Consolidating Data

Section 21: Tables

Lecture 113 Creating a Table

Lecture 114 Adding and Editing Records

Lecture 115 Inserting Records and Fields

Lecture 116 Deleting Records and Fields

Section 22: Sorting Data

Lecture 117 Sorting Data

Lecture 118 Custom Sort Orders

Section 23: Filtering Data

Lecture 119 Using AutoFilters

Lecture 120 Using the Top 10 AutoFilter

Lecture 121 Applying a Custom AutoFilter

Lecture 122 Creating Advanced Filters

Lecture 123 Applying Multiple Criteria

Lecture 124 Using Complex Criteria

Lecture 125 Copying Filter Results to a New Location

Lecture 126 Using Database Functions

Section 24: What-If Analysis and Forecasts

Lecture 127 Using Data Tables

Lecture 128 Using Scenario Manager

Lecture 129 Using Goal Seek

Lecture 130 Forecast Sheets

Section 25: Table-Related Functions

Lecture 131 The Hlookup and Vlookup Functions

Lecture 132 Using the IF, AND, and OR Functions

Lecture 133 The IFS Function

Section 26: Sparklines

Lecture 134 Inserting and Deleting Sparklines

Lecture 135 Modifying Sparklines

Section 27: Creating Charts in Excel

Lecture 136 Creating Charts

Lecture 137 Selecting Charts and Chart Elements

Lecture 138 Adding Chart Elements

Lecture 139 Moving and Resizing Charts

Lecture 140 Changing the Chart Type

Lecture 141 Changing the Data Range

Lecture 142 Switching Column and Row Data

Lecture 143 Choosing a Chart Layout

Lecture 144 Choosing a Chart Style

Lecture 145 Changing Color Schemes

Lecture 146 Printing Charts

Lecture 147 Deleting Charts

Section 28: Formatting Charts in Excel

Lecture 148 Formatting Chart Objects

Lecture 149 Inserting Objects into a Chart

Lecture 150 Formatting Axes

Lecture 151 Formatting Axis Titles

Lecture 152 Formatting a Chart Title

Lecture 153 Formatting Data Labels

Lecture 154 Formatting a Data Table

Lecture 155 Formatting Error Bars

Lecture 156 Formatting Gridlines

Lecture 157 Formatting a Legend

Lecture 158 Formatting Drop and High-Low Lines

Lecture 159 Formatting Trendlines

Lecture 160 Formatting Up/Down Bars

Lecture 161 Formatting the Chart and Plot Areas

Lecture 162 Naming Charts

Lecture 163 Applying Shape Styles

Lecture 164 Applying WordArt Styles

Lecture 165 Saving Custom Chart Templates

Section 29: Data Models

Lecture 166 Creating a Data Model from External Relational Data

Lecture 167 Creating a Data Model from Excel Tables

Lecture 168 Enabling Legacy Data Connections

Lecture 169 Relating Tables in a Data Model

Lecture 170 Managing a Data Model

Section 30: PivotTables and PivotCharts

Lecture 171 Creating Recommended PivotTables

Lecture 172 Manually Creating a PivotTable

Lecture 173 Creating a PivotChart

Lecture 174 Manipulating a PivotTable or PivotChart

Lecture 175 Changing Calculated Value Fields

Lecture 176 Formatting PivotTables

Lecture 177 Formatting PivotCharts

Lecture 178 Setting PivotTable Options

Lecture 179 Sorting and Filtering Using Field Headers

Section 31: Power Pivot

Lecture 180 Starting Power Pivot

Lecture 181 Managing the Data Model

Lecture 182 Calculated Columns

Lecture 183 Measures

Lecture 184 Creating KPIs

Lecture 185 Creating and Managing Perspectives

Lecture 186 Power Pivot PivotTables and PivotCharts

Section 32: Maps

Lecture 187 Enabling 3D Maps

Lecture 188 Creating a New 3D Maps Tour

Lecture 189 Editing a 3D Maps Tour

Lecture 190 Managing Layers in a 3D Maps Tour

Lecture 191 Filtering Layers

Lecture 192 Setting Layer Options

Lecture 193 Managing Scenes

Lecture 194 Custom 3D Maps

Lecture 195 Custom Regions

Lecture 196 World Map Options

Lecture 197 Inserting 3D Map Objects

Lecture 198 Previewing a Scene

Lecture 199 Playing a 3D Maps Tour

Lecture 200 Creating a Video of a 3D Maps Tour

Lecture 201 3D Maps Options

Section 33: Slicers and Timelines

Lecture 202 Inserting and Deleting Slicers

Lecture 203 Modifying Slicers

Lecture 204 Inserting and Deleting Timelines

Lecture 205 Modifying Timelines

Section 34: Security Features

Lecture 206 Unlocking Cells

Lecture 207 Worksheet Protection

Lecture 208 Workbook Protection

Lecture 209 Password Protecting Excel Files

Section 35: Making Macros

Lecture 210 Recording Macros

Lecture 211 Running and Deleting Recorded Macros

Lecture 212 The Personal Macro Workbook

Section 36: Using Online Templates

Lecture 213 Downloading Online Templates

Lecture 214 Saving a Template

Lecture 215 Creating New Workbooks from Saved Templates

Section 37: Legal Templates

Lecture 216 Chapter Overview

Lecture 217 Using the Law Firm Financial Analysis Worksheet

Lecture 218 Using the Law Firm Project Tracker

Lecture 219 Using the Law Firm Project Plan

Section 38: Legal Business Functions

Lecture 220 The Pv Function

Lecture 221 The Fv Function

Lecture 222 The IRR and XIRR Functions

Section 39: Simple IOLTA Management

Lecture 223 IOLTA Basics

Lecture 224 Using Excel for Simple IOLTA Management

Lecture 225 Using the Simple IOLTA Template

Section 40: Course Conclusion and Instructon Manual in PDF

Lecture 226 Course Conclusion and Instructon Manual in PDF

Lawyers,Attorneys,Legal Office Professionals,Students new to Microsoft Excel,Office employees,Executives,Managers,Assistants,Accounting professionals