VBA Training Courses

VBA Training Courses

VBA Training

100% Money Back Gurantee

  1. We provide Online Coaching,In -person
  2. Weekdays-Weekend Classes as per your ease
  3. Not more than 5 Students in one Batch
  4. Programme equipped with HardCore EXCEL Assignments
  5. Projects Making
  6. Online help even after the Training- Forever
  7. Arrangement of Videos for the revision of each Subject
  8. You may choose your Topics and we can design the training accordingly
  9. Easy EMI Options available
  10. 2 Days free Classes
  11. 100% Money Back Gurantee

Course Contents,For Weekly new videos,Subscribe to YOUTUBE channel:www.youtube.com/c/ajaykumarparmar

Day 1

  • Introduction To Macros
  • Purpose of Macros
  • Recording macros
  • Where to save macros
  • Running macros:
  • Custom buttons, menu items, keyboard shortcuts
  • Creating Record Macros
  • Recording a Macro
  • Running a Macro
  • Running a Macro from the Macros Dialog Box
  • Creating a Short-cut key to run a macro
  • Running a Macro with a Shortcut key
  • Assigning a Macro to a Menu or Toolbar
  • Editing a Macro with Visual Basic
  • Dot Notation
  • Add Button to a SpreadSheet
  • Offset Property

Day 2

  • Variables & Boxes
  • Finding the Last row or Last Col
  • How to define range
  • Playing with Ranges
  • InputBox Function
  • Using Visual Basic Functions

Day 3

  • Macros
  • Writing Formulas in Macro
  • Using Formula defined in Macro
  • Evaluate Method

Day 4

  • Loops
  • If Then Decision Structures
  • Logical Operators
  • Select Case Decision Structures
  • Case Else
  • Comparison Operators with Select Case Structure
  • For Loops
  • Do Loops

Day 5

  • UserForms & Active X Controls
  • Designing & Creating Forms
  • Working with Controls
  • Creating Custom Dialog Boxes
  • Userform Properties Methods & Events
  • Introduction to Form X and Active X Controls
  • Working with Errors
  • Resume Statements
  • Advanced VBA With Access & SQL
  • Using the Project Explorer
  • Using Constants
  • Excel Constants
  • Variable Constants
  • MsgBox Function

Day 6

  • File Dialogue
  • Change Events
  • How to work with Them?
  • Open Dialog,Save As

Day 7

  • Connect Excel to Outlook
  • Introduction to Customised Functions
  • Connect to Outlook using VBA
  • Query to retrieve Mail From, to and CC address
  • Retrieve Mail Subject and Time
  • Retrieve Mail Attachment

Day 8

  • Data Consolidation-MIS
  • Consolidating Multiple Workbooks in One
  • Rename & Moving Files
  • Send Keys

Day 9

  • Connecting with Database
  • Connect to MS Access
  • Working with SQL & Access
  • Understanding of the Queries
  • Various Kind of Joins
  • INNER JOIN
  • LEFT JOIN

Day 10

  • Pivot and Charts
  • Working with Pivot Tables
  • Working with Charts
  • Split

Day 11

  • Arrays
  • Understanding Arrays

Day 12

  • Questions & Doubts
  • Revision of the Content
  • RIGHT JOIN
  • Action and Select Queries Basics
  • SQL & Access Continue