Introduction to VBA Macros

Learn how to automate your spreadsheets by writing your very own the VBA code with this easy step by step introduction to VBA macros course.

Introduction to VBA Macros

Learn how to automate your spreadsheets by writing your very own the VBA code with this easy step by step introduction to VBA macros course.
66
views
Share the link to this page
Copied

About the Class

This course will teach you how to write VBA code so you can automate your spreadsheets to save you time and effort.

What is in the Course?

There are seven modules and within each module, there are a number of engaging step by step video tutorials which includes everything you need to know on how to create your very own Macros to automate your spreadsheets and ultimately to save you time. After each module, you will take a test to solidify what you have just learned.

  • Module 1: Here you will get the course outline and what will be covered in the course. You will also learn a little about me and why I am qualified to teach you VBA.
  • Module 2: You will learn exactly what is VBA, the reasons people use it and the advantages and disadvantages of VBA.
  • Module 3: You will learn to record a macro. If you are completely new to VBA then this will be your very first glimpse of VBA and understand why it is so powerful.
  • Module 4: You have recorded a macro but how do you execute it? In this section, I will show you various ways to run your macro.
  • Module 5: In order to become proficient in VBA you need to have an understanding of the visual basic editor. In this module, you will learn everything you need to know about the visual basic editor and where to store your VBA code.
  • Module 6: Learning VBA is not just about writing VBA code. You need to have an understanding of what exactly you are writing. In this module, I will explain how VBA is structured and introduce the excel object model.
  • Module 7: In this section, you will get to write your very own VBA codes. I will give you lots of examples of writing Macros to manipulate worksheet ranges, columns, and rows. I will also show you how to write your code more efficiently which means your macros will run quicker.

What you will learn from this course?

  • What is VBA and why people use it
  • How to Record Macros
  • How to eliminate manual repetitive tasks
  • How to automate your spreadsheets
  • How to write your very own VBA code to manipulate worksheets
  • How to make your VBA code more efficient
  • How to execute Macros in different ways
  • How VBA is structured with the Excel Object Model

Who should take this course?

  • Anybody who wants to automate their spreadsheets
  • You are an Excel user but want to take your skills to the next level
  • Anybody who works with data sets in Excel
  • Intermediate or advanced Excel users

Author

Harjit Suman

Excel and VBA Teacher
I am an Excel and VBA course teacher with over 10 years experience using Excel and VBA. I have taught Excel and VBA in large global organisations in a classroom environment. I am also an Excel Consultant and have provided Excel services to many small and large companies. Some of the services I have offered include writing advanced Excel...

School

Harjit Suman's School

Requirements

  • You should have intermediate Excel skills.
  • You have a PC/Mac with Excel installed on it.
  • You should desire to gain an understanding of how macros can drive efficiency.

Class Contents

