Excel VBA and Macros programming for Absolute Beginners

Learn to have better control over your excel books.
4.1 (9 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
1,679 students enrolled
$19
$25
24% off
Take This Course
  • Lectures 26
  • Length 1.5 hours
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 1/2016 English

Course Description

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

What are the requirements?

  • Just basic knowledge of Excel

What am I going to get from this course?

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

What is the target audience?

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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction to Course
00:55

In this Introductory course I'll be Introducing myself and the course to you. Its basically just a getting to know video

Section 2: Introduction to VBA
04:27

In this Excel VBA tutorial, we're going to start our lesson with some introduction then we're going to code our first Hello World Program.

03:06

In this excel vba tutorial, we're going to learn about Macro Recorder and learn advantages of using it.

Absolute Vs Relative Referance
02:59
How to protect your code
Preview
02:42
Section 3: Basics of VBA Programming
05:46

In this excel VBA tutorial, we're going to get better understanding you VBA environment and look around it.

04:17

In this Excel VBA coding tutorial, we're going to learn about variables, why we use them, and how can we declare them.

08:30

In this Excel VBA coding tutorial, we're going to learn about some important statements in VBA such as Range,Cells,active cell etc.

04:48

In this excel VBA coding tutorial, we're going to learn how to control our workbooks and worksheets with VBA.

Section 4: VBA Conditional Statements
03:05

In this excel VBA conditional statements tutorial, we're going to learn about if then Else statement with many examples.

04:23

In this excel VBA conditional statements tutorial, we're going to learn about various ways of using Case statement with many examples.

Section 5: VBA Loops Statements
02:28

In this Excel VBA loops tutorial, we're going to learn For loop statement with examples.

03:02

In this Excel VBA loops tutorial, we're going to learn the Do while and Do until loop statement with examples.

Section 6: VBA Message Box and Input Box
03:42

In this Excel VBA coding tutorial, we're going to get a deeper look at the MsgBox.

01:34

In this Excel VBA coding tutorial, we're going to get a deeper look at the inputbox.

Section 7: Introduction to Forms
02:50

In this first Excel VBA Forms tutorial, we're going to design and format our form.

01:13

In this Excel VBA tutorial, we're going to first code our close command Button, then we're gonna add labels and Text boxes.

02:35

In this Excel VBA coding tutorial,we're going to learn how we can access last non-populated row on our sheet with VBA.

03:22

In this excel VBA Forms tutorial, we're going to add new fields named Nationalities and Date of Birth.

03:51

In this excel VBA Forms tutorial, we're going to be replacing our Nationalities textbox with Combo Box.

04:11

In this excel VBA Forms tutorial, we're going to be adding extra two fields named Gender and Contact Number.

03:05

In this excel VBA Forms tutorial, we're going to be creating the same project above created using forms.

Section 8: VBA_miscellaneous
01:36

In this tutorial we're gonna learn how to trigger VBA code when opening excel Book.

03:48

In this tutorial I'll be showing you how to make an object variable and also show you how to use with Statement. With these two tips you can reduce the code amount by not repeating same code.

Section 9: Macro
Macro1_How to paste data to new workbook and save it
03:09
02:51

In this lecture we're going to learn to create a simple program which is going to check duplicates for us

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Muhammad Ali Yasin, Online Tutor

I'm an online tutor and I'm currently working at a Real Estate company called Saba Real Estate and controlling everything related to IT. I've been teaching online since middle school. I've taught many subjects such as HTML,CSS,Excel,Access,C#,C,VBA etc to many people around the world. I'm familiar with English,Arabic,Hindi,Urdu and little Japanese.

I love to watch anime and learn new languages whether its a programming language or a country language.

My aim in life is to build my own school and teach in it.

Ready to start learning?
Take This Course