| 1 - Course Introduction.mp4 | 13.3 MB | ||
| 10 - The Formula Bar.mp4 | 5.2 MB | ||
| 100 - Reviewing Changes.mp4 | 5.7 MB | ||
| 101 - Using Comments and Notes.mp4 | 68.6 MB | ||
| 102 - Compare and Merge Workbooks.mp4 | 14.4 MB | ||
| 103 - Auditing Worksheets.mp4 | 3.6 MB | ||
| 104 - Tracing Precedent and Dependent Cells.mp4 | 9.5 MB | ||
| 105 - Tracing Errors.mp4 | 2.2 MB | ||
| 106 - Error Checking.mp4 | 25.5 MB | ||
| 107 - Using the Watch Window.mp4 | 4.8 MB | ||
| 108 - Cell Validation.mp4 | 53.5 MB | ||
| 109 - Using Outlines.mp4 | 5.9 MB | ||
| 11 - The Workbook Window.mp4 | 11.8 MB | ||
| 110 - Applying and Removing Outlines.mp4 | 8.3 MB | ||
| 111 - Applying Subtotals.mp4 | 27.1 MB | ||
| 112 - Consolidating Data.mp4 | 24.3 MB | ||
| 113 - Creating a Table.mp4 | 18.7 MB | ||
| 114 - Adding and Editing Records.mp4 | 6.2 MB | ||
| 115 - Inserting Records and Fields.mp4 | 3.8 MB | ||
| 116 - Deleting Records and Fields.mp4 | 2 MB | ||
| 117 - Sorting Data.mp4 | 23.8 MB | ||
| 118 - Custom Sort Orders.mp4 | 37.5 MB | ||
| 119 - Using AutoFilters.mp4 | 14.6 MB | ||
| 12 - The Status Bar.mp4 | 8.6 MB | ||
| 120 - Using the Top 10 AutoFilter.mp4 | 10.6 MB | ||
| 121 - Applying a Custom AutoFilter.mp4 | 18 MB | ||
| 122 - Creating Advanced Filters.mp4 | 35.3 MB | ||
| 123 - Applying Multiple Criteria.mp4 | 29.2 MB | ||
| 124 - Using Complex Criteria.mp4 | 28.4 MB | ||
| 125 - Copying Filter Results to a New Location.mp4 | 9 MB | ||
| 126 - Using Database Functions.mp4 | 29.2 MB | ||
| 127 - Using Data Tables.mp4 | 19.7 MB | ||
| 128 - Using Scenario Manager.mp4 | 26.9 MB | ||
| 129 - Using Goal Seek.mp4 | 7 MB | ||
| 13 - The Workbook View Buttons.mp4 | 4.4 MB | ||
| 130 - Forecast Sheets.mp4 | 22.9 MB | ||
| 131 - The Hlookup and Vlookup Functions.mp4 | 26.3 MB | ||
| 132 - Using the IF AND and OR Functions.mp4 | 32.5 MB | ||
| 133 - The IFS Function.mp4 | 13.6 MB | ||
| 134 - Inserting and Deleting Sparklines.mp4 | 19.1 MB | ||
| 135 - Modifying Sparklines.mp4 | 24.7 MB | ||
| 136 - Creating Charts.mp4 | 35.3 MB | ||
| 137 - Selecting Charts and Chart Elements.mp4 | 18.8 MB | ||
| 138 - Adding Chart Elements.mp4 | 10.3 MB | ||
| 139 - Moving and Resizing Charts.mp4 | 17.5 MB | ||
| 14 - The Zoom Slider.mp4 | 9 MB | ||
| 140 - Changing the Chart Type.mp4 | 5.2 MB | ||
| 141 - Changing the Data Range.mp4 | 45.9 MB | ||
| 142 - Switching Column and Row Data.mp4 | 2.5 MB | ||
| 143 - Choosing a Chart Layout.mp4 | 2.7 MB | ||
| 144 - Choosing a Chart Style.mp4 | 5.2 MB | ||
| 145 - Changing Color Schemes.mp4 | 3.2 MB | ||
| 146 - Printing Charts.mp4 | 8 MB | ||
| 147 - Deleting Charts.mp4 | 4.9 MB | ||
| 148 - Formatting Chart Objects.mp4 | 10.8 MB | ||
| 149 - Inserting Objects into a Chart.mp4 | 74.3 MB | ||
| 15 - The Mini Toolbar.mp4 | 1.3 MB | ||
| 150 - Formatting Axes.mp4 | 7.2 MB | ||
| 151 - Formatting Axis Titles.mp4 | 9.9 MB | ||
| 152 - Formatting a Chart Title.mp4 | 8.7 MB | ||
| 153 - Formatting Data Labels.mp4 | 12.1 MB | ||
| 154 - Formatting a Data Table.mp4 | 8.9 MB | ||
| 155 - Formatting Error Bars.mp4 | 5.9 MB | ||
| 156 - Formatting Gridlines.mp4 | 7.1 MB | ||
| 157 - Formatting a Legend.mp4 | 6 MB | ||
| 158 - Formatting Drop and HighLow Lines.mp4 | 8 MB | ||
| 159 - Formatting Trendlines.mp4 | 5.8 MB | ||
| 16 - Keyboard Shortcuts.mp4 | 7.8 MB | ||
| 160 - Formatting UpDown Bars.mp4 | 9.1 MB | ||
| 161 - Formatting the Chart and Plot Areas.mp4 | 7.4 MB | ||
| 162 - Naming Charts.mp4 | 2.5 MB | ||
| 163 - Applying Shape Styles.mp4 | 12.3 MB | ||
| 164 - Applying WordArt Styles.mp4 | 6 MB | ||
| 165 - Saving Custom Chart Templates.mp4 | 16.5 MB | ||
| 166 - Creating a Data Model from External Relational Data.mp4 | 42.6 MB | ||
| 167 - Creating a Data Model from Excel Tables.mp4 | 14.6 MB | ||
| 168 - Enabling Legacy Data Connections.mp4 | 7.5 MB | ||
| 169 - Relating Tables in a Data Model.mp4 | 33.5 MB | ||
| 17 - Creating New Workbooks.mp4 | 2.6 MB | ||
| 170 - Managing a Data Model.mp4 | 31.2 MB | ||
| 171 - Creating Recommended PivotTables.mp4 | 37.9 MB | ||
| 172 - Manually Creating a PivotTable.mp4 | 112.4 MB | ||
| 173 - Creating a PivotChart.mp4 | 45.7 MB | ||
| 174 - Manipulating a PivotTable or PivotChart.mp4 | 12.3 MB | ||
| 175 - Changing Calculated Value Fields.mp4 | 11.5 MB | ||
| 176 - Formatting PivotTables.mp4 | 10.3 MB | ||
| 177 - Formatting PivotCharts.mp4 | 3.3 MB | ||
| 178 - Setting PivotTable Options.mp4 | 10.4 MB | ||
| 179 - Sorting and Filtering Using Field Headers.mp4 | 17.7 MB | ||
| 18 - Saving Workbooks.mp4 | 19.9 MB | ||
| 180 - Starting Power Pivot.mp4 | 7.1 MB | ||
| 181 - Managing the Data Model.mp4 | 17.8 MB | ||
| 182 - Calculated Columns.mp4 | 28.3 MB | ||
| 183 - Measures.mp4 | 37.7 MB | ||
| 184 - Creating KPIs.mp4 | 16.4 MB | ||
| 185 - Creating and Managing Perspectives.mp4 | 12.8 MB | ||
| 186 - Power Pivot PivotTables and PivotCharts.mp4 | 6.2 MB | ||
| 187 - Enabling 3D Maps.mp4 | 8.1 MB | ||
| 188 - Creating a New 3D Maps Tour.mp4 | 64 MB | ||
| 189 - Editing a 3D Maps Tour.mp4 | 10.8 MB | ||
| 19 - Closing Workbooks.mp4 | 3.2 MB | ||
| 190 - Managing Layers in a 3D Maps Tour.mp4 | 10.3 MB | ||
| 191 - Filtering Layers.mp4 | 24 MB | ||
| 192 - Setting Layer Options.mp4 | 29 MB | ||
| 193 - Managing Scenes.mp4 | 25.1 MB | ||
| 194 - Custom 3D Maps.mp4 | 57.3 MB | ||
| 195 - Custom Regions.mp4 | 43 MB | ||
| 196 - World Map Options.mp4 | 7 MB | ||
| 197 - Inserting 3D Map Objects.mp4 | 17.4 MB | ||
| 198 - Previewing a Scene.mp4 | 28.7 MB | ||
| 199 - Playing a 3D Maps Tour.mp4 | 31.3 MB | ||
| 2 - About Excel.mp4 | 7.7 MB | ||
| 20 - Opening Workbooks.mp4 | 39.8 MB | ||
| 200 - Creating a Video of a 3D Maps Tour.mp4 | 5.6 MB | ||
| 201 - 3D Maps Options.mp4 | 5.3 MB | ||
| 202 - Inserting and Deleting Slicers.mp4 | 13.9 MB | ||
| 203 - Modifying Slicers.mp4 | 8.2 MB | ||
| 204 - Inserting and Deleting Timelines.mp4 | 12.3 MB | ||
| 205 - Modifying Timelines.mp4 | 8.7 MB | ||
| 206 - Unlocking Cells.mp4 | 18.8 MB | ||
| 207 - Worksheet Protection.mp4 | 15.3 MB | ||
| 208 - Workbook Protection.mp4 | 8.3 MB | ||
| 209 - Password Protecting Excel Files.mp4 | 9.7 MB | ||
| 21 - Recovering Unsaved Workbooks.mp4 | 4.1 MB | ||
| 210 - Recording Macros.mp4 | 15.9 MB | ||
| 211 - Running and Deleting Recorded Macros.mp4 | 3.8 MB | ||
| 212 - The Personal Macro Workbook.mp4 | 8.4 MB | ||
| 213 - Downloading Online Templates.mp4 | 9.6 MB | ||
| 214 - Saving a Template.mp4 | 6.4 MB | ||
| 215 - Creating New Workbooks from Saved Templates.mp4 | 6.8 MB | ||
| 216 - Chapter Overview.mp4 | 4.3 MB | ||
| 217 - Using the Law Firm Financial Analysis Worksheet.mp4 | 34.4 MB | ||
| 218 - Using the Law Firm Project Tracker.mp4 | 44.6 MB | ||
| 219 - Using the Law Firm Project Plan.mp4 | 18.3 MB | ||
| 22 - Opening a Workbook in a New Window.mp4 | 5.2 MB | ||
| 220 - The Pv Function.mp4 | 11.1 MB | ||
| 221 - The Fv Function.mp4 | 9.6 MB | ||
| 222 - The IRR and XIRR Functions.mp4 | 36 MB | ||
| 223 - IOLTA Basics.mp4 | 9.9 MB | ||
| 224 - Using Excel for Simple IOLTA Management.mp4 | 4.5 MB | ||
| 225 - Using the Simple IOLTA Template.mp4 | 12.9 MB | ||
| 226 - Course Conclusion and Instructon Manual in PDF.mp4 | 5.7 MB | ||
| 226 - Mastering-Excel-Made-Easy-for-Lawyers-Manual.pdf | 4.9 MB | ||
| 23 - Arranging Open Workbook Windows.mp4 | 17.3 MB | ||
| 24 - Freeze Panes.mp4 | 10.7 MB | ||
| 25 - Split Panes.mp4 | 15.9 MB | ||
| 26 - Hiding and Unhiding Workbook Windows.mp4 | 4.3 MB | ||
| 27 - Comparing Open Workbooks.mp4 | 9.2 MB | ||
| 28 - Switching Open Workbooks.mp4 | 2.2 MB | ||
| 29 - Switching to Full Screen Mode.mp4 | 7.3 MB | ||
| 3 - The Excel Environment.mp4 | 17 MB | ||
| 30 - Working with Excel File Formats.mp4 | 19 MB | ||
| 31 - AutoSave Online Workbooks.mp4 | 32.1 MB | ||
| 32 - Selecting Cells.mp4 | 6.2 MB | ||
| 33 - Entering Text into Cells.mp4 | 7.6 MB | ||
| 34 - Entering Numbers into Cells.mp4 | 9.3 MB | ||
| 35 - AutoComplete.mp4 | 3.1 MB | ||
| 36 - Pick from DropDown List.mp4 | 2.7 MB | ||
| 37 - Flash Fill.mp4 | 16.7 MB | ||
| 38 - Selecting Ranges.mp4 | 24.9 MB | ||
| 39 - Ranged Data Entry.mp4 | 2.9 MB | ||
| 4 - The Title Bar.mp4 | 9.1 MB | ||
| 40 - Using AutoFill.mp4 | 13.2 MB | ||
| 41 - Ranged Formula Syntax.mp4 | 3.9 MB | ||
| 42 - Simple Formula Syntax.mp4 | 2.3 MB | ||
| 43 - Writing Formulas.mp4 | 16.6 MB | ||
| 44 - Using AutoSum.mp4 | 10 MB | ||
| 45 - Inserting Functions.mp4 | 10.9 MB | ||
| 46 - Editing a Range.mp4 | 3.4 MB | ||
| 47 - Formula AutoCorrect.mp4 | 1.8 MB | ||
| 48 - AutoCalculate.mp4 | 4.5 MB | ||
| 49 - Function Compatibility.mp4 | 9.3 MB | ||
| 5 - The Ribbon.mp4 | 19.9 MB | ||
| 50 - Relative References and Absolute References.mp4 | 13.9 MB | ||
| 51 - Cutting Copying and Pasting Data.mp4 | 12 MB | ||
| 52 - AutoFilling Cells.mp4 | 2.4 MB | ||
| 53 - The Undo Button.mp4 | 2.9 MB | ||
| 54 - The Redo Button.mp4 | 2.1 MB | ||
| 55 - Selecting Columns and Rows.mp4 | 11.9 MB | ||
| 56 - Adjusting Column Width and Row Height.mp4 | 27.2 MB | ||
| 57 - Hiding and Unhiding Columns and Rows.mp4 | 5.1 MB | ||
| 58 - Inserting and Deleting Columns and Rows.mp4 | 22.3 MB | ||
| 59 - Formatting Cells.mp4 | 13.2 MB | ||
| 6 - The File Tab and Backstage View.mp4 | 10.7 MB | ||
| 60 - 7.2.mp4 | 11.6 MB | ||
| 60 - The Format Cells Dialog Box.mp4 | 25.6 MB | ||
| 61 - Clearing All Formatting from Cells.mp4 | 1.6 MB | ||
| 62 - Copying All Formatting from Cells to Another Area.mp4 | 4.4 MB | ||
| 63 - Inserting and Deleting Worksheets.mp4 | 5.3 MB | ||
| 64 - Selecting Multiple Worksheets.mp4 | 3.6 MB | ||
| 65 - Navigating Worksheets.mp4 | 5 MB | ||
| 66 - Renaming Worksheets.mp4 | 2.9 MB | ||
| 67 - Coloring Worksheet Tabs.mp4 | 5.6 MB | ||
| 68 - Copying or Moving Worksheets.mp4 | 7 MB | ||
| 69 - Using Page Break Preview.mp4 | 7.6 MB | ||
| 7 - Scroll Bars.mp4 | 2.2 MB | ||
| 70 - Using the Page Layout View.mp4 | 3.1 MB | ||
| 71 - Opening the Page Setup Dialog Box.mp4 | 2.3 MB | ||
| 72 - Page Settings.mp4 | 6.4 MB | ||
| 73 - Setting Margins.mp4 | 3.4 MB | ||
| 74 - Creating Headers and Footers.mp4 | 15.8 MB | ||
| 75 - Sheet Settings.mp4 | 10.9 MB | ||
| 76 - Previewing and Printing Worksheets.mp4 | 13.1 MB | ||
| 77 - Using Excel Help.mp4 | 6.3 MB | ||
| 78 - Microsoft Search in Excel.mp4 | 24.1 MB | ||
| 79 - Smart Lookup.mp4 | 7.6 MB | ||
| 8 - The Quick Access Toolbar.mp4 | 17.4 MB | ||
| 80 - Creating 3D Formulas.mp4 | 4.6 MB | ||
| 81 - 3D Formula Syntax.mp4 | 2 MB | ||
| 82 - Creating 3D Range References.mp4 | 3.5 MB | ||
| 83 - Naming Ranges.mp4 | 15.1 MB | ||
| 84 - Creating Names from Headings.mp4 | 3.9 MB | ||
| 85 - Moving to a Named Range.mp4 | 1.8 MB | ||
| 86 - Using Named Ranges in Formulas.mp4 | 7.1 MB | ||
| 87 - Naming 3D Ranges.mp4 | 8.6 MB | ||
| 88 - Deleting Named Ranges.mp4 | 2.7 MB | ||
| 89 - Conditional Formatting.mp4 | 21.4 MB | ||
| 9 - Touch Mode.mp4 | 7 MB | ||
| 90 - Finding Cells with Conditional Formatting.mp4 | 2.9 MB | ||
| 91 - Clearing Conditional Formatting.mp4 | 3.4 MB | ||
| 92 - Using Table and Cell Styles.mp4 | 7.3 MB | ||
| 93 - Using Paste Special.mp4 | 28.2 MB | ||
| 94 - Pasting Links.mp4 | 13.5 MB | ||
| 95 - About Coauthoring and Sharing Workbooks.mp4 | 10.9 MB | ||
| 96 - Coauthoring Workbooks.mp4 | 54.7 MB | ||
| 97 - Adding Shared Workbook Buttons in Excel.mp4 | 39.7 MB | ||
| 98 - Traditional Workbook Sharing.mp4 | 19 MB | ||
| 99 - Highlighting Changes.mp4 | 17.9 MB | ||
| Bonus Resources.txt | 409.6 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| ▲ 230 total files | |||
Excel For Microsoft 365 For Lawyers Made Easy Training
https://DevCourseWeb.com
Published 4/2024
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 3.29 GB | Duration: 9h 31m
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)
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 2.7 GB | freecoursewb | 3 weeks | 12 | 1 | |
| 2.7 GB | freecoursewb | 3 weeks | 18 | 1 | |
|
Udemy - Microsoft Power BI for Excel Users - Turn Data into Insights Posted by
freecoursewb in Other
|
2.6 GB | freecoursewb | 1 month | 9 | 5 |
|
Udemy - Microsoft Excel - The Smart Path to Advanced Nested Functions Posted by
freecoursewb in Other
|
1.9 GB | freecoursewb | 1 month | 6 | 1 |
| 3.8 GB | freecoursewb | 1 month | 19 | 5 |
All Comments