BEST COMPUTER INSTITUTE IN DELHI
bajaj
Home About Us Contact Us Blog
ifda VBA-course ifda VBA-course

Learn

VBA Course

To automate repetitive and routine tasks

FILL YOUR DETAILx

About Courses

Visual Basic for Applications (VBA) is a computer programming language developed and owned by Microsoft which is used within Excel. VBA is a beginner friendly language and it is widely used by individuals interacting with Microsoft products. This course makes you an expert to gather data from multiple online systems, analyze the information, and report data at the same time in Excel. This course willl open great career prospect for you in the future.

Course Highlights

1.

Debugging code

2.

Power Pivot

3.

3D Dimensional Tables

4.

Automating Tasks in Excel

5.

5+ Assignment

6.

5+ Live Projects

7.

10 Course Module

8.

1 Year Free Backup Classes

REQUEST FOR DEMO CLASS


Take a look at how IFDA helps you to have a great career by delivering the best content and practice.

Note :- Please fill all detail for enabled submit button.

Learning Outcome

You will be able to write programs for the Windows operating system.
You will be able to automate tasks in Excel.
You will be able to analyze data on multi worksheets and build summary sheets.
You will be able to create a dynamic dashboard on user form with different controls.
You will be able to link various user forms with each other to create a complete interface between user and system.
You will be able to create macros and use them in object oriented programming.

Software and Apps that you will learn in this course

Course Content

MODULE 1

1) INTRODUCTION TO EXCEL

  1. Basic Understanding Menu and Toolbar, Introduction to different category of functions like Basics, Mathematical and Statistical, Date and Time, Logical, Lookup and References, Text and Information.

2) MATHEMATICAL FUNCTIONS

  1. Sum, Sumif, Sumifs, Count, Counta, Countblank, Countif, Countifs, Average, Averagea, Averageif, Averageifs, Subtotal.
  2. Aggregate, Rand, Randbetween, Roundup, Rounddown, Round, Sumproduct

3) DATE & TIME FUNCTION

  1. Date, Day, Month, Year, Edate, Eomonth, Networkdays, Workday, Weeknum, Weekday, Hour, Minute, Second, Now, Today, Time

4) TEXT FUNCTIONS & DATA VALIDATION

  1. Char, Clean, Code, Concatenate, Find, Search, Substitute, Replace, Len, Right, Left, Mid, Lower, Upper, Proper, Text, Trim, Value, Large, Small Filters (Basic, Advanced, Conditional), Sort (Ascending, Descending, Cell/ Font Color), Conditional Formatting, Data Validation, Group & Ungroup, Data split.

5) STATISTICAL FUNCTION & OTHER FUNCTIONS

  1. Isna, Isblank, Iserr, Iseven, Isodd, Islogical, Isytext, Max, Min, Len, Right, Left, Mid, ,Maxa, Maxifs, Median, Minifs, Mina, Vara, Correl, Geomen

6) LOGICAL FUNCTIONS

  1. And, Or, If, Iferror, Not, Nested If

7) LOOKUP & REFERENCE FUNCTIONS

  1. VLookup, HLookup, Index, Match, Offset, Indirect, Address, Column, Columns, Row, Rows, Choose, Arrays Concept In Lookup Formula’s, Past Special, Past link

8) POWER PIVOT- MIS, DATA ANALYSIS & VISUALIZATION

  1. Pivot Table, Power Pivot, What-if Analysis, Data Table –One Variable and Two Variables, Data Analysis Using Statistics, Descriptive Statistics, ANOVA, Moving Average, Testing Hypothesis, Measuring Covariance and Correlation, Distribution, Regression, Graphs & Charts, Analysis Tool Pack, Solver, Histogram, Pareto, Water Fall, Import and Export data, Protect/Unprotect sheets/workbooks, Worksheet formatting and Print Displa

9) DATA COLLECTION METHOD

  1. With Data Quality, Collaboration & Security Like Share Your Workbook On Share Drive With Quality

