Excel For Microsoft 365 For Lawyers Made Easy Training

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

Homepage

https://www.udemy.com/course/excel-for-microsoft-365-for-lawyers-made-easy-training/