Udemy - Learn Advanced Excel VBA for Automation

  • Category Other
  • Type Tutorials
  • Language English
  • Total size 882.3 MB
  • Uploaded By tutsnode
  • Downloads 728
  • Last checked 2 days ago
  • Date uploaded 5 years ago
  • Seeders 18
  • Leechers 5

Infohash : 173243422E3223D324BEFF5EB53C2933D92AA3EE




Description

I am not a Programmer. Why should I learn Excel VBA Macros?

Firstly, you don’t need to be an Excel Guru to take this course, just average Excel skills will do. It’s adjusted for first-time users. Secondly, it will benefit you in automating your Excel VBA work. It saves time and improves efficiency.

But I have heard from colleagues that it takes a lot of time (weeks and months) to actually implement the solutions and benefit from it.

This is what one of our students had to say in context of this-

“I am new to Excel Macros and your index page macro has helped me want to learn more about Excel VBA. I know you didn’t write the macro, but the technique of copy and paste into excel and then adjusting to accommodate the excel macro has helped me a lot.” Dave Wilson, Saint Helens, United Kingdom

—————————————————————————————————————-

Here’s the level of the course:

Beginner:
Easy to learn and Apply

Record and run basic macros
How to use macros without programming (Hint: Google search)
Define Object, Properties, and Methods
Use Range Navigation, Referencing and Variable Declaration

Intermediate Skills:
Able to implement techniques at work

Using Loops
Optimizing Code Efficiency
Using Event tracking
Creating Userforms
Recording Macro button

Advanced Skills:
Ninja-level Skills

Creating User-defined functions
Mini Projects: Split, Protect-Unprotect, Automate Comment Extraction
Final Project: Corporate Travel planning Project (involves: advanced user forms and Email Automation)

—————————————————————————————————————-

Your Question – Why should I take this course on Excel VBA Macros?

Unlike text-book approach, these videos quickly explain the super essentials and actionable steps to get started with Macros – practically. You will learn:

Essential pre-requisite Settings (Developer tab, Security, File extension etc.)
Head (start) and Tail (end) of a Macro code for easy identification
Understanding the nut and bolts of the workspace and key-buttons.
Record and ways to Run a Macro; Viewing the code
Understanding the VBA workspace – VB Editor, Project Explorer, Properties Window, Module etc.
Personal Excel VBA Macro Workbook

A beginner, as well as an advanced user of VBA Macros, must know a specific trick to locate relevant Macro codes through Google search. You will learn:

A special trick to using Google to locate VBA codes relevant to your work
Custom edit the code using record technique and VB Editor

We have lectures with duration 6.5 hr in this course.

——————————————————————————————————————

“I thought you knew me – You solved the exact problem which I face at my office in your course” by Rajesh Dhoot, India, ex-Sr. Manager, Finance and Accounts, Ultratech Cements – An Aditya Birla Group Co.

——————————————————————————————————————-

Your Question – So will I learn Loops, User Forms & Validations?

Our Response – Yes. This course covers all Excel VBA Macros techniques in VBA and ways to use them without Programming Know How.

——————————————————————————————————————

Important information before you join:

Once enrolled, you have unlimited, lifetime access to the course!
You will have instant and free access to any updates I’ll add to the course.
I will give you my full support regarding any issues or suggestions related to the course.
Guided practice – Workbooks included for immediate practice
Access to all videos 24 x 7 – learn online from anywhere
A 30-day money back guarantee (we want you to be 100% satisfied)

—————————————————————————————————————

If you have read this far, next action is JOINING this course. Invest few hrs to lead your career with zero programming know how.
Who this course is for:

Course is purely focussed on helping you achieve skill in Excel VBA to work without programming knowledge
Learn from the Pro – a Professional Corporate Trainer (PwC, EY, RBS, Tata Group, XLRI etc.)
Wish to automate repetitive tasks in Excel
If you have doing repetitive tasks i.e. making reports, dashboards or slides and looking for ways to automate your task
If you’ve been dealing with reports from ERP system and apply the same formulas each time to generate the results
If you want Excel to talk on cross-platforms with other Microsoft applications
If You want to use Excel for complicated & demanding tasks
If you want to create worksheet object, merge the data from various sheets and do heavy calculations
If you want to create your own small programs beneficial to perform tedious tasks for excel and want to be a master at programing language. With the help of Visual Basic for Application i.e. VBA, you can also create range object in Excel

