Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

Excel Advanced ( VBA Macro Programming ) Level 1- Evening Classes ( 4 Hours / Day )

No Reviews Yet

Course type: Online Instructor led Course

Platform: gotomeeting and other online platforms

Course ID: 20031

Course type: Online Instructor led Course

Platform: gotomeeting and other online platforms

No Reviews Yet

Date and Time

Not decided yet.

Umasankar Natarajan picture
Umasankar Natarajan

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

20 Years of Experience

About Umasankar Natarajan

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.
No reviews currently Be the First to Review

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

No reviews currently Be the First to Review

Discussions

Post your requirement and let us connect you with best possible matches for Microsoft Excel Training classes Post your requirement now
₹ 8,000 Enquire