Microsoft Excel VBA Macro Training

Course on Excel Automation. Taught by Microsoft Certified Trainers

  • (892)

This is a 30-hour program, designed for Advanced Excel users, to automate routine Excel reports or processes using VBA Programming & Excel macros coupled with 90+ small-scale scenarios, 7 case studies and, a Live VBA project (post-training) to get a knack of real-time automation.

The Course is structured in 3 phases - VB Programming, VBA (Excel Automation) and linking Excel to third-party applications.

  • Course Duration :
  • 30 Hours (12 Sessions, each of 2.5 Hours)
  • Course Pre-requisite :
  • Good knowledge on Excel Formulas
  • Mode of Training:
  • Virtual Classroom (Instructor-Led)
  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)
  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. Connecting to third party applications (Access, Outlook, IE etc)
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

Loading Schedule..

System Requirements: Windows OS, Office 2007 & above, microphone-enabled Headset, and a second monitor (optional).

  1. Link to join the session will be e-mailed to you well before hand.
  2. Click the link 15 minutes before the training to view the Trainer's screen in real-time.
  3. Practice the topics taught through assignments.
  4. Clear your doubts instantly with the Trainer.

System Check: To ensure smooth training, we will conduct a quick system check 3 days before the program.

Recommendations:

  1. We recommend using dual monitors, so that you have one screen to watch the instructor and another to work on.
  2. A few days before class, make sure that your computer is ready to go: high-speed, stable internet access with a good headset.
  3. On the day of the class, log into the classroom at least 15 minutes prior to the start of class, using the instructions that are sent after you complete registration. After you are logged in, follow the onscreen instructions to activate the audio.

Offered by Excelgoodies Consulting, Inc.

  1. Report Automation Specialist using VB Programming - On successfully implementing Live VBA Project

Offered by Microsoft, Inc.

  1. Microsoft Excel Expert - To be availed at additional cost.

About the Trainer

Mr. Sami (MCT, MOS, MEE)

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

He has undertaken assignments with the renowned 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.

I would like to talk to the Trainer before reserving my seat.

Schedule a call with my Trainer

Google Reviews

Learner stories around the world!

Tanner Ties

Senior Advisor

This course was really well done. The instructor Sami obviously knows what he is doing and many times if people had questions or errors he was able to resolve and knew what the problem was instantly without even looking at their code.

The course content was great as well. The first couple sessions...

Contact Us

Excelgoodies Software Private Limited

6-2-984, Unit No – 404,

Pavani Plaza, Khairatabad Road,

Khairatabad, Hyderabad – 500004

Tel: +91 9176633248

inquiry_hyderabad@excelgoodies.com