Other
The Advanced Excel, Power Pivot & VBA Bundle
Torrent info
Torrent Files List
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle (Size: 16.16 GB) (Files: 744)
[TutsNode.net] - The Advanced Excel, Power Pivot & VBA Bundle
51. Extras
1. EXTRA LESSON Getting Started with Power Pivot and Power Query in Excel Webinar.mp4
1. EXTRA LESSON Getting Started with Power Pivot and Power Query in Excel Webinar.srt
2. EXTRA RESOURCE The Most Frequently Used Excel Shortcuts - Infographic.html
2.1 PC Excel Most Used.pdf
23. VBA Intermediate Training Discover Excel Automation Secrets
4.1 VBA-Intermediate-Support-Files.zip
3.1 VBA-Intermediate-Exercise-Files.zip
2. WATCH ME Essential Information for a Successful Training Experience.srt
3. Course exercise and solution files.html
4. Course support files.html
1. Introduction.srt
2. WATCH ME Essential Information for a Successful Training Experience.mp4
1. Introduction.mp4
38. Advanced Pivot Tables Introduction
5. PivotTables Recap.srt
1. Introduction to Advanced PivotTables.srt
2. WATCH ME Essential Information for a Successful Training Experience.srt
3. DOWNLOAD ME Course Exercise Files.html
4. DOWNLOAD ME Course Support Files.html
6. Section Quiz.html
5. PivotTables Recap.mp4
2. WATCH ME Essential Information for a Successful Training Experience.mp4
1. Introduction to Advanced PivotTables.mp4
4.1 Advanced Pivot Tables Course Files.zip
3.1 Advanced Pivot Tables Exercise Files.zip
1. Introduction to Excel 2019 Advanced Course
2. WATCH ME Essential Information for a Successful Training Experience.srt
3. Excel 2019 Advanced Course Exercise Files.html
4. Excel 2019 Advanced Course Demo Files.html
5. Downloadable Course Transcripts.html
5.1 Microsoft Excel 2019 Advanced Course by Simon Sez IT .pdf
1. Introduction to the Course.srt
6. Course Structure.srt
1. Introduction to the Course.mp4
2. WATCH ME Essential Information for a Successful Training Experience.mp4
6. Course Structure.mp4
4.1 Excel 2019 Advaned Course Files.zip
3.1 Excel 2019 Advanced Exercise Files.zip
16. Essential VBA Training for Excel - Automate Repetitive Tasks Introduction
3.1 VBA-Exercise-and-Solution-Files.zip
2. WATCH ME Essential Information for a Successful Training Experience.srt
3. Course Exercise and Solution Files.html
1. Introduction to the VBA Course.srt
2. WATCH ME Essential Information for a Successful Training Experience.mp4
1. Introduction to the VBA Course.mp4
52. Bonuses
1. Ten Excel Tips and Tricks - Part 1.srt
2. Ten Excel Tips and Tricks - Part 2.srt
3. Ten Excel Tips and Tricks - Part 3.srt
1. Ten Excel Tips and Tricks - Part 1.mp4
3. Ten Excel Tips and Tricks - Part 3.mp4
2. Ten Excel Tips and Tricks - Part 2.mp4
49. Dashboards
1. Creating an Interactive Dashboard - Part 1.srt
2. Creating an Interactive Dashboard - Part 2.srt
4. Exercise 11.srt
3. Updating Pivot Charts and PivotTables.srt
5. Section Quiz.html
1. Creating an Interactive Dashboard - Part 1.mp4
2. Creating an Interactive Dashboard - Part 2.mp4
3. Updating Pivot Charts and PivotTables.mp4
4. Exercise 11.mp4
40. Preparing Data for Analysis
1. Cleaning Data.srt
2. Tabular Data.srt
3. Exercise 02.srt
4. Section Quiz.html
2. Tabular Data.mp4
1. Cleaning Data.mp4
3. Exercise 02.mp4
47. Pivot Charts
3. Formatting a Pivot Chart - Part 2.srt
2. Formatting a Pivot Chart - Part 1.srt
5. Dynamic Chart Titles.srt
1. Creating a Pivot Chart.srt
4. Creating a Map Chart using Pivot Data.srt
6. Include a Sparkline with your PivotTable.srt
7. Exercise 09.srt
8. Section Quiz.html
3. Formatting a Pivot Chart - Part 2.mp4
2. Formatting a Pivot Chart - Part 1.mp4
4. Creating a Map Chart using Pivot Data.mp4
1. Creating a Pivot Chart.mp4
6. Include a Sparkline with your PivotTable.mp4
5. Dynamic Chart Titles.mp4
7. Exercise 09.mp4
42. Formatting PivotTables
2. Custom Number Formatting.srt
1. PivotTable Styles.srt
3. Exercise 04.srt
4. Section Quiz.html
2. Custom Number Formatting.mp4
1. PivotTable Styles.mp4
3. Exercise 04.mp4
2. Functions
4. Section 2 Quiz.html
1. Functions - Part 1.srt
2. Functions - Part 2.srt
3. Autosum.srt
1. Functions - Part 1.mp4
2. Functions - Part 2.mp4
3. Autosum.mp4
44. Sorting and Filtering
2. Advanced Filtering.srt
1. Advanced Sorting.srt
3. Exercise 06.srt
4. Section Quiz.html
2. Advanced Filtering.mp4
1. Advanced Sorting.mp4
3. Exercise 06.mp4
45. Interacting with PivotTables
1. Inserting and formatting Slicers.srt
3. Connecting Slicers to multiple PivotTables.srt
2. Inserting and formatting Timelines.srt
4. Using Slicers in Protected Workbooks.srt
5. Exercise 07.srt
6. Section Quiz.html
1. Inserting and formatting Slicers.mp4
3. Connecting Slicers to multiple PivotTables.mp4
2. Inserting and formatting Timelines.mp4
4. Using Slicers in Protected Workbooks.mp4
5. Exercise 07.mp4
32. Useful Power Query Features
7. Conditional Columns in Power Query.srt
5. Duplicating and Referencing Queries.srt
6. Grouping and Aggregating Data.srt
2. Combine Data from Multiple Tables with Merge Queries.srt
4. Stack Data into One Table with Append Queries.srt
3. Use Merge Queries to Compare Two Tables.srt
1. Unpivoting Columns.srt
8. Practise Exercise.srt
9. Section 32 Quiz.html
5. Duplicating and Referencing Queries.mp4
6. Grouping and Aggregating Data.mp4
7. Conditional Columns in Power Query.mp4
1. Unpivoting Columns.mp4
4. Stack Data into One Table with Append Queries.mp4
2. Combine Data from Multiple Tables with Merge Queries.mp4
3. Use Merge Queries to Compare Two Tables.mp4
8. Practise Exercise.mp4
30. Power Pivot, Power Query & Dax Introduction
3.1 Exercise Files.zip
5. What is Power Query.srt
6. What is Power Pivot.srt
1. Welcome and Overview.srt
2. WATCH ME Essential Information for a Successful Training Experience.srt
4. Course Demo Files.html
3. Course Exercise Files.html
7. Section 30 Quiz.html
2. WATCH ME Essential Information for a Successful Training Experience.mp4
4.1 PowerQuery, PowerPivot and Dax Demo Files.zip
5. What is Power Query.mp4
6. What is Power Pivot.mp4
1. Welcome and Overview.mp4
21. Common Keys to VBA
8. One Approach To Completing Exercise 8.srt
3. Using Errors to Guide You.srt
2. The Workbook and Worksheet Objects.srt
7. The PageSetup Object and Print Ranges.srt
1. The Application Object.srt
6. The Chart and ChartObject Objects.srt
5. The PivotTable Object.srt
4. The Name and Names Objects.srt
8. One Approach To Completing Exercise 8.mp4
7. The PageSetup Object and Print Ranges.mp4
3. Using Errors to Guide You.mp4
2. The Workbook and Worksheet Objects.mp4
6. The Chart and ChartObject Objects.mp4
1. The Application Object.mp4
4. The Name and Names Objects.mp4
5. The PivotTable Object.mp4
9. Connecting to External Data
4. Get and Transform.srt
1. Connecting to Other workbooks.srt
2. Connecting to Access Databases.srt
6. Section 9 Quiz.html
3. Connecting Web Data Sources.srt
5. Exercise 05.srt
4. Get and Transform.mp4
1. Connecting to Other workbooks.mp4
2. Connecting to Access Databases.mp4
3. Connecting Web Data Sources.mp4
5. Exercise 05.mp4
4. Text Functions
3. Section 4 Quiz.html
1. Using Text Functions - Part 1.srt
2. Using Text Functions - Part 2.srt
2. Using Text Functions - Part 2.mp4
1. Using Text Functions - Part 1.mp4
24. VBA Language Details
6. The VBA Project Model.srt
7. Advanced Parameter Definitions.srt
4. Detailed Memory Management.srt
5. Code Module Interactions.srt
3. Code Modules.srt
2. Excel File Types.srt
1. Chapter 2 Preview.srt
6. The VBA Project Model.mp4
7. Advanced Parameter Definitions.mp4
2. Excel File Types.mp4
4. Detailed Memory Management.mp4
3. Code Modules.mp4
5. Code Module Interactions.mp4
1. Chapter 2 Preview.mp4
19. Introducing Macros
6. Looping Collections and the For Each Loop.srt
4. Methods for Communicating to the User.srt
5. Looping The For and Do While Loops.srt
2. Logical Constructs The Boolean Type.srt
1. Subroutines.srt
3. Logical Constructs If and Switch Statements.srt
4. Methods for Communicating to the User.mp4
5. Looping The For and Do While Loops.mp4
6. Looping Collections and the For Each Loop.mp4
1. Subroutines.mp4
3. Logical Constructs If and Switch Statements.mp4
2. Logical Constructs The Boolean Type.mp4
5. Logical Functions
2. Exercise 01.srt
3. Section 5 Quiz.html
1. Logical Functions.srt
1. Logical Functions.mp4
2. Exercise 01.mp4
41. Creating and Manipulating PivotTables
1. Creating and Manipulating a PivotTable.srt
2. Combining Data from Multiple Worksheets.srt
4. Report Layouts.srt
3. Grouping and Ungrouping.srt
5. Formatting Error Values and Empty Cells.srt
6. Exercise 03.srt
7. Section Quiz.html
1. Creating and Manipulating a PivotTable.mp4
4. Report Layouts.mp4
3. Grouping and Ungrouping.mp4
2. Combining Data from Multiple Worksheets.mp4
5. Formatting Error Values and Empty Cells.mp4
6. Exercise 03.mp4
26. Custom Objects
12. Designing a Userform.srt
11. Creating a Userform.srt
5. Practical Example of a Class.srt
13. Coding a Userform.srt
8. Initialization and Termination.srt
7. Special Class Variables and Components.srt
4. Defining a Class.srt
3. Create a New Class.srt
9. VBA Attributes and Usage.srt
10. Inheritance - Defining the Bookmarks Support Class.srt
6. Practice Test of a Class.srt
1. Chapter Overview + New Keyword.srt
2. Creating A Custom Type.srt
12. Designing a Userform.mp4
11. Creating a Userform.mp4
13. Coding a Userform.mp4
5. Practical Example of a Class.mp4
7. Special Class Variables and Components.mp4
10. Inheritance - Defining the Bookmarks Support Class.mp4
3. Create a New Class.mp4
9. VBA Attributes and Usage.mp4
1. Chapter Overview + New Keyword.mp4
6. Practice Test of a Class.mp4
2. Creating A Custom Type.mp4
8. Initialization and Termination.mp4
4. Defining a Class.mp4
27. External References and Office Interop
1. Modding the Excel Interface.srt
3. UI Interface Control Options and Access.srt
4. Piecing the UI Pieces Together.srt
2. UI Interface Scope and Range.srt
1. Modding the Excel Interface.mp4
3. UI Interface Control Options and Access.mp4
2. UI Interface Scope and Range.mp4
4. Piecing the UI Pieces Together.mp4
6. Lookup Functions
4. Section 6 Quiz.html
1. Lookup Functions - Part 1.srt
2. Lookup Functions - Part 2.srt
3. Exercise 02.srt
1. Lookup Functions - Part 1.mp4
2. Lookup Functions - Part 2.mp4
3. Exercise 02.mp4
8. Statistical Functions
2. Statistical Functions for Description - Part 2.srt
5. Exercise 04.srt
1. Statistical Functions for Description - Part 1.srt
8. Section 8 Quiz.html
4. Statistical Functions for Forecasting - Part 2.srt
7. Statistical Functions for Inference.srt
3. Statistical Functions for Forecasting - Part 1.srt
6. One Click Forecasting.srt
2. Statistical Functions for Description - Part 2.mp4
1. Statistical Functions for Description - Part 1.mp4
4. Statistical Functions for Forecasting - Part 2.mp4
6. One Click Forecasting.mp4
7. Statistical Functions for Inference.mp4
3. Statistical Functions for Forecasting - Part 1.mp4
5. Exercise 04.mp4
7. Financial Functions
5. Exercise 03.srt
6. Section 7 Quiz.html
1. Financial Functions and Terminology.srt
2. Personal Financial Functions.srt
3. Principal and Interest Payments.srt
4. Depreciation.srt
2. Personal Financial Functions.mp4
3. Principal and Interest Payments.mp4
1. Financial Functions and Terminology.mp4
4. Depreciation.mp4
5. Exercise 03.mp4
43. Value Field Settings
1. Summarizing Values.srt
2. Show Values As.srt
3. Exercise 05.srt
4. Section Quiz.html
1. Summarizing Values.mp4
2. Show Values As.mp4
3. Exercise 05.mp4
11. Pivot Tables
3. Filters and Slicers.srt
2. Working with Pivot Tables.srt
5. Exercise 07.srt
6. Section 11 Quiz.html
1. Introduction to Pivot Tables.srt
4. Pivot and Charts.srt
2. Working with Pivot Tables.mp4
3. Filters and Slicers.mp4
1. Introduction to Pivot Tables.mp4
4. Pivot and Charts.mp4
5. Exercise 07.mp4
48. Conditional Formatting
2. Graphical Conditional Formats.srt
1. Highlighting Cell Rules.srt
3. Conditional Formatting and Slicers.srt
4. Exercise 10.srt
5. Section Quiz.html
2. Graphical Conditional Formats.mp4
1. Highlighting Cell Rules.mp4
3. Conditional Formatting and Slicers.mp4
4. Exercise 10.mp4
10. Tables
1. Introduction to Tables.srt
5. Exercise 6.srt
6. Section 10 Quiz.html
2. Working with Tables.srt
3. Table References.srt
4. Table Styles.srt
1. Introduction to Tables.mp4
2. Working with Tables.mp4
3. Table References.mp4
4. Table Styles.mp4
5. Exercise 6.mp4
39. Importing Data
1. Importing data from a text file.srt
2. Importing data from Access.srt
3. Exercise 01.srt
4. Section Quiz.html
1. Importing data from a text file.mp4
2. Importing data from Access.mp4
3. Exercise 01.mp4
25. Excel Events
4. A Series Of Example Events.srt
5. Application Events.srt
2. Pre-Defined Events.srt
3. Event Parameters.srt
1. What Are Events.srt
4. A Series Of Example Events.mp4
5. Application Events.mp4
3. Event Parameters.mp4
2. Pre-Defined Events.mp4
1. What Are Events.mp4
18. VBA as a Language
4. How to Define and Manage Variables.srt
3. Variables and Method Calling Rules.srt
1. VBA Syntax, Keywords, and Comments.srt
2. Objects and VBA's Intellitext.srt
5. Constant Variable Types and Variables through Intellitext.srt
4. How to Define and Manage Variables.mp4
3. Variables and Method Calling Rules.mp4
1. VBA Syntax, Keywords, and Comments.mp4
2. Objects and VBA's Intellitext.mp4
5. Constant Variable Types and Variables through Intellitext.mp4
46. Calculations
3. Solve Order and List Formulas.srt
4. GETPIVOTDATA.srt
1. Creating a Calculated Field.srt
2. Creating a Calculated Item.srt
5. Exercise 08.srt
6. Section Quiz.html
4. GETPIVOTDATA.mp4
2. Creating a Calculated Item.mp4
3. Solve Order and List Formulas.mp4
1. Creating a Calculated Field.mp4
5. Exercise 08.mp4
36. Using PivotTables and Slicers
1. Create PivotTables and PivotCharts.srt
3. Create a Top 10 PivotTable.srt
2. Using Slicers with your PivotTables.srt
4. Practise Exercise.srt
5. Section 36 Quiz.html
1. Create PivotTables and PivotCharts.mp4
3. Create a Top 10 PivotTable.mp4
2. Using Slicers with your PivotTables.mp4
4. Practise Exercise.mp4
12. Data Analysis
4. Solver.srt
2. Scenario Manager.srt
5. Exercise 08.srt
6. Section 12 Quiz.html
1. What If Analysis.srt
3. Goal Seek.srt
2. Scenario Manager.mp4
4. Solver.mp4
1. What If Analysis.mp4
3. Goal Seek.mp4
5. Exercise 08.mp4
31. Getting Started with Power Query
4. Import Multiple Files from a Folder.srt
5. Connect to Data in Another Excel Workbook.srt
3. Editing an Existing Query.srt
2. Common Power Query Transformations.srt
1. Exploring the Power Query Editor.srt
7. Get Data From the Web.srt
6. IMPORTANT Checking the Location of your Query's Source.srt
8. Practise Exercise.srt
9. Section 31 Quiz.html
3. Editing an Existing Query.mp4
4. Import Multiple Files from a Folder.mp4
2. Common Power Query Transformations.mp4
5. Connect to Data in Another Excel Workbook.mp4
7. Get Data From the Web.mp4
1. Exploring the Power Query Editor.mp4
6. IMPORTANT Checking the Location of your Query's Source.mp4
8. Practise Exercise.mp4
3. Date and Time Functions
3. Complex Date and Time Functions.srt
1. How Date and Time Works.srt
2. Basic Date and Time Functions.srt
4. Section 3 Quiz.html
3. Complex Date and Time Functions.mp4
1. How Date and Time Works.mp4
2. Basic Date and Time Functions.mp4
20. Introducing Functions
5. The Worksheet Function Object.srt
7. The Range Object.srt
6. Completing Exercise 5.srt
3. Sending Values to Functions.srt
8. Writing an Array Formula.srt
2. Returning Values from Functions.srt
1. Functions.srt
4. Determining Limitations.srt
5. The Worksheet Function Object.mp4
7. The Range Object.mp4
6. Completing Exercise 5.mp4
3. Sending Values to Functions.mp4
8. Writing an Array Formula.mp4
4. Determining Limitations.mp4
1. Functions.mp4
2. Returning Values from Functions.mp4
17. The Environment
2. The VBA Editor.srt
3. First Coding Manipulations.srt
1. Getting Started.srt
1. Getting Started.mp4
3. First Coding Manipulations.mp4
2. The VBA Editor.mp4
14. Excel Web App
1. Web App - Part 1.srt
2. Web App - Part 2.srt
3. Section 14 Quiz.html
1. Web App - Part 1.mp4
2. Web App - Part 2.mp4
13. Graphs and Charts
8. Section 13 Quiz.html
5. Sparklines.srt
6. Stock Charts.srt
4. Bubble Charts.srt
1. Area Charts.srt
3. Radar Charts.srt
2. Surface Charts.srt
7. Exercise 9.srt
5. Sparklines.mp4
6. Stock Charts.mp4
1. Area Charts.mp4
4. Bubble Charts.mp4
2. Surface Charts.mp4
3. Radar Charts.mp4
7. Exercise 9.mp4
15. Course Conclusion
1. Close.srt
1. Close.mp4
28. External References and Office Interop
4. ADODB Library.srt
2. Reference Object.srt
5. The Scripting Library.srt
1. What are References How do they work.srt
3. Office Libraries.srt
4. ADODB Library.mp4
1. What are References How do they work.mp4
5. The Scripting Library.mp4
2. Reference Object.mp4
3. Office Libraries.mp4
35. More DAX Measures
1. Create a Date Table in Power Pivot.srt
5. Calculate the Percentage of a Total.srt
2. The CALCULATE Function.srt
3. The DIVIDE Function.srt
4. Using the DATESYTD Function.srt
6. Practise Exercise.srt
7. Section 35 Quiz.html
1. Create a Date Table in Power Pivot.mp4
5. Calculate the Percentage of a Total.mp4
2. The CALCULATE Function.mp4
3. The DIVIDE Function.mp4
4. Using the DATESYTD Function.mp4
6. Practise Exercise.mp4
22. Conclusion
1. Concluding Remarks.srt
2. Course Quiz.html
1. Concluding Remarks.mp4
29. Conclusion
1. Course Conclusion.srt
2. Course Quiz.html
1. Course Conclusion.mp4
34. Introduction to DAX
3. Creating your First DAX Measure.srt
2. Creating Calculated Columns with DAX.srt
4. The COUNTROWS Function.srt
5. SUMX and RELATED Functions.srt
1. Why use DAX.srt
6. Practise Exercise.srt
7. Section 34 Quiz.html
2. Creating Calculated Columns with DAX.mp4
3. Creating your First DAX Measure.mp4
4. The COUNTROWS Function.mp4
5. SUMX and RELATED Functions.mp4
1. Why use DAX.mp4
6. Practise Exercise.mp4
33. Creating the Data Model
3. Creating Relationships Between tables.srt
2. Understanding the Power Pivot Window.srt
5. Creating a PivotTable from the Data Model.srt
7. Grouping Queries.srt
4. Managing the Relationships of the Model.srt
6. Hide Fields from Client Tools.srt
1. Enable the Power Pivot Add-In.srt
8. Practise Exercise.srt
9. Section 33 Quiz.html
7. Grouping Queries.mp4
2. Understanding the Power Pivot Window.mp4
5. Creating a PivotTable from the Data Model.mp4
6. Hide Fields from Client Tools.mp4
3. Creating Relationships Between tables.mp4
4. Managing the Relationships of the Model.mp4
1. Enable the Power Pivot Add-In.mp4
8. Practise Exercise.mp4
37. Closing
1. Wrap Up.srt
1. Wrap Up.mp4
50. Course Close
1. Course Close.srt
1. Course Close.mp4
TutsNode.net.txt
.pad
0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
[TGx]Downloaded from torrentgalaxy.to .txt
Torrent description
Feel free to post any comments about this torrent, including links to Subtitle, samples, screenshots, or any other relevant information, Watch The Advanced Excel, Power Pivot & VBA Bundle Online Free Full Movies Like 123Movies, Putlockers, Fmovies, Netflix or Download Direct via Magnet Link in Torrent Details.