Requirements

Course works on all Microsoft Excel versions 2003, 2007, 2010, 2013, 2016. Of course the newer the better, but Excel VBA works same in all the versions.
You just need Very Basic knowledge of Excel because i’ll take you to the advanced level in this Excel VBA Course

Last Updated 2/2018

Files:

Learn Advanced Excel VBA for Automation [TutsNode.com] - Learn Advanced Excel VBA for Automation 01 Excel Macros for Beginner
  • 001 Why Learn Excel Macros_.mp4 (28.7 MB)
  • 001 Why Learn Excel Macros_.en.srt (6.3 KB)
  • 002 Download Practice Files.html (1.0 KB)
  • 003 Activate Developer tab in Excel.en.srt (3.0 KB)
  • 003 Activate Developer tab in Excel.mp4 (5.4 MB)
  • 004 Saving a Macro-enabled Excel WorkBook (XLSM).en.srt (4.2 KB)
  • 004 Saving a Macro-enabled Excel WorkBook (XLSM).mp4 (7.8 MB)
  • 005 Excel Macro Security Settings.en.srt (3.4 KB)
  • 005 Excel Macro Security Settings.mp4 (5.3 MB)
  • 006 Excel Developer Tab - Essential Buttons.en.srt (1.3 KB)
  • 006 Excel Developer Tab - Essential Buttons.mp4 (5.2 MB)
  • 007 Head and Tail of a Excel Macros (Sub Procedure and User Defined Function).en.srt (6.3 KB)
  • 007 Head and Tail of a Excel Macros (Sub Procedure and User Defined Function).mp4 (10.6 MB)
  • 008 Click Here button to run a Excel Macros.en.srt (2.4 KB)
  • 008 Click Here button to run a Excel Macros.mp4 (4.4 MB)
02 Hands on Learning on Macros
  • 009 Excel Macros - Record and Run.en.srt (7.6 KB)
  • 009 Excel Macros - Record and Run.mp4 (11.8 MB)
  • 010 Excel Macros - Viewing the code.en.srt (3.7 KB)
  • 010 Excel Macros - Viewing the code.mp4 (11.3 MB)
  • 011 Excel Macro-free vs. Macro-enabled Workbook.en.srt (1.4 KB)
  • 011 Excel Macro-free vs. Macro-enabled Workbook.mp4 (6.9 MB)
  • 012 Visual Basic Editor (VBE) - Excel VBA.en.srt (4.9 KB)
  • 012 Visual Basic Editor (VBE) - Excel VBA.mp4 (12.2 MB)
  • 013 Personal Macro Workbook.en.srt (7.1 KB)
  • 013 Personal Macro Workbook.mp4 (10.7 MB)
  • 014 Ways to Run a Macros (Excel VBA).en.srt (3.8 KB)
  • 014 Ways to Run a Macros (Excel VBA).mp4 (5.5 MB)
03 Learn to use Google search to automate your tasks without coding
  • 015 Using Google to locate useful Excel VBA codes - Part 1.en.srt (11.4 KB)
  • 015 Using Google to locate useful Excel VBA codes - Part 1.mp4 (18.4 MB)
  • 016 Using VBE and Macro Recorder to customize Excel Macro Code.en.srt (7.1 KB)
  • 016 Using VBE and Macro Recorder to customize Excel Macro Code.mp4 (12.0 MB)
  • 017 Using Google to locate useful Excel VBA codes - Part 2.en.srt (9.5 KB)
  • 017 Using Google to locate useful Excel VBA codes - Part 2.mp4 (15.1 MB)
