Visual Basic for Excel - Beginners Guide

Through this online training course you would be learning about the fundamentals of working with VBA & Macros. Vba help you automate your routine mundane tasks. The tutorials start right from scratch wherein you would understand the creation of your first macro, understand the VBA environment, work with macros using IF condition, using data filters, charting using VBA and creating user forms.

346

 3h 05m | 28 Videos | 86368 Views |   Beginner

Online VBA Macros – Beginners Training Course

Have you ever felt frustrated by doing same task again and again let’s say 100 times in a day in Excel? Did you ever wish that you would have created a function or something that would work on a single click? If the answer is yes, then this course is specially made for you.Let’s take an example of frustrated banker who used to deal with thousands of customers for calculating EMI.

But when he learnt VBA then it became very easy for him with EMI calculator. Even you can make your work easy by learning VBA’s.

This course provides a basic overview of using VBA to automate excel tasks. With limited knowledge of Excel and zero knowledge of programming anybody can Excel in this awesome course. The course is divided into 2 parts.

Basic part comprises of VB language, VBE, Macros

Advanced part comprises of writing email, creating pdf, sorting, designing user forms dynamically.

Here we learn about the VBA Environment, Macros with IF conditions, Data Filters, Charting using VBAs and designing of Userform.

This course on VBA & Macros is well structured and strategically designed online training program for learning Microsoft Excel VBA & Macros. The goal of this program is to make a beginner start learning VBA & Macros from scratch.

Target Audience for VBA Macros Course:

• All stream students
• Keen learners
• Professionals
• Financial Analyst
• Investment Banker

VBA Macros Course Highlights:

This course on VBA & Macros – Beginnersprovide a basic overview of using VBA to automate excel tasks. This Program on VBA & Macros is well structured and strategically designed online training program for learning Microsoft Excel VBA & Macros. The aim of this program is to make a beginner start learning VBA & Macros from scratch this course covers following:

• Introduction to VBA-This tutorial provide you basic understanding of VBA.
• My First Macro-Learn how to record macros in excel sheet.
• VBA Environment-Learn all about basics of VBA environment.
• Macros with IF Condition-Learn How to records macro with If condition.
• Also learn about Data Filter, Charting using VBA and Userforms.