|
|
0
|
|
0 B
|
|
|
1. Course Close.mp4
|
MP4
|
13.7 MB
|
|
|
1. Course Close.srt
|
SRT
|
2.2 KB
|
|
|
1. Course Introduction.mp4
|
MP4
|
67.7 MB
|
|
|
1. Course Introduction.srt
|
SRT
|
8.8 KB
|
|
|
1. Creating Dynamic Drop-down Lists.mp4
|
MP4
|
53.8 MB
|
|
|
1. Creating Dynamic Drop-down Lists.srt
|
SRT
|
10.3 KB
|
|
|
1. Creating a Pivot Chart.mp4
|
MP4
|
45.4 MB
|
|
|
1. Creating a Pivot Chart.srt
|
SRT
|
7.1 KB
|
|
|
1. Goal Seek and the PMT Function.mp4
|
MP4
|
30.4 MB
|
|
|
1. Goal Seek and the PMT Function.srt
|
SRT
|
7.3 KB
|
|
|
1. Importing Data into Excel.mp4
|
MP4
|
79.6 MB
|
|
|
1. Importing Data into Excel.srt
|
SRT
|
13.8 KB
|
|
|
1. Inserting and Formatting Slicers.mp4
|
MP4
|
50.7 MB
|
|
|
1. Inserting and Formatting Slicers.srt
|
SRT
|
10.7 KB
|
|
|
1. Logical Functions (AND, OR, IF).mp4
|
MP4
|
84.6 MB
|
|
|
1. Logical Functions (AND, OR, IF).srt
|
SRT
|
17.3 KB
|
|
|
1. Looking Up Information using VLOOKUP (Exact Match).mp4
|
MP4
|
80.8 MB
|
|
|
1. Looking Up Information using VLOOKUP (Exact Match).srt
|
SRT
|
14.5 KB
|
|
|
1. Performing Sorts on Multiple Columns.mp4
|
MP4
|
66.5 MB
|
|
|
1. Performing Sorts on Multiple Columns.srt
|
SRT
|
9.9 KB
|
|
|
1. PivotTables Explained.mp4
|
MP4
|
24.5 MB
|
|
|
1. PivotTables Explained.srt
|
SRT
|
2.9 KB
|
|
|
1. The Golden Rules of Spreadsheet Design.mp4
|
MP4
|
119.5 MB
|
|
|
1. The Golden Rules of Spreadsheet Design.srt
|
SRT
|
17.4 KB
|
|
|
1. Troubleshooting Common Errors.mp4
|
MP4
|
44.3 MB
|
|
|
1. Troubleshooting Common Errors.srt
|
SRT
|
11.5 KB
|
|
|
1. Understanding How Dates are Stored in Excel.mp4
|
MP4
|
32.8 MB
|
|
|
1. Understanding How Dates are Stored in Excel.srt
|
SRT
|
5.9 KB
|
|
|
1. What is a Dashboard.mp4
|
MP4
|
39.5 MB
|
|
|
1
|
|
162.8 KB
|
|
|
1. What is a Dashboard.srt
|
SRT
|
7.7 KB
|
|
|
2
|
|
734 KB
|
|
|
10. Applying PivotTable Styles.mp4
|
MP4
|
53.3 MB
|
|
|
10. Applying PivotTable Styles.srt
|
SRT
|
6.6 KB
|
|
|
10. Section Quiz.html
|
HTML
|
204.8 B
|
|
|
11. Exercise 06.mp4
|
MP4
|
52.4 MB
|
|
|
11. Exercise 06.srt
|
SRT
|
5 KB
|
|
|
12. Section Quiz.html
|
HTML
|
204.8 B
|
|
|
2. Applying Custom Date Formats.mp4
|
MP4
|
60.3 MB
|
|
|
2. Applying Custom Date Formats.srt
|
SRT
|
9.9 KB
|
|
|
2. Assembling a Dashboard - Part 1.mp4
|
MP4
|
90.7 MB
|
|
|
2. Assembling a Dashboard - Part 1.srt
|
SRT
|
14.9 KB
|
|
|
2. Creating a PivotTable from Scratch.mp4
|
MP4
|
65.4 MB
|
|
|
2. Creating a PivotTable from Scratch.srt
|
SRT
|
7.2 KB
|
|
|
2. Formatting a Pivot Chart - Part 1.mp4
|
MP4
|
55 MB
|
|
|
2. Formatting a Pivot Chart - Part 1.srt
|
SRT
|
12.3 KB
|
|
|
2. Improving Readability with Cell Styles.mp4
|
MP4
|
55.1 MB
|
|
|
2. Improving Readability with Cell Styles.srt
|
SRT
|
7 KB
|
|
|
2. Inserting Timeline Slicers.mp4
|
MP4
|
34.2 MB
|
|
|
2. Inserting Timeline Slicers.srt
|
SRT
|
7.1 KB
|
|
|
2. Looking Up Information using VLOOKUP (Approx Match).mp4
|
MP4
|
29.3 MB
|
|
|
2. Looking Up Information using VLOOKUP (Approx Match).srt
|
SRT
|
5.7 KB
|
|
|
2. Other Types of Data Validation.mp4
|
MP4
|
41.8 MB
|
|
|
2. Other Types of Data Validation.srt
|
SRT
|
9.1 KB
|
|
|
2. Removing Blank Rows, Cells and Duplicates.mp4
|
MP4
|
70.3 MB
|
|
|
2. Removing Blank Rows, Cells and Duplicates.srt
|
SRT
|
6.9 KB
|
|
|
2. Sorting Using a Custom List.mp4
|
MP4
|
36.8 MB
|
|
|
2. Sorting Using a Custom List.srt
|
SRT
|
4.5 KB
|
|
|
2. The IF Function.mp4
|
MP4
|
50.7 MB
|
|
|
2. The IF Function.srt
|
SRT
|
6.8 KB
|
|
|
2. Tracing Precedents and Formula Auditing.mp4
|
MP4
|
55.3 MB
|
|
|
2. Tracing Precedents and Formula Auditing.srt
|
SRT
|
11.2 KB
|
|
|
2. Using Scenario Manager.mp4
|
MP4
|
47.4 MB
|
|
|
2. Using Scenario Manager.srt
|
SRT
|
9.9 KB
|
|
|
2. WATCH ME Essential Information for a Successful Training Experience.mp4
|
MP4
|
38 MB
|
|
|
2. WATCH ME Essential Information for a Successful Training Experience.srt
|
SRT
|
2 KB
|
|
|
3. Assembling a Dashboard - Part 2.mp4
|
MP4
|
78.7 MB
|
|
|
3
|
|
615.3 KB
|
|
|
3. Assembling a Dashboard - Part 2.srt
|
SRT
|
13.6 KB
|
|
|
3. Changing Case and Removing Spaces.mp4
|
MP4
|
124.6 MB
|
|
|
3. Changing Case and Removing Spaces.srt
|
SRT
|
12.2 KB
|
|
|
3. Connecting Slicers to Pivot Charts.mp4
|
MP4
|
34.6 MB
|
|
|
3. Connecting Slicers to Pivot Charts.srt
|
SRT
|
6.8 KB
|
|
|
3. Controlling Data Input.mp4
|
MP4
|
77.6 MB
|
|
|
3. Controlling Data Input.srt
|
SRT
|
11.5 KB
|
|
|
3. Custom Data Validation.mp4
|
MP4
|
53.7 MB
|
|
|
3. Custom Data Validation.srt
|
SRT
|
13.9 KB
|
|
|
3. DOWNLOAD ME Course Exercise Files.html
|
HTML
|
921.6 B
|
|
|
3. Data Tables One Variable.mp4
|
MP4
|
27.8 MB
|
|
|
3. Data Tables One Variable.srt
|
SRT
|
6.1 KB
|
|
|
3. Exercise 10.mp4
|
MP4
|
52.8 MB
|
|
|
3. Exercise 10.srt
|
SRT
|
10.4 KB
|
|
|
3. Formatting a Pivot Chart - Part 2.mp4
|
MP4
|
59.7 MB
|
|
|
3. Formatting a Pivot Chart - Part 2.srt
|
SRT
|
13.3 KB
|
|
|
3. Looking Up Information Horizontally Using HLOOKUP.mp4
|
MP4
|
47 MB
|
|
|
3. Looking Up Information Horizontally Using HLOOKUP.srt
|
SRT
|
7.8 KB
|
|
|
3. Nested IFs.mp4
|
MP4
|
71.4 MB
|
|
|
3. Nested IFs.srt
|
SRT
|
10.4 KB
|
|
|
3. Pivoting the PivotTable Fields.mp4
|
MP4
|
35.4 MB
|
|
|
3. Pivoting the PivotTable Fields.srt
|
SRT
|
7.7 KB
|
|
|
3. The SORT and SORTBY Functions.mp4
|
MP4
|
94.4 MB
|
|
|
3. The SORT and SORTBY Functions.srt
|
SRT
|
13.9 KB
|
|
|
3. Using Date and Time Functions.mp4
|
MP4
|
82.7 MB
|
|
|
3. Using Date and Time Functions.srt
|
SRT
|
11.2 KB
|
|
|
3.1 Excel 2021 Intermediate Exercise Files.zip
|
ZIP
|
13.2 MB
|
|
|
4. Adding Navigation Buttons.mp4
|
MP4
|
103.3 MB
|
|
|
4. Adding Navigation Buttons.srt
|
SRT
|
12.2 KB
|
|
|
4. Applying Subtotals and Grand Totals.mp4
|
MP4
|
29.8 MB
|
|
|
4
|
|
347.4 KB
|
|
|
4. Applying Subtotals and Grand Totals.srt
|
SRT
|
4.4 KB
|
|
|
4. Assembling a Dashboard - Part 3.mp4
|
MP4
|
69.6 MB
|
|
|
4. Assembling a Dashboard - Part 3.srt
|
SRT
|
11.9 KB
|
|
|
4. DOWNLOAD ME Course Instructor Files.html
|
HTML
|
921.6 B
|
|
|
4. Data Tables Two Variables.mp4
|
MP4
|
27.9 MB
|
|
|
4. Data Tables Two Variables.srt
|
SRT
|
5.3 KB
|
|
|
4. Exercise 11.mp4
|
MP4
|
41.4 MB
|
|
|
4. Exercise 11.srt
|
SRT
|
8.5 KB
|
|
|
4. Performing Flexible Lookups With INDEX And MATCH.mp4
|
MP4
|
80.4 MB
|
|
|
4. Performing Flexible Lookups With INDEX And MATCH.srt
|
SRT
|
14.7 KB
|
|
|
4. Section Quiz.html
|
HTML
|
204.8 B
|
|
|
4. Splitting Data using Text to Columns.mp4
|
MP4
|
71.8 MB
|
|
|
4. Splitting Data using Text to Columns.srt
|
SRT
|
9.7 KB
|
|
|
4. The IFS Function.mp4
|
MP4
|
40.8 MB
|
|
|
4. The IFS Function.srt
|
SRT
|
8 KB
|
|
|
4. Updating PivotTable Data.mp4
|
MP4
|
54.9 MB
|
|
|
4. Updating PivotTable Data.srt
|
SRT
|
5.5 KB
|
|
|
4. Using Map Charts.mp4
|
MP4
|
37.3 MB
|
|
|
4. Using Map Charts.srt
|
SRT
|
7.7 KB
|
|
|
4. Using the Advanced Filter.mp4
|
MP4
|
60.8 MB
|
|
|
4. Using the Advanced Filter.srt
|
SRT
|
9.4 KB
|
|
|
4. Using the WORKDAY and WORKDAY.INT Functions.mp4
|
MP4
|
37.3 MB
|
|
|
4. Using the WORKDAY and WORKDAY.INT Functions.srt
|
SRT
|
5 KB
|
|
|
4.1 Excel 2021 Intermediate Course Files.zip
|
ZIP
|
39.9 MB
|
|
|
5. Applying Number Formatting to PivotTable Data.mp4
|
MP4
|
28.5 MB
|
|
|
5. Applying Number Formatting to PivotTable Data.srt
|
SRT
|
3.8 KB
|
|
|
5. Conditional IFs (SUMIF, COUNTIF, AVERAGEIF).mp4
|
MP4
|
56.8 MB
|
|
|
5. Conditional IFs (SUMIF, COUNTIF, AVERAGEIF).srt
|
SRT
|
8.8 KB
|
|
|
5. Exercise 07.mp4
|
MP4
|
32.6 MB
|
|
|
5. Exercise 07.srt
|
SRT
|
5.8 KB
|
|
|
5. Exercise 08.mp4
|
MP4
|
61.1 MB
|
|
|
5. Exercise 08.srt
|
SRT
|
9 KB
|
|
|
5. Exercise 09.mp4
|
MP4
|
34.5 MB
|
|
|
5. Exercise 09.srt
|
SRT
|
3.2 KB
|
|
|
5. Exercise 12.mp4
|
MP4
|
61.1 MB
|
|
|
5. Exercise 12.srt
|
SRT
|
10.9 KB
|
|
|
5. Extracting Unique Values - The UNIQUE Function.mp4
|
MP4
|
46.1 MB
|
|
|
5. Extracting Unique Values - The UNIQUE Function.srt
|
SRT
|
6.6 KB
|
|
|
5
|
|
419.4 KB
|
|
|
5. Section Quiz.html
|
HTML
|
204.8 B
|
|
|
5. Splitting Data using Text Functions.mp4
|
MP4
|
57.6 MB
|
|
|
5. Splitting Data using Text Functions.srt
|
SRT
|
11.4 KB
|
|
|
5. Using XLOOKUP and XMATCH.mp4
|
MP4
|
75 MB
|
|
|
5. Using XLOOKUP and XMATCH.srt
|
SRT
|
14.1 KB
|
|
|
5. Using the NETWORKDAYS and NETWORKDAYS.INT Function.mp4
|
MP4
|
31.4 MB
|
|
|
5. Using the NETWORKDAYS and NETWORKDAYS.INT Function.srt
|
SRT
|
3.9 KB
|
|
|
6. Multiple Criteria (SUMIFS, COUNTIFS, AVERAGEIFS).mp4
|
MP4
|
63 MB
|
|
|
6
|
|
331.2 KB
|
|
|
6. Multiple Criteria (SUMIFS, COUNTIFS, AVERAGEIFS).srt
|
SRT
|
9 KB
|
|
|
6. Section Quiz.html
|
HTML
|
204.8 B
|
|
|
6. Show Values As and Summarize Values By.mp4
|
MP4
|
47.1 MB
|
|
|
6. Show Values As and Summarize Values By.srt
|
SRT
|
8.4 KB
|
|
|
6. Splitting or Combining Cell Data Using Flash fill.mp4
|
MP4
|
46.7 MB
|
|
|
6. Splitting or Combining Cell Data Using Flash fill.srt
|
SRT
|
7.2 KB
|
|
|
6. Tabulate Date Differences with the DATEDIF Function.mp4
|
MP4
|
59.3 MB
|
|
|
6. Tabulate Date Differences with the DATEDIF Function.srt
|
SRT
|
8.6 KB
|
|
|
6. The FILTER Function.mp4
|
MP4
|
76.6 MB
|
|
|
6. The FILTER Function.srt
|
SRT
|
12 KB
|
|
|
6. The OFFSET Function.mp4
|
MP4
|
67.6 MB
|
|
|
6. The OFFSET Function.srt
|
SRT
|
13.8 KB
|
|
|
7
|
|
191.8 KB
|
|
|
7. Calculate Dates with EDATE and EOMONTH.mp4
|
MP4
|
59.3 MB
|
|
|
7. Calculate Dates with EDATE and EOMONTH.srt
|
SRT
|
10.2 KB
|
|
|
7. Error Handling with IFERROR and IFNA.mp4
|
MP4
|
58.3 MB
|
|
|
7. Error Handling with IFERROR and IFNA.srt
|
SRT
|
7.9 KB
|
|
|
7. Exercise 03.mp4
|
MP4
|
53.5 MB
|
|
|
7. Exercise 03.srt
|
SRT
|
7.1 KB
|
|
|
7. Grouping PivotTable Data.mp4
|
MP4
|
54.7 MB
|
|
|
7. Grouping PivotTable Data.srt
|
SRT
|
7.6 KB
|
|
|
7. Joining Data using CONCAT.mp4
|
MP4
|
67.1 MB
|
|
|
7. Joining Data using CONCAT.srt
|
SRT
|
9.8 KB
|
|
|
7. The INDIRECT Function.mp4
|
MP4
|
74.8 MB
|
|
|
7. The INDIRECT Function.srt
|
SRT
|
12.1 KB
|
|
|
8. Exercise 01.mp4
|
MP4
|
71.3 MB
|
|
|
8. Exercise 01.srt
|
SRT
|
9.3 KB
|
|
|
8. Exercise 02.mp4
|
MP4
|
52.9 MB
|
|
|
8. Exercise 02.srt
|
SRT
|
6.4 KB
|
|
|
8. Exercise 04.mp4
|
MP4
|
32.3 MB
|
|
|
8. Exercise 04.srt
|
SRT
|
5.8 KB
|
|
|
8
|
|
590.1 KB
|
|
|
8. Formatting Data as a Table.mp4
|
MP4
|
78.2 MB
|
|
|
8. Formatting Data as a Table.srt
|
SRT
|
12.5 KB
|
|
|
8. Formatting Error Values and Empty Cells.mp4
|
MP4
|
54.2 MB
|
|
|
8. Formatting Error Values and Empty Cells.srt
|
SRT
|
7.2 KB
|
|
|
8. Section Quiz.html
|
HTML
|
204.8 B
|
|
|
9. Choosing a Report Layout.mp4
|
MP4
|
45 MB
|
|
|
9
|
|
426 KB
|
|
|
9. Choosing a Report Layout.srt
|
SRT
|
6.1 KB
|
|
|
9. Exercise 05.mp4
|
MP4
|
71 MB
|
|
|
9. Exercise 05.srt
|
SRT
|
6.9 KB
|
|
|
9. Section Quiz.html
|
HTML
|
204.8 B
|
|
|
TutsNode.com.txt
|
TXT
|
102.4 B
|
|
|
[TGx]Downloaded from torrentgalaxy.to .txt
|
TXT
|
614.4 B
|
|
|
10
|
|
323.6 KB
|
|
|
11
|
|
820.5 KB
|
|
|
12
|
|
431.5 KB
|
|
|
13
|
|
419 KB
|
|
|
14
|
|
7.3 KB
|
|
|
15
|
|
191.4 KB
|
|
|
16
|
|
165.7 KB
|
|
|
17
|
|
610.1 KB
|
|
|
18
|
|
699.5 KB
|
|
|
19
|
|
12.4 KB
|
|
|
20
|
|
759.3 KB
|
|
|
21
|
|
453.8 KB
|
|
|
22
|
|
272.5 KB
|
|
|
23
|
|
380.5 KB
|
|
|
24
|
|
945.8 KB
|
|
|
25
|
|
475.4 KB
|
|
|
26
|
|
662.9 KB
|
|
|
27
|
|
2.6 KB
|
|
|
28
|
|
928.4 KB
|
|
|
29
|
|
928.6 KB
|
|
|
30
|
|
168 KB
|
|
|
31
|
|
673.3 KB
|
|
|
32
|
|
260.8 KB
|
|
|
33
|
|
704.2 KB
|
|
|
34
|
|
751.9 KB
|
|
|
35
|
|
675.7 KB
|
|
|
36
|
|
414.9 KB
|
|
|
37
|
|
181.2 KB
|
|
|
38
|
|
746.2 KB
|
|
|
39
|
|
906.4 KB
|
|
|
40
|
|
9.9 KB
|
|
|
41
|
|
133.8 KB
|
|
|
42
|
|
301.8 KB
|
|
|
43
|
|
801.9 KB
|
|
|
44
|
|
216.9 KB
|
|
|
45
|
|
289.1 KB
|
|
|
46
|
|
537.4 KB
|
|
|
47
|
|
674.8 KB
|
|
|
48
|
|
122.8 KB
|
|
|
49
|
|
216.5 KB
|
|
|
50
|
|
563.9 KB
|
|
|
51
|
|
272.4 KB
|
|
|
52
|
|
293.2 KB
|
|
|
53
|
|
601.8 KB
|
|
|
54
|
|
948.4 KB
|
|
|
56
|
|
276.2 KB
|
|
|
57
|
|
946.2 KB
|
|
|
58
|
|
656.5 KB
|
|
|
60
|
|
743.8 KB
|
|
|
61
|
|
199.6 KB
|
|
|
62
|
|
613.7 KB
|
|
|
63
|
|
238 KB
|
|
|
64
|
|
59.3 KB
|
|
|
65
|
|
477 KB
|
|
|
67
|
|
676.4 KB
|
|
|
68
|
|
756.7 KB
|
|
|
69
|
|
210.3 KB
|
|
|
70
|
|
570.7 KB
|
|
|
71
|
|
459.4 KB
|
|
|
72
|
|
483.8 KB
|
|
|
73
|
|
798.1 KB
|
|
|
74
|
|
192.3 KB
|
|
|
75
|
|
360.9 KB
|
|
|
76
|
|
710.7 KB
|
|
|
77
|
|
657.7 KB
|
|
|
78
|
|
617.3 KB
|
|
|
79
|
|
221.5 KB
|
|
|
80
|
|
759.9 KB
|
|
|
81
|
|
518.3 KB
|
|
|
82
|
|
62.8 KB
|
|
|
83
|
|
212 KB
|
|
|
84
|
|
532.4 KB
|
|
|
85
|
|
284.4 KB
|
