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 Advanced ( VBA Macro Programming ) Level 1

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 Umasankar

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

course photo

Excel Advanced ( VBA Macro Programming ) Level 1

BTM Layout, Bangalore

8,000

2 Reviews
5 Interested

About the Course


This Advanced Microsoft Excel VBA Macro Programming training class is designed for students to gain the skills necessary to automate your excel vba macro work. Trainees will learn in depth knowledge about excel vba macro programming

Topics Covered

01) Macro
Recording Macro
Running Macro
Modifying Macro
Creating a Short-cut key to macro
Running a Macro with a Shortcut key
Running a Macro from the Macros Dialog Box
Working with Macro Buttons
Running a Macro from Macro Buttons
Assigning a Macro to a Menu or Toolbar
Adding Macros to the Quick Access Toolbar
Running a Macro from Menu or Toolbar

02) Understanding The VBA Editor
The Visual Basic Editor
Parts of the VBA Editor
Project Window
Properties Window
Modules and Macros

03) Debugging Code
Compile Errors
Runtime Errors
Logic Errors
Design Time, Runtime, and Break Mode
Setting Breakpoints & Stop
Stepping through Code
Running Selected Parts of Code
Debug Window
Understanding Errors
Using Debugging Tools
Setting Breakpoints

04) Immediate Window
Using the Immediate Window
Using Variables
Constants
Object Variables
Displaying data to the user
Obtaining data from the user

05) Constants, Variable
Constants
Variables
Rules for variables name
Reserved Words
Scope and Life of variables
Declaration and Redeclaration

06) Data Types
Different Data Types
Why do we need Data Types?
User Defined Data Types

07) Running Code
Run mode and Design mode
Running Code from the development environment
Running Code from the host application

08) Arrays
Single Dimentional Array
Two Dimentional Array
Access Array elements
Join & Split

09) Functions
String Functions
Format Function
Date and Time Functions
Conversion Functions

10) MessageBox and Input Box
Using Message Boxes
Using Input Boxes
Using a Set Statement

11) Operators
Arithmetic
Comparison
Logical
Concatenation
Is and Like

12) VBA Syntax and Grammar
Objects – The Grammar
Using Properties and Methods
Understanding Parameters
The Object Browser
Understanding object hierarchy
Tools for better coding

13) Procedures
Rules for Procedures name
Subroutines Procedures
Functions Procedures
Creating Custom Functions
Class Procedures
Argument Data Types - ByRef, ByVal, Optional
Argument Data Types - ParamArray - Variable number of arguments
Scope and Visibility

14) Standard Modules
Creating Modules
Writing Functions
Calling Module Functions
Importing Modules
Exporting Modules

15) Class Procedures
Inserting a Class Module
Creating an Object
Creating a Collection

16) Branching & Conditional Statement (Decision Making)
If without Endif
If ... Else Endif
If ... Elseif ... Else ... Endif
Next If
Select ... Case
Nexted Select ... Case

17) Repeatation
With ... End With statement

18) Loops
For ... Next
For Each ... Next
Do While ... Loop
Do Loop ... While
Do Until ... Loop
Do Loop ... Until
While ... Wend
With ... End With

19) Errors and the Error Function
On Error
Resume
Error Trapping
Generating Own Errors

20) Excel Object Model
Properties, Methods, Events Explained
Application Object
Windows Object
Workbook Object
Worksheet Object
Range Object
Row Object
Column Object
Cell Object

21) Dialogs, Forms & Control
Creating form
Displaying form
Creating control over form
Label Control
Textbox Control
Combobox Control
Listbox Control
Spin Control
Radio Control
Checkbox Control
Command Button
ListBox control
Date Picker
Setting the Tab Order
Populating a Control

22) Interaction of Excel with
VBA Forms & above Controls
Forms Control & above Activex Controls

23) Interacting with Outlook
Connect to Outlook using VBA
Send email Automatically (From, To and CC address)
Send email Automatically with Attachement

24) Interacting with Database ( MS Access )
Creating a Database ( MS Access )
Connecting Excel with MS Access
ADO and DAO connection
Adding new Data
Deleting Data
Editing and Saving Data