04 OBJECTS, PROPERTIES & METHODS in Excel Macros
  • 018 Objects, Properties, Values, Methods and Parameters - Part 1.en.srt (3.4 KB)
  • 018 Objects, Properties, Values, Methods and Parameters - Part 1.mp4 (3.8 MB)
  • 019 Objects, Properties, Values, Methods and Parameters - Part 2.en.srt (3.0 KB)
  • 019 Objects, Properties, Values, Methods and Parameters - Part 2.mp4 (4.5 MB)
05 WORKSPACE in Excel Macros
  • 020 Code Color and Activating Edit Toolbar with Comments in Excel Macros.en.srt (4.4 KB)
  • 020 Code Color and Activating Edit Toolbar with Comments in Excel Macros.mp4 (6.3 MB)
  • 021 Edit Toolbar - Indent & Bookmark in Excel Macros.en.srt (2.5 KB)
  • 021 Edit Toolbar - Indent & Bookmark in Excel Macros.mp4 (4.1 MB)
  • 022 Excel Macros Code writing shortcuts including Intellisense.en.srt (2.7 KB)
  • 022 Excel Macros Code writing shortcuts including Intellisense.mp4 (4.3 MB)
  • 023 Testing the Excel Macro Code.en.srt (4.4 KB)
  • 023 Testing the Excel Macro Code.mp4 (7.4 MB)
  • 024 Immediate Window - Part 01.en.srt (4.4 KB)
  • 024 Immediate Window - Part 01.mp4 (5.0 MB)
06 Understanding RANGE & CELLS OBJECT in Excel Macros
  • 025 Range Selection - Method 1.en.srt (7.3 KB)
  • 025 Range Selection - Method 1.mp4 (11.1 MB)
  • 026 Range Selection - Method 2 and 3.en.srt (4.8 KB)
  • 026 Range Selection - Method 2 and 3.mp4 (7.5 MB)
  • 027 Advantage of Range Selection - Method 2 and 3.en.srt (8.1 KB)
  • 027 Advantage of Range Selection - Method 2 and 3.mp4 (11.4 MB)
  • 028 Range Selection (Rows and Columns) - Method 4.en.srt (1.3 KB)
  • 028 Range Selection (Rows and Columns) - Method 4.mp4 (3.1 MB)
  • 029 Assigning values to selected range of cells in Excel.en.srt (2.9 KB)
  • 029 Assigning values to selected range of cells in Excel.mp4 (4.0 MB)
  • 030 Exercise 1 - Assigning values to selected range of cells in Excel.en.srt (2.3 KB)
  • 030 Exercise 1 - Assigning values to selected range of cells in Excel.mp4 (3.3 MB)
  • 031 Exercise 2- Assigning values to selected range of cells in Excel.en.srt (1.2 KB)
  • 031 Exercise 2- Assigning values to selected range of cells in Excel.mp4 (1.5 MB)
  • 032 Multiple Range Selection - Method 5.en.srt (2.6 KB)
  • 032 Multiple Range Selection - Method 5.mp4 (4.4 MB)
  • 033 Multiple Range Selection - Method 6.en.srt (3.2 KB)
  • 033 Multiple Range Selection - Method 6.mp4 (4.7 MB)
  • 034 RangeSelectionWays - Others.en.srt (2.8 KB)
  • 034 RangeSelectionWays - Others.mp4 (3.7 MB)
07 ABSOLUTE vs RELATIVE REFERENCE in Excel Macros
  • 035 Offset - Excel Basics.en.srt (2.8 KB)
  • 035 Offset - Excel Basics.mp4 (3.7 MB)
  • 036 Using Relative Reference in Excel Macros.en.srt (4.4 KB)
  • 036 Using Relative Reference in Excel Macros.mp4 (7.1 MB)
