|
|
1. Aggregating Methods.mp4
|
MP4
|
48.5 MB
|
|
|
1. Basics Conditional Formatting.mp4
|
MP4
|
62.8 MB
|
|
|
1. Creating easy Pivot-Tables.mp4
|
MP4
|
69.7 MB
|
|
|
1. Download Project Data.html
|
HTML
|
0 B
|
|
|
1. Duplicating Pivot-Tables.mp4
|
MP4
|
34.8 MB
|
|
|
1. Introduction case study.html
|
HTML
|
0 B
|
|
|
1. Pivot-Charts vs. Excel-Charts.mp4
|
MP4
|
68.3 MB
|
|
|
1. Pivot-Table Style Options.mp4
|
MP4
|
17.4 MB
|
|
|
1. Slicer.mp4
|
MP4
|
63.2 MB
|
|
|
1. Thank you very much!.html
|
HTML
|
0 B
|
|
|
1. VBA for Pivot Tables.mp4
|
MP4
|
15.5 MB
|
|
|
1. Welcome!.html
|
HTML
|
512 B
|
|
|
1.1 Aggregating Methods.xlsx
|
XLSX
|
179 KB
|
|
|
1.1 Basics Conditional Formatting.xlsx
|
XLSX
|
186.7 KB
|
|
|
1.1 Creating easy Pivot-Tables.xlsx
|
XLSX
|
191.4 KB
|
|
|
1.1 Duplicating Pivot-Tables.xlsx
|
XLSX
|
174.7 KB
|
|
|
1.1 Pivot-Charts vs. Excel-Charts.xlsx
|
XLSX
|
190.6 KB
|
|
|
1.1 Pivot-Table Style Options.xlsx
|
XLSX
|
194 KB
|
|
|
1.1 Project Data.xlsx
|
XLSX
|
144.6 KB
|
|
|
1.1 Slicer.xlsx
|
XLSX
|
204.7 KB
|
|
|
1.1 VBA for Pivot Tables.xlsx
|
XLSX
|
211.6 KB
|
|
|
10. Power Pivot.html
|
HTML
|
102.4 B
|
|
|
10. Quick Access Toolbar.mp4
|
MP4
|
33.4 MB
|
|
|
10. Solution Practical Exercise PivotCharts.html
|
HTML
|
0 B
|
|
|
10.1 Quick Access Toolbar.xlsx
|
XLSX
|
132.2 KB
|
|
|
11. Data Visualization.html
|
HTML
|
102.4 B
|
|
|
11. Dynamic Tables.mp4
|
MP4
|
107.5 MB
|
|
|
11.1 Dynamic Tables.xlsx
|
XLSX
|
145 KB
|
|
|
12. Introduction Pivot-Tables.html
|
HTML
|
102.4 B
|
|
|
2. Actions (Clear, Select, Move).mp4
|
MP4
|
47.6 MB
|
|
|
2. Column- and Bar-Charts.mp4
|
MP4
|
38.7 MB
|
|
|
2. Course Material.html
|
HTML
|
0 B
|
|
|
2. Creating Pivot-Table.html
|
HTML
|
0 B
|
|
|
2. Field Options.mp4
|
MP4
|
50.6 MB
|
|
|
2. Issue Multiple Pivot-Tables.mp4
|
MP4
|
48.9 MB
|
|
|
2. Macro-Recorder for Macro Refresh Pivot-Table.mp4
|
MP4
|
83.2 MB
|
|
|
2. Percentages.mp4
|
MP4
|
61.9 MB
|
|
|
2. Pivot-Table Styles.mp4
|
MP4
|
33.1 MB
|
|
|
2. Rules.mp4
|
MP4
|
35.5 MB
|
|
|
2. Timeline.mp4
|
MP4
|
34.8 MB
|
|
|
2.1 Actions (Clear, Select, Move).xlsx
|
XLSX
|
186.3 KB
|
|
|
2.1 Column- and Bar-Charts.xlsx
|
XLSX
|
187.3 KB
|
|
|
2.1 Field Options.xlsx
|
XLSX
|
176 KB
|
|
|
2.1 Issue Multiple Pivot-Tables.xlsx
|
XLSX
|
134.6 KB
|
|
|
2.1 Percentages.xlsx
|
XLSX
|
183.5 KB
|
|
|
2.1 Pivot-Table Style.xlsx
|
XLSX
|
194 KB
|
|
|
2.1 Record Macros.xlsx
|
XLSX
|
211.6 KB
|
|
|
2.1 Rules.xlsx
|
XLSX
|
187.7 KB
|
|
|
2.1 Timeline.xlsx
|
XLSX
|
196.2 KB
|
|
|
2.2 Overview Issues Pivot Tables.xlsx
|
XLSX
|
19.6 KB
|
|
|
3. Advanced Rules.mp4
|
MP4
|
79 MB
|
|
|
3. Calculating.mp4
|
MP4
|
35.3 MB
|
|
|
3. How to work with this Course.html
|
HTML
|
0 B
|
|
|
3. Layout.mp4
|
MP4
|
44.5 MB
|
|
|
3. Line- and Area-Charts.mp4
|
MP4
|
35.5 MB
|
|
|
3. Lookup Functions.mp4
|
MP4
|
88.6 MB
|
|
|
3. Options.mp4
|
MP4
|
49.4 MB
|
|
|
3. Refreshing and Changing the Data Source.mp4
|
MP4
|
29.2 MB
|
|
|
3. Selection Pane.mp4
|
MP4
|
34.6 MB
|
|
|
3. VBA-Code Refresh Pivot-Table.mp4
|
MP4
|
42.9 MB
|
|
|
3.1 Advanced Rules.xlsx
|
XLSX
|
210.1 KB
|
|
|
3.1 Calculating.xlsx
|
XLSX
|
174.2 KB
|
|
|
3.1 Layout.xlsx
|
XLSX
|
185.6 KB
|
|
|
3.1 Line- and Area-Charts.xlsx
|
XLSX
|
202.2 KB
|
|
|
3.1 Lookup Functions.xlsx
|
XLSX
|
181.3 KB
|
|
|
3.1 Options.xlsx
|
XLSX
|
186 KB
|
|
|
3.1 Refreshing and Changing the Data Source.xlsx
|
XLSX
|
175.3 KB
|
|
|
3.1 Selection Pane.xlsx
|
XLSX
|
206.3 KB
|
|
|
3.1 Writing VBA-Code.xlsx
|
XLSX
|
211.7 KB
|
|
|
4. ChatGPT Signing up.mp4
|
MP4
|
17.7 MB
|
|
|
4. Conditional Formatting.html
|
HTML
|
102.4 B
|
|
|
4. Creating our Dashboard.mp4
|
MP4
|
94.8 MB
|
|
|
4. Drill Throughs.mp4
|
MP4
|
28.1 MB
|
|
|
4. Generate GetPivotData.mp4
|
MP4
|
26.8 MB
|
|
|
4. Grouping.mp4
|
MP4
|
38.2 MB
|
|
|
4. Pie-Charts TreeMap Trick.mp4
|
MP4
|
39.1 MB
|
|
|
4. Power Pivot Basics.mp4
|
MP4
|
29.4 MB
|
|
|
4. Printing Pivot-Tables.mp4
|
MP4
|
25.1 MB
|
|
|
4. What will You learn in this Course.html
|
HTML
|
0 B
|
|
|
4.1 ChatGPT Website.html
|
HTML
|
102.4 B
|
|
|
4.1 Dashboard.xlsx
|
XLSX
|
205.3 KB
|
|
|
4.1 Drill Throughs.xlsx
|
XLSX
|
187.4 KB
|
|
|
4.1 Generate GetPivotData.xlsx
|
XLSX
|
177.1 KB
|
|
|
4.1 Grouping.xlsx
|
XLSX
|
175.4 KB
|
|
|
4.1 Pie-Charts TreeMap Trick.xlsx
|
XLSX
|
207.4 KB
|
|
|
4.1 Power Pivot Basics.xlsx
|
XLSX
|
171.3 KB
|
|
|
4.1 Printing Pivot-Tables.xlsx
|
XLSX
|
186.3 KB
|
|
|
5. Adding Tables into Power Pivot Environment.mp4
|
MP4
|
46.1 MB
|
|
|
5. ChatGPT VBA-Code for Pivot-Tables.mp4
|
MP4
|
62.5 MB
|
|
|
5. Dashboards.html
|
HTML
|
102.4 B
|
|
|
5. Design and Layout Options.html
|
HTML
|
102.4 B
|
|
|
5. Field Lists.mp4
|
MP4
|
19.8 MB
|
|
|
5. Practical Exercise Data Analysis.html
|
HTML
|
0 B
|
|
|
5. Radar-Chart.mp4
|
MP4
|
23.9 MB
|
|
|
5. Sorting.mp4
|
MP4
|
27.6 MB
|
|
|
5. Using Pivot-Tables in Business.mp4
|
MP4
|
65.5 MB
|
|
|
5.1 Adding Tables into Power Pivot.xlsx
|
XLSX
|
670 KB
|
|
|
5.1 ChatGPT VBA-Code for Pivot-Tables.xlsx
|
XLSX
|
212.3 KB
|
|
|
5.1 Field Lists.xlsx
|
XLSX
|
181 KB
|
|
|
5.1 Pie-Charts TreeMap Trick.xlsx
|
XLSX
|
197.4 KB
|
|
|
5.1 Sorting.xlsx
|
XLSX
|
176.2 KB
|
|
|
5.1 Why Pivot Tables.xlsx
|
XLSX
|
156.8 KB
|
|
|
6. Building our Data Model.mp4
|
MP4
|
34.7 MB
|
|
|
6. Filtering.mp4
|
MP4
|
65.6 MB
|
|
|
6. Mistakes by creating a Pivot-Table.mp4
|
MP4
|
87.8 MB
|
|
|
6. Overview Pivot-Charts.mp4
|
MP4
|
13.6 MB
|
|
|
6. Practical Exercise VBA & ChatGPT for Pivot-Tables.html
|
HTML
|
0 B
|
|
|
6. Recommended Pivot Tables.mp4
|
MP4
|
29.4 MB
|
|
|
6. Solution Practical Exercise Data Analysis.html
|
HTML
|
0 B
|
|
|
6.1 Building our Data Model.xlsx
|
XLSX
|
690 KB
|
|
|
6.1 Filtering.xlsx
|
XLSX
|
178.6 KB
|
|
|
6.1 Mistakes by creating a Pivot-Table.xlsx
|
XLSX
|
183.5 KB
|
|
|
6.1 Overview Chart Types.xlsx
|
XLSX
|
32.2 KB
|
|
|
6.1 Recommended Pivot Tables.xlsx
|
XLSX
|
226.6 KB
|
|
|
7. Creating our first Pivot-Table.mp4
|
MP4
|
75.7 MB
|
|
|
7. Data Analysis.html
|
HTML
|
102.4 B
|
|
|
7. Design Configuration.mp4
|
MP4
|
52.5 MB
|
|
|
7. Pivot-Tables across multiple Data Tables.mp4
|
MP4
|
34.3 MB
|
|
|
7. Practical Exercise Formatting.html
|
HTML
|
0 B
|
|
|
7. Practical Exercise Sorting & Filtering.mp4
|
MP4
|
7.3 MB
|
|
|
7. Solution Practical Exercise VBA & ChatGPT for Pivot-Tables.html
|
HTML
|
0 B
|
|
|
7.1 Configurating Pivot-Charts.xlsx
|
XLSX
|
197 KB
|
|
|
7.1 Creating our first Pivot-Table.xlsx
|
XLSX
|
209.5 KB
|
|
|
7.1 Exercise Sorting and Filtering.xlsx
|
XLSX
|
124 KB
|
|
|
7.1 Pivot-Tables across multiple Data Tables.xlsx
|
XLSX
|
741.2 KB
|
|
|
8. Creating our first Analysis.mp4
|
MP4
|
62.3 MB
|
|
|
8. Format.mp4
|
MP4
|
93.6 MB
|
|
|
8. Pivot Table Analysis.mp4
|
MP4
|
45.6 MB
|
|
|
8. Solution Practical Exercise Formatting.html
|
HTML
|
0 B
|
|
|
8. Solution Practical Exercise Sorting & Filtering.mp4
|
MP4
|
47.3 MB
|
|
|
8. VBA & ChatGPT for Pivot-Tables.html
|
HTML
|
102.4 B
|
|
|
8.1 Creating our first Analysis.xlsx
|
XLSX
|
132.2 KB
|
|
|
8.1 Formatting Pivot-Charts.xlsx
|
XLSX
|
202.5 KB
|
|
|
8.1 Pivot Table Analysis.xlsx
|
XLSX
|
754.2 KB
|
|
|
8.1 Solution Exercise Sorting and Filtering.xlsx
|
XLSX
|
185.2 KB
|
|
|
9. Customized Ribbon.mp4
|
MP4
|
27.5 MB
|
|
|
9. Formatting.html
|
HTML
|
102.4 B
|
|
|
9. Pivot and PivotChart.html
|
HTML
|
0 B
|
|
|
9. Practical Exercise PivotCharts.html
|
HTML
|
0 B
|
|
|
9. Sorting & Filtering.html
|
HTML
|
102.4 B
|
|
|
9.1 Customized Ribbon.xlsx
|
XLSX
|
132.2 KB
|
|
|
Bonus Resources.txt
|
TXT
|
409.6 B
|
|
|
Get Bonus Downloads Here.url
|
URL
|
204.8 B
|
