Udemy - Ultimate Excel VBA Macros Training Course

  • Category Other
  • Type Tutorials
  • Language English
  • Total size 2.3 GB
  • Uploaded By tutsnode
  • Downloads 351
  • Last checked 1 week ago
  • Date uploaded 5 years ago
  • Seeders 6
  • Leechers 5

Infohash : D921195D33D354B85F5395095CEFCE807A410A9C




Description

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

Files:

Ultimate Excel VBA Macros Training Course [TutsNode.com] - Ultimate Excel VBA Macros Training Course 2. Part 2 Understanding VBA Interface
  • 4. Creating Sub Procedures For Common Tasks 2.mp4 (169.0 MB)
  • 2.1 10 - Difference between Function and Sub Procedure.xlsm (223.9 KB)
  • 5.1 13- VBA Object Explorer.xlsm (300.0 KB)
  • 3. Creating Sub Procedures For Common Tasks 1.srt (8.2 KB)
  • 4.1 Creating Sub Procedures for Common Tasks Part 2.mp4 (128.7 MB)
  • 2. Difference Between Sub Procedures And Functions.srt (8.1 KB)
  • 1.1 9 - Understand VBA Modules, Procedures, Functions and Sub-Procedures.xlsm (296.3 KB)
  • 6.1 14 - Project Properties.xlsm (121.3 KB)
  • 1. Understand VBA Modules, Procedures, Functions And Sub-Procedures.mp4 (84.3 MB)
  • 3. Creating Sub Procedures For Common Tasks 1.mp4 (81.6 MB)
  • 3.1 11 - Creating Sub Procedues for Common Tasks 1.xlsm (75.8 KB)
  • 2. Difference Between Sub Procedures And Functions.mp4 (46.0 MB)
  • 7.1 Understanding Data Types and Variables.xlsx (73.0 KB)
  • 6. VBA Project Properties.srt (3.6 KB)
  • 10.1 Understanding Objects Properties and Methods.xlsx (59.9 KB)
  • 8.1 Calculations in VBA Module.xlsx (43.7 KB)
  • 9.1 Navigate through VBA Objects.xlsx (507.9 KB)
  • 7. Understanding Variables and Data Types.srt (5.7 KB)
  • 4. Creating Sub Procedures For Common Tasks 2.srt (17.3 KB)
  • 9. Navigate Through VBA Objects Available With Excel.srt (5.4 KB)
  • 1. Understand VBA Modules, Procedures, Functions And Sub-Procedures.srt (10.8 KB)
  • 8. Calculations In VBA Module.srt (4.5 KB)
  • 10. Understand Objects, Methods, Properties, And Events.srt (3.5 KB)
  • 5. VBA Object Explorer.srt (3.5 KB)
  • 9. Navigate Through VBA Objects Available With Excel.mp4 (19.3 MB)
  • 7. Understanding Variables and Data Types.mp4 (17.1 MB)
  • 5. VBA Object Explorer.mp4 (15.4 MB)
  • 10. Understand Objects, Methods, Properties, And Events.mp4 (15.4 MB)
  • 8. Calculations In VBA Module.mp4 (14.3 MB)
  • 6. VBA Project Properties.mp4 (13.2 MB)
1. Part 1 Introduction to VBA
  • 7.1 8- Offset Formula interaction with SUMIF and COUNTA.xlsm (471.7 KB)
  • 6. Offset Formula And Its Importance To Navigate In Excel Sheets.mp4 (166.8 MB)
  • 5. Important Excel Formulas Prior Knowledge Needed For VBA.mp4 (135.7 MB)
  • 5.1 6- Important Excel Formulas Prior Knowledge Needed For VBA - review notes.xlsm (253.7 KB)
  • 7. Offset Formula Interaction With Sumif And Counta.mp4 (121.9 MB)
  • 3. Introduction To Macros Interface From Developer Tab.srt (16.0 KB)
  • 1. Introduction to VBA VBA And Complex Scenarios Relating To Finance Professionals.mp4 (121.8 MB)
  • 3. Introduction To Macros Interface From Developer Tab.mp4 (102.1 MB)
  • 4. Relationship Between Macros And VBA.mp4 (95.4 MB)
  • 4.1 5- Relationship between Macros and VBA - review notes.xlsm (185.4 KB)
  • 2. Navigate Through The VBA Interface From Excel.mp4 (70.6 MB)
  • 2.1 Navigate through the Visual Basic.mp4 (35.6 MB)
  • 6.1 7- Offset Formula and its importance to navigate in Excel Sheets.xlsm (468.6 KB)
  • 5. Important Excel Formulas Prior Knowledge Needed For VBA.srt (14.2 KB)
  • 6. Offset Formula And Its Importance To Navigate In Excel Sheets.srt (18.5 KB)
  • 7. Offset Formula Interaction With Sumif And Counta.srt (13.4 KB)
  • 1. Introduction to VBA VBA And Complex Scenarios Relating To Finance Professionals.srt (12.7 KB)
  • 2. Navigate Through The VBA Interface From Excel.srt (11.4 KB)
  • 4. Relationship Between Macros And VBA.srt (10.9 KB)
  • 1.1 2- VBA and its Growing Importance for Finance Professionals.xlsm (2.0 MB)
  • 2.2 3- Navigating Through Visual Basic.xlsm (1.3 MB)
  • 3.1 4- Introduction to Macros from Developer Tab - Review notes.xlsm (520.8 KB)
