Excel VBA and Macros programming for Absolute Beginners

Excel VBA and Macros programming for Absolute Beginners, available at $19.99, has an average rating of 4.05, with 31 lectures, based on 42 reviews, and has 2549 subscribers.

You will learn about Tackle complicated Excel situations Easily Automate Excel and make it do all the work for you Save thousands of hours of your life This course is ideal for individuals who are It is for one who wants to learn how powerful VBA is. or It is for one who is tired of limitations of Excel. It is particularly useful for It is for one who wants to learn how powerful VBA is. or It is for one who is tired of limitations of Excel.

Enroll now: Excel VBA and Macros programming for Absolute Beginners

Summary

Title: Excel VBA and Macros programming for Absolute Beginners

Price: $19.99

Average Rating: 4.05

Number of Lectures: 31

Number of Published Lectures: 31

Number of Curriculum Items: 31

Number of Published Curriculum Objects: 31

Original Price: $199.99

Quality Status: approved

Status: Live

What You Will Learn

Tackle complicated Excel situations Easily
Automate Excel and make it do all the work for you
Save thousands of hours of your life

Who Should Attend

It is for one who wants to learn how powerful VBA is.
It is for one who is tired of limitations of Excel.

Target Audiences

It is for one who wants to learn how powerful VBA is.
It is for one who is tired of limitations of Excel.

Last Update: 2-July-2017 : Make VBA Speak for us

Last Update: 22-June-2017 : Opening Notepad with VBA

Last Update: 17-March-2016 : Creating Duplicates exists program

Last Update: 6-Feb-2016 : How to paste data to new workbook and save it

Did you know that repetition is a curse, if you don’t stop then
you’ll be wasting thousands of hours of your life. As an Excel user, you know
that many times you create same sheet, with same formatting and same formulas,
again and again. So, you’re wasting thousands of hours, which you can spend with
your family, or doing other important stuff.

Luckily,
there is a tool or a language using which you can save those thousand hours of
your life by creating a simple program which does the work for you. The program
will create the sheet for you, it’ll format it for you and it’ll insert the
formulas you. Not just that It’ll protect your data in different ways.

Excel
VBA, the programming language we’re going to learn in this course which’ll help
you automate your daily tasks more smarter and more easier. You’ll be able to tackle
different and complicated situations easier.

So,
don’t waste anymore hour or second of your life and take this course
immediately, uncover the tools which’ll make your life easier.

Note: This course is available for free if you can’t afford to buy it, just message me and I’ll send you the link

Course Curriculum

Chapter 1: Introduction to Course

Lecture 1: Introduction to Course and Me

Chapter 2: Introduction to VBA

Lecture 1: What is Excel VBA ?

Lecture 2: VBA Macro Recorder

Lecture 3: Absolute Vs Relative Reference

Lecture 4: How to protect your code

Chapter 3: Basics of VBA Programming

Lecture 1: Getting to know VBA Environment

Lecture 2: Excel VBA Variables

Lecture 3: Learning Range,Cells,Active cell etc.

Lecture 4: VBA_Worksheets and Workbooks

Lecture 5: Introduction To Functions

Chapter 4: VBA Conditional Statements

Lecture 1: IF Then Else Statement

Lecture 2: Select Case Statement

Chapter 5: VBA Loops Statements

Lecture 1: Do While and Do Until Loop Statement

Lecture 2: For Loop Statement

Chapter 6: VBA Message Box and Input Box

Lecture 1: Message Box detailed

Lecture 2: Input Box detailed

Chapter 7: Introduction to Forms

Lecture 1: Getting Started with Forms

Lecture 2: Forms_ coding close button and adding Text Boxes

Lecture 3: How to access last row of worksheet in Excel

Lecture 4: Forms_Adding Nationality and Date of Birth to project

Lecture 5: Forms_Adding Combo Box

Lecture 6: VBA_Forms_Adding Gender and Contact Number

Lecture 7: Recreating project using Active X Controls

Chapter 8: VBA_miscellaneous

Lecture 1: VBA_Auto Open

Lecture 2: VBA_Object Variables and With statement_Learn to stop repeating

Lecture 3: Opening Notepad With VBA

Lecture 4: Make VBA Speak for us

Chapter 9: Macro

Lecture 1: Macro1_How to paste data to new workbook and save it

Lecture 2: Creating Duplicates exists program

Lecture 3: How to delay the code execution

Chapter 10: What to do Now ?

Lecture 1: What to do now ?

Instructors

Muhammad Ali Yasin
Online Tutor

Rating Distribution

1 stars: 4 votes
2 stars: 3 votes
3 stars: 4 votes
4 stars: 14 votes
5 stars: 17 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!

Menu