loading......

coming soon

Coming Soon

We are in process of building the inventory of good professionals in this category

Got it!

Where do you need ?

location

Please select a Location.

Enquire

Submit your enquiry for Excel VBA Macro Training in Chennai

Please enter valid question or comment

Please enter your name.

Please enter valid email

Please enter valid Phone Number

Please enter the Pin Code.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Excel Sense

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer

Share

Excel VBA Macro Training in Chennai

Excel VBA Macro Training in Chennai

Nungambakkam, Chennai

8,000

No Reviews Yet
0 Interested

About the Course


Excel Sense is a start up ms excel training institute. We offer Professional and advance Excel training and Macro training using VBA to students / learners at graduate, postgraduate and professional levels.
We can also tailor MS Excel training to your needs, or to your company project requirements, taking you from first principles to whatever level you want to achieve.
We just don't stop with teaching you excel options but expertise you in customizing the various options for your needs.

There are 12 Classes. All the classes only in the weekend. Each class covers 2.30hrs.

Topics Covered

It is a general purpose programming language, that comes along as standard with the Excel or Office can be used to perform various business tasks like-

Automate Report Generation
Automate Chart creation
Creating Dashboards
Communicating with MS Access Databases
Analyzing Business Data
Reconciling Data
Timesavings
Create our Own Functions
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 Excel
Must have worked on applications using Excel for atleast 1 year
Good Analytical Skill and Numerical ability is an advantage
Should take up Excel Test

Session - 1

VBA Overview & VBA Basic

What is VBA?
Quick Review of Macros
Introducing the Visual Basic Editor
Using the Visual Basic Editor
Uses of Record Macro
Understanding and creating Modules
How to create a Message Box
Write program to update and retrieve information using Input Box
Conditions (IF, AND, OR etc.)
Understanding and using Select Case statement
How do I define a Variables and Rules for defining a Variable Name and Type
Creating And Using Variables
Working with For …. Next procedure
Working with Do While …. Loop procedure
Calling Procedures from one procedure to another
How to Save and Protect Modules
Session - 2 & 3

Workbook Objects

Create or Add Single and Multiple Workbooks
Workbooks Save and Save As with Password
Open Single and Multiple Workbooks
Close Specific and Multiple Workbooks
Get Count of Workbooks
To refer a particular Workbooks
Activate from one Workbook to another Workbook
Open Workbooks from Specific Path
Get Workbooks Name and Path
Hide and Unhide for Single and Multiple
Workbooks
Calculate entire Workbook
Protect and Unprotect Worksheets

Session - 4

Worksheet Objects
Insert a Single and Multiple Worksheets
Delete Specific and Multiple Worksheets
Get Count of Worksheets
Select a Specific and All Worksheets
Get All Worksheets Name
Hide and Unhide for Single and Multiple Worksheets
Rename for Single and Multiple Worksheets
Protect and Unprotect Worksheets
Sort and Move Worksheets
Calculate entire Worksheet

Session - 5

Cell Objects
Insert single and multiple Row, Column and Cells
Delete single and multiple Row, Column and Cells
Get Range or Address of Cell and Selection
Navigate from one Cell to another Cell
Select specific Range, Cell, Rows and Column
Types of Selection and Offset method
All the Options in Paste Special
All the Options in Go To
How to update the Formulas
Cut, Copy and Paste Options

Session - 6

Excel Options
Create New Pivot, Refersh and Other Pivot Opotions
All the Filter and Advance Filter Options
Data Sort Options
All Text to Columns Options
All Data Formatting Options
Fill, Clear, Find and Replace Options
Preparation of Chart and Dashboard

Session - 7

VBA Function
What is Function?
User Defined Function
Create a Function using IF Condition and Select Case
Create an Advanced IF Conditional Fuctions
Create an Advanced Computation and Conditional Function

Session - 8

VBA Function
Create a Vlookup Fucntions
Create a Sum Fuctions
Create Count Function
Count All
Count Only Numbers
Count Only Text
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

Who should attend

All the Finance and Marketing person can attend this training and the person who handle huge volume o huge data, they should attend this training. Because it will be very useful to their carrier development.

Pre-requisites

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 Excel
Must have worked on applications using Excel for atleast 1 year
Good Analytical Skill and Numerical ability is an advantage
Should take up Excel Test

What you need to bring

Notebook and pen

Key Takeaways

Automate Report Generation
Automate Chart creation
Creating Dashboards
Communicating with MS Access Databases
Analyzing Business Data
Reconciling Data
Timesavings
Create our Own Functions
Gallery
Reviews
There are no Reviews yet. Be the First to Review
Questions and Comments

Thousands of experts Tutors, Trainers & other Professionals are available to answer your questions

Comment ?

Questions Guidelines

  • Start your question with simple statements like "what", "when", "where", or "how".
  • Ensure your question or answer is not offensive or insensitive - it may be voted down or banned.
  • Please provide as much detail as possible as this will allow our members to better understand and respond to your question.
  • Take some time to categorize your question. This will greatly help other users find the question.


You can add upto 6 Images

Ask

Showing 1 to 7 of 7

Excel 05/08/2013

Hi,

Please find below the course details.

Excel (VBA) Macro Training
Course Fee - 8000/-
Classes - 12

Saturday (6pm to 8.30pm)
Duration - 2.30 hrs

0 0

Answer

You can add upto 6 Images

U

Karthik 03/08/2013

Hi Karthik,

Cost of Excel VBA Macro Training is Rs.8000/-.

0 0

Answer

You can add upto 6 Images

U

Arul 03/08/2013

would like to know the course details, cost, venue schedule etc

0 0

Answer

You can add upto 6 Images

U

Karthick 02/08/2013

i want to know about the trianing on Excel macro (VBA) Course costing.

0 0

Answer

You can add upto 6 Images

U

Seenivasan 19/01/2013

Can you please send me the address and contact number

0 0

Answer

You can add upto 6 Images

U

Jagan 29/12/2012

The right centre at the right place to get the knowledge in Excel & VBA. Please use the opportunity to upgrade your excel knowledge.

0 0

Answer

You can add upto 6 Images

U

venkadesh 23/10/2012

advance ms excel and vb macros fees details

0 0

Answer

You can add upto 6 Images


There are no Reviews yet. Be the First to Review

Date and Time

Not decided yet.

About the Trainer

Jagan

MBA


Course trainer has over 7 years of experience in Financial environment and He has automated so many reports and files in various organisation.
Seats Left-

Students Interested 0

Course Id: 4461