4. Part 4 VBA Statements
  • 10.1 Open Statement.xlsx (27.1 KB)
  • 3. Dim and Range.srt (7.2 KB)
  • 12.3 VBA Operators and Meanings.xlsx (110.7 KB)
  • 10.2 Statement to Open All Workbooks.xlsx (85.1 KB)
  • 3.1 Dim and Range in VBA.xlsx (65.2 KB)
  • 3. Dim and Range.mp4 (38.0 MB)
  • 5.1 Variables and Multi-Dimensional.xlsx (63.0 KB)
  • 7. Creating Dynamic Loops with Conditions.srt (33.3 MB)
  • 12.2 Defining Variables.xlsx (53.6 KB)
  • 7. Creating Dynamic Loops with Conditions.mp4 (33.3 MB)
  • 6. Expression In VBA Statements.srt (1.7 KB)
  • 8. Using With Statements.srt (2.7 KB)
  • 7.1 Conditional Loops.xlsx (44.6 KB)
  • 5. What Are Variables Including Multinational Arrays And Storing Variable Values.mp4 (29.2 MB)
  • 2.1 Keyword Operator as VBA stateme.xlsx (42.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.0 KB)
  • 14.1 For Next Each.xlsx (40.2 KB)
  • 13.1 For Next Loops.xlsx (37.5 KB)
  • 8.1 With Statements.xlsx (35.2 KB)
  • 4.1 Strings and Integers.xlsx (31.0 KB)
  • 1.1 Dynamic Statements.xlsx (29.7 KB)
  • 11.1 Navigate Sheets.xlsx (29.5 KB)
  • 6.1 Expressions in VBA.xlsx (26.9 KB)
  • 9.1 Statement to Refer to Workbooks.xlsx (23.1 KB)
  • 12.1 Defining Constants.xlsx (21.3 KB)
  • 2.2 Using Constants .xlsx (20.8 KB)
  • 1. Dynamic Formula Editing to Automate Processes.srt (4.2 KB)
  • 13. Using ForNext Statements.srt (4.2 KB)
  • 14. Using For EachNext Statements.srt (3.6 KB)
  • 10. Statement To Open All Workbooks.srt (3.6 KB)
  • 9. Statement To Refer Current Workbook And Navigate Through Sheets.srt (3.4 KB)
  • 4. Concept Of Strings And Integers.srt (3.3 KB)
  • 12. Defining Variables And Their Syntax.srt (3.2 KB)
  • 2. Keyword Operator As VBA Statements.srt (3.1 KB)
  • 1. Dynamic Formula Editing to Automate Processes.mp4 (21.4 MB)
  • 14. Using For EachNext Statements.mp4 (21.3 MB)
  • 10. Statement To Open All Workbooks.mp4 (20.8 MB)
  • 13. Using ForNext Statements.mp4 (16.4 MB)
  • 2. Keyword Operator As VBA Statements.mp4 (16.0 MB)
  • 12. Defining Variables And Their Syntax.mp4 (15.6 MB)
  • 4. Concept Of Strings And Integers.mp4 (13.8 MB)
  • 9. Statement To Refer Current Workbook And Navigate Through Sheets.mp4 (12.8 MB)
  • 8. Using With Statements.mp4 (11.8 MB)
  • 11. Statement To Refer To A Worksheet In Same Workbook Or In Other Workbook.mp4 (8.0 MB)
  • 6. Expression In VBA Statements.mp4 (6.0 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 (23.4 KB)
  • 4.1 Accounting Function 2 NPV.xlsx (50.7 KB)
  • 3.1 Accounting Function 1 DRB.xlsx (40.5 KB)
  • 2.1 Adding Comments to Functions.xlsx (37.9 KB)
  • 5.1 Commission Calculation.xlsx (31.8 KB)
  • 1. How To Create Custom Functions In Excel.srt (2.1 KB)
  • 4. Accounting Functions 2 Present Value And NPV Customization.srt (1.6 KB)
  • 3. Accounting Functions 1 Depreciation Reducing Balance Method.srt (1.3 KB)
  • 5. Commission Calculation.srt (1.3 KB)
  • 4. Accounting Functions 2 Present Value And NPV Customization.mp4 (12.0 MB)
  • 2. Adding Comments To Functions And Limitation Of Functions At Sheet Level.mp4 (11.0 MB)
  • 5. Commission Calculation.mp4 (9.2 MB)
  • 1. How To Create Custom Functions In Excel.mp4 (8.2 MB)
  • 3. Accounting Functions 1 Depreciation Reducing Balance Method.mp4 (7.4 MB)
5. Understand VBA Objects
  • 1.1 Workbook Objects.xlsx (134.9 KB)
  • 2.1 Worksheet Objects .xlsx (133.3 KB)
  • 11.1 If Worksheet Function.xlsx (39.8 KB)
  • 16.1 Property Commands and Using Dot.xlsx (116.5 KB)
  • 14.1 Next and Last.xlsx (33.1 KB)
  • 12.1 On Error.xlsx (79.2 KB)
  • 6.1 Entire Row and Columns.xlsx (27.0 KB)
  • 6. Cell Entire Row And Columns Properties And Commands.srt (1.9 KB)
  • 18.1 Regular Expressions.xlsx (47.4 KB)
  • 10.1 Immediate Local and Watch.xlsx (53.7 KB)
  • 1.2 Introduction To VBA Objects.xlsx (49.0 KB)
  • 13.2 Default Commands.xlsx (46.2 KB)
  • 18.2 Input Box.xlsx (46.1 KB)
  • 3.1 ActiveCell and Selection.xlsx (22.1 KB)
  • 15. Application Command To Open Microsoft Apps.srt (2.8 KB)
  • 5.1 Active Sheet.xlsx (41.0 KB)
  • 7.2 Boolean Values .xlsx (40.4 KB)
  • 16. Offset Command Or Range Command In VBA, Uses, Limitations And Errors.mp4 (27.1 MB)
  • 13.1 For Each and If for Automation.xlsx (35.9 KB)
  • 1. Workbook Objects And Related Sub Categories.srt (2.9 KB)
  • 17.1 VBA Message Box.xlsx (35.6 KB)
  • 10. Immediate, Locals And Watch Window For Debugging.mp4 (24.2 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 (30.3 KB)
  • 7. Explanation Of Boolean Term In VBA.srt (2.3 KB)
  • 9.1 Error Handling.xlsx (26.1 KB)
  • 7.1 Select.xlsx (25.1 KB)
  • 8. This Workbook Command And Related Sub Categories.srt (2.3 KB)
  • 9. VBA Error Handling And Debugging.srt (2.8 KB)
  • 4.1 Active Window.xlsx (25.0 KB)
  • 13. For Each And If Command, And Other Conditional Commands For Automating.mp4 (23.0 MB)
  • 12. On Error Command.srt (2.7 KB)
  • 16.2 Offset and Downsides.xlsx (21.1 KB)
  • 8.1 This Workbook.xlsx (19.6 KB)
  • 13. For Each And If Command, And Other Conditional Commands For Automating.srt (5.0 KB)
  • 2. Worksheet Objects And Related Sub Categories.mp4 (22.1 MB)
  • 17. VBA Message Box Function With Dynamic Parameters.srt (2.1 KB)
  • 18. VBA Input Box Function For Entering Commands.srt (2.9 KB)
  • 14. Next And Last Command.srt (4.5 KB)
  • 10. Immediate, Locals And Watch Window For Debugging.srt (4.4 KB)
  • 16. Offset Command Or Range Command In VBA, Uses, Limitations And Errors.srt (3.8 KB)
  • 11. If Worksheet Function Command.srt (2.1 KB)
  • 3. Active Cell, Column, Rows Or String Selection Objects.srt (3.2 KB)
  • 2. Worksheet Objects And Related Sub Categories.srt (3.1 KB)
  • 1. Workbook Objects And Related Sub Categories.mp4 (19.5 MB)
  • 14. Next And Last Command.mp4 (17.1 MB)
  • 18. VBA Input Box Function For Entering Commands.mp4 (17.1 MB)
  • 3. Active Cell, Column, Rows Or String Selection Objects.mp4 (14.9 MB)
  • 17. VBA Message Box Function With Dynamic Parameters.mp4 (13.7 MB)
  • 12. On Error Command.mp4 (12.6 MB)
  • 15. Application Command To Open Microsoft Apps.mp4 (12.4 MB)
  • 9. VBA Error Handling And Debugging.mp4 (12.1 MB)
  • 6. Cell Entire Row And Columns Properties And Commands.mp4 (11.7 MB)
  • 11. If Worksheet Function Command.mp4 (11.6 MB)
  • 5. Active Sheet Command And Related Sub Categories.mp4 (11.5 MB)
  • 4. Active Window Command And Related Sub Categories.mp4 (11.2 MB)
  • 7. Explanation Of Boolean Term In VBA.mp4 (8.9 MB)
  • 8. This Workbook Command And Related Sub Categories.mp4 (7.4 MB)
7. Customized Sub Procedures
  • 3.1 Rename All Worksheets .xlsx (20.4 KB)
  • 1. How To Create Custom Sub Procedures In Excel.srt (3.2 KB)
  • 1.1 Create Custom Sub Procedures.xlsx (73.5 KB)
  • 2.2 Convert Text to Proper Text.xlsx (27.0 KB)
  • 4.1 Add All Values into New WS.xlsx (72.5 KB)
  • 5.1 Find and Replace Characters.xlsx (32.4 KB)
  • 1.2 Trim Function.xlsx (38.7 KB)
  • 2. Convert Dynamic Range into String Data.srt (2.5 KB)
  • 2.3 Combine All Workbooks.xlsx (31.3 KB)
  • 2.1 Auto Adjust Rows and Columns.xlsx (21.7 KB)
  • 3. Rename All Worksheets Based On Cell Values.srt (1.7 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 (18.5 MB)
  • 4. Add Values In All Worksheet In One Single Master Sheet.mp4 (14.0 MB)
  • 3. Rename All Worksheets Based On Cell Values.mp4 (9.4 MB)
  • 2. Convert Dynamic Range into String Data.mp4 (8.5 MB)
  • 5. Find And Replace Accented Alphabets and Foreign Text Characters.mp4 (8.0 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 (37.9 KB)
  • 4.1 Print Settings.xlsx (31.7 KB)
  • 6.1 Programming Charts.xlsx (30.5 KB)
  • 5.1 Chart Object.xlsx (30.5 KB)
  • 3.1 Convert Excel to CSV.xlsx (26.9 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.5 KB)
  • 1.1 Find and Replace.xlsx (23.2 KB)
  • 2.1 Rename Worksheets.xlsx (21.7 KB)
  • 7. Generating Dynamic Results With Pivot Table Objects.srt (2.9 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 (13.4 MB)
  • 7. Generating Dynamic Results With Pivot Table Objects.mp4 (12.0 MB)
  • 1. Find and Replace Function For Multiple Strings.mp4 (11.2 MB)
  • 4. Print Settings Including Page Margins, Specific Triggers, And Custom Pages.mp4 (9.2 MB)
  • 2. Rename All Worksheets With Single Command Based On Pre Defined Values.mp4 (6.5 MB)
  • 5. Chart Object Command As A Sub Command Of Active Worksheets.mp4 (5.4 MB)
  • 6. Programming Charts.mp4 (5.0 MB)
3. Generating VBA through Record Macro
  • 1.1 Assigning a Macro to Shape.xlsx (95.3 KB)
  • 3.1 Limits of Record Macro.xlsx (74.4 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 (29.4 MB)
  • 4.1 Overview of VBA Statements.xlsx (40.2 KB)
  • 2.1 Understanding VBA Code Range.xlsx (35.6 KB)
  • 4. Overview of VBA Statements.mp4 (22.3 MB)
  • 1. Assigning Macro To A Shape In Excel For Easy Navigation Between VBA Codes.srt (5.3 KB)
  • 3. Understanding The Limitations Of Record Macro Technique In Comparison With VBA.srt (5.3 KB)
  • 4. Overview of VBA Statements.srt (3.4 KB)
  • 1. Assigning Macro To A Shape In Excel For Easy Navigation Between VBA Codes.mp4 (18.9 MB)
  • 2. Understanding VBA Code Range Selection, Cell Navigations And Actions.mp4 (12.1 MB)
6. Active X Controls and Form Controls
  • 2.1 Userforms for Data Entry.xlsx (78.1 KB)
  • 2. Userforms In VBA For Data Entry And Input.srt (2.5 KB)
  • 4. Create A Sample Userform For Purchase Invoice.srt (2.4 KB)
  • 1.1 Overview Form, Form Controls.xlsx (73.3 KB)
  • 4.1 Create Sample Userform.xlsx (63.1 KB)
  • 3.1 Userforms Linking to VBA.xlsx (61.6 KB)
  • 3. User Forms And Link With Developer Form Control And Active X Controls.srt (2.2 KB)
  • 1. Overview Of Form, Form Controls And Activex Controls.srt (3.1 KB)
  • 4. Create A Sample Userform For Purchase Invoice.mp4 (18.7 MB)
  • 2. Userforms In VBA For Data Entry And Input.mp4 (15.2 MB)
  • 1. Overview Of Form, Form Controls And Activex Controls.mp4 (11.6 MB)
  • 3. User Forms And Link With Developer Form Control And Active X Controls.mp4 (8.6 MB)
  • TutsNode.com.txt (0.1 KB)
    • .pad
    • 0 (0.1 KB)
    • 1 (0.3 KB)
    • 2 (0.9 KB)
    • 3 (0.7 KB)
    • 4 (0.8 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 (240.0 KB)
    • 23 (129.1 KB)
    • 24 (251.5 KB)
    • 25 (239.9 KB)
    • 26 (15.5 KB)
    • 27 (232.0 KB)
    • 28 (54.5 KB)
    • 29 (258.3 KB)
    • 30 (46.2 KB)
    • 31 (377.2 KB)
    • 32 (385.1 KB)
    • 33 (435.0 KB)
    • 34 (125.7 KB)
    • 35 (17.5 KB)
    • 36 (413.8 KB)
    • 37 (54.1 KB)
    • 38 (71.3 KB)
    • 39 (273.4 KB)
    • 40 (98.1 KB)
    • 41 (218.8 KB)
    • 42 (28.4 KB)
    • 43 (195.8 KB)
    • 44 (282.9 KB)
    • 45 (100.7 KB)
    • 46 (307.4 KB)
    • 47 (252.2 KB)
    • 48 (404.2 KB)
    • 49 (122.2 KB)
    • 50 (424.7 KB)
    • 51 (450.8 KB)
    • 52 (47.9 KB)
    • 53 (48.9 KB)
    • 54 (156.8 KB)
    • 55 (275.9 KB)
    • 56 (379.7 KB)
    • 57 (418.6 KB)
    • 58 (49.5 KB)
    • 59 (319.5 KB)
    • 60 (323.9 KB)
    • 61 (7.7 KB)
    • 62 (151.8 KB)
    • 63 (262.0 KB)
    • 64 (341.1 KB)
    • 65 (94.7 KB)
    • 66 (378.9 KB)
    • 67 (36.7 KB)
    • 68 (307.0 KB)
    • 69 (13.6 KB)
    • 70 (13.7 KB)
    • 71 (76.3 KB)
    • 72 (149.8 KB)
    • 73 (502.7 KB)
    • 74 (47.1 KB)
    • 75 (142.3 KB)
    • 76 (10.4 KB)
    • 77 (26.7 KB)
    • 78 (244.9 KB)
  • [TGx]Downloaded from torrentgalaxy.to .txt (0.6 KB)

There are currently no comments. Feel free to leave one :)

Code:

  • udp://inferno.demonoid.pw:3391/announce
  • udp://tracker.openbittorrent.com:80/announce
  • udp://tracker.opentrackr.org:1337/announce
  • udp://torrent.gresille.org:80/announce
  • udp://glotorrents.pw:6969/announce
  • udp://tracker.leechers-paradise.org:6969/announce
  • udp://tracker.pirateparty.gr:6969/announce
  • udp://tracker.coppersurfer.tk:6969/announce
  • udp://ipv4.tracker.harry.lu:80/announce
  • udp://9.rarbg.to:2710/announce
  • udp://shadowshq.yi.org:6969/announce
  • udp://tracker.zer0day.to:1337/announce
REVERSE-PROXY 🔄 RP (success) | 2159ms 📄 torrent 🕐 16 Jan 2026, 09:22:04 am IST ⏰ 10 Feb 2026, 09:22:04 am IST ✅ Valid for 24d 23h 🔄 Wait 10m