Excel VBA/MACRO
Many manual repetitive task can be replaced with Excel macro, discover the magic of Excel macro by learning this step-by-step online course. Shorten your time to produce report from few hours to few minute. Learn and amaze your colleague soon.
Your Instructor
Course Curriculum
First Step - Know your current level of Excel VBA
Available in
days
days
after you enroll
Introduction to Microsoft Excel Macro
Available in
days
days
after you enroll
-
PreviewHow to Record your first macro (3:15)
-
StartWrite your first macro (5:47)
-
PreviewGet Last Row (3:49)
-
PreviewGet Next Row (4:25)
-
PreviewUsing ActiveCell object (4:01)
-
PreviewCurrentRegion and SpecialCell (5:00)
-
StartCopy worksheet (5:40)
-
StartInserting blank row (6:51)
-
StartBold Rows selected using Selection Object (5:34)
-
StartUsing ActiveCell (1:56)
-
PreviewCalling other procedure (3:57)
-
PreviewAutomate Subtotal (4:04)
-
StartWrite code to combine words (7:06)
Mastering Flow Control
Available in
days
days
after you enroll
Frequently Asked Questions
When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
How long do I have access to the course?
How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.
This course is definitely a must for Business Performance Analyst, those who require to produce report on daily, weekly, monthly, half yearly, quarterly basis. Thank you for enrolling this course soon.