10) ANALYSIS SINGLE/MULTIDIMENSIONAL ANALYSIS

  1. Like Three Dimensional (3D) Tables, Sensitive Analysis Like Data Table, Manual What-If Analysis, Threshold Values, Goal Seek, One- Variable Data Table, Two-Variable Data Table

11) ADVANCED DASHBOARD IN EXCEL

  1. Overview of Chart types, Chart Formatting, Active X Form Controls, Principle of great dashboard design, Selecting Correct Chart to display data, Interactive Charts with Form Controls, Combo box, Check Box, Scroll Bar and Radio Button, Interactive Dashboard with Form Controls, Form Controls for reports automation, Data Models using Power Pivot

MODULE 2

12) INTRODUCTION TO PROGRAMMING INTRODUCTION TO LOGICAL THINKING FLOWCHARTS & ALGORITHMS

  1. Define Objective, Start & End Points; Identifying Solution & Breaking it Into Sequential Steps Writing a Algorithm
  2. Step-by-Step Instructions, Flowcharts, Process Flow Diagrams. Excel Macros - an Introduction

13) COMPLETE REVIEW OF THE VBA LANGUAGE (SUBS, FUNCTIONS, VARIABLES, ARRAYS, LOOPS, LOGIC...ETC.)

  1. Excel Macro Language Review (VBA) Including Variables, Data Types, Constants, Arrays, Operators Expressions, Loops, Logic Decisions And Calling
  2. Overview Of Commanding Excel Using VBA Including A Discussion Of Objects, Properties And Methods
  3. The Power of Macros - What, When, How to use Macros. Introduction to Object Oriented Programming
  4. Objects, Its Functions, Methods and Properties Introduction to Events
  5. Details of Events, How & When to use of Events, Preparing to 'Macro' Visual Basic Editor (vba) – Developer Tab, Security
  6. Introduction to the vba, Properties window, Project Explorer, Password Protection of Code How to use the vba - Features, Options, Intelligence Technology
  7. Debugging Mode, Bookmarks, Breakpoints, Watch Window, Immediate Window and Locals Window Inbuilt vba Help Feature - Tips and Tricks
  8. Form Controls vs. ActiveX Controls Getting into the Code
  9. Message Box and Input Box Working with Data in Excel through VBA
  10. Data Types, Constants and Variables
  11. Different type of data type; How and When to use Variables to Store Information.
  12. For-Next, For-Each, Do-While, Do until, Do Loop Decision-Making and Code Branching
  13. If-Then-Else, Select-Case, And/or Nested Conditions
  14. What is user’s Defined Functions?
  15. How to create & use them.
  16. Use of Arrays in VBA programming with one dimensional, two dimensional or multi-dimensional analysis

14) EXCEL VBA POWER PROGRAMMING FOR VBA MACROS

  1. Working with Dynamic Ranges. Protecting Worksheets, Cells and Ranges. Working with Multiple Files. Opening & Saving Files
  2. How to Analyze Data On Multi Worksheets And Build Summary Sheets
  3. How to Access The Windows File And Folder System To Open And Close Workbooks
  4. How to Protect Your Code Against Errors
  5. How to Use Excel And VBA To Create Basic Dash Boards
  6. How to Create Your Own Custom Business Worksheet Functions In VBA
  7. How to Create Basic Report Generation Tools Using Excel VBA, Microsoft Word And PowerPoint
  8. How to Use The Excel Visual Basic Macro Recorder To Record Excel Tasks In VBA And Then Interpret The Code

15) OVERVIEW OF USING USER FORMS TO CREATE BUSINESS WIZARDS

  1. Working with User Forms & User Forms Events like List box, Combo box, Option Buttons, Check box, Text box, Labels, Command button, Toggle button.
  2. How to create dynamic dashboard on user form with different controls
  3. How to link various user form with each other to create a complete interface between user and system