08 RANGE NAVIGATION in Excel Macros
  • 037 Navigating between a Range of cells - Part 1A.en.srt (3.2 KB)
  • 037 Navigating between a Range of cells - Part 1A.mp4 (5.8 MB)
  • 038 Navigating between a Range of cells - Part 2.en.srt (1.8 KB)
  • 038 Navigating between a Range of cells - Part 2.mp4 (3.9 MB)
  • 039 Navigating between a Range of cells - Part 3.en.srt (2.3 KB)
  • 039 Navigating between a Range of cells - Part 3.mp4 (5.3 MB)
  • 040 Exercise - Finding Last Row Number in Excel.en.srt (6.5 KB)
  • 040 Exercise - Finding Last Row Number in Excel.mp4 (9.7 MB)
  • 041 Exercise 2 - Finding Last Column Number in Excel.en.srt (5.4 KB)
  • 041 Exercise 2 - Finding Last Column Number in Excel.mp4 (9.1 MB)
  • 042 Exercise 3 - Finding Last Column Number in Excel.en.srt (1.8 KB)
  • 042 Exercise 3 - Finding Last Column Number in Excel.mp4 (3.6 MB)
09 Variable Declaration in Excel Macros
  • 043 Variable Declaration in Excel Macros Part 1.en.srt (5.3 KB)
  • 043 Variable Declaration in Excel Macros Part 1.mp4 (9.4 MB)
  • 044 Variable Declaration in Excel Macros Part 2.en.srt (2.8 KB)
  • 044 Variable Declaration in Excel Macros Part 2.mp4 (4.3 MB)
  • 045 Private Macros vs Public Macros Part 1.en.srt (3.2 KB)
  • 045 Private Macros vs Public Macros Part 1.mp4 (4.9 MB)
  • 046 Private Macros vs Public Macros Part 2.en.srt (7.1 KB)
  • 046 Private Macros vs Public Macros Part 2.mp4 (11.8 MB)
  • 047 OptionExplicit in Excel Macros.en.srt (6.0 KB)
  • 047 OptionExplicit in Excel Macros.mp4 (8.9 MB)
  • 048 Difference - DIM vs. SET in Excel Macros.en.srt (2.8 KB)
  • 048 Difference - DIM vs. SET in Excel Macros.mp4 (4.7 MB)
10 Loops in Excel Macros
  • 049 For Next in Excel Macros.en.srt (4.5 KB)
  • 049 For Next in Excel Macros.mp4 (7.8 MB)
  • 050 If Else End If nested within For Next - Excel Macros.en.srt (6.9 KB)
  • 050 If Else End If nested within For Next - Excel Macros.mp4 (11.9 MB)
  • 051 Do While in Excel Macros.en.srt (10.9 KB)
  • 051 Do While in Excel Macros.mp4 (17.2 MB)
  • 052 Do Until in Excel Macros.en.srt (3.9 KB)
  • 052 Do Until in Excel Macros.mp4 (7.0 MB)
  • 053 For Each Next in Excel Macros.en.srt (5.6 KB)
  • 053 For Each Next in Excel Macros.mp4 (9.6 MB)
  • 054 If End If nested within For Each Next - Excel Macros.en.srt (6.2 KB)
  • 054 If End If nested within For Each Next - Excel Macros.mp4 (10.5 MB)
  • 055 Excel Macros Exercise - Do While and Loop Counter.en.srt (15.4 KB)
  • 055 Excel Macros Exercise - Do While and Loop Counter.mp4 (28.5 MB)
  • 056 With End With - Excel Macros Example 1.en.srt (15.4 KB)
  • 056 With End With - Excel Macros Example 1.mp4 (28.5 MB)
  • 057 With End With - Excel Macros Example 2.en.srt (1.9 KB)
  • 057 With End With - Excel Macros Example 2.mp4 (2.9 MB)
  • 058 Select Case - Demonstration in Excel Macros.en.srt (3.2 KB)
  • 058 Select Case - Demonstration in Excel Macros.mp4 (4.6 MB)
  • 059 Excel Macros Select Case - Explanation.en.srt (6.8 KB)
  • 059 Excel Macros Select Case - Explanation.mp4 (10.8 MB)
11 OPTIMIZING EXCEL VBA CODE EFFICIENCY
  • 060 Speed up the Macros code running - Part 1.en.srt (4.7 KB)
  • 060 Speed up the Macros code running - Part 1.mp4 (6.4 MB)
  • 061 Speed up the Macros code running - Part 2.en.srt (3.4 KB)
  • 061 Speed up the Macros code running - Part 2.mp4 (6.5 MB)
  • 062 Speed up the macros code running - Part 3.en.srt (3.1 KB)
  • 062 Speed up the macros code running - Part 3.mp4 (5.4 MB)
