Excel VBA/Macros foundations for beginners
4.7 (29 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.
308 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel VBA/Macros foundations for beginners to your Wishlist.

Add to Wishlist

Excel VBA/Macros foundations for beginners

A Beginner's Roadmap to Learning Excel VBA !
4.7 (29 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.
308 students enrolled
Created by Abdelrahman Abdou
Last updated 7/2017
English
Current price: $10 Original price: $195 Discount: 95% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 9 hours on-demand video
  • 6 Articles
  • 37 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • By the end of the course, You will have developed a solid foundation in Excel VBA that will enable you to tackle more advanced topics in Excel VBA with ease.
  • Learn how to deal with cells, worksheets, workbooks, and other objects in Excel using the VBA Language
  • Learning one programming language can help you learn other programming languages as well!
View Curriculum
Requirements
  • You should be an intermediate user of Excel
  • You need to know how to write formulas, use pivot tables and draw charts.
  • You need to have Excel 2007 or later
Description

Learn step by step how to automate your spreadsheets using the power of programming in Excel! 

This course is designed to teach beginners who have no background in programming how to program in Excel VBA!

What you need before taking this course

  • The will to learn !
  • You need to be at least an intermediate user of Excel, know how to write formulas, draw charts and use pivot tables.

A Powerful Skill at Your Fingertips

Learning how to program in Excel will increase your market value and allow you to save time on your spreadsheets.

It will also be a great way to tap into the world of programming, and will help lay the foundation in case you need to learn any other programming language!

Who is the target audience?

This course is targeted towards beginners who want to start learning how to program in Excel.

If you don't know anything about Macros/VBA language, then this course is for you.

If you can only record Macros, but don't know how to write VBA code, then this course is for you as well.

If you already know how to write VBA code, including IF statements,Loops, and use Events, then this course isn't for you.

You need to be someone who knows his way around Excel and knows how to write formulas,use pivot tables, and draw charts.


Who is the target audience?
  • Someone who wants to learn how to program/write code in Excel using the Visual Basic for Applications (VBA) language.
  • Needs to know how to write formulas, use pivot tables and draw charts in Excel.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
129 Lectures
09:12:55
+
Introduction
9 Lectures 39:20

In this lecture, students will have an introduction about the course contents,objectives and target audience.

Preview 03:29

Leaving a Review and Providing me with Feedback
04:59

This lecture explains the difference between recording macros and writing VBA code.

Preview 03:49

This lecture explains the the object model in Excel VBA

Understanding Objects in Excel VBA
07:18

This lecture explains the syntax of the VBA language.

Preview 09:48

Understanding VBA Syntax- Exercise
00:02

This lecture explains how to activate the developer tab which is key for dealing with the VBA language in Excel.

Activating the Developer tab
00:55

This lecture explains how to record a basic macro.

Recording a basic Macro
05:04

This lecture explains the difference between recording macros in relative vs absolute mode.

Absolute vs Relative Macro recording
03:56
+
Exploring the Visual Basic Environment
7 Lectures 18:44

This lecture introduces the Visual basic Environment in Excel.

Introduction to The Visual Basic Environment
02:09

This lecture explains what the project explorer is and how to deal with it.

The Project Explorer
02:05

This lecture explains the properties window.

The Properties WIndow
02:17

This lecture explains the code window VB Environment.

The Code WIndow
04:18

This lecture explains the immediate,locals and watch windows.

Immediate,Locals and Watch Window
03:48

This lecture explains how to deal with modules in the VB Environment.

Dealing with Modules
03:08

This lecture explains how to write comments in Excel VBA and what they are used for.

Comments in Excel VBA
00:59
+
The Range Object
12 Lectures 54:33

Introduction to the range object in Excel VBA and how to change a cell's value.

Workbook for the range object is attached to this lecture.

Introduction and Changing Cell Values
10:27

Explains how to add a text to a cell.

Adding a text to a cell
01:27

Explains how to deal with named ranges in Excel VBA.

Dealing with Named Ranges
03:15

Explains the difference between the value vs Text properties in Excel VBA

Value vs Text Property
03:37

Explains the row and column properties for the range object in Excel VBA

Row and Column properties
02:02

Explains the select method for the range object

The Select Method
02:12

Explains the count property for the range object.

The Count Property
03:37

Explains the address property for the range object.

The Address Property
09:23

Explains the formula property for the range object.

The Formula Property
03:27

Explains the number format property for the range object.

The Number Format Property
06:34

Explains the font property for the range object.

The Font Property
08:14

Exercise- Range object
00:18
+
Understanding the Cells collection object
5 Lectures 16:12

Introduction to the cells collection object in Excel VBA

Workbook for the cells collection object is attached to this lecture.

What is the cells object?
05:55

How to affect cells positionally within a range using the cells collection object.

Using the Cells collection to affect cells positionally within a range
05:08

explains how to affect all cells within a sheet.

Affecting all cells within a sheet
02:20

Explains how to combine the range and cells objects in Excel VBA.

Combining Range and cells objects
02:33

Exercise-Cells collection object
00:16
+
Working with Sheets/Worksheets
7 Lectures 30:56

How to select sheets in Excel VBA.

Selecting Sheets
05:48

Explains how to add new sheets in Excel VBA.

Adding Sheets
11:07

Explains the difference between the sheets and worksheets collection objects.

Sheets vs Worksheets
03:54

Explains how to copy sheets using Excel VBA.

Copying Sheets
05:15

Explains how to move sheets using Excel VBA.

Moving Sheets
01:16

Explains how to delete sheets in Excel VBA.

Deleting Sheets
03:32

Exercises-Worksheets
00:04
+
Understanding Variables in Excel VBA
9 Lectures 58:33

An introduction to variables in Excel VBA.

Introduction to Variables
06:22

Explains the different variable data types in Excel VBA.

Variable Data Types
09:27

Explains how to declare variables in Excel VBA.

Declaring Variables
14:06

How to force variable declaration using the Option Explicit statement in Excel VBA.

Forcing Variable Declaration
04:56

Explains object variables in Excel VBA.

Object Variables
08:28

How to call a procedure from another and variable scope in Excel VBA

Calling a procedure from Another Procedure & Variable Scope
03:15

Explains the difference between public and private variables in Excel VBA.

Public and Private Variables
07:14

How to declare constants in Excel VBA.

Declaring Constants
04:42

Exercises-Variables
00:03
+
Dealing with Workbooks
6 Lectures 28:12

Different ways to refer to workbooks in Excel VBA.

Referring to Workbooks-Different ways
03:45

How to close workbooks in Excel VBA.

Closing Workbooks
03:17

How to add and save workbooks in Excel VBA - Save method

Adding and Saving Workbooks Part 1 - Save method
04:03

How to add and save workbooks in Excel VBA - Save As method

Adding and Saving Workbooks Part 2 - Save as method
10:26

How to open workbooks in Excel VBA.

opening Workbooks
06:18

Exercise-Dealing with workbooks
00:23
+
Must Know Excel VBA Logic
16 Lectures 01:13:07

How to find the last row in Excel VBA.

Finding the Last row
08:58

How to find the last column in Excel VBA.

Finding the Last Column
03:39

How to find the next row (Row after the last row) in Excel VBA.

Finding the next row
04:24

Explains the With statement in Excel VBA.

The WITH Statement
03:52

Explains the different comparison operators in Excel VBA.

Comparison operators in Excel VBA
00:59

Introduction to IF statements in Excel VBA and how to build simple IF statements.

IF Statements- Simple IF Statements
06:43

Explains the IF THEN ELSE structure in Excel VBA.

IF THEN ELSE Structure
03:21

Explains the IF THEN ELSEIF Structure in Excel VBA.

IF THEN ELSEIF Structure
06:42

Explains how to create Nested IFs in Excel VBA and why the IF THEN ELSEIF structure is preferred.

Nested IFs
04:21

Explains the OR and AND logical operators in Excel VBA.

OR - AND logical operators
07:08

Explains the NOT logical operator in Excel VBA.

NOT Logical operator
02:49

If Statement Exercise
01:33

Explains the simple CASE statements in Excel VBA.

CASE Statements Part 1 - Single Case Statements
08:49

Explains the nested CASE statements in Excel VBA.

CASE Statements Part 2 - Nested Case Statements
06:22

Case Statements-Exercise
00:43

Explains the GOTO statement and how to create labels to jump to different parts of your code.

GOTO and Labels
02:44
+
Looping in Excel VBA
14 Lectures 53:34

An introduction to loops in Excel VBA.

Loops-Introduction
01:26

Explains the FOR NEXT loop in Excel VBA.

FOR NEXT Loop
10:55

Explains the EXIT FOR statement in Excel VBA.

Exit For
08:36

Exercise - For Next loop
01:00

An introduction to for each loops in Excel VBA.

FOR EACH Loop - Intro
06:42

FOR EACH Loops - More examples
04:48

Exercise - For each loop
01:47

Introduction to the DO Loop in Excel VBA.

Do Loop - Introduction
03:49

Example for the DO loop in Excel VBA.

Do Loop Example
01:27

Explains the do until structure in Excel VBA.

Do Until
01:50

Explains the DO WHILE structure in Excel VBA.

Do While
01:44

An Example that is worked out using both the DO WHILE and DO UNTIL structures to illustrate the difference between them.

Do while vs Do until - Movies Example
03:47

Explains the EXIT DO statement in Excel VBA.

Exit Do Statement
04:57

Exercise - Do Loop
00:46
+
Interacting with your users
10 Lectures 39:14

Introduction to the messagbox function in Excel VBA that enables us to display messageboxes.

The Messagebox - Introduction
03:14

Explains the inputs for the messagebox function in Excel VBA.

Messagebox -Inputs
07:22

Explains how to capture the user's input when using message boxes.

Messagebox - Capturing the User's input
04:30

Explains how to add a new line to your VBA strings.

Adding a new line to your VBA Strings
02:00

Exercise - Messagebox
02:10

An introduction to the input box function in Excel VBA.

The Inputbox - introduction
03:38

First Example for the input box 

Inputbox - Example1 - Capturing a user's name
05:18

Part 1 of the 2nd example for input boxes.

Inputbox -Employee Database Example Part 1
05:19

Part 2 of the 2nd example for input boxes.

Inputbox -Employee Database Example Part 2
03:59

Exercise - InputBox
01:44
2 More Sections
About the Instructor
Abdelrahman Abdou
4.5 Average rating
308 Reviews
15,582 Students
4 Courses
Founder|ExcelBonanza.com|15000+ Students|148 Countries

Hi, I'm Abdelrahman and I'm an Excel Lover :)

I have a Bachelor's Degree in Chemical Engineering.

I Worked as MIS and Reporting Analyst in Vodafone International Services In Egypt for 3 years.

I have more than 5 Years of Experience in Excel including building Dashboards and VBA.

I have created numerous dashboards in my company and automated tens of reports.

I love learning new things and my main learning method is through self-learning by watching video tutorials.

I love Excel and I'm trying to share the love with everyone else !