25) Dashboard
Creating simple Dashboard
Automating Dashboard Data
Modifying Dashboard
Dynamic Chart

Who should attend

Anyone who is looking to learn Excel VBA Macro Programming from Basic to Advance. Who wants to automate their company excel work without any further Excel VBA Macro Programming training from their supervisor

Pre-requisites

1 ) Student should have basic computer knowledge like working in Windows, Just they should know about logon to the system and connect the system to the internet.

2) Experience with Excel Basic (Ribbon, Tabs and Commands) and Intermediate (Formulas and Functions)

Student can contact me 1 or 2 days before the workshop, I will send the link for online teaching software and make his/her system ready to run the class smoothly.

What you need to bring

As It is online class, Students should have good Laptop or Desktop with good internet connection at least 256kbps. Internet Connection should be work continuous.

Laptop or Desktop should have Windows XP, Windows Vista, Windows 7, Windows 8 or 8.1 OS installed.

Laptop or Desktop should have Ms Office 2007 or 2010 or 2013

If their Internet connection disconnect frequently, there may be chance of missing some sessions.
If they miss some of the sessions / topics, can reach me, I will take separate class to cover the missing sessions.""

Key Takeaways

My training will focus with practical example of Excel VBA Macro Programming.

Students will gather more knowledge about Excel VBA Programming.

Students able to write professional looking excel vba macro automation code independently.

Students able to debug their code and fix the bugs independently.

Students can directly work in their company Excel VBA Macro projects directly without any further excel vba macro Programming training from their supervisor / company

Students can also optimise the code to improve the performance.
Reviews

Recommendations & reviews from previous Customers:

Satya Mellacheruvu

"I found him to be knowledgeable, technically sound and has in depth knowledge,good at fundamentals, conceptually clarity regarding the subject. Doubts were clarified with lot of patience. Material provided was really good in terms of class room sessions and instructor led examples . I would definitely recommend him for VBA and Advanced VBA. "

attended Excel Advanced ( VBA Macro Programming ) Level 1


Satya Mellacheruvu

"I found him to be knowledgeable, technically sound and has in depth knowledge,good at fundamentals, conceptually clarity regarding the subject. Doubts were clarified with lot of patience. Material provided was really good in terms of class room sessions and instructor led examples . I would definitely recommend him for VBA and Advanced VBA. "

attended Excel Advanced ( VBA Macro Programming ) Level 1


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


Recommendations & reviews from previous Customers:

Satya Mellacheruvu

"I found him to be knowledgeable, technically sound and has in depth knowledge,good at fundamentals, conceptually clarity regarding the subject. Doubts were clarified with lot of patience. Material provided was really good in terms of class room sessions and instructor led examples . I would definitely recommend him for VBA and Advanced VBA. "

attended Excel Advanced ( VBA Macro Programming ) Level 1


Satya Mellacheruvu

"I found him to be knowledgeable, technically sound and has in depth knowledge,good at fundamentals, conceptually clarity regarding the subject. Doubts were clarified with lot of patience. Material provided was really good in terms of class room sessions and instructor led examples . I would definitely recommend him for VBA and Advanced VBA. "

attended Excel Advanced ( VBA Macro Programming ) Level 1


Date and Time

Not decided yet.

About the Trainer

Umasankar Natarajan picture

Umasankar Natarajan

B.E., M.B.A., PMP


I have 22 Years experience - 20+ years of software design & development experience and 2 years of Non IT experience.

I have practically worked C, C++ , PHP, MySQL for 18+ years in different software companies like Tata Elxsi, Mphasis, Aricent, Mindtree.

I worked 8+ years as Project Manager, where I worked many excel vba project to create dashboard and automate project reports.

I completed 25+ realtime project in Software Industries. Out of which I have done 21+ C & C++ Real time projects. 15+ Excel Projects for Automation, Dashboard and report generation.

6+ PHP MySQL Real time Projects.

I can teach you Excel VBA Macro Programming in depth with practical examples.

I can teach you C and C++ Programming in depth with practical examples. Also I will teach C & C++ with memory level debugging.

I can teach you PHP - MySQL programming in depth with practical examples.
Seats Left-

Students Interested 5

Course Id: 20078