|
|
0
|
|
484.1 KB
|
|
|
1. Congratulations on Completing the Excel PivotTables Beginner to Advanced Course.mp4
|
MP4
|
35 MB
|
|
|
1. Excel PivotTable VALUE Defaults.mp4
|
MP4
|
157.4 MB
|
|
|
1. Grouping PivotTable Date Values.mp4
|
MP4
|
181.5 MB
|
|
|
1. Inserting an Excel Pivot Chart.mp4
|
MP4
|
66.9 MB
|
|
|
1. Microsoft Excel PivotTables - Beginner to Advanced Course Introduction.mp4
|
MP4
|
113.1 MB
|
|
|
1. Proper Microsoft Excel List Design and Layout.mp4
|
MP4
|
16.5 MB
|
|
|
1. Sorting Data in an Excel PivotTable.mp4
|
MP4
|
117.9 MB
|
|
|
1. Why Excel Power Query.mp4
|
MP4
|
81.3 MB
|
|
|
1. Working with Excel PivotTable Styles.mp4
|
MP4
|
67 MB
|
|
|
1
|
|
500.9 KB
|
|
|
1. Why Use an Excel PivotTable.mp4
|
MP4
|
91.8 MB
|
|
|
2
|
|
11.6 KB
|
|
|
3
|
|
580.9 KB
|
|
|
4
|
|
665.7 KB
|
|
|
5
|
|
533.3 KB
|
|
|
6
|
|
114.6 KB
|
|
|
7
|
|
934.9 KB
|
|
|
8
|
|
318 KB
|
|
|
9
|
|
148.3 KB
|
|
|
10
|
|
30.3 KB
|
|
|
10. CHALLENGE 04 Cleaning Up Excel Data.html
|
HTML
|
204.8 B
|
|
|
10. Merge Multiple Queries through Power Query.mp4
|
MP4
|
192.5 MB
|
|
|
11. Apply Excel Data Validation to List to Ensure Data Integrity.mp4
|
MP4
|
100.3 MB
|
|
|
11. Create a PivotTable based on Multiple Datasets.mp4
|
MP4
|
66.3 MB
|
|
|
12. Highlight Invalid List data.mp4
|
MP4
|
67.8 MB
|
|
|
13. Removing Duplicate Records from Excel List.mp4
|
MP4
|
117.5 MB
|
|
|
14. Format Excel List as Table.mp4
|
MP4
|
47.7 MB
|
|
|
15. CHALLENGE 05 Applying Validation to PivotTable Source Data.html
|
HTML
|
204.8 B
|
|
|
2. Combining Charts with PivotTable Slicers.mp4
|
MP4
|
59.5 MB
|
|
|
2. Date Value Group Settings.mp4
|
MP4
|
63 MB
|
|
|
2. Excel PivotTable Course Exercise Files (DOWNLOAD).mp4
|
MP4
|
52.3 MB
|
|
|
2. Introduction to External Data Sources.mp4
|
MP4
|
64.8 MB
|
|
|
2. Introduction to PivotTable Source Data.mp4
|
MP4
|
97.8 MB
|
|
|
2. Manage Value Field Settings.mp4
|
MP4
|
114.6 MB
|
|
|
2. Managing Excel PivotTable Subtotals.mp4
|
MP4
|
119.9 MB
|
|
|
2. Microsoft Excel - Do's and Don'ts of Proper Excel List Design.mp4
|
MP4
|
140.9 MB
|
|
|
2. Using Custom Lists to Sort in an Excel PivotTable.mp4
|
MP4
|
137.1 MB
|
|
|
2.1 ExcelPivotTableExerciseFiles.zip
|
ZIP
|
2.4 MB
|
|
|
3. Cleaning Up Excel List Data.mp4
|
MP4
|
80.9 MB
|
|
|
3. Creating a New Query.mp4
|
MP4
|
81.8 MB
|
|
|
3. Excel PivotTable Course QA (ASK QUESTIONS).mp4
|
MP4
|
52.3 MB
|
|
|
3. Inserting an Excel PivotTable.mp4
|
MP4
|
107.2 MB
|
|
|
3. Managing Excel PivotTable Grand Totals.mp4
|
MP4
|
58.6 MB
|
|
|
3. Manually Grouping PivotTable Row Data.mp4
|
MP4
|
124.9 MB
|
|
|
3. PivotTable and Pivot Chart Connection.mp4
|
MP4
|
73.5 MB
|
|
|
3. Show Values As Settings.mp4
|
MP4
|
133.7 MB
|
|
|
3. Sorting PivotTable Column Headers.mp4
|
MP4
|
54.3 MB
|
|
|
4. CHALLENGE 01 Post to the Course QA.html
|
HTML
|
204.8 B
|
|
|
4. Excel PivotTable Multi-Level Row Groupings.mp4
|
MP4
|
72.2 MB
|
|
|
4. Filtering Data in an Excel PivotTable.mp4
|
MP4
|
147.5 MB
|
|
|
4. Formatting PivotTable Slicers.mp4
|
MP4
|
115.6 MB
|
|
|
4. Formatting PivotTable Values.mp4
|
MP4
|
110.2 MB
|
|
|
4. Formatting a Pivot Chart with Chart Styles.mp4
|
MP4
|
58.8 MB
|
|
|
4. Proper Excel List Headers.mp4
|
MP4
|
69.3 MB
|
|
|
4. Transform Power Query Data.mp4
|
MP4
|
61.3 MB
|
|
|
4. Working with the PivotTable Field List.mp4
|
MP4
|
124 MB
|
|
|
5. Adding and Removing Chart Elements.mp4
|
MP4
|
110.8 MB
|
|
|
5. CHALLENGE 02 Create an Excel PivotTable.html
|
HTML
|
204.8 B
|
|
|
5. CHALLENGE 06 PivotTable Value Field Settings.html
|
HTML
|
204.8 B
|
|
|
5. CHALLENGE 07 PivotTable Grouping.html
|
HTML
|
204.8 B
|
|
|
5. Loading a Query to an Excel Worksheet.mp4
|
MP4
|
66.2 MB
|
|
|
5. Removing Empty Excel List Rows.mp4
|
MP4
|
122.3 MB
|
|
|
5. Working with PivotTable Slicers to Filter Data.mp4
|
MP4
|
114.6 MB
|
|
|
6. Microsoft Excel PROPER() Function.mp4
|
MP4
|
100 MB
|
|
|
6. Modify Excel PivotTable Field Layout.mp4
|
MP4
|
110.4 MB
|
|
|
6. Removing a PivotTable Slicer.mp4
|
MP4
|
29.2 MB
|
|
|
6. Updating the Original Source Data.mp4
|
MP4
|
61.7 MB
|
|
|
7. CHALLENGE 03 Modify PivotTable Summary.html
|
HTML
|
204.8 B
|
|
|
7. Creating a PivotTable based on the Query.mp4
|
MP4
|
91.5 MB
|
|
|
7. Microsoft Excel TRIM() Function.mp4
|
MP4
|
69.9 MB
|
|
|
7. Working with Excel PivotTable Timeline Filters.mp4
|
MP4
|
80.2 MB
|
|
|
8. Introduction to Excel Table Relationships.mp4
|
MP4
|
111.8 MB
|
|
|
8. Microsoft Excel VALUE() Function.mp4
|
MP4
|
81.6 MB
|
|
|
8. Refreshing an Excel PivotTable.mp4
|
MP4
|
65.2 MB
|
|
|
8. Sorting and Filtering Excel PivotTable Data.html
|
HTML
|
204.8 B
|
|
|
9. Append Multiple Queries through Power Query.mp4
|
MP4
|
164 MB
|
|
|
9. BONUS TIP - Excel Table as PivotTable Source.mp4
|
MP4
|
150.3 MB
|
|
|
9. Microsoft Excel UPPER() Function.mp4
|
MP4
|
51.4 MB
|
|
|
TutsNode.net.txt
|
TXT
|
102.4 B
|
|
|
[TGx]Downloaded from torrentgalaxy.to .txt
|
TXT
|
614.4 B
|
|
|
11
|
|
745 KB
|
|
|
12
|
|
75.2 KB
|
|
|
13
|
|
143.5 KB
|
|
|
14
|
|
548.1 KB
|
|
|
15
|
|
381.2 KB
|
|
|
16
|
|
403.8 KB
|
|
|
17
|
|
417.8 KB
|
|
|
18
|
|
883.4 KB
|
|
|
19
|
|
244.8 KB
|
|
|
20
|
|
162.7 KB
|
|
|
21
|
|
604.4 KB
|
|
|
22
|
|
819.3 KB
|
|
|
23
|
|
831.9 KB
|
|
|
24
|
|
679.1 KB
|
|
|
25
|
|
17.6 KB
|
|
|
26
|
|
226.6 KB
|
|
|
27
|
|
206.6 KB
|
|
|
28
|
|
524.5 KB
|
|
|
29
|
|
242.2 KB
|
|
|
30
|
|
424.6 KB
|
|
|
31
|
|
716.6 KB
|
|
|
32
|
|
125.8 KB
|
|
|
33
|
|
865.3 KB
|
|
|
34
|
|
485.2 KB
|
|
|
35
|
|
830.8 KB
|
|
|
36
|
|
136.3 KB
|
|
|
37
|
|
732.1 KB
|
|
|
38
|
|
204.9 KB
|
|
|
39
|
|
7.8 KB
|
|
|
40
|
|
108.9 KB
|
|
|
41
|
|
715.4 KB
|
|
|
42
|
|
868.5 KB
|
|
|
43
|
|
857.7 KB
|
|
|
44
|
|
237.3 KB
|
|
|
45
|
|
975.2 KB
|
|
|
46
|
|
301 KB
|
|
|
47
|
|
672.3 KB
|
|
|
48
|
|
489.6 KB
|
|
|
49
|
|
163.8 KB
|
|
|
50
|
|
376.9 KB
|
|
|
51
|
|
679.7 KB
|
|
|
52
|
|
713.4 KB
|
|
|
53
|
|
720.8 KB
|
|
|
54
|
|
572.3 KB
|
|
|
55
|
|
258.7 KB
|
|
|
56
|
|
37 KB
|
|
|
57
|
|
788.4 KB
|
|
|
58
|
|
516.3 KB
|