The Advanced Excel Power Pivot VBA Bundle | D36C59CC690A1BDADEA4846330CCC1CD508C5350

The Advanced Excel Power Pivot VBA Bundle

Name	The Advanced Excel, Power Pivot & VBA Bundle	DOWNLOAD Copy Link
Total Size	17.4 GB
Total Files	744
Last Seen	2025-02-20 00:40
Hash	D36C59CC690A1BDADEA4846330CCC1CD508C5350

/51. Extras/
1. EXTRA LESSON Getting Started with Power Pivot and Power Query in Excel Webinar.mp4	582.3 MB
1. EXTRA LESSON Getting Started with Power Pivot and Power Query in Excel Webinar.srt	85.9 KB
2. EXTRA RESOURCE The Most Frequently Used Excel Shortcuts - Infographic.html	0.0 KB
2.1 PC Excel Most Used.pdf	2.3 MB
/
TutsNode.net.txt	0.1 KB
[TGx]Downloaded from torrentgalaxy.to .txt	0.6 KB
/.../23. VBA Intermediate Training Discover Excel Automation Secrets/
4.1 VBA-Intermediate-Support-Files.zip	651.7 KB
3.1 VBA-Intermediate-Exercise-Files.zip	1.3 MB
2. WATCH ME Essential Information for a Successful Training Experience.srt	2.0 KB
3. Course exercise and solution files.html	1.0 KB
4. Course support files.html	1.0 KB
1. Introduction.srt	3.7 KB
2. WATCH ME Essential Information for a Successful Training Experience.mp4	39.7 MB
1. Introduction.mp4	29.2 MB
/.../38. Advanced Pivot Tables Introduction/
5. PivotTables Recap.srt	19.2 KB
1. Introduction to Advanced PivotTables.srt	5.3 KB
2. WATCH ME Essential Information for a Successful Training Experience.srt	2.0 KB
3. DOWNLOAD ME Course Exercise Files.html	1.0 KB
4. DOWNLOAD ME Course Support Files.html	1.0 KB
6. Section Quiz.html	0.2 KB
5. PivotTables Recap.mp4	132.0 MB
2. WATCH ME Essential Information for a Successful Training Experience.mp4	39.7 MB
1. Introduction to Advanced PivotTables.mp4	36.6 MB
4.1 Advanced Pivot Tables Course Files.zip	28.4 MB
3.1 Advanced Pivot Tables Exercise Files.zip	2.5 MB
/.../1. Introduction to Excel 2019 Advanced Course/
2. WATCH ME Essential Information for a Successful Training Experience.srt	2.0 KB
3. Excel 2019 Advanced Course Exercise Files.html	0.9 KB
4. Excel 2019 Advanced Course Demo Files.html	0.9 KB
5. Downloadable Course Transcripts.html	0.7 KB
5.1 Microsoft Excel 2019 Advanced Course by Simon Sez IT .pdf	933.3 KB
1. Introduction to the Course.srt	8.8 KB
6. Course Structure.srt	5.9 KB
1. Introduction to the Course.mp4	78.9 MB
2. WATCH ME Essential Information for a Successful Training Experience.mp4	39.7 MB
6. Course Structure.mp4	29.3 MB
4.1 Excel 2019 Advaned Course Files.zip	10.3 MB
3.1 Excel 2019 Advanced Exercise Files.zip	2.4 MB
/.../16. Essential VBA Training for Excel - Automate Repetitive Tasks Introduction/
3.1 VBA-Exercise-and-Solution-Files.zip	360.9 KB
2. WATCH ME Essential Information for a Successful Training Experience.srt	1.8 KB
3. Course Exercise and Solution Files.html	0.9 KB
1. Introduction to the VBA Course.srt	3.7 KB
2. WATCH ME Essential Information for a Successful Training Experience.mp4	36.6 MB
1. Introduction to the VBA Course.mp4	11.6 MB
/52. Bonuses/
1. Ten Excel Tips and Tricks - Part 1.srt	63.2 KB
2. Ten Excel Tips and Tricks - Part 2.srt	60.1 KB
3. Ten Excel Tips and Tricks - Part 3.srt	48.3 KB
1. Ten Excel Tips and Tricks - Part 1.mp4	353.0 MB
3. Ten Excel Tips and Tricks - Part 3.mp4	333.2 MB
2. Ten Excel Tips and Tricks - Part 2.mp4	308.0 MB
/49. Dashboards/
1. Creating an Interactive Dashboard - Part 1.srt	33.0 KB
2. Creating an Interactive Dashboard - Part 2.srt	19.8 KB
4. Exercise 11.srt	5.2 KB
3. Updating Pivot Charts and PivotTables.srt	6.2 KB
5. Section Quiz.html	0.2 KB
1. Creating an Interactive Dashboard - Part 1.mp4	182.7 MB
2. Creating an Interactive Dashboard - Part 2.mp4	125.7 MB
3. Updating Pivot Charts and PivotTables.mp4	53.9 MB
4. Exercise 11.mp4	33.0 MB
/.../40. Preparing Data for Analysis/
1. Cleaning Data.srt	25.9 KB
2. Tabular Data.srt	23.3 KB
3. Exercise 02.srt	4.3 KB
4. Section Quiz.html	0.2 KB
2. Tabular Data.mp4	231.3 MB
1. Cleaning Data.mp4	172.8 MB
3. Exercise 02.mp4	25.1 MB
/.../47. Pivot Charts/
3. Formatting a Pivot Chart - Part 2.srt	23.8 KB
2. Formatting a Pivot Chart - Part 1.srt	23.5 KB
5. Dynamic Chart Titles.srt	19.9 KB
1. Creating a Pivot Chart.srt	17.3 KB
4. Creating a Map Chart using Pivot Data.srt	16.8 KB
6. Include a Sparkline with your PivotTable.srt	15.4 KB
7. Exercise 09.srt	10.9 KB
8. Section Quiz.html	0.2 KB
3. Formatting a Pivot Chart - Part 2.mp4	136.8 MB
2. Formatting a Pivot Chart - Part 1.mp4	126.7 MB
4. Creating a Map Chart using Pivot Data.mp4	118.7 MB
1. Creating a Pivot Chart.mp4	108.7 MB
6. Include a Sparkline with your PivotTable.mp4	101.3 MB
5. Dynamic Chart Titles.mp4	91.0 MB
7. Exercise 09.mp4	57.9 MB
/.../42. Formatting PivotTables/
2. Custom Number Formatting.srt	23.6 KB
1. PivotTable Styles.srt	17.0 KB
3. Exercise 04.srt	2.4 KB
4. Section Quiz.html	0.2 KB
2. Custom Number Formatting.mp4	171.2 MB
1. PivotTable Styles.mp4	136.1 MB
3. Exercise 04.mp4	18.7 MB
/2. Functions/
4. Section 2 Quiz.html	0.2 KB
1. Functions - Part 1.srt	17.1 KB
2. Functions - Part 2.srt	10.8 KB
3. Autosum.srt	7.3 KB
1. Functions - Part 1.mp4	103.0 MB
2. Functions - Part 2.mp4	60.9 MB
3. Autosum.mp4	43.3 MB
/.../44. Sorting and Filtering/
2. Advanced Filtering.srt	19.8 KB
1. Advanced Sorting.srt	12.2 KB
3. Exercise 06.srt	3.3 KB
4. Section Quiz.html	0.2 KB
2. Advanced Filtering.mp4	113.0 MB
1. Advanced Sorting.mp4	71.6 MB
3. Exercise 06.mp4	21.2 MB
/.../45. Interacting with PivotTables/
1. Inserting and formatting Slicers.srt	19.8 KB
3. Connecting Slicers to multiple PivotTables.srt	11.5 KB
2. Inserting and formatting Timelines.srt	9.7 KB
4. Using Slicers in Protected Workbooks.srt	8.0 KB
5. Exercise 07.srt	3.1 KB
6. Section Quiz.html	0.2 KB
1. Inserting and formatting Slicers.mp4	150.7 MB
3. Connecting Slicers to multiple PivotTables.mp4	82.4 MB
2. Inserting and formatting Timelines.mp4	68.1 MB
4. Using Slicers in Protected Workbooks.mp4	51.9 MB
5. Exercise 07.mp4	20.1 MB
/.../32. Useful Power Query Features/
7. Conditional Columns in Power Query.srt	8.1 KB
5. Duplicating and Referencing Queries.srt	10.5 KB
6. Grouping and Aggregating Data.srt	8.9 KB
2. Combine Data from Multiple Tables with Merge Queries.srt	7.6 KB
4. Stack Data into One Table with Append Queries.srt	6.9 KB
3. Use Merge Queries to Compare Two Tables.srt	5.9 KB
1. Unpivoting Columns.srt	5.4 KB
8. Practise Exercise.srt	1.2 KB
9. Section 32 Quiz.html	0.2 KB
5. Duplicating and Referencing Queries.mp4	73.2 MB
6. Grouping and Aggregating Data.mp4	64.5 MB
7. Conditional Columns in Power Query.mp4	51.3 MB
1. Unpivoting Columns.mp4	47.8 MB
4. Stack Data into One Table with Append Queries.mp4	45.4 MB
2. Combine Data from Multiple Tables with Merge Queries.mp4	40.8 MB
3. Use Merge Queries to Compare Two Tables.mp4	34.2 MB
8. Practise Exercise.mp4	10.9 MB
/.pad/
0	0.1 KB
1	1.3 MB
2	233.8 KB
3	285.5 KB
4	1.5 MB
5	1.8 MB
6	2.1 MB
7	1.3 MB
8	745.2 KB
9	515.2 KB
10	257.4 KB
11	86.7 KB
12	428.1 KB
13	445.4 KB
14	2.0 MB
15	1.6 MB
16	1.6 MB
17	232.7 KB
18	1.4 MB
19	153.7 KB
20	44.0 KB
21	1.3 MB
22	153.9 KB
23	1.1 MB
24	1.8 MB
25	258.9 KB
26	523.9 KB
27	1.2 MB
28	419.6 KB
29	2.0 MB
30	837.2 KB
31	1.4 MB
32	156.7 KB
33	508.9 KB
34	243.2 KB
35	248.0 KB
36	490.6 KB
37	1.1 MB
38	1.9 MB
39	1.6 MB
40	376.4 KB
41	1.8 MB
42	1.9 MB
43	70.7 KB
44	1.9 MB
45	807.8 KB
46	1.1 MB
47	1.5 MB
48	1.5 MB
49	1.7 MB
50	290.0 KB
51	428.9 KB
52	1.5 MB
53	1.6 MB
54	855.0 KB
55	1.1 MB
56	1.6 MB
57	1.9 MB
58	467.4 KB
59	1.7 MB
60	541.8 KB
61	941.1 KB
62	2.0 MB
63	575.8 KB
64	784.5 KB
65	1.1 MB
66	1.3 MB
67	1.3 MB
68	1.8 MB
69	2.0 MB
70	1.3 MB
71	1.5 MB
72	118.4 KB
73	432.7 KB
74	1.2 MB
75	1.5 MB
76	93.9 KB
77	1.1 MB
78	1.3 MB
79	332.6 KB
80	665.2 KB
81	1.2 MB
82	1.3 MB
83	1.3 MB
84	1.5 MB
85	1.5 MB
86	888.3 KB
87	1.0 MB
88	1.7 MB
89	789.9 KB
90	1.1 MB
91	1.1 MB
92	1.1 MB
93	1.7 MB
94	1.9 MB
95	132.4 KB
96	512.1 KB
97	1.1 MB
98	1.2 MB
99	1.9 MB
100	2.0 MB
101	70.1 KB
102	588.6 KB
103	655.6 KB
104	782.6 KB
105	1.1 MB
106	205.6 KB
107	579.3 KB
108	636.2 KB
109	1.1 MB
110	1.8 MB
111	603.4 KB
112	791.9 KB
113	1.1 MB
114	1.3 MB
115	1.4 MB
116	123.3 KB
117	192.5 KB
118	383.8 KB
119	1.6 MB
120	1.7 MB
121	2.0 MB
122	539.1 KB
123	703.4 KB
124	1.3 MB
125	621.4 KB
126	1.7 MB
127	2.0 MB
128	2.0 MB
129	109.4 KB
130	202.5 KB
131	1.5 MB
132	1.5 MB
133	1.6 MB
134	1.9 MB
135	2.1 MB
136	590.8 KB
137	794.2 KB
138	1.4 MB
139	209.8 KB
140	649.5 KB
141	1.3 MB
142	479.1 KB
143	494.2 KB
144	1.1 MB
145	668.3 KB
146	684.6 KB
147	886.9 KB
148	1.1 MB
149	1.6 MB
150	438.1 KB
151	1.1 MB
152	2.0 MB
153	511.1 KB
154	602.5 KB
155	725.6 KB
156	1.1 MB
157	758.2 KB
158	1.1 MB
159	1.1 MB
160	1.4 MB
161	1.6 MB
162	1.9 MB
163	380.4 KB
164	629.5 KB
165	1.1 MB
166	2.1 MB
167	111.7 KB
168	136.0 KB
169	148.8 KB
170	149.4 KB
171	932.2 KB
172	1.3 MB
173	2.0 MB
174	444.7 KB
175	1.1 MB
176	1.1 MB
177	1.5 MB
178	533.7 KB
179	648.5 KB
180	723.7 KB
181	1.4 MB
182	793.7 KB
183	55.8 KB
184	187.6 KB
185	595.0 KB
186	957.8 KB
187	21.1 KB
188	856.6 KB
189	946.4 KB
190	81.2 KB
191	554.5 KB
192	1.1 MB
193	1.3 MB
194	1.0 MB
195	1.9 MB
196	540.9 KB
197	919.8 KB
198	20.0 KB
199	148.9 KB
200	1.1 MB
201	1.4 MB
202	1.8 MB
203	78.7 KB
204	513.5 KB
205	598.0 KB
206	992.3 KB
207	1.2 MB
208	1.5 MB
209	1.5 MB
210	1.8 MB
211	767.3 KB
212	796.1 KB
213	807.4 KB
214	1.2 MB
215	1.6 MB
216	1.8 MB
217	2.0 MB
218	437.7 KB
219	993.6 KB
220	1.4 MB
221	1.6 MB
222	1.7 MB
223	225.1 KB
224	886.5 KB
225	1.1 MB
226	49.1 KB
227	602.1 KB
228	831.1 KB
229	1.5 MB
230	1.7 MB
231	1.8 MB
/.../30. Power Pivot, Power Query & Dax Introduction/
3.1 Exercise Files.zip	1.3 MB
5. What is Power Query.srt	5.6 KB
6. What is Power Pivot.srt	3.9 KB
1. Welcome and Overview.srt	3.0 KB
2. WATCH ME Essential Information for a Successful Training Experience.srt	2.0 KB
4. Course Demo Files.html	1.0 KB
3. Course Exercise Files.html	1.0 KB
7. Section 30 Quiz.html	0.2 KB
2. WATCH ME Essential Information for a Successful Training Experience.mp4	39.9 MB
4.1 PowerQuery, PowerPivot and Dax Demo Files.zip	27.2 MB
5. What is Power Query.mp4	17.8 MB
6. What is Power Pivot.mp4	13.1 MB
1. Welcome and Overview.mp4	12.9 MB
/.../21. Common Keys to VBA/
8. One Approach To Completing Exercise 8.srt	18.9 KB
3. Using Errors to Guide You.srt	18.2 KB
2. The Workbook and Worksheet Objects.srt	17.4 KB
7. The PageSetup Object and Print Ranges.srt	17.3 KB
1. The Application Object.srt	14.6 KB
6. The Chart and ChartObject Objects.srt	13.6 KB
5. The PivotTable Object.srt	9.6 KB
4. The Name and Names Objects.srt	9.2 KB
8. One Approach To Completing Exercise 8.mp4	142.2 MB
7. The PageSetup Object and Print Ranges.mp4	140.6 MB
3. Using Errors to Guide You.mp4	112.8 MB
2. The Workbook and Worksheet Objects.mp4	101.6 MB
6. The Chart and ChartObject Objects.mp4	101.0 MB
1. The Application Object.mp4	92.4 MB
4. The Name and Names Objects.mp4	84.9 MB
5. The PivotTable Object.mp4	78.0 MB
/.../9. Connecting to External Data/
4. Get and Transform.srt	18.6 KB
1. Connecting to Other workbooks.srt	16.7 KB
2. Connecting to Access Databases.srt	16.1 KB
6. Section 9 Quiz.html	0.2 KB
3. Connecting Web Data Sources.srt	10.1 KB
5. Exercise 05.srt	7.0 KB
4. Get and Transform.mp4	152.6 MB
1. Connecting to Other workbooks.mp4	121.2 MB
2. Connecting to Access Databases.mp4	118.1 MB
3. Connecting Web Data Sources.mp4	82.4 MB
5. Exercise 05.mp4	46.2 MB
/4. Text Functions/
3. Section 4 Quiz.html	0.2 KB
1. Using Text Functions - Part 1.srt	14.8 KB
2. Using Text Functions - Part 2.srt	13.7 KB
2. Using Text Functions - Part 2.mp4	182.5 MB
1. Using Text Functions - Part 1.mp4	142.2 MB
/.../24. VBA Language Details/
6. The VBA Project Model.srt	18.3 KB
7. Advanced Parameter Definitions.srt	16.4 KB
4. Detailed Memory Management.srt	11.7 KB
5. Code Module Interactions.srt	11.2 KB
3. Code Modules.srt	10.1 KB
2. Excel File Types.srt	10.0 KB
1. Chapter 2 Preview.srt	2.8 KB
6. The VBA Project Model.mp4	112.2 MB
7. Advanced Parameter Definitions.mp4	93.4 MB
2. Excel File Types.mp4	77.8 MB
4. Detailed Memory Management.mp4	77.5 MB
3. Code Modules.mp4	68.4 MB
5. Code Module Interactions.mp4	65.4 MB
1. Chapter 2 Preview.mp4	17.1 MB
/.../19. Introducing Macros/
6. Looping Collections and the For Each Loop.srt	6.5 KB
4. Methods for Communicating to the User.srt	12.5 KB
5. Looping The For and Do While Loops.srt	9.4 KB
2. Logical Constructs The Boolean Type.srt	8.7 KB
1. Subroutines.srt	7.7 KB
3. Logical Constructs If and Switch Statements.srt	7.1 KB
4. Methods for Communicating to the User.mp4	65.1 MB
5. Looping The For and Do While Loops.mp4	63.7 MB
6. Looping Collections and the For Each Loop.mp4	48.8 MB
1. Subroutines.mp4	42.9 MB
3. Logical Constructs If and Switch Statements.mp4	28.8 MB
2. Logical Constructs The Boolean Type.mp4	13.9 MB
/5. Logical Functions/
2. Exercise 01.srt	2.6 KB
3. Section 5 Quiz.html	0.2 KB
1. Logical Functions.srt	11.2 KB
1. Logical Functions.mp4	74.4 MB
2. Exercise 01.mp4	13.4 MB
/.../41. Creating and Manipulating PivotTables/
1. Creating and Manipulating a PivotTable.srt	18.2 KB
2. Combining Data from Multiple Worksheets.srt	17.6 KB
4. Report Layouts.srt	16.1 KB
3. Grouping and Ungrouping.srt	15.6 KB
5. Formatting Error Values and Empty Cells.srt	12.0 KB
6. Exercise 03.srt	2.2 KB
7. Section Quiz.html	0.2 KB
1. Creating and Manipulating a PivotTable.mp4	144.6 MB
4. Report Layouts.mp4	107.3 MB
3. Grouping and Ungrouping.mp4	101.2 MB
2. Combining Data from Multiple Worksheets.mp4	94.8 MB
5. Formatting Error Values and Empty Cells.mp4	90.3 MB
6. Exercise 03.mp4	13.9 MB
/.../26. Custom Objects/
12. Designing a Userform.srt	17.7 KB
11. Creating a Userform.srt	16.1 KB
5. Practical Example of a Class.srt	15.4 KB
13. Coding a Userform.srt	15.0 KB
8. Initialization and Termination.srt	13.6 KB
7. Special Class Variables and Components.srt	13.5 KB
4. Defining a Class.srt	13.4 KB
3. Create a New Class.srt	13.4 KB
9. VBA Attributes and Usage.srt	12.9 KB
10. Inheritance - Defining the Bookmarks Support Class.srt	12.8 KB
6. Practice Test of a Class.srt	11.8 KB
1. Chapter Overview + New Keyword.srt	10.8 KB
2. Creating A Custom Type.srt	8.7 KB
12. Designing a Userform.mp4	123.5 MB
11. Creating a Userform.mp4	104.8 MB
13. Coding a Userform.mp4	102.0 MB
5. Practical Example of a Class.mp4	97.5 MB
7. Special Class Variables and Components.mp4	96.7 MB
10. Inheritance - Defining the Bookmarks Support Class.mp4	91.1 MB
3. Create a New Class.mp4	83.6 MB
9. VBA Attributes and Usage.mp4	83.2 MB
1. Chapter Overview + New Keyword.mp4	80.9 MB
6. Practice Test of a Class.mp4	76.4 MB
2. Creating A Custom Type.mp4	74.8 MB
8. Initialization and Termination.mp4	67.9 MB
4. Defining a Class.mp4	65.5 MB
/.../27. External References and Office Interop/
1. Modding the Excel Interface.srt	17.5 KB
3. UI Interface Control Options and Access.srt	14.1 KB
4. Piecing the UI Pieces Together.srt	12.9 KB
2. UI Interface Scope and Range.srt	6.3 KB
1. Modding the Excel Interface.mp4	109.6 MB
3. UI Interface Control Options and Access.mp4	91.7 MB
2. UI Interface Scope and Range.mp4	42.1 MB
4. Piecing the UI Pieces Together.mp4	30.7 MB
/6. Lookup Functions/
4. Section 6 Quiz.html	0.2 KB
1. Lookup Functions - Part 1.srt	16.5 KB
2. Lookup Functions - Part 2.srt	9.7 KB
3. Exercise 02.srt	7.5 KB
1. Lookup Functions - Part 1.mp4	113.0 MB
2. Lookup Functions - Part 2.mp4	67.8 MB
3. Exercise 02.mp4	47.1 MB
/8. Statistical Functions/
2. Statistical Functions for Description - Part 2.srt	16.5 KB
5. Exercise 04.srt	2.0 KB
1. Statistical Functions for Description - Part 1.srt	15.0 KB
8. Section 8 Quiz.html	0.2 KB
4. Statistical Functions for Forecasting - Part 2.srt	14.3 KB
7. Statistical Functions for Inference.srt	13.0 KB
3. Statistical Functions for Forecasting - Part 1.srt	11.7 KB
6. One Click Forecasting.srt	11.1 KB
2. Statistical Functions for Description - Part 2.mp4	124.0 MB
1. Statistical Functions for Description - Part 1.mp4	123.2 MB
4. Statistical Functions for Forecasting - Part 2.mp4	100.4 MB
6. One Click Forecasting.mp4	91.5 MB
7. Statistical Functions for Inference.mp4	91.0 MB
3. Statistical Functions for Forecasting - Part 1.mp4	88.0 MB
5. Exercise 04.mp4	15.5 MB
/7. Financial Functions/
5. Exercise 03.srt	2.0 KB
6. Section 7 Quiz.html	0.2 KB
1. Financial Functions and Terminology.srt	11.1 KB
2. Personal Financial Functions.srt	10.8 KB
3. Principal and Interest Payments.srt	7.7 KB
4. Depreciation.srt	5.6 KB
2. Personal Financial Functions.mp4	75.6 MB
3. Principal and Interest Payments.mp4	58.8 MB
1. Financial Functions and Terminology.mp4	58.1 MB
4. Depreciation.mp4	38.9 MB
5. Exercise 03.mp4	15.8 MB
/.../43. Value Field Settings/
1. Summarizing Values.srt	16.1 KB
2. Show Values As.srt	12.2 KB
3. Exercise 05.srt	2.4 KB
4. Section Quiz.html	0.2 KB
1. Summarizing Values.mp4	122.5 MB
2. Show Values As.mp4	76.5 MB
3. Exercise 05.mp4	17.5 MB
/.../11. Pivot Tables/
3. Filters and Slicers.srt	15.9 KB
2. Working with Pivot Tables.srt	15.5 KB
5. Exercise 07.srt	3.0 KB
6. Section 11 Quiz.html	0.2 KB
1. Introduction to Pivot Tables.srt	12.8 KB
4. Pivot and Charts.srt	10.7 KB
2. Working with Pivot Tables.mp4	138.9 MB
3. Filters and Slicers.mp4	130.0 MB
1. Introduction to Pivot Tables.mp4	99.1 MB
4. Pivot and Charts.mp4	77.1 MB
5. Exercise 07.mp4	24.6 MB
/.../48. Conditional Formatting/
2. Graphical Conditional Formats.srt	15.4 KB
1. Highlighting Cell Rules.srt	14.2 KB
3. Conditional Formatting and Slicers.srt	9.3 KB
4. Exercise 10.srt	3.4 KB
5. Section Quiz.html	0.2 KB
2. Graphical Conditional Formats.mp4	117.3 MB
1. Highlighting Cell Rules.mp4	96.0 MB
3. Conditional Formatting and Slicers.mp4	82.6 MB
4. Exercise 10.mp4	26.4 MB
/10. Tables/
1. Introduction to Tables.srt	15.0 KB
5. Exercise 6.srt	1.7 KB
6. Section 10 Quiz.html	0.2 KB
2. Working with Tables.srt	12.9 KB
3. Table References.srt	9.9 KB
4. Table Styles.srt	6.9 KB
1. Introduction to Tables.mp4	119.6 MB
2. Working with Tables.mp4	100.2 MB
3. Table References.mp4	78.6 MB
4. Table Styles.mp4	56.4 MB
5. Exercise 6.mp4	12.7 MB
/.../39. Importing Data/
1. Importing data from a text file.srt	15.0 KB
2. Importing data from Access.srt	12.6 KB
3. Exercise 01.srt	6.8 KB
4. Section Quiz.html	0.2 KB
1. Importing data from a text file.mp4	111.3 MB
2. Importing data from Access.mp4	88.7 MB
3. Exercise 01.mp4	32.9 MB
/.../25. Excel Events/
4. A Series Of Example Events.srt	14.1 KB
5. Application Events.srt	10.2 KB
2. Pre-Defined Events.srt	10.2 KB
3. Event Parameters.srt	9.7 KB
1. What Are Events.srt	2.2 KB
4. A Series Of Example Events.mp4	84.7 MB
5. Application Events.mp4	67.0 MB
3. Event Parameters.mp4	64.3 MB
2. Pre-Defined Events.mp4	51.9 MB
1. What Are Events.mp4	18.9 MB
/.../18. VBA as a Language/
4. How to Define and Manage Variables.srt	13.9 KB
3. Variables and Method Calling Rules.srt	13.3 KB
1. VBA Syntax, Keywords, and Comments.srt	12.5 KB
2. Objects and VBA's Intellitext.srt	9.3 KB
5. Constant Variable Types and Variables through Intellitext.srt	5.2 KB
4. How to Define and Manage Variables.mp4	66.9 MB
3. Variables and Method Calling Rules.mp4	57.4 MB
1. VBA Syntax, Keywords, and Comments.mp4	49.4 MB
2. Objects and VBA's Intellitext.mp4	42.6 MB
5. Constant Variable Types and Variables through Intellitext.mp4	23.8 MB
/46. Calculations/
3. Solve Order and List Formulas.srt	13.5 KB
4. GETPIVOTDATA.srt	12.9 KB
1. Creating a Calculated Field.srt	11.6 KB
2. Creating a Calculated Item.srt	11.1 KB
5. Exercise 08.srt	9.7 KB
6. Section Quiz.html	0.2 KB
4. GETPIVOTDATA.mp4	93.8 MB
2. Creating a Calculated Item.mp4	86.5 MB
3. Solve Order and List Formulas.mp4	78.6 MB
1. Creating a Calculated Field.mp4	72.8 MB
5. Exercise 08.mp4	59.3 MB
/.../36. Using PivotTables and Slicers/
1. Create PivotTables and PivotCharts.srt	13.5 KB
3. Create a Top 10 PivotTable.srt	9.8 KB
2. Using Slicers with your PivotTables.srt	7.0 KB
4. Practise Exercise.srt	0.7 KB
5. Section 36 Quiz.html	0.2 KB
1. Create PivotTables and PivotCharts.mp4	114.8 MB
3. Create a Top 10 PivotTable.mp4	82.6 MB
2. Using Slicers with your PivotTables.mp4	59.3 MB
4. Practise Exercise.mp4	7.6 MB
/.../12. Data Analysis/
4. Solver.srt	13.4 KB
2. Scenario Manager.srt	13.3 KB
5. Exercise 08.srt	1.9 KB
6. Section 12 Quiz.html	0.2 KB
1. What If Analysis.srt	12.0 KB
3. Goal Seek.srt	8.3 KB
2. Scenario Manager.mp4	132.8 MB
4. Solver.mp4	97.7 MB
1. What If Analysis.mp4	75.4 MB
3. Goal Seek.mp4	53.2 MB
5. Exercise 08.mp4	13.9 MB
/.../31. Getting Started with Power Query/
4. Import Multiple Files from a Folder.srt	13.4 KB
5. Connect to Data in Another Excel Workbook.srt	11.5 KB
3. Editing an Existing Query.srt	11.3 KB
2. Common Power Query Transformations.srt	9.6 KB
1. Exploring the Power Query Editor.srt	7.2 KB
7. Get Data From the Web.srt	6.4 KB
6. IMPORTANT Checking the Location of your Query's Source.srt	4.0 KB
8. Practise Exercise.srt	0.9 KB
9. Section 31 Quiz.html	0.2 KB
3. Editing an Existing Query.mp4	97.0 MB
4. Import Multiple Files from a Folder.mp4	90.4 MB
2. Common Power Query Transformations.mp4	75.7 MB
5. Connect to Data in Another Excel Workbook.mp4	72.3 MB
7. Get Data From the Web.mp4	60.6 MB
1. Exploring the Power Query Editor.mp4	49.3 MB
6. IMPORTANT Checking the Location of your Query's Source.mp4	26.3 MB
8. Practise Exercise.mp4	11.2 MB
/.../3. Date and Time Functions/
3. Complex Date and Time Functions.srt	13.3 KB
1. How Date and Time Works.srt	12.0 KB
2. Basic Date and Time Functions.srt	11.1 KB
4. Section 3 Quiz.html	0.2 KB
3. Complex Date and Time Functions.mp4	88.9 MB
1. How Date and Time Works.mp4	82.7 MB
2. Basic Date and Time Functions.mp4	74.9 MB
/.../20. Introducing Functions/
5. The Worksheet Function Object.srt	13.0 KB
7. The Range Object.srt	12.3 KB
6. Completing Exercise 5.srt	11.2 KB
3. Sending Values to Functions.srt	9.8 KB
8. Writing an Array Formula.srt	7.4 KB
2. Returning Values from Functions.srt	7.2 KB
1. Functions.srt	7.1 KB
4. Determining Limitations.srt	6.9 KB
5. The Worksheet Function Object.mp4	107.1 MB
7. The Range Object.mp4	85.9 MB
6. Completing Exercise 5.mp4	78.6 MB
3. Sending Values to Functions.mp4	66.7 MB
8. Writing an Array Formula.mp4	58.9 MB
4. Determining Limitations.mp4	43.0 MB
1. Functions.mp4	38.6 MB
2. Returning Values from Functions.mp4	16.7 MB
/.../17. The Environment/
2. The VBA Editor.srt	13.0 KB
3. First Coding Manipulations.srt	11.9 KB
1. Getting Started.srt	8.8 KB
1. Getting Started.mp4	80.1 MB
3. First Coding Manipulations.mp4	68.6 MB
2. The VBA Editor.mp4	62.3 MB
/.../14. Excel Web App/
1. Web App - Part 1.srt	12.7 KB
2. Web App - Part 2.srt	11.9 KB
3. Section 14 Quiz.html	0.2 KB
1. Web App - Part 1.mp4	87.6 MB
2. Web App - Part 2.mp4	80.8 MB
/.../13. Graphs and Charts/
8. Section 13 Quiz.html	0.2 KB
5. Sparklines.srt	10.7 KB
6. Stock Charts.srt	10.5 KB
4. Bubble Charts.srt	8.4 KB
1. Area Charts.srt	7.6 KB
3. Radar Charts.srt	6.5 KB
2. Surface Charts.srt	5.2 KB
7. Exercise 9.srt	4.4 KB
5. Sparklines.mp4	124.8 MB
6. Stock Charts.mp4	99.1 MB
1. Area Charts.mp4	86.9 MB
4. Bubble Charts.mp4	59.3 MB
2. Surface Charts.mp4	45.5 MB
3. Radar Charts.mp4	42.5 MB
7. Exercise 9.mp4	41.6 MB
/.../15. Course Conclusion/
1. Close.srt	1.0 KB
1. Close.mp4	8.3 MB
/.../28. External References and Office Interop/
4. ADODB Library.srt	10.0 KB
2. Reference Object.srt	9.7 KB
5. The Scripting Library.srt	9.0 KB
1. What are References How do they work.srt	8.7 KB
3. Office Libraries.srt	6.2 KB
4. ADODB Library.mp4	72.8 MB
1. What are References How do they work.mp4	61.2 MB
5. The Scripting Library.mp4	60.9 MB
2. Reference Object.mp4	60.7 MB
3. Office Libraries.mp4	45.0 MB
/.../35. More DAX Measures/
1. Create a Date Table in Power Pivot.srt	9.7 KB
5. Calculate the Percentage of a Total.srt	6.7 KB
2. The CALCULATE Function.srt	3.5 KB
3. The DIVIDE Function.srt	3.2 KB
4. Using the DATESYTD Function.srt	2.4 KB
6. Practise Exercise.srt	0.9 KB
7. Section 35 Quiz.html	0.2 KB
1. Create a Date Table in Power Pivot.mp4	74.7 MB
5. Calculate the Percentage of a Total.mp4	45.6 MB
2. The CALCULATE Function.mp4	22.0 MB
3. The DIVIDE Function.mp4	20.4 MB
4. Using the DATESYTD Function.mp4	14.9 MB
6. Practise Exercise.mp4	11.0 MB
/22. Conclusion/
1. Concluding Remarks.srt	7.4 KB
2. Course Quiz.html	0.2 KB
1. Concluding Remarks.mp4	49.6 MB
/29. Conclusion/
1. Course Conclusion.srt	7.4 KB
2. Course Quiz.html	0.2 KB
1. Course Conclusion.mp4	49.7 MB
/.../34. Introduction to DAX/
3. Creating your First DAX Measure.srt	7.1 KB
2. Creating Calculated Columns with DAX.srt	5.7 KB
4. The COUNTROWS Function.srt	5.2 KB
5. SUMX and RELATED Functions.srt	4.7 KB
1. Why use DAX.srt	3.4 KB
6. Practise Exercise.srt	0.7 KB
7. Section 34 Quiz.html	0.2 KB
2. Creating Calculated Columns with DAX.mp4	41.3 MB
3. Creating your First DAX Measure.mp4	39.7 MB
4. The COUNTROWS Function.mp4	32.8 MB
5. SUMX and RELATED Functions.mp4	24.0 MB
1. Why use DAX.mp4	12.1 MB
6. Practise Exercise.mp4	9.6 MB
/.../33. Creating the Data Model/
3. Creating Relationships Between tables.srt	5.5 KB
2. Understanding the Power Pivot Window.srt	5.1 KB
5. Creating a PivotTable from the Data Model.srt	4.6 KB
7. Grouping Queries.srt	4.3 KB
4. Managing the Relationships of the Model.srt	3.6 KB
6. Hide Fields from Client Tools.srt	3.6 KB
1. Enable the Power Pivot Add-In.srt	1.9 KB
8. Practise Exercise.srt	0.7 KB
9. Section 33 Quiz.html	0.2 KB
7. Grouping Queries.mp4	37.9 MB
2. Understanding the Power Pivot Window.mp4	37.3 MB
5. Creating a PivotTable from the Data Model.mp4	32.1 MB
6. Hide Fields from Client Tools.mp4	16.3 MB
3. Creating Relationships Between tables.mp4	16.2 MB
4. Managing the Relationships of the Model.mp4	15.3 MB
1. Enable the Power Pivot Add-In.mp4	15.3 MB
8. Practise Exercise.mp4	9.4 MB
/37. Closing/
1. Wrap Up.srt	1.5 KB
1. Wrap Up.mp4	2.7 MB
/.../50. Course Close/
1. Course Close.srt	0.8 KB
1. Course Close.mp4	7.8 MB
Total files 744