16) CONNECTION BETWEEN EXCEL VBA & OTHER PLATFORMS

  1. How to Establish Connection Between VBA and Internet Explorer to Open any Internet Website through VBA
  2. How to Establish Connection Between Excel VBA and power presentation to create power point through VBA
  3. How to Establish Connection Between Excel VBA and Access database to update the data in access through VBA
  4. How to Establish Connection Between Excel VBA and outlooks through VBA
  5. How to Establish Connection Between Excel VBA and MS Word through VBA

17) TESTING AND DEBUGGING YOUR CODE

  1. Types of Errors
  2. Using Breakpoints
  3. Debugging Techniques

18) DIALOGUE BOXES

  1. UsingMsgBox Function
  2. UsingInputBox Function
  3. Working with FileDialog
  4. Working GetOpenFilname Method
  5. Working GetSaveAsFilename Method

Jobs You will Get After Completing Course

VBA reduces a tedious, time-consuming process down to a few button clicks that finishes in minutes. This course is a powerful weapon to make your career productive. Each and every organization needs an expert to automate data in excel. There are plenty of jobs where VBA is a useful and an additional skill that will increase your employability and earning potential.

Job profile

After completing this course

Average salary

( 1+ year experience)

MIS Executive 22k-34k
Business Analyst 58k to 125k
Technical Support 33k to 45k
Database Analyst 48k to 133k
Database Administrator 43k to 67k
Business Intelligence Analyst 53k to 141k

Features & Facilities



Student Reviews

ifda student review
Dolly Bairwa
Student
Google Review 

Hello,
My name is sarita,I'm student of IFDA institute. IFDA is the best computer training institute. Overall I love all the classes I have taken through IFDA institute,all the instructiors are kind and petient.They are very experienced in the program they are teaching.I have recommended this site to my school and friends. IFDA provides both practical and theoretical classes. Had a great experience here.☺️

ifda student review
Chy. Nisha
Student
Google Review 

I have a great experience in IFDA. The trainers are very supportive and explain every topic in detail. This Institute also provide backup classes on Saturday. I would like to suggest to join IFDA Institute to my friends and relatives. Thank u

ifda student review
Simran Simran
Student
Google Review 

I consider it very helpful because when when I first got into IFDA institute, it was very friendly and my knowledge in technology has gotten just not better but best. All the faculty here are very polite and ready to help whenever asked. Getting in this institute was my best decision.


Frequently Asked Questions

We provide internship and 100% job assistance to those students who are hard working and well mannered till the course is completed. We conduct interviews with our recruiters for you to get hired that help you to gain professionalism in this field.

Students can pursue this course if they have completed class 10th from a recognised board who are eager to learn about programming and want to get specialized in excel and Microsoft office field.

• Broad programming language- includes data analytics, simple to advanced applications, such as analytics projects, binary codes, and Microsoft Office scripts.
• Easy to learn- It is easy to learn in comparison to other coding languages.
• Includes all Microsoft Office Programs- this programming language is applicable in all Microsoft Office programs.
• No additional software- . It’s already fully integrated into Microsoft Office programs and does not require additional software.

VBA is a computer programming language that is used within Excel. Excel is a broader software used for many different types of purposes on the other hand, VBA enhances its capabilities with the features such as automating, accessing, creating macros, generating custom reports, etc.

VBA is relatively easier to learn in comparison with other programming languages. It is considered a beginner-friendly language, and has many resources available for students new to programming.

Yes we provide weekly classes or you can schedule your class according to your suitable time. We also provide online and backup classes so you can attend your missed or pending lectures.

Our Alumni's Works At
ifda Alumni's
ifda Alumni's
ifda Alumni's
ifda Alumni's
ifda Alumni's
ifda Alumni's
Call Today To Get Free DEMO

Get free counselling by our experience counsellors. We offer you free demo & trial classes to evaluate your eligibilty for the couurse.

Have you
Any question
Or need some help?

Please fill out the form below with your enquiry, and we will respond you as soon as possible.

Note :- Please fill all detail for enabled Send Enquiry button.