Study Learn Grow
Teach yourself Excel VBA Step by Step

Teach yourself Excel VBA Step by Step


This course also covers more advanced topics, including recording a macro in stages, The course wraps up with a macro project brings together each of the elements in a real-world scenario.

Overview

About this Course
In this course the author Sam Parulekar, demonstrates common tasks for which macros are used, and walks through the process of creating and running simple macros. This course also covers more advanced topics, including recording a macro in stages, The course wraps up with a macro project brings together each of the elements in a real-world scenario. Exercise files accompany the course.

Topics include:

Understanding the VBA environment
Recording macros in stages
Writing VBA code
Using loops
Debugging macros
Testing
Copying Data from one worksheet to another
Basic knowledge
The student should have working knowledge of Excel
The student should have a computer with Excel installed (any version will do)

Course Information

The student should have working knowledge of Excel
The student should have a computer with Excel installed (any version will do)

What you will learn
Enabling the Developer Tab
Writing and running your first Macro Program
How to edit a recorded Macro
How to perform calculations using Macro
Looping Data using Do and For Loop
Conditional formatting using Macros
Using Cell properties
Finding next blank row
How to Copy data from one worksheet to another

This course is Ideal for any person who knows basics of Excel and would like to migrate to Advance Excel.
This course also suits a person who wants to learn to automate his work.
This course is also recommended for person who is new to programming and wants to explore and master programming.

• Lifetime Access to Each Course
• Certificate on Completion of Course
• No Extra Charges Or Admin Fees
• Easy Access to Courses
• High Priority Support After Sales.
• Big Discounts on Individual Courses

Course Specifications

IT and Computing courses are available to study on our learning platform. 

See All Courses

Adult education is the non-credential activity of gaining skills and improved education. 

See All Courses

Online education is electronically supported learning that relies on the Internet for teacher/student interaction. 

See All Courses

A short course is a learning programme that gives you combined content or specific skills training in a short period of time. Short courses often lean towards the more practical side of things and have less theory than a university course – this gives you a more hands-on experience within your field of interest.

See All Courses

Course duration is 24 hours.

See All Courses

Study Learn Grow

Related Jobs