CertAchiever

Microsoft Excel VBA Training

contact us: +918882136965

Instructor-led live online classes

Weekday Classes | Weekend Classes |

Microsoft Excel VBA Training

$100

Microsoft Excel VBA Training

VBA is an integral aspect of any analytics related course. This is because VBA finds multiple applications in Excel related tasks such as automation, interactions between Office applications, and implementation of business logic in Excel. VBA significantly improves workbook performance and enables tasks that might have been impossible using simple MS – Excel Formulas.

Training Features

Instructor-led Sessions

Both Weekdays and Weekend batches are available.

Real-Life Case Studies

During the sessions you will be working on the case studies provided by the trainer.

Lifetime Access

You will get the life time access of training material including videos & study guides..

Assignments

Each class will be followed by practical assignments to practice the concepts covered in class

24 x 7 Expert Support

We have a lifetime 24x7 online support team to resolve all your technical queries,through a ticket based tracking system..

Certification

Towards the end of the course, you will be awarded with Training competition certification based on you performance.

Course Curriculum

Learning Objectives

In this module, you will get introduced to why VBA is a necessary aspect of any analytics function. The goal is to ensure that students become acquainted with the VBA environment, coding basics, and functionalities of VBA.

Topics Covered

VBA introduction - Overview, Variable definition and scoping, Understand the object model of VBA, Protection and event handling

Hands On

Hands-on on basic VBA to get you started, How to link Excel front-end to VBA code

Learning Objectives

In this module, you will learn about the loops and conditional statements in VBA. This module covers topics on different types of data storage and handling techniques in VBA. It will be a good starting point to write complex VBA code to automate repetitive tasks and handle data structures.

Topics Covered

Different Loops in VBA – FOR, DO WHILE, WHILE, Conditional Statements – IF, IF-ELSE, SELECT CASE, Data handling methods – ARRAYS, COLLECTIONS, DICTIONARIES

Hands On

Exercise to demonstrate the loops implementation – definition of criteria for loop execution, number of runs and difference between the different loops, Explanation of the conditional statement through complex business logic to demonstrate capability in real time, Live dataset storage, access, and manipulation using all the points defined above plus VBA specific data techniques

Learning Objectives

In this module, you will learn how to handle the various shapes and charts using VBA. This module covers the topics for data manipulation, setting source for chart data and accessing different chart properties like series color, legends, axis formatting, overall general formatting. Then the focus will shift to the different form controls in VBA like dropdowns, list boxes, option buttons, etc.

Topics Covered

Charts – Data manipulation, setting source data, properties modification, Form controls – Understand the uses of form controls, Handling shapes and their properties in VBA

Hands On

Live exercise to demonstrate the functionalities of all the listed items above

Learning Objectives

In this module, you will learn how to work with the advanced interaction between different workbooks and office applications. This module covers topics like opening different files, reading data from them and writing data through a single workbook. Also, there will be an overview of generating PDF and PPT reports from within Excel using VBA.

Topics Covered

File handling through VBA, Data manipulation between different workbooks, Consolidation of data into a single workbook, Export data from the workbook in PDF, PPT, and Excel formats

Hands On

Hands-on guidance to walk through the file handling, data manipulation and export functionalities of VBA, Understand best practices to implement the above functionalities

Learning Objectives

In this module, you will learn how to use user forms in Excel and VBA to create a great user experience in your workbooks. This module will serve as a base for the final project which will utilize all the topics described above. User forms provide a dynamic way to select, filter and enter data into the workbook.

Topics Covered

User form design and properties, User form events, Data manipulation using the form

Hands On

User form setup and data handling through the same, Live project to connect the user form to front-end Excel

FAQ's

You will never miss a lecture at CertAchiever! You can choose either of the two options:

View the recorded session of the class available in your LMS.

·You can attend the missed session, in any other live batch."

We have limited number of participants in a live session to maintain the Quality Standards. So, unfortunately participation in a live class without enrollment is not possible. However, you can go through the sample class recording and it would give you a clear insight about how are the classes conducted, quality of instructors and the level of interaction in the class.

You can give us a CALL at +918882136965 (IN) OR email at admin@certachiever.com

Certification

Once your training will complete, you will be awarded with training completion certification from the Trainer.