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