|
|
0
|
|
34.8 KB
|
|
|
1. Create a Date Table in Power Pivot.mp4
|
MP4
|
71.3 MB
|
|
|
1
|
|
284.6 KB
|
|
|
1. Create PivotTables and PivotCharts.mp4
|
MP4
|
109.6 MB
|
|
|
1. Create PivotTables and PivotCharts.srt
|
SRT
|
13.2 KB
|
|
|
1. Create a Date Table in Power Pivot.srt
|
SRT
|
9.6 KB
|
|
|
1. EXTRA LESSON Getting Started with Power Pivot and Power Query in Excel Webinar.mp4
|
MP4
|
555.5 MB
|
|
|
1. EXTRA LESSON Getting Started with Power Pivot and Power Query in Excel Webinar.srt
|
SRT
|
83.9 KB
|
|
|
1. Enable the Power Pivot Add-In.mp4
|
MP4
|
14.6 MB
|
|
|
1. Enable the Power Pivot Add-In.srt
|
SRT
|
1.9 KB
|
|
|
1. Exploring the Power Query Editor.mp4
|
MP4
|
47 MB
|
|
|
1. Exploring the Power Query Editor.srt
|
SRT
|
7 KB
|
|
|
1. Ten Excel Tips and Tricks - Part 1.mp4
|
MP4
|
336.7 MB
|
|
|
1. Ten Excel Tips and Tricks - Part 1.srt
|
SRT
|
61.7 KB
|
|
|
1. Unpivoting Columns.mp4
|
MP4
|
45.5 MB
|
|
|
1. Unpivoting Columns.srt
|
SRT
|
5.5 KB
|
|
|
1. Welcome and Overview.mp4
|
MP4
|
12.3 MB
|
|
|
1. Welcome and Overview.srt
|
SRT
|
2.9 KB
|
|
|
1. Why use DAX.mp4
|
MP4
|
11.6 MB
|
|
|
1. Why use DAX.srt
|
SRT
|
3.3 KB
|
|
|
1. Wrap Up.mp4
|
MP4
|
2.5 MB
|
|
|
1. Wrap Up.srt
|
SRT
|
1.4 KB
|
|
|
2. Combine Data from Multiple Tables with Merge Queries.mp4
|
MP4
|
39 MB
|
|
|
2. Combine Data from Multiple Tables with Merge Queries.srt
|
SRT
|
7.4 KB
|
|
|
2. Common Power Query Transformations.mp4
|
MP4
|
72.1 MB
|
|
|
2. Common Power Query Transformations.srt
|
SRT
|
9.5 KB
|
|
|
2. Creating Calculated Columns with DAX.mp4
|
MP4
|
39.4 MB
|
|
|
2. Creating Calculated Columns with DAX.srt
|
SRT
|
5.6 KB
|
|
|
2. EXTRA RESOURCE The Most Frequently Used Excel Shortcuts - Infographic.html
|
HTML
|
0 B
|
|
|
2. Ten Excel Tips and Tricks - Part 2.mp4
|
MP4
|
293.7 MB
|
|
|
2. Ten Excel Tips and Tricks - Part 2.srt
|
SRT
|
58.7 KB
|
|
|
2. The CALCULATE Function.mp4
|
MP4
|
21 MB
|
|
|
2
|
|
337.4 KB
|
|
|
2. The CALCULATE Function.srt
|
SRT
|
3.4 KB
|
|
|
2. Understanding the Power Pivot Window.mp4
|
MP4
|
35.6 MB
|
|
|
2. Understanding the Power Pivot Window.srt
|
SRT
|
4.9 KB
|
|
|
2. Using Slicers with your PivotTables.mp4
|
MP4
|
56.5 MB
|
|
|
2. Using Slicers with your PivotTables.srt
|
SRT
|
6.8 KB
|
|
|
2. WATCH ME Essential Information for a Successful Training Experience.mp4
|
MP4
|
37.9 MB
|
|
|
2. WATCH ME Essential Information for a Successful Training Experience.srt
|
SRT
|
2 KB
|
|
|
2.1 PC Excel Most Used.pdf
|
PDF
|
2.2 MB
|
|
|
3. Create a Top 10 PivotTable.mp4
|
MP4
|
78.8 MB
|
|
|
3. Create a Top 10 PivotTable.srt
|
SRT
|
9.8 KB
|
|
|
3. Creating Relationships Between tables.mp4
|
MP4
|
15.4 MB
|
|
|
3. Creating Relationships Between tables.srt
|
SRT
|
5.3 KB
|
|
|
3
|
|
287.4 KB
|
|
|
3. Creating your First DAX Measure.mp4
|
MP4
|
37.9 MB
|
|
|
3. Creating your First DAX Measure.srt
|
SRT
|
7 KB
|
|
|
3. DOWNLOAD ME Course Exercise Files.html
|
HTML
|
1 KB
|
|
|
3. Editing an Existing Query.mp4
|
MP4
|
92.5 MB
|
|
|
3. Editing an Existing Query.srt
|
SRT
|
11 KB
|
|
|
3. Ten Excel Tips and Tricks - Part 3.mp4
|
MP4
|
317.7 MB
|
|
|
3. Ten Excel Tips and Tricks - Part 3.srt
|
SRT
|
47.2 KB
|
|
|
3. The DIVIDE Function.mp4
|
MP4
|
19.5 MB
|
|
|
3. The DIVIDE Function.srt
|
SRT
|
3.2 KB
|
|
|
3. Use Merge Queries to Compare Two Tables.mp4
|
MP4
|
32.6 MB
|
|
|
3. Use Merge Queries to Compare Two Tables.srt
|
SRT
|
5.7 KB
|
|
|
3.1 Exercise Files.zip
|
ZIP
|
1.3 MB
|
|
|
4. DOWNLOAD ME Course Demo Files.html
|
HTML
|
1 KB
|
|
|
4. Import Multiple Files from a Folder.mp4
|
MP4
|
86.3 MB
|
|
|
4. Import Multiple Files from a Folder.srt
|
SRT
|
13.1 KB
|
|
|
4. Practise Exercise.mp4
|
MP4
|
7.2 MB
|
|
|
4. Stack Data into One Table with Append Queries.mp4
|
MP4
|
43.3 MB
|
|
|
4
|
|
396.9 KB
|
|
|
4. Managing the Relationships of the Model.mp4
|
MP4
|
14.6 MB
|
|
|
4. Managing the Relationships of the Model.srt
|
SRT
|
3.6 KB
|
|
|
4. Practise Exercise.srt
|
SRT
|
716.8 B
|
|
|
4. Stack Data into One Table with Append Queries.srt
|
SRT
|
6.8 KB
|
|
|
4. The COUNTROWS Function.mp4
|
MP4
|
31.3 MB
|
|
|
4. The COUNTROWS Function.srt
|
SRT
|
5 KB
|
|
|
4. Using the DATESYTD Function.mp4
|
MP4
|
14.3 MB
|
|
|
4. Using the DATESYTD Function.srt
|
SRT
|
2.3 KB
|
|
|
4.1 PowerQuery, PowerPivot and Dax Demo Files.zip
|
ZIP
|
26 MB
|
|
|
5. Calculate the Percentage of a Total.mp4
|
MP4
|
43.5 MB
|
|
|
5. Calculate the Percentage of a Total.srt
|
SRT
|
6.5 KB
|
|
|
5. Connect to Data in Another Excel Workbook.mp4
|
MP4
|
69 MB
|
|
|
5. Connect to Data in Another Excel Workbook.srt
|
SRT
|
11.3 KB
|
|
|
5. Creating a PivotTable from the Data Model.mp4
|
MP4
|
30.7 MB
|
|
|
5. Creating a PivotTable from the Data Model.srt
|
SRT
|
4.6 KB
|
|
|
5. Duplicating and Referencing Queries.mp4
|
MP4
|
69.7 MB
|
|
|
5. Duplicating and Referencing Queries.srt
|
SRT
|
10.3 KB
|
|
|
5. SUMX and RELATED Functions.mp4
|
MP4
|
22.9 MB
|
|
|
5. SUMX and RELATED Functions.srt
|
SRT
|
4.6 KB
|
|
|
5. Section 7 Quiz.html
|
HTML
|
204.8 B
|
|
|
5
|
|
472.2 KB
|
|
|
5. What is Power Query.mp4
|
MP4
|
16.9 MB
|
|
|
5. What is Power Query.srt
|
SRT
|
5.5 KB
|
|
|
6. Grouping and Aggregating Data.mp4
|
MP4
|
61.5 MB
|
|
|
6. Grouping and Aggregating Data.srt
|
SRT
|
8.7 KB
|
|
|
6. Hide Fields from Client Tools.mp4
|
MP4
|
15.5 MB
|
|
|
6. Hide Fields from Client Tools.srt
|
SRT
|
3.4 KB
|
|
|
6. IMPORTANT Checking the Location of your Query's Source.mp4
|
MP4
|
25.1 MB
|
|
|
6
|
|
733.5 KB
|
|
|
6. IMPORTANT Checking the Location of your Query's Source.srt
|
SRT
|
4 KB
|
|
|
6. Practise Exercise.mp4
|
MP4
|
9.2 MB
|
|
|
6. Practise Exercise.srt
|
SRT
|
716.8 B
|
|
|
6. What is Power Pivot.mp4
|
MP4
|
12.5 MB
|
|
|
6. What is Power Pivot.srt
|
SRT
|
3.8 KB
|
|
|
7. Section 1 Quiz.html
|
HTML
|
204.8 B
|
|
|
7. Section 6 Quiz.html
|
HTML
|
204.8 B
|
|
|
TutsNode.net.txt
|
TXT
|
102.4 B
|
|
|
[TGx]Downloaded from torrentgalaxy.to .txt
|
TXT
|
614.4 B
|
|
|
7
|
|
243.2 KB
|
|
|
7. Conditional Columns in Power Query.mp4
|
MP4
|
48.9 MB
|
|
|
7. Conditional Columns in Power Query.srt
|
SRT
|
8 KB
|
|
|
7. Get Data From the Web.mp4
|
MP4
|
57.7 MB
|
|
|
7. Get Data From the Web.srt
|
SRT
|
6.2 KB
|
|
|
7. Grouping Queries.mp4
|
MP4
|
36.1 MB
|
|
|
7. Grouping Queries.srt
|
SRT
|
4.2 KB
|
|
|
7. Section 5 Quiz.html
|
HTML
|
204.8 B
|
|
|
8. Practise Exercise.srt
|
SRT
|
716.8 B
|
|
|
8
|
|
912 KB
|
|
|
8. Practise Exercise.mp4
|
MP4
|
8.9 MB
|
|
|
9
|
|
767.8 KB
|
|
|
9. Section 2 Quiz.html
|
HTML
|
204.8 B
|
|
|
9. Section 3 Quiz.html
|
HTML
|
204.8 B
|
|
|
9. Section 4 Quiz.html
|
HTML
|
204.8 B
|
|
|
10
|
|
258.9 KB
|
|
|
11
|
|
51.2 KB
|
|
|
12
|
|
538.8 KB
|
|
|
13
|
|
259.4 KB
|
|
|
14
|
|
497.9 KB
|
|
|
15
|
|
68.6 KB
|
|
|
16
|
|
3.4 KB
|
|
|
17
|
|
484.4 KB
|
|
|
18
|
|
495.7 KB
|
|
|
19
|
|
754 KB
|
|
|
20
|
|
637.5 KB
|
|
|
21
|
|
35.2 KB
|
|
|
22
|
|
90.3 KB
|
|
|
23
|
|
132.5 KB
|
|
|
24
|
|
891.8 KB
|
|
|
25
|
|
392.7 KB
|
|
|
26
|
|
409.9 KB
|
|
|
27
|
|
741.4 KB
|
|
|
28
|
|
351.8 KB
|
|
|
29
|
|
20.6 KB
|
|
|
30
|
|
950.9 KB
|
|
|
31
|
|
87.1 KB
|
|
|
32
|
|
14.9 KB
|
|
|
33
|
|
491.6 KB
|
|
|
34
|
|
80.2 KB
|
|
|
35
|
|
509.7 KB
|
|
|
36
|
|
585.1 KB
|
|
|
37
|
|
444.8 KB
|
|
|
38
|
|
460.1 KB
|
|
|
39
|
|
742.2 KB
|
|
|
40
|
|
504.2 KB
|
|
|
41
|
|
737 KB
|
|
|
42
|
|
425 KB
|
|
|
43
|
|
326.6 KB
|
|
|
44
|
|
547.3 KB
|
|
|
45
|
|
634.1 KB
|
|
|
46
|
|
851.4 KB
|
|
|
47
|
|
62.7 KB
|
|
|
48
|
|
808.7 KB
|
|
|
49
|
|
475.3 KB
|
|
|
50
|
|
837.6 KB
|
