Excel VBA for Beginners

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 should take this course?

Someone who wants to learn how to program/write code in Excel using the Visual Basic for Applications (VBA) language.
Someone who needs to know how to write formulas, use pivot tables, and draw charts in Excel.

You will find all the Course files attached at the beginning of the course.

Author

Abdelrahman Abdou

Certified Microsoft Excel Expert| Excel & Power BI Consultant

Certified Microsoft Excel Expert with 10+ Years Experience in Excel and the Telecom Industry Excel & Power BI Consultant Online Instructor since 2015 Founder & Owner @ ExcelBonanza.com - A blog dedicated to teaching and learning Microsoft Excel

School

Abdelrahman Abdou's School

Requirements

Should have basic knowledge of formulas, use pivot tables, and draw charts in Microsoft Excel.
You Have a PC/Mac (Windows Preferred) with Microsoft Excel installed on it.

Class Contents

1-Introducing Excel VBA (Visual Basic for Applications)

Course Promo

Preview

Course Example & Exercise Files

Introduction & Know your Instructor

Recording Macros vs Writing VBA code

Understanding Objects

Understanding the VBA Syntax

Recording a Basic Macro

Absolute vs Relative Macro Recording

Activating the Developer Tab

2- The Visual Basic Editor

Introduction to the Visual Basic Editor(VBE)

The Project Explorer

The Properties Window

The Code Window

Immediate, Local and Watch Windows

Dealing with Modules

3- The Range object - Dealing with cells

Introduction and changing cell values

Adding a text to a cell

Dealing with Named Ranges

Value vs Text Properties

Row & Columns Properties

Number Format Property

The Font Property

4-The Cells Collection object for dealing with Cells

What is the cells object?

Affecting cells positionally within a range

Affecting all cells within a sheet

Combining Range and cells object

5- Dealing with Worksheets

Calling a procedure from another procedure

Public and Private Variables

Declaring Constants

7- Dealing with Workbooks

Referring to workbooks

Closing Workbooks

Adding and Saving Workbooks - Part 1

Adding and Saving Workbooks - Part 2

Opening Workbooks

8- Must know Excel Logic

Finding the Last Row

Finding the last column

Finding the next row

The With Statement

Comparison operators in Excel VBA

GOTO Statement and Labels

IF Statements - Part 1 - Simple IF Statements

IF Statements Part 2- IF THEN ELSE Structure

IF Statements Part 3 - IF THEN ELSEIF Structure

IF Statements Part 4 - Nested IF Statements

IF Statements - Exercise

OR / AND Logical Operators

NOT Logical Operator

Case Statements Part 1 - Single Case Statements

Case Statements Part 2 - Nested Case Statements

Case Statements- Exercise

9- Loops

Introduction to Loops

FOR NEXT Loop

EXIT FOR Statement

FOR NEXT Loop - Exercise

FOR EACH Loop Part 1 - Introduction and looping through worksheets in a collection

FOR EACH Loop Part 2 - More examples of FOR EACH

FOR EACH Loop - Exercise

DO Loop - Introduction

DO Loop - Simple Example

DO UNTIL with Example

DO WHILE with Example

DO WHILE vs DO UNTIL - Movies Example

Exit Do Statement

DO Loop - Exercise

10 - Interacting with users

Message Box - Introduction

Message Box - Inputs

Message Box - Capturing User's Input

Message Box - Exercise

Adding a New Line to VBA Strings

Input box - Introduction

Input Box - Capturing a User's Name

Input Box - Employee Database Example - Part 1

Input Box - Employee Database Example - Part 2

Input Box - Exercise

11- Error Handling

Error Handling - Introduction

Different Types of Errors in action

On Error resume Next

On Error GO TO Statement

Resetting the error handling status - ON Error GO TO 0

The Err Object

Setting a breakpoint on your code

Events in Excel VBA

Worksheet Events - Worksheet Selection Change Event

Worksheet Events -Worksheet activate Event

Worksheet Events - Worksheet de-activate event

Worksheet Events - Worksheet Before delete event

Worksheet Events - Before Double Click Event

Worksheet Events - Before Right Click Event

Worksheet Events - Worksheet Calculate Event

Enabling and Disabling Events

Worksheet Events - Worksheet Change Event

Worksheet Events - Follow Hyperlink Event

Worksheet Events - Exercise

Workbook Events - Workbook Open Event

Workbook Events - Workbook Activate Event

Workbook Events - Workbook BeforeSave Event

Workbook Events - Workbook After Save event

Workbook Events - Workbook Before Close event

Workbook Events - Workbook Before Print event

Workbook Events - Workbook de-activate event

Workbook Events - Workbook New Chart event

Workbook Events - Workbook New Sheet event

Workbook Events - Workbook Sheet Calculate event

Workbook Events - Workbook Sheet de-activate event

Workbook Events - Workbook HyperLink Event

Workbook Events - Workbook Window Activate event

Workbook Events - Workbook Window de-activate event

Workbook Events - Workbook Window resize event

Workbook Events - Exercise

One-time Fee

$99.99

List Price: $139.99

You save: $40

€85.19

List Price: €119.27

You save: €34.08

£74.77

List Price: £104.68

