Excel VBA and Macros programming for Absolute Beginners
4.5 (15 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,699 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel VBA and Macros programming for Absolute Beginners to your Wishlist.

Add to Wishlist

Excel VBA and Macros programming for Absolute Beginners

Learn to have better control over your excel books.
4.5 (15 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,699 students enrolled
Last updated 6/2017
English
Current price: $10 Original price: $20 Discount: 50% off
3 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Tackle complicated Excel situations Easily
  • Automate Excel and make it do all the work for you
  • Save thousands of hours of your life
View Curriculum
Requirements
  • Just basic knowledge of Excel
Description

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

Who 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
27 Lectures
01:35:00
+
Introduction to Course
1 Lecture 00:55

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

Preview 00:55
+
Introduction to VBA
4 Lectures 13:14

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.

Preview 04:27

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

VBA Macro Recorder
03:06

Absolute Vs Relative Referance
02:59

+
Basics of VBA Programming
4 Lectures 23:21

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

Getting to know VBA Environment
05:46

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

Excel VBA Variables
04:17

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

Preview 08:30

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

VBA_Worksheets and Workbooks
04:48
+
VBA Conditional Statements
2 Lectures 07:28

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

IF Then Else Statement
03:05

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

Select Case Statement
04:23
+
VBA Loops Statements
2 Lectures 05:30

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

For Loop Statement
02:28

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

Do While and Do Until Loop Statement
03:02
+
VBA Message Box and Input Box
2 Lectures 05:16

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

Message Box detailed
03:42

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

Input Box detailed
01:34
+
Introduction to Forms
7 Lectures 21:07

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

Getting Started with Forms
02:50

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

Forms_ coding close button and adding Text Boxes
01:13

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

How to access last row of worksheet in Excel
02:35

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

Forms_Adding Nationality and Date of Birth to project
03:22

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

Forms_Adding Combo Box
03:51

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

VBA_Forms_Adding Gender and Contact Number
04:11

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

Recreating project using Active X Controls
03:05
+
VBA_miscellaneous
3 Lectures 12:09

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

Preview 01:36

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.

VBA_Object Variables and With statement_Learn to stop repeating
03:48

In this video I'm going to be showing you how to open notepad, notepad files, and Calculator using VBA as well as 

Opening Notepad With VBA
06:45
+
Macro
2 Lectures 06:00
Macro1_How to paste data to new workbook and save it
03:09

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

Preview 02:51
About the Instructor
Muhammad Ali Yasin
4.8 Average rating
18 Reviews
2,434 Students
2 Courses
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.