12 Events in Excel Macros
  • 063 Introduction to Events in Excel Macros.en.srt (2.6 KB)
  • 063 Introduction to Events in Excel Macros.mp4 (4.0 MB)
  • 064 Excel Macros Events - Workbook_Open and Worksheet_Activate.en.srt (7.1 KB)
  • 064 Excel Macros Events - Workbook_Open and Worksheet_Activate.mp4 (9.4 MB)
  • 065 Excel Macros Exercise 1 - Tracking Workbook Opens.en.srt (12.2 KB)
  • 065 Excel Macros Exercise 1 - Tracking Workbook Opens.mp4 (18.6 MB)
  • 066 Excel Macros Exercise 2 - Tracking Workbook Save.en.srt (5.0 KB)
  • 066 Excel Macros Exercise 2 - Tracking Workbook Save.mp4 (9.8 MB)
  • 067 Excel Macros Event - Worksheet_BeforeDoubleClick.en.srt (9.9 KB)
  • 067 Excel Macros Event - Worksheet_BeforeDoubleClick.mp4 (14.0 MB)
  • 068 Excel Macros Event - Worksheet_Change.en.srt (6.1 KB)
  • 068 Excel Macros Event - Worksheet_Change.mp4 (10.3 MB)
  • 069 Excel Macros Event - Worksheet_Calculate.en.srt (3.6 KB)
  • 069 Excel Macros Event - Worksheet_Calculate.mp4 (6.6 MB)
  • 070 Pivot Table - Refresh - WorkSheetActivate in Excel Macros.en.srt (5.2 KB)
  • 070 Pivot Table - Refresh - WorkSheetActivate in Excel Macros.mp4 (9.9 MB)
13 Excel Macros Input Box
  • 071 Introduction to InputBox in Excel Macros.en.srt (4.0 KB)
  • 071 Introduction to InputBox in Excel Macros.mp4 (7.4 MB)
  • 072 Excel Macros Input Box - Part 1.en.srt (7.3 KB)
  • 072 Excel Macros Input Box - Part 1.mp4 (11.4 MB)
  • 073 Excel Macros Input Box - Part 2.en.srt (8.1 KB)
  • 073 Excel Macros Input Box - Part 2.mp4 (12.5 MB)
  • 074 Excel Macros Input Box - Part 3.en.srt (4.0 KB)
  • 074 Excel Macros Input Box - Part 3.mp4 (6.8 MB)
  • 075 Excel Macros Input Box - Part 4.en.srt (8.7 KB)
  • 075 Excel Macros Input Box - Part 4.mp4 (13.6 MB)
14 Message Box in Excel VBA
  • 076 Introduction to MsgBox in Excel VBA.en.srt (2.7 KB)
  • 076 Introduction to MsgBox in Excel VBA.mp4 (2.9 MB)
  • 077 Excel VBA MsgBox - Part 1.en.srt (6.1 KB)
  • 077 Excel VBA MsgBox - Part 1.mp4 (7.6 MB)
  • 078 Excel VBA MsgBox - Part 2.en.srt (9.6 KB)
  • 078 Excel VBA MsgBox - Part 2.mp4 (15.6 MB)
  • 079 Excel VBA MsgBox - Part 3.en.srt (2.1 KB)
  • 079 Excel VBA MsgBox - Part 3.mp4 (4.6 MB)
  • 080 Excel VBA MsgBox - Part 4.en.srt (3.7 KB)
  • 080 Excel VBA MsgBox - Part 4.mp4 (6.0 MB)
15 Insert button under Developer Tab
  • 081 Excel VBA Form Controls vs ActiveX Controls.en.srt (5.4 KB)
  • 081 Excel VBA Form Controls vs ActiveX Controls.mp4 (7.8 MB)
  • 082 Mouse Move Event with Application Status bar in Excel Macros.en.srt (6.4 KB)
  • 082 Mouse Move Event with Application Status bar in Excel Macros.mp4 (7.8 MB)
