|
|
001 Creating a PivotTable.mp4
|
MP4
|
134.6 MB
|
|
|
001 Creating a PivotTable_en.srt
|
SRT
|
19.2 KB
|
|
|
001 Filtering Data, Part 1.mp4
|
MP4
|
80 MB
|
|
|
001 Filtering Data, Part 1_en.srt
|
SRT
|
11.7 KB
|
|
|
001 Inserting Graphics.mp4
|
MP4
|
89.1 MB
|
|
|
001 Inserting Graphics_en.srt
|
SRT
|
13.6 KB
|
|
|
001 Using Advanced Chart Features.mp4
|
MP4
|
57.2 MB
|
|
|
001 Using Advanced Chart Features_en.srt
|
SRT
|
6.7 KB
|
|
|
001 Using Autofill.mp4
|
MP4
|
80.4 MB
|
|
|
001 Using Autofill_en.srt
|
SRT
|
12.7 KB
|
|
|
002 Applying Trendlines.mp4
|
MP4
|
51.2 MB
|
|
|
002 Applying Trendlines_en.srt
|
SRT
|
7.2 KB
|
|
|
002 Copying Formulas and Functions.mp4
|
MP4
|
90.6 MB
|
|
|
002 Copying Formulas and Functions_en.srt
|
SRT
|
12.8 KB
|
|
|
002 Filtering Data, Part 2.mp4
|
MP4
|
91.8 MB
|
|
|
002 Filtering Data, Part 2_en.srt
|
SRT
|
12.4 KB
|
|
|
002 Modifying Graphics, Part 1.mp4
|
MP4
|
44.2 MB
|
|
|
002 Modifying Graphics, Part 1_en.srt
|
SRT
|
9.1 KB
|
|
|
002 Summarizing Data in a PivotTable.mp4
|
MP4
|
94 MB
|
|
|
002 Summarizing Data in a PivotTable_en.srt
|
SRT
|
12.9 KB
|
|
|
003 Creating a Chart Template.mp4
|
MP4
|
42.5 MB
|
|
|
003 Creating a Chart Template_en.srt
|
SRT
|
5.5 KB
|
|
|
003 Grouping Data in a PivtotTable.mp4
|
MP4
|
68.3 MB
|
|
|
003 Grouping Data in a PivtotTable_en.srt
|
SRT
|
9.8 KB
|
|
|
003 Modifying Graphics, Part 2.mp4
|
MP4
|
50.6 MB
|
|
|
003 Modifying Graphics, Part 2_en.srt
|
SRT
|
10 KB
|
|
|
003 Querying with Database Functions.mp4
|
MP4
|
98.6 MB
|
|
|
003 Querying with Database Functions_en.srt
|
SRT
|
11.6 KB
|
|
|
003 Using Named Ranges, Part 1.mp4
|
MP4
|
67.7 MB
|
|
|
003 Using Named Ranges, Part 1_en.srt
|
SRT
|
8.7 KB
|
|
|
004 Formatting a PivotTable.mp4
|
MP4
|
118.6 MB
|
|
|
004 Formatting a PivotTable_en.srt
|
SRT
|
11.8 KB
|
|
|
004 Using Named Ranges, Part 2.mp4
|
MP4
|
55.7 MB
|
|
|
004 Using Named Ranges, Part 2_en.srt
|
SRT
|
9.4 KB
|
|
|
004 Using the Subtotal Function.mp4
|
MP4
|
56.7 MB
|
|
|
004 Using the Subtotal Function_en.srt
|
SRT
|
7.4 KB
|
|
|
005 Selecting and Moving PivotTables.mp4
|
MP4
|
43.9 MB
|
|
|
005 Selecting and Moving PivotTables_en.srt
|
SRT
|
5.1 KB
|
|
|
005 Using Named Ranges, Part 3.mp4
|
MP4
|
50.1 MB
|
|
|
005 Using Named Ranges, Part 3_en.srt
|
SRT
|
8 KB
|
|
|
005 Using the Subtotal Feature.mp4
|
MP4
|
73.6 MB
|
|
|
005 Using the Subtotal Feature_en.srt
|
SRT
|
10.8 KB
|
|
|
006 Changing PivotTables Options.mp4
|
MP4
|
127.9 MB
|
|
|
006 Changing PivotTables Options_en.srt
|
SRT
|
14 KB
|
|
|
006 Working with Date Functions, Part 1.mp4
|
MP4
|
125.5 MB
|
|
|
006 Working with Date Functions, Part 1_en.srt
|
SRT
|
15.1 KB
|
|
|
007 Adding Calculated Fields.mp4
|
MP4
|
24 MB
|
|
|
007 Adding Calculated Fields_en.srt
|
SRT
|
3.1 KB
|
|
|
007 Working with Date Functions, Part 2.mp4
|
MP4
|
54.5 MB
|
|
|
007 Working with Date Functions, Part 2_en.srt
|
SRT
|
6.5 KB
|
|
|
008 Using Slicers.mp4
|
MP4
|
88.7 MB
|
|
|
008 Using Slicers_en.srt
|
SRT
|
11.9 KB
|
|
|
008 Working with Date Functions, Part 3.mp4
|
MP4
|
57.3 MB
|
|
|
008 Working with Date Functions, Part 3_en.srt
|
SRT
|
5.5 KB
|
|
|
009 Using Timeline Slicers.mp4
|
MP4
|
23.8 MB
|
|
|
009 Using Timeline Slicers_en.srt
|
SRT
|
2.6 KB
|
|
|
009 Working with Time Functions.mp4
|
MP4
|
59.1 MB
|
|
|
009 Working with Time Functions_en.srt
|
SRT
|
8.7 KB
|
|
|
010 Creating Internal Links.mp4
|
MP4
|
72.1 MB
|
|
|
010 Creating Internal Links_en.srt
|
SRT
|
6.5 KB
|
|
|
010 Working with Conditional Functions.mp4
|
MP4
|
100.5 MB
|
|
|
010 Working with Conditional Functions_en.srt
|
SRT
|
12.3 KB
|
|
|
011 Creating External Links.mp4
|
MP4
|
94.7 MB
|
|
|
011 Creating External Links_en.srt
|
SRT
|
14.6 KB
|
|
|
011 Multiple Criteria Functions.mp4
|
MP4
|
55.1 MB
|
|
|
011 Multiple Criteria Functions_en.srt
|
SRT
|
7.6 KB
|
|
|
012 Using Paste Special.mp4
|
MP4
|
83.5 MB
|
|
|
012 Using Paste Special_en.srt
|
SRT
|
9.5 KB
|
|
|
013 Consolidating Data.mp4
|
MP4
|
94.3 MB
|
|
|
013 Consolidating Data_en.srt
|
SRT
|
11.1 KB
|
|
|
014 Co-Authoring, Part 1.mp4
|
MP4
|
73.8 MB
|
|
|
014 Co-Authoring, Part 1_en.srt
|
SRT
|
10.6 KB
|
|
|
015 Co-Authoring, Part 2.mp4
|
MP4
|
53.7 MB
|
|
|
015 Co-Authoring, Part 2_en.srt
|
SRT
|
7.3 KB
|
|
|
016 Using Compare and Merge.mp4
|
MP4
|
44.8 MB
|
|
|
016 Using Compare and Merge_en.srt
|
SRT
|
4.8 KB
|
|
|
017 Adding Digital Signatures.mp4
|
MP4
|
63.1 MB
|
|
|
017 Adding Digital Signatures_en.srt
|
SRT
|
9.3 KB
|
|
|
018 Protecting Worksheets.mp4
|
MP4
|
110.7 MB
|
|
|
018 Protecting Worksheets_en.srt
|
SRT
|
17.5 KB
|
|
|
019 Protecting a Workbook Structure.mp4
|
MP4
|
47.4 MB
|
|
|
019 Protecting a Workbook Structure_en.srt
|
SRT
|
5 KB
|
|
|
020 Protecting a Workbook File.mp4
|
MP4
|
80.3 MB
|
|
|
020 Protecting a Workbook File_en.srt
|
SRT
|
11.9 KB
|
|
|
021 Applying a Data Validation.mp4
|
MP4
|
118.4 MB
|
|
|
021 Applying a Data Validation_en.srt
|
SRT
|
12.3 KB
|
|
|
022 Adding a Dropdown List.mp4
|
MP4
|
61.3 MB
|
|
|
022 Adding a Dropdown List_en.srt
|
SRT
|
7.2 KB
|
|
|
023 Customizing Data Validation.mp4
|
MP4
|
56.9 MB
|
|
|
023 Customizing Data Validation_en.srt
|
SRT
|
8.9 KB
|
|
|
024 Recording a Macro.mp4
|
MP4
|
88.6 MB
|
|
|
024 Recording a Macro_en.srt
|
SRT
|
13 KB
|
|
|
025 Running a Macro.mp4
|
MP4
|
61.4 MB
|
|
|
025 Running a Macro_en.srt
|
SRT
|
8.7 KB
|
|
|
026 Editing a Macro.mp4
|
MP4
|
92.3 MB
|
|
|
026 Editing a Macro_en.srt
|
SRT
|
13.2 KB
|
|
|
027 Using VLOOKUP, Part 1.mp4
|
MP4
|
75.9 MB
|
|
|
027 Using VLOOKUP, Part 1_en.srt
|
SRT
|
10.1 KB
|
|
|
028 Using VLOOKUP, Part 2.mp4
|
MP4
|
61.2 MB
|
|
|
028 Using VLOOKUP, Part 2_en.srt
|
SRT
|
8.9 KB
|
|
|
029 More Lookup Functions.mp4
|
MP4
|
141.2 MB
|
|
|
029 More Lookup Functions_en.srt
|
SRT
|
15.7 KB
|
|
|
030 Using Array Formulas.mp4
|
MP4
|
91.1 MB
|
|
|
030 Using Array Formulas_en.srt
|
SRT
|
9.8 KB
|
|
|
031 Using Goal Seek.mp4
|
MP4
|
36.1 MB
|
|
|
031 Using Goal Seek_en.srt
|
SRT
|
5.6 KB
|
|
|
032 Inserting Symbols and Characters.mp4
|
MP4
|
30.9 MB
|
|
|
032 Inserting Symbols and Characters_en.srt
|
SRT
|
4 KB
|
|
|
033 Working with Forms.mp4
|
MP4
|
98.7 MB
|
|
|
033 Working with Forms_en.srt
|
SRT
|
16.3 KB
|
|
|
Bonus Resources.txt
|
TXT
|
409.6 B
|
|
|
Get Bonus Downloads Here.url
|
URL
|
204.8 B
|