One-time Fee
$69.99
List Price:  $99.99
You save:  $30
€64.60
List Price:  €92.30
You save:  €27.69
£55.40
List Price:  £79.14
You save:  £23.74
CA$95.14
List Price:  CA$135.92
You save:  CA$40.78
A$107.21
List Price:  A$153.17
You save:  A$45.95
S$94.29
List Price:  S$134.71
You save:  S$40.41
HK$547.55
List Price:  HK$782.26
You save:  HK$234.70
CHF 63.39
List Price:  CHF 90.56
You save:  CHF 27.17
NOK kr753.41
List Price:  NOK kr1,076.34
You save:  NOK kr322.93
DKK kr481.90
List Price:  DKK kr688.47
You save:  DKK kr206.56
NZ$116.54
List Price:  NZ$166.49
You save:  NZ$49.95
د.إ257.02
List Price:  د.إ367.19
You save:  د.إ110.16
৳7,699.83
List Price:  ৳11,000.23
You save:  ৳3,300.40
₹5,834.28
List Price:  ₹8,335.05
You save:  ₹2,500.76
RM331.26
List Price:  RM473.25
You save:  RM141.99
₦97,755.03
List Price:  ₦139,656.03
You save:  ₦41,901
₨19,509.87
List Price:  ₨27,872.43
You save:  ₨8,362.56
฿2,546.30
List Price:  ฿3,637.73
You save:  ฿1,091.43
₺2,255.86
List Price:  ₺3,222.80
You save:  ₺966.93
B$348.35
List Price:  B$497.67
You save:  B$149.31
R1,321.80
List Price:  R1,888.37
You save:  R566.56
Лв126.46
List Price:  Лв180.67
You save:  Лв54.20
₩94,455.35
List Price:  ₩134,942
You save:  ₩40,486.65
₪256.23
List Price:  ₪366.06
You save:  ₪109.83
₱3,937.46
List Price:  ₱5,625.18
You save:  ₱1,687.72
¥10,582.69
List Price:  ¥15,118.78
You save:  ¥4,536.09
MX$1,164.09
List Price:  MX$1,663.06
You save:  MX$498.96
QR255.79
List Price:  QR365.44
You save:  QR109.64
P961.07
List Price:  P1,373.02
You save:  P411.94
KSh9,203.68
List Price:  KSh13,148.68
You save:  KSh3,945
E£3,306.33
List Price:  E£4,723.53
You save:  E£1,417.20
ብር3,986
List Price:  ብር5,694.53
You save:  ብር1,708.53
Kz58,526.40
List Price:  Kz83,612.73
You save:  Kz25,086.33
CLP$68,613.99
List Price:  CLP$98,024.19
You save:  CLP$29,410.20
CN¥505.72
List Price:  CN¥722.49
You save:  CN¥216.77
RD$4,149.44
List Price:  RD$5,928.03
You save:  RD$1,778.58
DA9,428.56
List Price:  DA13,469.95
You save:  DA4,041.39
FJ$157.67
List Price:  FJ$225.25
You save:  FJ$67.58
Q547.27
List Price:  Q781.84
You save:  Q234.57
GY$14,690.75
List Price:  GY$20,987.69
You save:  GY$6,296.93
ISK kr9,671.91
List Price:  ISK kr13,817.61
You save:  ISK kr4,145.70
DH707.37
List Price:  DH1,010.57
You save:  DH303.20
L1,234.61
List Price:  L1,763.81
You save:  L529.19
ден3,973.74
List Price:  ден5,677.01
You save:  ден1,703.27
MOP$565.34
List Price:  MOP$807.66
You save:  MOP$242.32
N$1,327.13
List Price:  N$1,895.98
You save:  N$568.85
C$2,582.33
List Price:  C$3,689.21
You save:  C$1,106.87
रु9,350.11
List Price:  रु13,357.88
You save:  रु4,007.76
S/259.70
List Price:  S/371.02
You save:  S/111.31
K268.50
List Price:  K383.60
You save:  K115.09
SAR262.50
List Price:  SAR375.02
You save:  SAR112.51
ZK1,783.85
List Price:  ZK2,548.47
You save:  ZK764.61
L321.17
List Price:  L458.83
You save:  L137.66
Kč1,633.99
List Price:  Kč2,334.38
You save:  Kč700.38
Ft25,496.77
List Price:  Ft36,425.52
You save:  Ft10,928.74
SEK kr741.62
List Price:  SEK kr1,059.50
You save:  SEK kr317.88
ARS$59,963.93
List Price:  ARS$85,666.43
You save:  ARS$25,702.49
Bs486.54
List Price:  Bs695.09
You save:  Bs208.54
COP$272,760.10
List Price:  COP$389,673.99
You save:  COP$116,913.89
₡35,355.24
List Price:  ₡50,509.65
You save:  ₡15,154.41
L1,731.96
List Price:  L2,474.33
You save:  L742.37
₲515,624.88
List Price:  ₲736,638.54
You save:  ₲221,013.66
$U2,646.58
List Price:  $U3,781
You save:  $U1,134.41
zł278.71
List Price:  zł398.17
You save:  zł119.46

What's Included

Language: English
Level: Beginner
Skills: VBA, Macros, VBA Code, Coding, Visual Basic for Applications, VBA for Spreadsheets, Automate Spreadsheets
Age groups: All ages
Duration: 1 hour 23 minutes
54 Videos
6 Quizzes
0
Saves
66
Views
This class has not been saved

Sign Up

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.