16 User Form in Excel VBA
  • 083 Introduction to User Form in Excel VBA.en.srt (1.5 KB)
  • 083 Introduction to User Form in Excel VBA.mp4 (2.1 MB)
  • 084 Excel Macros User Form - Basics.en.srt (5.3 KB)
  • 084 Excel Macros User Form - Basics.mp4 (6.8 MB)
  • 085 Excel Macros Exercise on User Form- Part 1 of 4.en.srt (2.6 KB)
  • 085 Excel Macros Exercise on User Form- Part 1 of 4.mp4 (3.1 MB)
  • 086 Excel Macros Exercise on User Form- Part 2 of 4.en.srt (9.7 KB)
  • 086 Excel Macros Exercise on User Form- Part 2 of 4.mp4 (13.6 MB)
  • 087 Excel Macros Exercise on User Form- Part 3 of 4.en.srt (5.3 KB)
  • 087 Excel Macros Exercise on User Form- Part 3 of 4.mp4 (8.9 MB)
  • 088 Excel Macros Exercise on User Form- Part 4 of 4.en.srt (15.9 KB)
  • 088 Excel Macros Exercise on User Form- Part 4 of 4.mp4 (22.1 MB)
  • 089 Excel Macros Option Button - Part 1.en.srt (6.9 KB)
  • 089 Excel Macros Option Button - Part 1.mp4 (13.6 MB)
  • 090 Excel Macros Option Button - Part 2.en.srt (8.2 KB)
  • 090 Excel Macros Option Button - Part 2.mp4 (14.5 MB)
  • 091 Introduction - Multi Page in Excel Maros.en.srt (2.2 KB)
  • 091 Introduction - Multi Page in Excel Maros.mp4 (3.0 MB)
  • 092 Multi Page in Excel Macros - Part 1.en.srt (7.7 KB)
  • 092 Multi Page in Excel Macros - Part 1.mp4 (12.9 MB)
  • 093 Multi Page in Excel Macros - Part 2.en.srt (5.0 KB)
  • 093 Multi Page in Excel Macros - Part 2.mp4 (7.9 MB)
  • 094 Multi Page in Excel Macros - Part 3.en.srt (9.1 KB)
  • 094 Multi Page in Excel Macros - Part 3.mp4 (13.2 MB)
  • 095 Check Box in Excel Macros.en.srt (9.4 KB)
  • 095 Check Box in Excel Macros.mp4 (16.7 MB)
  • 096 Check Box in Excel Macros - Method 1.en.srt (3.0 KB)
  • 096 Check Box in Excel Macros - Method 1.mp4 (6.0 MB)
  • 097 Check Box in Excel Macros - Method 2.en.srt (7.0 KB)
  • 097 Check Box in Excel Macros - Method 2.mp4 (10.1 MB)
17 UDF in Excel Macros
  • 098 UDF Introduction.en.srt (3.9 KB)
  • 098 UDF Introduction.mp4 (4.1 MB)
  • 099 UDF Example 1 - ScoreResult with IF END IF.en.srt (4.3 KB)
  • 099 UDF Example 1 - ScoreResult with IF END IF.mp4 (5.9 MB)
  • 100 UDF Example 2 - CellComments.en.srt (5.5 KB)
  • 100 UDF Example 2 - CellComments.mp4 (6.5 MB)
  • 101 UDF Samples - Series A.en.srt (6.5 KB)
  • 101 UDF Samples - Series A.mp4 (11.2 MB)
  • 102 UDF Samples - Series B.en.srt (1.4 KB)
  • 102 UDF Samples - Series B.mp4 (2.1 MB)
  • TutsNode.com.txt (0.1 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
R2-CACHE ☁️ R2 (hit) | CDN: MISS (0s) 📄 torrent 🕐 03 Jan 2026, 10:11:08 am IST ⏰ 28 Jan 2026, 10:11:07 am IST ✅ Valid for 11d 22h 🔄 Refresh Cache