You save: £29.91

CA$137.78

List Price: CA$192.89

You save: CA$55.11

A$150.31

List Price: A$210.44

You save: A$60.13

S$129.19

List Price: S$180.88

You save: S$51.68

HK$777.80

List Price: HK$1,088.96

You save: HK$311.15

CHF 79.59

List Price: CHF 111.43

You save: CHF 31.83

NOK kr1,013.63

List Price: NOK kr1,419.13

You save: NOK kr405.49

DKK kr636.11

List Price: DKK kr890.58

You save: DKK kr254.47

NZ$172.27

List Price: NZ$241.19

You save: NZ$68.91

د.إ367.21

List Price: د.إ514.11

You save: د.إ146.90

৳12,200.05

List Price: ৳17,080.55

You save: ৳4,880.50

₹9,057.54

List Price: ₹12,680.92

You save: ₹3,623.38

RM409.68

List Price: RM573.58

You save: RM163.89

₦144,900.08

List Price: ₦202,865.92

You save: ₦57,965.83

₨27,977.78

List Price: ₨39,170.01

You save: ₨11,192.23

฿3,144.12

List Price: ฿4,401.89

You save: ฿1,257.77

₺4,257.57

List Price: ₺5,960.77

You save: ₺1,703.19

B$541.88

List Price: B$758.66

You save: B$216.77

R1,687.37

List Price: R2,362.39

You save: R675.01

Лв166.64

List Price: Лв233.31

You save: Лв66.66

₩147,438.25

List Price: ₩206,419.45

You save: ₩58,981.20

₪322.26

List Price: ₪451.18

You save: ₪128.91

₱5,910.90

List Price: ₱8,275.50

You save: ₱2,364.60

¥15,573.94

List Price: ¥21,804.14

You save: ¥6,230.19

MX$1,801.20

List Price: MX$2,521.76

You save: MX$720.55

QR363.83

List Price: QR509.38

You save: QR145.55

P1,322.75

List Price: P1,851.91

You save: P529.15

KSh12,873.43

List Price: KSh18,023.31

You save: KSh5,149.88

E£4,730.87

List Price: E£6,623.40

You save: E£1,892.53

ብር15,598.69

List Price: ብር21,838.79

You save: ብር6,240.10

Kz91,690.83

List Price: Kz128,370.83

You save: Kz36,680

CLP$91,270.93

List Price: CLP$127,782.96

You save: CLP$36,512.02

CN¥705.37

List Price: CN¥987.55

You save: CN¥282.18

RD$6,346.47

List Price: RD$8,885.32

You save: RD$2,538.84

DA12,964.71

List Price: DA18,151.11

You save: DA5,186.40

FJ$227.15

List Price: FJ$318.02

You save: FJ$90.87

Q764.64

List Price: Q1,070.52

You save: Q305.88

GY$20,885.90

List Price: GY$29,241.10

You save: GY$8,355.19

ISK kr12,616.33

List Price: ISK kr17,663.37

You save: ISK kr5,047.03

DH918.43

List Price: DH1,285.85

You save: DH367.41

L1,687.62

List Price: L2,362.74

You save: L675.11

ден5,239.78

List Price: ден7,335.90

You save: ден2,096.12

MOP$800.52

List Price: MOP$1,120.76

You save: MOP$320.24

N$1,684.29

List Price: N$2,358.08

You save: N$673.78

C$3,674.23

List Price: C$5,144.07

You save: C$1,469.83

रु14,445.11

List Price: रु20,223.73

You save: रु5,778.62

S/336.11

List Price: S/470.57

You save: S/134.45

K430.33

List Price: K602.48

You save: K172.15

SAR375.18

List Price: SAR525.27

You save: SAR150.08

ZK2,303.63

List Price: ZK3,225.17

You save: ZK921.54

L433.54

List Price: L606.98

You save: L173.43

Kč2,066.70

List Price: Kč2,893.46

You save: Kč826.76

Ft32,660.30

List Price: Ft45,725.73

You save: Ft13,065.42

SEK kr926.89

List Price: SEK kr1,297.69

You save: SEK kr370.79

ARS$143,373.53

List Price: ARS$200,728.68

You save: ARS$57,355.14

Bs689.81

List Price: Bs965.76

You save: Bs275.95

COP$380,209.72

List Price: COP$532,308.82

You save: COP$152,099.10

₡49,937.50

List Price: ₡69,914.50

You save: ₡19,977

L2,628.31

List Price: L3,679.75

You save: L1,051.43

₲670,577.05

List Price: ₲938,834.69

You save: ₲268,257.64

$U3,917.97

List Price: $U5,485.31

You save: $U1,567.34

zł359.54

List Price: zł503.38

You save: zł143.83

What's Included

Language: English

Level: Beginner

Skills: Excel, Spreadsheet Automation, Coding, Programming, Excel VBA, Spreadsheets, Automation

Age groups: All ages

Duration: 9 hours 8 minutes

121 Videos

1 Document

Excel VBA for Beginners

Excel VBA for Beginners

About the Class

Author

Abdelrahman Abdou

School

Abdelrahman Abdou's School

Requirements

Class Contents

What's Included

Sign Up

Sign Up

Share