Learn Advanced Excel VBA for Automation

  • Course provided by Udemy
  • Study type: Online
  • Starts: Anytime
  • Price: See latest price on Udemy
Udemy

Course 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
  • Learn how to put Excel on AUTOPILOT Will be able to take Excel Automation tasks for self as well as client Automate your work and the work for others Learn how to record and run Excel Macros in detail Learn to use Google search to automate your tasks without coding Learn OBJECTS, PROPERTIES & METHODS in Excel Macros Learn to Color the code and Activating Edit Toolbar with Comments in Excel VBA Programming Understand RANGE & CELLS OBJECT in Excel VBA Macros Learn ABSOLUTE vs RELATIVE REFERENCE in Excel VBA Programming Learn RANGE NAVIGATION in Excel Macros Learn Variable Declaration in Excel VBA Programming Learn how to Loop in Excel VBA Learn how to OPTIMIZING EXCEL VBA CODE EFFICIENCY Learn what is Events in Excel Macros Learn how to make Input Box and Message Box in Excel VBA Programming Learn how to Insert button under Developer Tab Learn how to make User Form in Excel VBA Learn what is UDF in Excel VBA Programming Won’t waste time in manipulating and repetitive formatting Use my excel file to send emails automatically (basically communicate with different tools) Make use of custom functions that can be run from things like a button on a spreadsheet, the Excel Ribbon Show more Show less 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 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 Show more Show less Course content 17 sections • 102 lectures • 6h 21m total length Expand all sections Excel Macros for Beginner 8 lectures • 18min Why Learn Excel Macros? Preview 04:17 Download Practice Files 00:00 Activate Developer tab in Excel Preview 02:02 Saving a Macro-enabled Excel WorkBook (XLSM) 02:53 Excel Macro Security Settings 02:13 Excel Developer Tab - Essential Buttons 00:54 Head and Tail of a Excel Macros (Sub Procedure and User Defined Function) 04:00 Click Here button to run a Excel Macros 01:46 Hands on Learning on Macros 6 lectures • 20min Excel Macros - Record and Run Preview 05:07 Excel Macros - Viewing the code 02:41 Excel Macro-free vs. Macro-enabled Workbook 00:55 Visual Basic Editor (VBE) - Excel VBA 03:18 Personal Macro Workbook 05:20 Ways to Run a Macros (Excel VBA) Preview 02:46 Learn to use Google search to automate your tasks without coding 3 lectures • 19min Using Google to locate useful Excel VBA codes - Part 1 07:42 Using VBE and Macro Recorder to customize Excel Macro Code 04:46 Using Google to locate useful Excel VBA codes - Part 2 06:29 OBJECTS, PROPERTIES & METHODS in Excel Macros 2 lectures • 4min Objects, Properties, Values, Methods and Parameters - Part 1 02:19 Objects, Properties, Values, Methods and Parameters - Part 2 02:02 WORKSPACE in Excel Macros 5 lectures • 13min Code Color and Activating Edit Toolbar with Comments in Excel Macros 03:00 Edit Toolbar - Indent & Bookmark in Excel Macros 01:49 Excel Macros Code writing shortcuts including Intellisense 01:58 Testing the Excel Macro Code 02:58 Immediate Window - Part 01 03:06 Understanding RANGE & CELLS OBJECT in Excel Macros 10 lectures • 26min Range Selection - Method 1 04:55 Range Selection - Method 2 and 3 03:21 Advantage of Range Selection - Method 2 and 3 05:48 Range Selection (Rows and Columns) - Method 4 00:54 Assigning values to selected range of cells in Excel 02:01 Exercise 1 - Assigning values to selected range of cells in Excel 01:35 Exercise 2- Assigning values to selected range of cells in Excel 00:45 Multiple Range Selection - Method 5 02:01 Multiple Range Selection - Method 6 02:19 RangeSelectionWays - Others 02:04 ABSOLUTE vs RELATIVE REFERENCE in Excel Macros 2 lectures • 5min Offset - Excel Basics 01:53 Using Relative Reference in Excel Macros 03:11 RANGE NAVIGATION in Excel Macros 6 lectures • 15min Navigating between a Range of cells - Part 1A 02:14 Navigating between a Range of cells - Part 2 01:20 Navigating between a Range of cells - Part 3 01:49 Exercise - Finding Last Row Number in Excel 04:17 Exercise 2 - Finding Last Column Number in Excel 03:42 Exercise 3 - Finding Last Column Number in Excel 01:25 Variable Declaration in Excel Macros 6 lectures • 21min Variable Declaration in Excel Macros Part 1 04:26 Variable Declaration in Excel Macros Part 2 02:03 Private Macros vs Public Macros Part 1 02:16 Private Macros vs Public Macros Part 2 05:31 OptionExplicit in Excel Macros 04:29 Difference - DIM vs. SET in Excel Macros 02:03 Loops in Excel Macros 11 lectures • 1hr 1min For Next in Excel Macros 03:27 If Else End If nested within For Next - Excel Macros 05:23 Do While in Excel Macros 07:23 Do Until in Excel Macros 02:59 For Each Next in Excel Macros 04:08 If End If nested within For Each Next - Excel Macros 04:46 Excel Macros Exercise - Do While and Loop Counter 11:55 With End With - Excel Macros Example 1 11:55 With End With - Excel Macros Example 2 01:26 Select Case - Demonstration in Excel Macros 02:21 Excel Macros Select Case - Explanation 05:18 7 more sections Instructor Yoda Learning Data Analyst |MS Office Expert & PMP | Instructor/Programmer 4.5 Instructor Rating 8,882 Reviews 129,439 Students 28 Courses 20,000 Classroom Students | 100,000+ Students Online ex-KPMG, ex-J.P. Morgan | Chartered Accountant Taught 12k+ participants across PwC, EY and Deloitte over last 10 years I am a Chartered Accountant from India. I have worked with KPMG (Audit) and J.P. Morgan (Debt Capital Markets) and Futures First (Proprietary Trading Desk) before venturing into Corporate Training (first part-time and then full-time) After a decade of corporate training and winning multiple accolades in Office Productivity and Financial Modelling, in 2015, I created a mission to help 1 million people by 2020. I started creating high-quality video courses and helped people online to become faster-smarter-better at work. A lot of my students at PwC, EY, Deloitte, Amazon, Uber, Tata Group, Rio Tinto use these video courses to excel at work. If I’m going to succeed in my mission of helping 1 million professional in the next five years, I NEED YOU to succeed… I can’t reach my goal without helping you reach yours! Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781842f9e7f2ca9',m:'8cafa4274e0e080bf776544e6d22d9cc81f6aae3-1627846598-1800-AZ2KGDTyWJZnI8S+AZl2R4i4A9YnbJqpDK5WEdktVGnzJhPmy6vW+4uKnfotC2GhtfJi3IuHpwlVllzkw+fvtjZWFEjkPyydTMua0FShv/Yp91OZ+yGZZumwPRKTWhs68EqhXzVwLkEdxM8RKTKvUHLYZ40KrmVXnTCCkOp3UyWzyOGDyEvEjXjh53nQyHh46jbQlHjp5/v/mOoPQ0fjvQ4=',s:[0xea6d696873,0xe98ea03bbb],}})();
  • Will be able to take Excel Automation tasks for self as well as client Automate your work and the work for others Learn how to record and run Excel Macros in detail Learn to use Google search to automate your tasks without coding Learn OBJECTS, PROPERTIES & METHODS in Excel Macros Learn to Color the code and Activating Edit Toolbar with Comments in Excel VBA Programming Understand RANGE & CELLS OBJECT in Excel VBA Macros Learn ABSOLUTE vs RELATIVE REFERENCE in Excel VBA Programming Learn RANGE NAVIGATION in Excel Macros Learn Variable Declaration in Excel VBA Programming Learn how to Loop in Excel VBA Learn how to OPTIMIZING EXCEL VBA CODE EFFICIENCY Learn what is Events in Excel Macros Learn how to make Input Box and Message Box in Excel VBA Programming Learn how to Insert button under Developer Tab Learn how to make User Form in Excel VBA Learn what is UDF in Excel VBA Programming Won’t waste time in manipulating and repetitive formatting Use my excel file to send emails automatically (basically communicate with different tools) Make use of custom functions that can be run from things like a button on a spreadsheet, the Excel Ribbon Show more Show less 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 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 Show more Show less Course content 17 sections • 102 lectures • 6h 21m total length Expand all sections Excel Macros for Beginner 8 lectures • 18min Why Learn Excel Macros? Preview 04:17 Download Practice Files 00:00 Activate Developer tab in Excel Preview 02:02 Saving a Macro-enabled Excel WorkBook (XLSM) 02:53 Excel Macro Security Settings 02:13 Excel Developer Tab - Essential Buttons 00:54 Head and Tail of a Excel Macros (Sub Procedure and User Defined Function) 04:00 Click Here button to run a Excel Macros 01:46 Hands on Learning on Macros 6 lectures • 20min Excel Macros - Record and Run Preview 05:07 Excel Macros - Viewing the code 02:41 Excel Macro-free vs. Macro-enabled Workbook 00:55 Visual Basic Editor (VBE) - Excel VBA 03:18 Personal Macro Workbook 05:20 Ways to Run a Macros (Excel VBA) Preview 02:46 Learn to use Google search to automate your tasks without coding 3 lectures • 19min Using Google to locate useful Excel VBA codes - Part 1 07:42 Using VBE and Macro Recorder to customize Excel Macro Code 04:46 Using Google to locate useful Excel VBA codes - Part 2 06:29 OBJECTS, PROPERTIES & METHODS in Excel Macros 2 lectures • 4min Objects, Properties, Values, Methods and Parameters - Part 1 02:19 Objects, Properties, Values, Methods and Parameters - Part 2 02:02 WORKSPACE in Excel Macros 5 lectures • 13min Code Color and Activating Edit Toolbar with Comments in Excel Macros 03:00 Edit Toolbar - Indent & Bookmark in Excel Macros 01:49 Excel Macros Code writing shortcuts including Intellisense 01:58 Testing the Excel Macro Code 02:58 Immediate Window - Part 01 03:06 Understanding RANGE & CELLS OBJECT in Excel Macros 10 lectures • 26min Range Selection - Method 1 04:55 Range Selection - Method 2 and 3 03:21 Advantage of Range Selection - Method 2 and 3 05:48 Range Selection (Rows and Columns) - Method 4 00:54 Assigning values to selected range of cells in Excel 02:01 Exercise 1 - Assigning values to selected range of cells in Excel 01:35 Exercise 2- Assigning values to selected range of cells in Excel 00:45 Multiple Range Selection - Method 5 02:01 Multiple Range Selection - Method 6 02:19 RangeSelectionWays - Others 02:04 ABSOLUTE vs RELATIVE REFERENCE in Excel Macros 2 lectures • 5min Offset - Excel Basics 01:53 Using Relative Reference in Excel Macros 03:11 RANGE NAVIGATION in Excel Macros 6 lectures • 15min Navigating between a Range of cells - Part 1A 02:14 Navigating between a Range of cells - Part 2 01:20 Navigating between a Range of cells - Part 3 01:49 Exercise - Finding Last Row Number in Excel 04:17 Exercise 2 - Finding Last Column Number in Excel 03:42 Exercise 3 - Finding Last Column Number in Excel 01:25 Variable Declaration in Excel Macros 6 lectures • 21min Variable Declaration in Excel Macros Part 1 04:26 Variable Declaration in Excel Macros Part 2 02:03 Private Macros vs Public Macros Part 1 02:16 Private Macros vs Public Macros Part 2 05:31 OptionExplicit in Excel Macros 04:29 Difference - DIM vs. SET in Excel Macros 02:03 Loops in Excel Macros 11 lectures • 1hr 1min For Next in Excel Macros 03:27 If Else End If nested within For Next - Excel Macros 05:23 Do While in Excel Macros 07:23 Do Until in Excel Macros 02:59 For Each Next in Excel Macros 04:08 If End If nested within For Each Next - Excel Macros 04:46 Excel Macros Exercise - Do While and Loop Counter 11:55 With End With - Excel Macros Example 1 11:55 With End With - Excel Macros Example 2 01:26 Select Case - Demonstration in Excel Macros 02:21 Excel Macros Select Case - Explanation 05:18 7 more sections Instructor Yoda Learning Data Analyst |MS Office Expert & PMP | Instructor/Programmer 4.5 Instructor Rating 8,882 Reviews 129,439 Students 28 Courses 20,000 Classroom Students | 100,000+ Students Online ex-KPMG, ex-J.P. Morgan | Chartered Accountant Taught 12k+ participants across PwC, EY and Deloitte over last 10 years I am a Chartered Accountant from India. I have worked with KPMG (Audit) and J.P. Morgan (Debt Capital Markets) and Futures First (Proprietary Trading Desk) before venturing into Corporate Training (first part-time and then full-time) After a decade of corporate training and winning multiple accolades in Office Productivity and Financial Modelling, in 2015, I created a mission to help 1 million people by 2020. I started creating high-quality video courses and helped people online to become faster-smarter-better at work. A lot of my students at PwC, EY, Deloitte, Amazon, Uber, Tata Group, Rio Tinto use these video courses to excel at work. If I’m going to succeed in my mission of helping 1 million professional in the next five years, I NEED YOU to succeed… I can’t reach my goal without helping you reach yours! Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781842f9e7f2ca9',m:'8cafa4274e0e080bf776544e6d22d9cc81f6aae3-1627846598-1800-AZ2KGDTyWJZnI8S+AZl2R4i4A9YnbJqpDK5WEdktVGnzJhPmy6vW+4uKnfotC2GhtfJi3IuHpwlVllzkw+fvtjZWFEjkPyydTMua0FShv/Yp91OZ+yGZZumwPRKTWhs68EqhXzVwLkEdxM8RKTKvUHLYZ40KrmVXnTCCkOp3UyWzyOGDyEvEjXjh53nQyHh46jbQlHjp5/v/mOoPQ0fjvQ4=',s:[0xea6d696873,0xe98ea03bbb],}})();
  • Automate your work and the work for others Learn how to record and run Excel Macros in detail Learn to use Google search to automate your tasks without coding Learn OBJECTS, PROPERTIES & METHODS in Excel Macros Learn to Color the code and Activating Edit Toolbar with Comments in Excel VBA Programming Understand RANGE & CELLS OBJECT in Excel VBA Macros Learn ABSOLUTE vs RELATIVE REFERENCE in Excel VBA Programming Learn RANGE NAVIGATION in Excel Macros Learn Variable Declaration in Excel VBA Programming Learn how to Loop in Excel VBA Learn how to OPTIMIZING EXCEL VBA CODE EFFICIENCY Learn what is Events in Excel Macros Learn how to make Input Box and Message Box in Excel VBA Programming Learn how to Insert button under Developer Tab Learn how to make User Form in Excel VBA Learn what is UDF in Excel VBA Programming Won’t waste time in manipulating and repetitive formatting Use my excel file to send emails automatically (basically communicate with different tools) Make use of custom functions that can be run from things like a button on a spreadsheet, the Excel Ribbon Show more Show less 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 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 Show more Show less Course content 17 sections • 102 lectures • 6h 21m total length Expand all sections Excel Macros for Beginner 8 lectures • 18min Why Learn Excel Macros? Preview 04:17 Download Practice Files 00:00 Activate Developer tab in Excel Preview 02:02 Saving a Macro-enabled Excel WorkBook (XLSM) 02:53 Excel Macro Security Settings 02:13 Excel Developer Tab - Essential Buttons 00:54 Head and Tail of a Excel Macros (Sub Procedure and User Defined Function) 04:00 Click Here button to run a Excel Macros 01:46 Hands on Learning on Macros 6 lectures • 20min Excel Macros - Record and Run Preview 05:07 Excel Macros - Viewing the code 02:41 Excel Macro-free vs. Macro-enabled Workbook 00:55 Visual Basic Editor (VBE) - Excel VBA 03:18 Personal Macro Workbook 05:20 Ways to Run a Macros (Excel VBA) Preview 02:46 Learn to use Google search to automate your tasks without coding 3 lectures • 19min Using Google to locate useful Excel VBA codes - Part 1 07:42 Using VBE and Macro Recorder to customize Excel Macro Code 04:46 Using Google to locate useful Excel VBA codes - Part 2 06:29 OBJECTS, PROPERTIES & METHODS in Excel Macros 2 lectures • 4min Objects, Properties, Values, Methods and Parameters - Part 1 02:19 Objects, Properties, Values, Methods and Parameters - Part 2 02:02 WORKSPACE in Excel Macros 5 lectures • 13min Code Color and Activating Edit Toolbar with Comments in Excel Macros 03:00 Edit Toolbar - Indent & Bookmark in Excel Macros 01:49 Excel Macros Code writing shortcuts including Intellisense 01:58 Testing the Excel Macro Code 02:58 Immediate Window - Part 01 03:06 Understanding RANGE & CELLS OBJECT in Excel Macros 10 lectures • 26min Range Selection - Method 1 04:55 Range Selection - Method 2 and 3 03:21 Advantage of Range Selection - Method 2 and 3 05:48 Range Selection (Rows and Columns) - Method 4 00:54 Assigning values to selected range of cells in Excel 02:01 Exercise 1 - Assigning values to selected range of cells in Excel 01:35 Exercise 2- Assigning values to selected range of cells in Excel 00:45 Multiple Range Selection - Method 5 02:01 Multiple Range Selection - Method 6 02:19 RangeSelectionWays - Others 02:04 ABSOLUTE vs RELATIVE REFERENCE in Excel Macros 2 lectures • 5min Offset - Excel Basics 01:53 Using Relative Reference in Excel Macros 03:11 RANGE NAVIGATION in Excel Macros 6 lectures • 15min Navigating between a Range of cells - Part 1A 02:14 Navigating between a Range of cells - Part 2 01:20 Navigating between a Range of cells - Part 3 01:49 Exercise - Finding Last Row Number in Excel 04:17 Exercise 2 - Finding Last Column Number in Excel 03:42 Exercise 3 - Finding Last Column Number in Excel 01:25 Variable Declaration in Excel Macros 6 lectures • 21min Variable Declaration in Excel Macros Part 1 04:26 Variable Declaration in Excel Macros Part 2 02:03 Private Macros vs Public Macros Part 1 02:16 Private Macros vs Public Macros Part 2 05:31 OptionExplicit in Excel Macros 04:29 Difference - DIM vs. SET in Excel Macros 02:03 Loops in Excel Macros 11 lectures • 1hr 1min For Next in Excel Macros 03:27 If Else End If nested within For Next - Excel Macros 05:23 Do While in Excel Macros 07:23 Do Until in Excel Macros 02:59 For Each Next in Excel Macros 04:08 If End If nested within For Each Next - Excel Macros 04:46 Excel Macros Exercise - Do While and Loop Counter 11:55 With End With - Excel Macros Example 1 11:55 With End With - Excel Macros Example 2 01:26 Select Case - Demonstration in Excel Macros 02:21 Excel Macros Select Case - Explanation 05:18 7 more sections Instructor Yoda Learning Data Analyst |MS Office Expert & PMP | Instructor/Programmer 4.5 Instructor Rating 8,882 Reviews 129,439 Students 28 Courses 20,000 Classroom Students | 100,000+ Students Online ex-KPMG, ex-J.P. Morgan | Chartered Accountant Taught 12k+ participants across PwC, EY and Deloitte over last 10 years I am a Chartered Accountant from India. I have worked with KPMG (Audit) and J.P. Morgan (Debt Capital Markets) and Futures First (Proprietary Trading Desk) before venturing into Corporate Training (first part-time and then full-time) After a decade of corporate training and winning multiple accolades in Office Productivity and Financial Modelling, in 2015, I created a mission to help 1 million people by 2020. I started creating high-quality video courses and helped people online to become faster-smarter-better at work. A lot of my students at PwC, EY, Deloitte, Amazon, Uber, Tata Group, Rio Tinto use these video courses to excel at work. If I’m going to succeed in my mission of helping 1 million professional in the next five years, I NEED YOU to succeed… I can’t reach my goal without helping you reach yours! Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781842f9e7f2ca9',m:'8cafa4274e0e080bf776544e6d22d9cc81f6aae3-1627846598-1800-AZ2KGDTyWJZnI8S+AZl2R4i4A9YnbJqpDK5WEdktVGnzJhPmy6vW+4uKnfotC2GhtfJi3IuHpwlVllzkw+fvtjZWFEjkPyydTMua0FShv/Yp91OZ+yGZZumwPRKTWhs68EqhXzVwLkEdxM8RKTKvUHLYZ40KrmVXnTCCkOp3UyWzyOGDyEvEjXjh53nQyHh46jbQlHjp5/v/mOoPQ0fjvQ4=',s:[0xea6d696873,0xe98ea03bbb],}})();
  • Learn how to record and run Excel Macros in detail Learn to use Google search to automate your tasks without coding Learn OBJECTS, PROPERTIES & METHODS in Excel Macros Learn to Color the code and Activating Edit Toolbar with Comments in Excel VBA Programming Understand RANGE & CELLS OBJECT in Excel VBA Macros Learn ABSOLUTE vs RELATIVE REFERENCE in Excel VBA Programming Learn RANGE NAVIGATION in Excel Macros Learn Variable Declaration in Excel VBA Programming Learn how to Loop in Excel VBA Learn how to OPTIMIZING EXCEL VBA CODE EFFICIENCY Learn what is Events in Excel Macros Learn how to make Input Box and Message Box in Excel VBA Programming Learn how to Insert button under Developer Tab Learn how to make User Form in Excel VBA Learn what is UDF in Excel VBA Programming Won’t waste time in manipulating and repetitive formatting Use my excel file to send emails automatically (basically communicate with different tools) Make use of custom functions that can be run from things like a button on a spreadsheet, the Excel Ribbon Show more Show less 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 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 Show more Show less Course content 17 sections • 102 lectures • 6h 21m total length Expand all sections Excel Macros for Beginner 8 lectures • 18min Why Learn Excel Macros? Preview 04:17 Download Practice Files 00:00 Activate Developer tab in Excel Preview 02:02 Saving a Macro-enabled Excel WorkBook (XLSM) 02:53 Excel Macro Security Settings 02:13 Excel Developer Tab - Essential Buttons 00:54 Head and Tail of a Excel Macros (Sub Procedure and User Defined Function) 04:00 Click Here button to run a Excel Macros 01:46 Hands on Learning on Macros 6 lectures • 20min Excel Macros - Record and Run Preview 05:07 Excel Macros - Viewing the code 02:41 Excel Macro-free vs. Macro-enabled Workbook 00:55 Visual Basic Editor (VBE) - Excel VBA 03:18 Personal Macro Workbook 05:20 Ways to Run a Macros (Excel VBA) Preview 02:46 Learn to use Google search to automate your tasks without coding 3 lectures • 19min Using Google to locate useful Excel VBA codes - Part 1 07:42 Using VBE and Macro Recorder to customize Excel Macro Code 04:46 Using Google to locate useful Excel VBA codes - Part 2 06:29 OBJECTS, PROPERTIES & METHODS in Excel Macros 2 lectures • 4min Objects, Properties, Values, Methods and Parameters - Part 1 02:19 Objects, Properties, Values, Methods and Parameters - Part 2 02:02 WORKSPACE in Excel Macros 5 lectures • 13min Code Color and Activating Edit Toolbar with Comments in Excel Macros 03:00 Edit Toolbar - Indent & Bookmark in Excel Macros 01:49 Excel Macros Code writing shortcuts including Intellisense 01:58 Testing the Excel Macro Code 02:58 Immediate Window - Part 01 03:06 Understanding RANGE & CELLS OBJECT in Excel Macros 10 lectures • 26min Range Selection - Method 1 04:55 Range Selection - Method 2 and 3 03:21 Advantage of Range Selection - Method 2 and 3 05:48 Range Selection (Rows and Columns) - Method 4 00:54 Assigning values to selected range of cells in Excel 02:01 Exercise 1 - Assigning values to selected range of cells in Excel 01:35 Exercise 2- Assigning values to selected range of cells in Excel 00:45 Multiple Range Selection - Method 5 02:01 Multiple Range Selection - Method 6 02:19 RangeSelectionWays - Others 02:04 ABSOLUTE vs RELATIVE REFERENCE in Excel Macros 2 lectures • 5min Offset - Excel Basics 01:53 Using Relative Reference in Excel Macros 03:11 RANGE NAVIGATION in Excel Macros 6 lectures • 15min Navigating between a Range of cells - Part 1A 02:14 Navigating between a Range of cells - Part 2 01:20 Navigating between a Range of cells - Part 3 01:49 Exercise - Finding Last Row Number in Excel 04:17 Exercise 2 - Finding Last Column Number in Excel 03:42 Exercise 3 - Finding Last Column Number in Excel 01:25 Variable Declaration in Excel Macros 6 lectures • 21min Variable Declaration in Excel Macros Part 1 04:26 Variable Declaration in Excel Macros Part 2 02:03 Private Macros vs Public Macros Part 1 02:16 Private Macros vs Public Macros Part 2 05:31 OptionExplicit in Excel Macros 04:29 Difference - DIM vs. SET in Excel Macros 02:03 Loops in Excel Macros 11 lectures • 1hr 1min For Next in Excel Macros 03:27 If Else End If nested within For Next - Excel Macros 05:23 Do While in Excel Macros 07:23 Do Until in Excel Macros 02:59 For Each Next in Excel Macros 04:08 If End If nested within For Each Next - Excel Macros 04:46 Excel Macros Exercise - Do While and Loop Counter 11:55 With End With - Excel Macros Example 1 11:55 With End With - Excel Macros Example 2 01:26 Select Case - Demonstration in Excel Macros 02:21 Excel Macros Select Case - Explanation 05:18 7 more sections Instructor Yoda Learning Data Analyst |MS Office Expert & PMP | Instructor/Programmer 4.5 Instructor Rating 8,882 Reviews 129,439 Students 28 Courses 20,000 Classroom Students | 100,000+ Students Online ex-KPMG, ex-J.P. Morgan | Chartered Accountant Taught 12k+ participants across PwC, EY and Deloitte over last 10 years I am a Chartered Accountant from India. I have worked with KPMG (Audit) and J.P. Morgan (Debt Capital Markets) and Futures First (Proprietary Trading Desk) before venturing into Corporate Training (first part-time and then full-time) After a decade of corporate training and winning multiple accolades in Office Productivity and Financial Modelling, in 2015, I created a mission to help 1 million people by 2020. I started creating high-quality video courses and helped people online to become faster-smarter-better at work. A lot of my students at PwC, EY, Deloitte, Amazon, Uber, Tata Group, Rio Tinto use these video courses to excel at work. If I’m going to succeed in my mission of helping 1 million professional in the next five years, I NEED YOU to succeed… I can’t reach my goal without helping you reach yours! Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781842f9e7f2ca9',m:'8cafa4274e0e080bf776544e6d22d9cc81f6aae3-1627846598-1800-AZ2KGDTyWJZnI8S+AZl2R4i4A9YnbJqpDK5WEdktVGnzJhPmy6vW+4uKnfotC2GhtfJi3IuHpwlVllzkw+fvtjZWFEjkPyydTMua0FShv/Yp91OZ+yGZZumwPRKTWhs68EqhXzVwLkEdxM8RKTKvUHLYZ40KrmVXnTCCkOp3UyWzyOGDyEvEjXjh53nQyHh46jbQlHjp5/v/mOoPQ0fjvQ4=',s:[0xea6d696873,0xe98ea03bbb],}})();
  • Learn to use Google search to automate your tasks without coding Learn OBJECTS, PROPERTIES & METHODS in Excel Macros Learn to Color the code and Activating Edit Toolbar with Comments in Excel VBA Programming Understand RANGE & CELLS OBJECT in Excel VBA Macros Learn ABSOLUTE vs RELATIVE REFERENCE in Excel VBA Programming Learn RANGE NAVIGATION in Excel Macros Learn Variable Declaration in Excel VBA Programming Learn how to Loop in Excel VBA Learn how to OPTIMIZING EXCEL VBA CODE EFFICIENCY Learn what is Events in Excel Macros Learn how to make Input Box and Message Box in Excel VBA Programming Learn how to Insert button under Developer Tab Learn how to make User Form in Excel VBA Learn what is UDF in Excel VBA Programming Won’t waste time in manipulating and repetitive formatting Use my excel file to send emails automatically (basically communicate with different tools) Make use of custom functions that can be run from things like a button on a spreadsheet, the Excel Ribbon Show more Show less 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 Basi