This course is designed for the non-programming Excel user, to help them learn how to use the VBA portion of Excel. Learning how to write VBA code will allow Excel users to automate many tasks in Excel, saving them time in the long run. This course provides the information necessary for someone who has no knowledge of programming to learn the basics of programming while at the same time learning how to create useful macros with VBA in Excel.
Who this course is for:
Basic – Intermediate level Excel users looking to improve their skills with Excel
Requirements
Basic-Intermediate knowledge of Excel
Last Updated 12/2020
VISITOR COMMENTS (0 )
FILE LIST
Filename
Size
.pad/0
53 B
.pad/1
343 B
.pad/10
6 B
.pad/11
317 B
.pad/12
15 B
.pad/13
68 B
.pad/14
407 B
.pad/15
576 B
.pad/16
21 B
.pad/2
929 B
.pad/3
669 B
.pad/4
854 B
.pad/5
227 B
.pad/6
233 B
.pad/7
25 B
.pad/8
160 B
.pad/9
67 B
TutsNode.com.txt
63 B
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/1. Part 1 Introduction to VBA/1. Introduction to VBA VBA And Complex Scenarios Relating To Finance Professionals.mp4
121.8 MB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/1. Part 1 Introduction to VBA/2. Navigate Through The VBA Interface From Excel.mp4
70.6 MB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/1. Part 1 Introduction to VBA/2.1 Navigate through the Visual Basic.mp4
35.6 MB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/1. Part 1 Introduction to VBA/3. Introduction To Macros Interface From Developer Tab.mp4
102.1 MB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/1. Part 1 Introduction to VBA/3. Introduction To Macros Interface From Developer Tab.srt
16 KB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/1. Part 1 Introduction to VBA/4. Relationship Between Macros And VBA.mp4
95.4 MB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/1. Part 1 Introduction to VBA/4.1 5- Relationship between Macros and VBA - review notes.xlsm
185.4 KB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/1. Part 1 Introduction to VBA/5. Important Excel Formulas Prior Knowledge Needed For VBA.mp4
135.7 MB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/1. Part 1 Introduction to VBA/5.1 6- Important Excel Formulas Prior Knowledge Needed For VBA - review notes.xlsm
253.7 KB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/1. Part 1 Introduction to VBA/6. Offset Formula And Its Importance To Navigate In Excel Sheets.mp4
166.8 MB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/1. Part 1 Introduction to VBA/7. Offset Formula Interaction With Sumif And Counta.mp4
121.9 MB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/1. Part 1 Introduction to VBA/7.1 8- Offset Formula interaction with SUMIF and COUNTA.xlsm
471.7 KB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/2. Part 2 Understanding VBA Interface/1. Understand VBA Modules, Procedures, Functions And Sub-Procedures.mp4
84.3 MB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/2. Part 2 Understanding VBA Interface/1.1 9 - Understand VBA Modules, Procedures, Functions and Sub-Procedures.xlsm
296.3 KB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/2. Part 2 Understanding VBA Interface/10.1 Understanding Objects Properties and Methods.xlsx
59.9 KB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/2. Part 2 Understanding VBA Interface/2. Difference Between Sub Procedures And Functions.mp4
46 MB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/2. Part 2 Understanding VBA Interface/2. Difference Between Sub Procedures And Functions.srt
8.1 KB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/2. Part 2 Understanding VBA Interface/2.1 10 - Difference between Function and Sub Procedure.xlsm
223.9 KB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/2. Part 2 Understanding VBA Interface/3. Creating Sub Procedures For Common Tasks 1.mp4
81.6 MB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/2. Part 2 Understanding VBA Interface/3. Creating Sub Procedures For Common Tasks 1.srt
8.2 KB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/2. Part 2 Understanding VBA Interface/3.1 11 - Creating Sub Procedues for Common Tasks 1.xlsm
75.8 KB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/2. Part 2 Understanding VBA Interface/4. Creating Sub Procedures For Common Tasks 2.mp4
169 MB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/2. Part 2 Understanding VBA Interface/4.1 Creating Sub Procedures for Common Tasks Part 2.mp4
128.7 MB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/2. Part 2 Understanding VBA Interface/5.1 13- VBA Object Explorer.xlsm
300 KB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/2. Part 2 Understanding VBA Interface/6. VBA Project Properties.srt
3.6 KB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/2. Part 2 Understanding VBA Interface/6.1 14 - Project Properties.xlsm
121.3 KB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/2. Part 2 Understanding VBA Interface/7.1 Understanding Data Types and Variables.xlsx
73 KB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/2. Part 2 Understanding VBA Interface/8.1 Calculations in VBA Module.xlsx
43.7 KB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/3. Generating VBA through Record Macro/1.1 Assigning a Macro to Shape.xlsx
95.3 KB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/3. Generating VBA through Record Macro/2. Understanding VBA Code Range Selection, Cell Navigations And Actions.srt
1.8 KB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/3. Generating VBA through Record Macro/3. Understanding The Limitations Of Record Macro Technique In Comparison With VBA.mp4
29.4 MB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/3. Generating VBA through Record Macro/3.1 Limits of Record Macro.xlsx
74.4 KB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/4. Part 4 VBA Statements/10.1 Open Statement.xlsx
27.1 KB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/4. Part 4 VBA Statements/10.2 Statement to Open All Workbooks.xlsx
85.1 KB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/4. Part 4 VBA Statements/12.2 Defining Variables.xlsx
53.6 KB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/4. Part 4 VBA Statements/12.3 VBA Operators and Meanings.xlsx
110.7 KB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/4. Part 4 VBA Statements/2.1 Keyword Operator as VBA stateme.xlsx
42.4 KB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/4. Part 4 VBA Statements/3. Dim and Range.mp4
38 MB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/4. Part 4 VBA Statements/3. Dim and Range.srt
7.2 KB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/4. Part 4 VBA Statements/3.1 Dim and Range in VBA.xlsx
65.2 KB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/4. Part 4 VBA Statements/5. What Are Variables Including Multinational Arrays And Storing Variable Values.mp4
29.2 MB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/4. Part 4 VBA Statements/5.1 Variables and Multi-Dimensional.xlsx
63 KB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/4. Part 4 VBA Statements/6. Expression In VBA Statements.srt
1.7 KB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/4. Part 4 VBA Statements/7. Creating Dynamic Loops with Conditions.mp4
33.3 MB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/4. Part 4 VBA Statements/7. Creating Dynamic Loops with Conditions.srt
33.3 MB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/4. Part 4 VBA Statements/7.1 Conditional Loops.xlsx
44.6 KB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/4. Part 4 VBA Statements/8. Using With Statements.srt
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/5. Understand VBA Objects/3.1 ActiveCell and Selection.xlsx
22.1 KB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/5. Understand VBA Objects/5.1 Active Sheet.xlsx
41 KB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/5. Understand VBA Objects/6. Cell Entire Row And Columns Properties And Commands.srt
1.9 KB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/5. Understand VBA Objects/6.1 Entire Row and Columns.xlsx
27 KB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/6. Active X Controls and Form Controls/1.1 Overview Form, Form Controls.xlsx
73.3 KB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/6. Active X Controls and Form Controls/2. Userforms In VBA For Data Entry And Input.srt
2.5 KB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/6. Active X Controls and Form Controls/2.1 Userforms for Data Entry.xlsx
78.1 KB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/6. Active X Controls and Form Controls/3.1 Userforms Linking to VBA.xlsx
61.6 KB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/6. Active X Controls and Form Controls/4. Create A Sample Userform For Purchase Invoice.srt
2.4 KB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/6. Active X Controls and Form Controls/4.1 Create Sample Userform.xlsx
63.1 KB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/7. Customized Sub Procedures/1. How To Create Custom Sub Procedures In Excel.srt
3.2 KB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/7. Customized Sub Procedures/1.1 Create Custom Sub Procedures.xlsx
73.5 KB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/7. Customized Sub Procedures/2.2 Convert Text to Proper Text.xlsx
27 KB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/7. Customized Sub Procedures/3.1 Rename All Worksheets .xlsx
20.4 KB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/7. Customized Sub Procedures/4.1 Add All Values into New WS.xlsx
72.5 KB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/7. Customized Sub Procedures/5.1 Find and Replace Characters.xlsx
32.4 KB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/8. Customized Functions/1.1 Create Custom Functions in Exce.xlsx
23.4 KB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/8. Customized Functions/2. Adding Comments To Functions And Limitation Of Functions At Sheet Level.srt
2 KB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/8. Customized Functions/3.1 Accounting Function 1 DRB.xlsx
40.5 KB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/8. Customized Functions/4.1 Accounting Function 2 NPV.xlsx
50.7 KB
[TutsNode.com] - Ultimate Excel VBA Macros Training Course/9. Other Areas of VBA/6. Programming Charts.srt