HOT
blank

Excel Automation: Learn VBA & Macros From Scratch!

Office Productivity

Rating4.4
Enroll Now

Excel Automation: Learn VBA & Macros From Scratch!, available at $64.99, has an average rating of 4.35, with 52 lectures, based on 242 reviews, and has 778 subscribers.

You will learn about Fundamentals of coding, to be able to Understand, Read & Write your own codes Understand the syntax so you can read an existing code and make changes where necessary Combined use of Writing & Recording to build full fledged Automations of your own Save time by Automating repetitive or Routine work This course is ideal for individuals who are Someone who wants to automate their work in Excel or Someone who wants to save Time and Energy spent on repetitive or routine work or Average or above average Excel Users or Leaders who want to drive process improvements or efficiency in their teams It is particularly useful for Someone who wants to automate their work in Excel or Someone who wants to save Time and Energy spent on repetitive or routine work or Average or above average Excel Users or Leaders who want to drive process improvements or efficiency in their teams.

Enroll now: Excel Automation: Learn VBA & Macros From Scratch!

Summary

Title: Excel Automation: Learn VBA & Macros From Scratch!

Price: $64.99

Average Rating: 4.35

Number of Lectures: 52

Number of Published Lectures: 52

Number of Curriculum Items: 65

Number of Published Curriculum Objects: 65

Original Price: ₹7,500

Quality Status: approved

Status: Live

What You Will Learn

  • Fundamentals of coding, to be able to Understand, Read & Write your own codes
  • Understand the syntax so you can read an existing code and make changes where necessary
  • Combined use of Writing & Recording to build full fledged Automations of your own
  • Save time by Automating repetitive or Routine work

Who Should Attend

  • Someone who wants to automate their work in Excel
  • Someone who wants to save Time and Energy spent on repetitive or routine work
  • Average or above average Excel Users
  • Leaders who want to drive process improvements or efficiency in their teams

Target Audiences

  • Someone who wants to automate their work in Excel
  • Someone who wants to save Time and Energy spent on repetitive or routine work
  • Average or above average Excel Users
  • Leaders who want to drive process improvements or efficiency in their teams

This course is built for Existing Excel users who would like to make their life more simplerand smarterby automating manual/repetitive work in Excel.

FAQs

Q: I’ve never done coding before and have no background to VBA. Can I still learn it?

A: Yes, This course is mainly targeted to those who are absolutely new to coding/programming. I’ve trained over 5000 students with no programming background successfully. 

Q: I’m not a great learner, I find difficulty understanding and working with codes/programming. can I learn it?

A: I consider myself as the worst student. So if I can learn it, you can too. 

Q: Why is coding/programming considered so difficult? Can a person with not a great memory learn it?

A: Anything is difficult to remember and understand, if you do not have ample background to it, which answers the “WHYs?” of those concepts. Moreover, I’m myself the person who’s not too great at memory, and that makes me ensure that I use simple language, with relatable examples and provide ample background to the concepts in my course. 

Q: I know how to record macros and I’m doing pretty well? What more this course has to offer?

A: Recording is just one part of your learning. there are many more concepts in VBA which a person should know, to get smarter andmore efficientat coding. This course doesn’t revolve around recording the macros only. It focuses more on how toWrite the macros from scratch. The idea is to make sure you are able tounderstand the codes so well, that it becomes easy for you to make moresmarter macrosgoing forward. Refer to thecourse contents of this course to know the details of what will be covered in this course.

 “If you feel something is complicated or not your cup of tea, its majorly because you tried jumping on the advanced concepts rather than absorbing the basics first”  –  

This course is an effort to provide ample background of each concepts and stresses on the fundamental areas to ensure that you learn it correctly and can re-implement the concepts when required.

After completing this course you will be able to:

  1. Build your own full fledged macros from scratch

  2. Writeyour macros

  3. Understandyour macros

  4. Edit/Modify your macros to improve performance

  5. Create your own User Defined Functions

  6. Auto execute Macros on Several Events.

  7. Re implementthe concepts to different problems

  8. Start Lovingto code (in case you currently don’t)

Looking forward to having more interactions with you in the course.

Happy Learning!

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: Approach

Chapter 2: Theory

Lecture 1: Intro To Section

Lecture 2: VBA & Macros – Get the correct understanding

Lecture 3: Object Oriented Programming Language – Made Easy

Lecture 4: Object Referencing in VBA

Lecture 5: Object Within Object Referencing in VBA

Lecture 6: Function Referencing

Lecture 7: Understand Properties and Methods

Lecture 8: Intro to VBA Window and Writing Macros

Lecture 9: Saving your Macros

Lecture 10: Enabling Macros

Lecture 11: Connections

Lecture 12: Connections(1/3): Objects & Functions

Lecture 13: Connections(2/3): Objects & Properties

Lecture 14: Connections(3/3): Objects & Methods

Lecture 15: Different ways you can execute your Macros

Chapter 3: Writing your Macros

Lecture 1: Intro To Section

Lecture 2: Variables

Lecture 3: Range Loop – FOR

Lecture 4: Conditional Loop – DO

Lecture 5: Conditional Statement (IF, AND, OR)

Lecture 6: Select Case Statements

Lecture 7: How to make your Macros – Smart

Lecture 8: Error Handling

Lecture 9: What's next ?

Chapter 4: Recording Macros

Lecture 1: Introduction

Lecture 2: How to Record?

Chapter 5: Complete Macros (Writing + Recording)

Lecture 1: Introduction to Section

Lecture 2: Execute Multiple Macros with a single Button

Lecture 3: ScreenUpdating Property

Chapter 6: Starting Advanced

Lecture 1: Introduction

Chapter 7: Sub Routine

Lecture 1: Introduction

Lecture 2: Example – Button Click

Lecture 3: Example – Keyboard Shortcut

Lecture 4: Example – Custom Keystroke

Lecture 5: Example – Scheduling Macros

Lecture 6: Summarizing Sub Routines

Chapter 8: Private Sub Routines

Lecture 1: Introduction

Lecture 2: Example – WorkBook Open Event

Lecture 3: Example – WorkBook Close Event

Lecture 4: Example – Change Event

Lecture 5: Summarizing Private Sub Routines

Chapter 9: Function Routines

Lecture 1: Introduction

Lecture 2: Understand How to create a Basic Function (Static output)

Lecture 3: Understand How to make your Function Dynamic (Using Cell references as input)

Chapter 10: Global Macros

Lecture 1: Introduction to Global Macros

Lecture 2: What is an Excel ADD IN?

Lecture 3: Global Macros – SUB

Lecture 4: Global Macros – FUNCTION

Lecture 5: Global Macros – PRIVATE SUB

Lecture 6: Closing

Instructors

  • Kamal Vaswani
    Kamal Vaswani
    Sr Business Analyst |10,000+ Hrs of Experience as Instructor

Rating Distribution

  • 1 stars: 4 votes
  • 2 stars: 4 votes
  • 3 stars: 18 votes
  • 4 stars: 82 votes
  • 5 stars: 134 votes

Frequently Asked Questions


How long do I have access to the course materials?


You can view and review the lecture materials indefinitely, like an on-demand channel.


Can I take my courses with me wherever I go?


Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

You may also like

Top 10 Chatgpt And Ai Tools Courses to Learn in November 2024

Top 10 Excel Vba Courses to Learn in November 2024

YouTube: How to Start a Successful YouTube Channel