Excel VBA Training Course in Jaipur

 

Course Name – Excel VBA Training Course         

Duration – 1 Month

 

Excel is one of the most popular software applications within the world and is used by firms in almost every industry, from pizza parlors to personal equity. Companies, educational institutions, and government agencies all use Excel to manage and analyze data, create spreadsheets and reports, print charts, and far more. It’s no wonder why a working knowledge of this spreadsheet software is an important skill for people that spend a part of their workday ahead of a computer, even for people who don’t necessarily have an accounting or finance-related careers. Thus Excel skills are in demand, and it’s no surprise people with Excel knowledge are earning more cash than their counterparts.

 

Target Audience

 

  • Undergraduate, Graduates and Postgraduates

  • Job aspirants

 

Pre-requisites

 

  • Basic Computer

  • Basic Internet

  • Advanced Excel

 

Recommended Next Course

 

  • Commercial Accountant

  • Digital Marketing

 

Complete Course Contents

 

Module 1: Understanding Security Levels

 

Why security

Security levels and its meaning

 

Module 2: Functions

 

What is Function and Subroutine

Writing Functions using VBA Editor

Calling function in another workbook

 

Module 3: Recording Macros

 

Recording and running macro

Storing macro in numerous books

Creating buttons and assigning macro to that

Creating My Menu

 

Module 4: The Visual Basic Editor

 

Editing macros using VBA Editor

Understanding the project explorer

Exploring windows properties

Modifying code in code window

Debugging code

 

Module 5: Programming Fundamentals

 

Variables, data types and constants

Arrays

Object Variables

Conditional structures (If …. Then, Select Case)

Logical Operators

Looping constructs (For loops, Do loops, while… Wend)

Built-in functions

Creating Subroutines

 

Module 6: Excel Object Model

 

Working with objects – properties, events and methods

Application objects

Workbook objects, Worksheet objects and Range objects

Charts objects

Pivot table objects

 

Module 7: User Forms

 

Creating forms

Form events

Creating custom menus and toolbars

Creating Add-ins

 

Module 8: Working with other applications

 

Working Word, PowerPoint and other applications.