Ultimate Excel VBA Macros Training Course | D921195D33D354B85F5395095CEFCE807A410A9C

Ultimate Excel VBA Macros Training Course

Name	Ultimate Excel VBA Macros Training Course	DOWNLOAD Copy Link
Total Size	2.5 GB
Total Files	316
Last Seen	2024-07-05 23:34
Hash	D921195D33D354B85F5395095CEFCE807A410A9C

/.../2. Part 2 Understanding VBA Interface/
4. Creating Sub Procedures For Common Tasks 2.mp4	177.2 MB
2.1 10 - Difference between Function and Sub Procedure.xlsm	229.3 KB
5.1 13- VBA Object Explorer.xlsm	307.2 KB
3. Creating Sub Procedures For Common Tasks 1.srt	8.4 KB
4.1 Creating Sub Procedures for Common Tasks Part 2.mp4	135.0 MB
2. Difference Between Sub Procedures And Functions.srt	8.3 KB
1.1 9 - Understand VBA Modules, Procedures, Functions and Sub-Procedures.xlsm	303.4 KB
6.1 14 - Project Properties.xlsm	124.2 KB
1. Understand VBA Modules, Procedures, Functions And Sub-Procedures.mp4	88.4 MB
3. Creating Sub Procedures For Common Tasks 1.mp4	85.6 MB
3.1 11 - Creating Sub Procedues for Common Tasks 1.xlsm	77.6 KB
2. Difference Between Sub Procedures And Functions.mp4	48.2 MB
7.1 Understanding Data Types and Variables.xlsx	74.7 KB
6. VBA Project Properties.srt	3.7 KB
10.1 Understanding Objects Properties and Methods.xlsx	61.3 KB
8.1 Calculations in VBA Module.xlsx	44.8 KB
9.1 Navigate through VBA Objects.xlsx	520.1 KB
7. Understanding Variables and Data Types.srt	5.8 KB
4. Creating Sub Procedures For Common Tasks 2.srt	17.7 KB
9. Navigate Through VBA Objects Available With Excel.srt	5.5 KB
1. Understand VBA Modules, Procedures, Functions And Sub-Procedures.srt	11.1 KB
8. Calculations In VBA Module.srt	4.6 KB
10. Understand Objects, Methods, Properties, And Events.srt	3.6 KB
5. VBA Object Explorer.srt	3.6 KB
9. Navigate Through VBA Objects Available With Excel.mp4	20.2 MB
7. Understanding Variables and Data Types.mp4	18.0 MB
5. VBA Object Explorer.mp4	16.2 MB
10. Understand Objects, Methods, Properties, And Events.mp4	16.2 MB
8. Calculations In VBA Module.mp4	15.0 MB
6. VBA Project Properties.mp4	13.8 MB
/
TutsNode.com.txt	0.1 KB
[TGx]Downloaded from torrentgalaxy.to .txt	0.6 KB
/.../1. Part 1 Introduction to VBA/
7.1 8- Offset Formula interaction with SUMIF and COUNTA.xlsm	483.1 KB
6. Offset Formula And Its Importance To Navigate In Excel Sheets.mp4	174.9 MB
5. Important Excel Formulas Prior Knowledge Needed For VBA.mp4	142.3 MB
5.1 6- Important Excel Formulas Prior Knowledge Needed For VBA - review notes.xlsm	259.7 KB
7. Offset Formula Interaction With Sumif And Counta.mp4	127.8 MB
3. Introduction To Macros Interface From Developer Tab.srt	16.4 KB
1. Introduction to VBA VBA And Complex Scenarios Relating To Finance Professionals.mp4	127.8 MB
3. Introduction To Macros Interface From Developer Tab.mp4	107.0 MB
4. Relationship Between Macros And VBA.mp4	100.0 MB
4.1 5- Relationship between Macros and VBA - review notes.xlsm	189.9 KB
2. Navigate Through The VBA Interface From Excel.mp4	74.1 MB
2.1 Navigate through the Visual Basic.mp4	37.3 MB
6.1 7- Offset Formula and its importance to navigate in Excel Sheets.xlsm	479.8 KB
5. Important Excel Formulas Prior Knowledge Needed For VBA.srt	14.5 KB
6. Offset Formula And Its Importance To Navigate In Excel Sheets.srt	18.9 KB
7. Offset Formula Interaction With Sumif And Counta.srt	13.7 KB
1. Introduction to VBA VBA And Complex Scenarios Relating To Finance Professionals.srt	13.0 KB
2. Navigate Through The VBA Interface From Excel.srt	11.6 KB
4. Relationship Between Macros And VBA.srt	11.2 KB
1.1 2- VBA and its Growing Importance for Finance Professionals.xlsm	2.1 MB
2.2 3- Navigating Through Visual Basic.xlsm	1.3 MB
3.1 4- Introduction to Macros from Developer Tab - Review notes.xlsm	533.3 KB
/.../4. Part 4 VBA Statements/
10.1 Open Statement.xlsx	27.8 KB
3. Dim and Range.srt	7.3 KB
12.3 VBA Operators and Meanings.xlsx	113.4 KB
10.2 Statement to Open All Workbooks.xlsx	87.1 KB
3.1 Dim and Range in VBA.xlsx	66.8 KB
3. Dim and Range.mp4	39.8 MB
5.1 Variables and Multi-Dimensional.xlsx	64.5 KB
7. Creating Dynamic Loops with Conditions.srt	34.9 MB
12.2 Defining Variables.xlsx	54.9 KB
7. Creating Dynamic Loops with Conditions.mp4	34.9 MB
6. Expression In VBA Statements.srt	1.7 KB
8. Using With Statements.srt	2.7 KB
7.1 Conditional Loops.xlsx	45.7 KB
5. What Are Variables Including Multinational Arrays And Storing Variable Values.mp4	30.7 MB
2.1 Keyword Operator as VBA stateme.xlsx	43.4 KB
11. Statement To Refer To A Worksheet In Same Workbook Or In Other Workbook.srt	1.7 KB
5. What Are Variables Including Multinational Arrays And Storing Variable Values.srt	6.1 KB
14.1 For Next Each.xlsx	41.2 KB
13.1 For Next Loops.xlsx	38.4 KB
8.1 With Statements.xlsx	36.0 KB
4.1 Strings and Integers.xlsx	31.7 KB
1.1 Dynamic Statements.xlsx	30.4 KB
11.1 Navigate Sheets.xlsx	30.2 KB
6.1 Expressions in VBA.xlsx	27.5 KB
9.1 Statement to Refer to Workbooks.xlsx	23.7 KB
12.1 Defining Constants.xlsx	21.8 KB
2.2 Using Constants .xlsx	21.3 KB
1. Dynamic Formula Editing to Automate Processes.srt	4.3 KB
13. Using ForNext Statements.srt	4.3 KB
14. Using For EachNext Statements.srt	3.7 KB
10. Statement To Open All Workbooks.srt	3.7 KB
9. Statement To Refer Current Workbook And Navigate Through Sheets.srt	3.5 KB
4. Concept Of Strings And Integers.srt	3.4 KB
12. Defining Variables And Their Syntax.srt	3.3 KB
2. Keyword Operator As VBA Statements.srt	3.2 KB
1. Dynamic Formula Editing to Automate Processes.mp4	22.4 MB
14. Using For EachNext Statements.mp4	22.3 MB
10. Statement To Open All Workbooks.mp4	21.8 MB
13. Using ForNext Statements.mp4	17.2 MB
2. Keyword Operator As VBA Statements.mp4	16.8 MB
12. Defining Variables And Their Syntax.mp4	16.4 MB
4. Concept Of Strings And Integers.mp4	14.5 MB
9. Statement To Refer Current Workbook And Navigate Through Sheets.mp4	13.4 MB
8. Using With Statements.mp4	12.4 MB
11. Statement To Refer To A Worksheet In Same Workbook Or In Other Workbook.mp4	8.4 MB
6. Expression In VBA Statements.mp4	6.2 MB
/8. Customized Functions/
2. Adding Comments To Functions And Limitation Of Functions At Sheet Level.srt	2.0 KB
1.1 Create Custom Functions in Exce.xlsx	24.0 KB
4.1 Accounting Function 2 NPV.xlsx	51.9 KB
3.1 Accounting Function 1 DRB.xlsx	41.5 KB
2.1 Adding Comments to Functions.xlsx	38.8 KB
5.1 Commission Calculation.xlsx	32.5 KB
1. How To Create Custom Functions In Excel.srt	2.2 KB
4. Accounting Functions 2 Present Value And NPV Customization.srt	1.6 KB
3. Accounting Functions 1 Depreciation Reducing Balance Method.srt	1.4 KB
5. Commission Calculation.srt	1.3 KB
4. Accounting Functions 2 Present Value And NPV Customization.mp4	12.5 MB
2. Adding Comments To Functions And Limitation Of Functions At Sheet Level.mp4	11.5 MB
5. Commission Calculation.mp4	9.7 MB
1. How To Create Custom Functions In Excel.mp4	8.6 MB
3. Accounting Functions 1 Depreciation Reducing Balance Method.mp4	7.8 MB
/.pad/
0	0.1 KB
1	0.3 KB
2	0.9 KB
3	0.7 KB
4	0.9 KB
5	0.2 KB
6	0.2 KB
7	0.0 KB
8	0.2 KB
9	0.1 KB
10	0.0 KB
11	0.3 KB
12	0.0 KB
13	0.1 KB
14	0.4 KB
15	0.6 KB
16	0.0 KB
17	0.1 KB
18	0.1 KB
19	0.0 KB
20	0.7 KB
21	0.0 KB
22	245.7 KB
23	132.2 KB
24	257.5 KB
25	245.7 KB
26	15.8 KB
27	237.6 KB
28	55.8 KB
29	264.5 KB
30	47.4 KB
31	386.3 KB
32	394.3 KB
33	445.5 KB
34	128.7 KB
35	18.0 KB
36	423.8 KB
37	55.4 KB
38	73.1 KB
39	280.0 KB
40	100.4 KB
41	224.1 KB
42	29.0 KB
43	200.5 KB
44	289.7 KB
45	103.1 KB
46	314.8 KB
47	258.2 KB
48	413.9 KB
49	125.2 KB
50	434.8 KB
51	461.6 KB
52	49.1 KB
53	50.0 KB
54	160.6 KB
55	282.6 KB
56	388.8 KB
57	428.6 KB
58	50.7 KB
59	327.2 KB
60	331.7 KB
61	7.9 KB
62	155.4 KB
63	268.3 KB
64	349.3 KB
65	97.0 KB
66	388.0 KB
67	37.5 KB
68	314.4 KB
69	13.9 KB
70	14.1 KB
71	78.1 KB
72	153.4 KB
73	514.8 KB
74	48.2 KB
75	145.7 KB
76	10.6 KB
77	27.4 KB
78	250.8 KB
/.../5. Understand VBA Objects/
1.1 Workbook Objects.xlsx	138.2 KB
2.1 Worksheet Objects .xlsx	136.5 KB
11.1 If Worksheet Function.xlsx	40.8 KB
16.1 Property Commands and Using Dot.xlsx	119.3 KB
14.1 Next and Last.xlsx	33.9 KB
12.1 On Error.xlsx	81.1 KB
6.1 Entire Row and Columns.xlsx	27.7 KB
6. Cell Entire Row And Columns Properties And Commands.srt	1.9 KB
18.1 Regular Expressions.xlsx	48.5 KB
10.1 Immediate Local and Watch.xlsx	55.0 KB
1.2 Introduction To VBA Objects.xlsx	50.2 KB
13.2 Default Commands.xlsx	47.3 KB
18.2 Input Box.xlsx	47.2 KB
3.1 ActiveCell and Selection.xlsx	22.6 KB
15. Application Command To Open Microsoft Apps.srt	2.9 KB
5.1 Active Sheet.xlsx	42.0 KB
7.2 Boolean Values .xlsx	41.4 KB
16. Offset Command Or Range Command In VBA, Uses, Limitations And Errors.mp4	28.4 MB
13.1 For Each and If for Automation.xlsx	36.8 KB
1. Workbook Objects And Related Sub Categories.srt	2.9 KB
17.1 VBA Message Box.xlsx	36.4 KB
10. Immediate, Locals And Watch Window For Debugging.mp4	25.3 MB
4. Active Window Command And Related Sub Categories.srt	1.7 KB
5. Active Sheet Command And Related Sub Categories.srt	2.1 KB
15.1 Windows Applications.xlsx	31.1 KB
7. Explanation Of Boolean Term In VBA.srt	2.3 KB
9.1 Error Handling.xlsx	26.8 KB
7.1 Select.xlsx	25.7 KB
8. This Workbook Command And Related Sub Categories.srt	2.3 KB
9. VBA Error Handling And Debugging.srt	2.9 KB
4.1 Active Window.xlsx	25.6 KB
13. For Each And If Command, And Other Conditional Commands For Automating.mp4	24.1 MB
12. On Error Command.srt	2.8 KB
16.2 Offset and Downsides.xlsx	21.6 KB
8.1 This Workbook.xlsx	20.1 KB
13. For Each And If Command, And Other Conditional Commands For Automating.srt	5.1 KB
2. Worksheet Objects And Related Sub Categories.mp4	23.2 MB
17. VBA Message Box Function With Dynamic Parameters.srt	2.2 KB
18. VBA Input Box Function For Entering Commands.srt	3.0 KB
14. Next And Last Command.srt	4.7 KB
10. Immediate, Locals And Watch Window For Debugging.srt	4.6 KB
16. Offset Command Or Range Command In VBA, Uses, Limitations And Errors.srt	3.9 KB
11. If Worksheet Function Command.srt	2.2 KB
3. Active Cell, Column, Rows Or String Selection Objects.srt	3.3 KB
2. Worksheet Objects And Related Sub Categories.srt	3.2 KB
1. Workbook Objects And Related Sub Categories.mp4	20.4 MB
14. Next And Last Command.mp4	18.0 MB
18. VBA Input Box Function For Entering Commands.mp4	17.9 MB
3. Active Cell, Column, Rows Or String Selection Objects.mp4	15.6 MB
17. VBA Message Box Function With Dynamic Parameters.mp4	14.4 MB
12. On Error Command.mp4	13.2 MB
15. Application Command To Open Microsoft Apps.mp4	13.0 MB
9. VBA Error Handling And Debugging.mp4	12.7 MB
6. Cell Entire Row And Columns Properties And Commands.mp4	12.3 MB
11. If Worksheet Function Command.mp4	12.2 MB
5. Active Sheet Command And Related Sub Categories.mp4	12.0 MB
4. Active Window Command And Related Sub Categories.mp4	11.7 MB
7. Explanation Of Boolean Term In VBA.mp4	9.3 MB
8. This Workbook Command And Related Sub Categories.mp4	7.7 MB
/.../7. Customized Sub Procedures/
3.1 Rename All Worksheets .xlsx	20.9 KB
1. How To Create Custom Sub Procedures In Excel.srt	3.3 KB
1.1 Create Custom Sub Procedures.xlsx	75.3 KB
2.2 Convert Text to Proper Text.xlsx	27.7 KB
4.1 Add All Values into New WS.xlsx	74.2 KB
5.1 Find and Replace Characters.xlsx	33.1 KB
1.2 Trim Function.xlsx	39.6 KB
2. Convert Dynamic Range into String Data.srt	2.6 KB
2.3 Combine All Workbooks.xlsx	32.1 KB
2.1 Auto Adjust Rows and Columns.xlsx	22.2 KB
3. Rename All Worksheets Based On Cell Values.srt	1.8 KB
4. Add Values In All Worksheet In One Single Master Sheet.srt	2.1 KB
5. Find And Replace Accented Alphabets and Foreign Text Characters.srt	1.7 KB
1. How To Create Custom Sub Procedures In Excel.mp4	19.4 MB
4. Add Values In All Worksheet In One Single Master Sheet.mp4	14.7 MB
3. Rename All Worksheets Based On Cell Values.mp4	9.8 MB
2. Convert Dynamic Range into String Data.mp4	8.9 MB
5. Find And Replace Accented Alphabets and Foreign Text Characters.mp4	8.4 MB
/.../9. Other Areas of VBA/
6. Programming Charts.srt	1.4 KB
3. Convert Excel Data Into Csv For Programming.srt	1.8 KB
7.1 Generating Dynamic Pivot Tables.xlsx	38.8 KB
4.1 Print Settings.xlsx	32.5 KB
6.1 Programming Charts.xlsx	31.3 KB
5.1 Chart Object.xlsx	31.3 KB
3.1 Convert Excel to CSV.xlsx	27.6 KB
1. Find and Replace Function For Multiple Strings.srt	1.8 KB
2. Rename All Worksheets With Single Command Based On Pre Defined Values.srt	1.6 KB
1.1 Find and Replace.xlsx	23.8 KB
2.1 Rename Worksheets.xlsx	22.2 KB
7. Generating Dynamic Results With Pivot Table Objects.srt	3.0 KB
4. Print Settings Including Page Margins, Specific Triggers, And Custom Pages.srt	1.5 KB
5. Chart Object Command As A Sub Command Of Active Worksheets.srt	1.2 KB
3. Convert Excel Data Into Csv For Programming.mp4	14.1 MB
7. Generating Dynamic Results With Pivot Table Objects.mp4	12.5 MB
1. Find and Replace Function For Multiple Strings.mp4	11.7 MB
4. Print Settings Including Page Margins, Specific Triggers, And Custom Pages.mp4	9.6 MB
2. Rename All Worksheets With Single Command Based On Pre Defined Values.mp4	6.8 MB
5. Chart Object Command As A Sub Command Of Active Worksheets.mp4	5.6 MB
6. Programming Charts.mp4	5.2 MB
/.../3. Generating VBA through Record Macro/
1.1 Assigning a Macro to Shape.xlsx	97.6 KB
3.1 Limits of Record Macro.xlsx	76.2 KB
2. Understanding VBA Code Range Selection, Cell Navigations And Actions.srt	1.8 KB
3. Understanding The Limitations Of Record Macro Technique In Comparison With VBA.mp4	30.8 MB
4.1 Overview of VBA Statements.xlsx	41.2 KB
2.1 Understanding VBA Code Range.xlsx	36.5 KB
4. Overview of VBA Statements.mp4	23.4 MB
1. Assigning Macro To A Shape In Excel For Easy Navigation Between VBA Codes.srt	5.5 KB
3. Understanding The Limitations Of Record Macro Technique In Comparison With VBA.srt	5.4 KB
4. Overview of VBA Statements.srt	3.5 KB
1. Assigning Macro To A Shape In Excel For Easy Navigation Between VBA Codes.mp4	19.9 MB
2. Understanding VBA Code Range Selection, Cell Navigations And Actions.mp4	12.6 MB
/.../6. Active X Controls and Form Controls/
2.1 Userforms for Data Entry.xlsx	79.9 KB
2. Userforms In VBA For Data Entry And Input.srt	2.6 KB
4. Create A Sample Userform For Purchase Invoice.srt	2.5 KB
1.1 Overview Form, Form Controls.xlsx	75.0 KB
4.1 Create Sample Userform.xlsx	64.6 KB
3.1 Userforms Linking to VBA.xlsx	63.1 KB
3. User Forms And Link With Developer Form Control And Active X Controls.srt	2.3 KB
1. Overview Of Form, Form Controls And Activex Controls.srt	3.2 KB
4. Create A Sample Userform For Purchase Invoice.mp4	19.7 MB
2. Userforms In VBA For Data Entry And Input.mp4	16.0 MB
1. Overview Of Form, Form Controls And Activex Controls.mp4	12.2 MB
3. User Forms And Link With Developer Form Control And Active X Controls.mp4	9.0 MB
Total files 316