Microsoft Excel VBA Macro Programming

Course on Excel Automation. Taught by Microsoft Certified Trainers

  • (914)

This is a 25 hours Course designed for Excel users, to automate their routine Excel Reports and Processes through 90+ Scenarios, 7 Case studies, and a Live VBA Project. You need not be a programmer to learn Excel Report Automation!

The Course structure covers following 3 phases:
1. VB Programming
2. VBA or Excel Automation
3. Connecting Excel to third-party applications (like MS-Outlook, MS-Access, IE, etc.)

Talk to the Trainer

Know your current Excel skills through a quick pre-assessment, discuss your requirements (if any) with the Trainer and, feel your comfort level before registering for the program.

Course Fee

$699
Join a VBA Batch at $499 Click here
  • Course Duration :
  • 25 Hours (8 Sessions, each of 3 Hours)
  • Pre-requisite :
  • Proficient Knowledge on Excel Formulas
  • Mode of Training:
  • Virtual Classroom (Instructor-Led)

Our 5 Step Learning Process

VBA Learning Redefined.

Learn VBA from Microsoft Certified Trainers

LEARN from Microsoft Certified Trainers

90+ Small Scale VBA Scenarios

EXPLORE 90+ Small Scale VB Scenarios

Practice with 7 VBA Case Studies

PRACTICE with 7 VBA Case Studies

HANDS-ON experience with a Live VBA Project

HANDS-ON experience with a Live VBA Project

ON-JOB Support

ON-JOB Support to implement learnings

Course Content - Overview

Creating Record Macros
  1. Recording a Macro
  2. Running a Macro
  3. Running a Macro from the Macros Dialog Box
  4. Creating a Short-cut key to run a macro
  5. Running a Macro with a Shortcut key
  6. Assigning a Macro to a Menu or Toolbar
  7. Editing a Macro with Visual Basic
Visual Basic Editor
  1. Objects
  2. Methods
  3. Properties
  4. Programming Tools
  5. The Menu Bar
The Project Explorer
  1. Using the Project Explorer
Using Constants
  1. Excel Constants
  2. Variable Constants
Excel Objects
  1. Objects, Properties and Methods
  2. Getting & Setting Properties
  3. Calling Methods
  4. Passing Arguments
  5. Singular Objects & Collections of Objects
Using Visual Basic Functions
  1. InputBox Function
  2. MsgBox Function
  3. Using a Set Statement
Building Formular Control Structures
  1. If Then Janision Structures
  2. Logical Operators
  3. Select Case Janision Structures
  4. Case Else
  5. Comparison Operators with Select Case Structure
  6. For Loops
  7. Do Loops
  8. While...Wend Statement
Running Code
  1. Run mode and Design mode
  2. Running Code from the development environment
  3. Running Code from the host application
The Properties Window
  1. Changing a Property
Variables
  1. Dimensioning a variable
  2. Using variables in routines
  3. Object Variables
UserForms
  1. Designing & Creating Forms
  2. Working with Controls
  3. Creating Custom Dialog Boxes
  4. Userform Properties Methods & Events
Advanced VBA Programming Techniques
  1. Developing Excel Utilities with VBA
  2. Error Handling
  3. Using In-Built Excel Features in VBA
  4. Working with Pivot Tables
  5. Working with Charts
  6. Understanding Excel's Events
  7. Interacting with Other Applications
  8. Creating and Using Add-Ins
Developing Applications
  1. Working with the Ribbon
  2. Working with Shortcut Menus
  3. Providing Help for Your Applications
  4. Developing User Oriented Applications
Event Handling
  1. VBA Editing & Debugging
  2. Auto Macros
  3. Error Handling
Connecting to Database
  1. Connect to MS Access
  2. Access Database & Retrieve Data from MS Access
  3. Create Table & Query Data Filter DB using Query
  4. Update and Modify DB
  5. Create Single and Multiple Mapping Tables
  6. Filter DB using Query
  7. Query data grouping
  8. Retrieve Data using Logical Access Query
Connect Excel to Outlook
  1. Connect to Outlook using VBA
  2. Query to retrieve Mail From, to and CC address
  3. Retrieve Mail Subject and Time
  4. Retrieve Mail Attachment

What will you be able to do post-training?

  1. Automate any live scenarios in Excel using VBA with ease
  2. Have high comfort on Programming
  3. Increased maturity in handling Excel related automations
  4. Develop scalable Excel Applications with ease, avoiding re-work
  5. Connect to third-party applications (Access, Outlook, IE, etc.)

What's included in your training?

  1. 90+ Small scale Scenarios
  2. 7 Major VBA Case Studies
  3. Live VBA Project (Post-Training)
  4. VBA Automation Specialist Certification
  5. 30 Days Post-Training Support (On-Job)

Course Fee

For One-to-One
personalized training
$699
Join a VBA (Group)
Batch at

Live VBA Project

We believe firmly in result-oriented Automation training. Hence, the learning at Excelgoodies doesn't stop just with the Classroom sessions. Post the Training; you will be offered an opportunity to take up a live VBA project from your company and implement all the concepts learned in real-time.

You will also be honored with the "Report Automation Specialist" Certificate on saving at least 2 hours of work per day.

About the Trainer

Mr.Sami (MCT, MOS, MEE)

Mr. Sami, Microsoft Certified Trainer, with his qualifications in Finance and IT brings in 14 years of Industry experience. He has successfully trained 3000+ professionals by now, and the counting is still on.

He has undertaken the renowned VBA assignments with IRS, The World Bank, Tata Chemicals, Buckman Laboratories, Standard Chartered, ING Barings and much more. His nature of going that Extra Mile has got him the startling popularity amongst the Excelgoodies prominent clients.

Learner stories around the world!

Reviews

  • Trainer's Expertise
  • Course Structure
  • Course Content
  • Quality of Assignments
  • Certification Process

Jayden Noah

Financial Analyst

Programming is something I thought would never be able to get hang on. I really appreciate Mr. Sami for making the most complex concepts look so simple.

I wouldn’t be wrong and, shall not be the only one who would say...

Michael Joshua,

Operations Analyst

Informative workshop! It has substantially enriched my knowledge and added value to my Career Profile. I really appreciate the way Sami go out of the way to help us understand the topics.

I come from a non-programming background yet, the topics were taught in the most laymen...

Frank Young

Business Analyst

It was indeed some good learning! Sessions were highly informative with loaded tips here and there by Sami on remembering concepts and implementing it back at work.

I really enjoyed Assignments session which truly boosted my confidence in Automation...

Karen Smith

Quantitative Analyst

Good sessions. Highly passionate trainer. Sami was quick enough to identify the skill sets and the knowledge of the participants to pace his training accordingly.

His way of simplifying the coding concepts was just spell bounding. He knew his students...

Cody K

Risk Reporting Developer

A well-structured program. The flow of training was carried out pretty well by the tutor. Enjoyed working with case studies and the concepts were taught in the simplest way

It made me much more confident to assume...

Other Excel Courses offered

Powerpivot - Data Analytics

View Details

Advanced Excel Training

View Details

Financial Modeling with Excel

View Details

MIS Reporting with Excel

View Details