S
speak2jagan
VBA MACRO Training in Chenna
Visual Basic For Applications (VBA) & Macro Tranin
Microsoft Visual Basic for Applications (VBA, Macros) when use
with Microsoft Excel can build powerful automated business tools quickl
and minimum cost. If you sit in front of a computer screen all da
creating reports in Microsoft Excel, you know the power of this VB
software package. But if you aren't using macros yet, you don't know th
half of it. Macros automate common and repetitive keystrokes that yo
use in Excel to create and edit spreadsheets. By reducing the number o
keystrokes required to perform common commands, macros speed up you
production and reduce the time you have to spend staring at a
electronic spreadsheet each day. We provide the best VBA Macros trainin
in Nungambakkam, Chennai. We also provide Corporate Training in VBA. I
is a general purpose programming language, that comes along as standar
with the Excel or Office can be used to perform various business task
like
Automate Report Generatio
Automate Chart creatio
Creating Dashboard
Communicating with MS Access Database
Analyzing Business Dat
Reconciling Dat
Timesaving
Create our Own Function
Prerequisites for attending the VBA Training programme
Good Knowledge of all features of Excel such as Filters, Pivot Tables
Text to Columns etc
Good knowledge of Fundamental and Formulae and Functions in Exce
Must have worked on applications using Excel for atleast 1 yea
Good Analytical Skill and Numerical ability is an advantag
Should take up Excel Tes
Clas
Syllabu
Training Detail
Session - 1
VBA Overview & VBA Basi
What is VBA
Quick Review of Macro
Introducing the Visual Basic Edito
Using the Visual Basic Edito
Uses of Record Macr
Understanding and creating Module
How to create a Message Bo
Write program to update and retrieve information using Input Bo
Conditions (IF, AND, OR etc.
Understanding and using Select Case statemen
How do I define a Variables and Rules for defining a Variable Name an
Typ
Creating And Using Variable
Working with For …. Next procedur
Working with Do While …. Loop procedur
Calling Procedures from one procedure to anothe
How to Save and Protect Module
Session -
Session - 3
Workbook Object
Create or Add Single and Multiple Workbook
Workbooks Save and Save As with Passwor
Open Single and Multiple Workbook
Close Specific and Multiple Workbook
Get Count of Workbook
To refer a particular Workbook
Activate from one Workbook to another Workboo
Open Workbooks from Specific Pat
Get Workbooks Name and Pat
Hide and Unhide for Single and Multiple Workbook
Calculate entire Workboo
Protect and Unprotect Worksheet
Session - 4
Worksheet Object
Insert a Single and Multiple Worksheet
Delete Specific and Multiple Worksheet
Get Count of Worksheet
Select a Specific and All Worksheet
Get All Worksheets Nam
Hide and Unhide for Single and Multiple Worksheet
Rename for Single and Multiple Worksheet
Protect and Unprotect Worksheet
Sort and Move Worksheet
Calculate entire Workshee
Session - 5
Cell Object
Insert single and multiple Row, Column and Cell
Delete single and multiple Row, Column and Cell
Get Range or Address of Cell and Selectio
Navigate from one Cell to another Cel
Select specific Range, Cell, Rows and Colum
Types of Selection and Offset metho
All the Options in Paste Specia
All the Options in Go T
How to update the Formula
Cut, Copy and Paste Option
Session - 6
Excel Option
Create New Pivot, Refersh and Other Pivot Opotion
All the Filter and Advance Filter Option
Data Sort Option
All Text to Columns Option
All Data Formatting Option
Fill, Clear, Find and Replace Option
Preparation of Chart and Dashboar
Session - 7
VBA Functio
What is Function
User Defined Functio
Create a Function using IF Condition and Select Cas
Create an Advanced IF Conditional Fuction
Create an Advanced Computation and Conditional Function
Session - 8
VBA Functio
Create a Vlookup Fucntion
Create a Sum Fuction
Create Count Functio
Count Al
Count Only Number
Count Only Tex
Count Only Blanks
Count All
Session - 9
Access Database & Retrive Data From Access Databsae Using VBA Excel
Create a New Table and Database in MS Access
Load the Data into Access Database
Create a Query in Access Database
Create Single and Multiple Mapping Tables
Filter Single and Multiple criteria using Access Query
Create Query for Data Grouping
Create Query to Select required Columns
Retrive specific data using Logical Access Query
Create Access Query to Update, Change and Delete the Information in
Access
Retrive information through Excel from Access Database using VBA
Session - 10
Form Controls and User Forms
Create and Design an UserForm
How to Link the VBA Macro to UserForm
Overview of Form Controls
Create a Form Information Tables and Database
Session - 11
Files Automations through VBA
Files Automations real time scenarios
VBA Sample Project Report preparation
Session - 12
Outlook / Questions and Clarifications
Retrive the Information through Excel from Outlook using VBA
Write query to Retrive Mail From, To and CC address from Outlook
Write query to Retrive Mail Subject and Time from Outlook
Write query to retrive Mail Attachment from Outlook
Contact us
EXCEL SENSE,
No.96, Kaveri Complex,
No.374 A 3rd Floor,
Nungambakkam High Road,
Chennai-600034
Phone:+9144 42624688
Mobile:+91 9789024023, +91 9941246766
E-Mail: (e-mail address removed)
Visual Basic For Applications (VBA) & Macro Tranin
Microsoft Visual Basic for Applications (VBA, Macros) when use
with Microsoft Excel can build powerful automated business tools quickl
and minimum cost. If you sit in front of a computer screen all da
creating reports in Microsoft Excel, you know the power of this VB
software package. But if you aren't using macros yet, you don't know th
half of it. Macros automate common and repetitive keystrokes that yo
use in Excel to create and edit spreadsheets. By reducing the number o
keystrokes required to perform common commands, macros speed up you
production and reduce the time you have to spend staring at a
electronic spreadsheet each day. We provide the best VBA Macros trainin
in Nungambakkam, Chennai. We also provide Corporate Training in VBA. I
is a general purpose programming language, that comes along as standar
with the Excel or Office can be used to perform various business task
like
Automate Report Generatio
Automate Chart creatio
Creating Dashboard
Communicating with MS Access Database
Analyzing Business Dat
Reconciling Dat
Timesaving
Create our Own Function
Prerequisites for attending the VBA Training programme
Good Knowledge of all features of Excel such as Filters, Pivot Tables
Text to Columns etc
Good knowledge of Fundamental and Formulae and Functions in Exce
Must have worked on applications using Excel for atleast 1 yea
Good Analytical Skill and Numerical ability is an advantag
Should take up Excel Tes
Clas
Syllabu
Training Detail
Session - 1
VBA Overview & VBA Basi
What is VBA
Quick Review of Macro
Introducing the Visual Basic Edito
Using the Visual Basic Edito
Uses of Record Macr
Understanding and creating Module
How to create a Message Bo
Write program to update and retrieve information using Input Bo
Conditions (IF, AND, OR etc.
Understanding and using Select Case statemen
How do I define a Variables and Rules for defining a Variable Name an
Typ
Creating And Using Variable
Working with For …. Next procedur
Working with Do While …. Loop procedur
Calling Procedures from one procedure to anothe
How to Save and Protect Module
Session -
Session - 3
Workbook Object
Create or Add Single and Multiple Workbook
Workbooks Save and Save As with Passwor
Open Single and Multiple Workbook
Close Specific and Multiple Workbook
Get Count of Workbook
To refer a particular Workbook
Activate from one Workbook to another Workboo
Open Workbooks from Specific Pat
Get Workbooks Name and Pat
Hide and Unhide for Single and Multiple Workbook
Calculate entire Workboo
Protect and Unprotect Worksheet
Session - 4
Worksheet Object
Insert a Single and Multiple Worksheet
Delete Specific and Multiple Worksheet
Get Count of Worksheet
Select a Specific and All Worksheet
Get All Worksheets Nam
Hide and Unhide for Single and Multiple Worksheet
Rename for Single and Multiple Worksheet
Protect and Unprotect Worksheet
Sort and Move Worksheet
Calculate entire Workshee
Session - 5
Cell Object
Insert single and multiple Row, Column and Cell
Delete single and multiple Row, Column and Cell
Get Range or Address of Cell and Selectio
Navigate from one Cell to another Cel
Select specific Range, Cell, Rows and Colum
Types of Selection and Offset metho
All the Options in Paste Specia
All the Options in Go T
How to update the Formula
Cut, Copy and Paste Option
Session - 6
Excel Option
Create New Pivot, Refersh and Other Pivot Opotion
All the Filter and Advance Filter Option
Data Sort Option
All Text to Columns Option
All Data Formatting Option
Fill, Clear, Find and Replace Option
Preparation of Chart and Dashboar
Session - 7
VBA Functio
What is Function
User Defined Functio
Create a Function using IF Condition and Select Cas
Create an Advanced IF Conditional Fuction
Create an Advanced Computation and Conditional Function
Session - 8
VBA Functio
Create a Vlookup Fucntion
Create a Sum Fuction
Create Count Functio
Count Al
Count Only Number
Count Only Tex
Count Only Blanks
Count All
Session - 9
Access Database & Retrive Data From Access Databsae Using VBA Excel
Create a New Table and Database in MS Access
Load the Data into Access Database
Create a Query in Access Database
Create Single and Multiple Mapping Tables
Filter Single and Multiple criteria using Access Query
Create Query for Data Grouping
Create Query to Select required Columns
Retrive specific data using Logical Access Query
Create Access Query to Update, Change and Delete the Information in
Access
Retrive information through Excel from Access Database using VBA
Session - 10
Form Controls and User Forms
Create and Design an UserForm
How to Link the VBA Macro to UserForm
Overview of Form Controls
Create a Form Information Tables and Database
Session - 11
Files Automations through VBA
Files Automations real time scenarios
VBA Sample Project Report preparation
Session - 12
Outlook / Questions and Clarifications
Retrive the Information through Excel from Outlook using VBA
Write query to Retrive Mail From, To and CC address from Outlook
Write query to Retrive Mail Subject and Time from Outlook
Write query to retrive Mail Attachment from Outlook
Contact us
EXCEL SENSE,
No.96, Kaveri Complex,
No.374 A 3rd Floor,
Nungambakkam High Road,
Chennai-600034
Phone:+9144 42624688
Mobile:+91 9789024023, +91 9941246766
E-Mail: (e-mail address removed)