VBA Macros Automation

0( 0 REVIEWS )
STUDENTS

Excel VBA Macros Automation Training in Delhi


XL Technologies is one of the best Training institutions in India. We offer best Excel VBA macros training course in Delhi/NCR. We have designed our Visual basic application (VBA) course by our corporate experienced trainers. VBA macros course has been designed as per the corporate world’s requirement.

“We offer VBA macros training course within our premises and on-site corporate places too.”

What is VBA & Macros?

Visual basic for application is called as VBA in short. VBA is a part of the Excel program.  It’s a programming language that works with Microsoft Office applications like MS Excel & MS word & MS PowerPoint. VBA helps us in Automation & development in Excel.

Macro is a set of codes which is written in VBA. We use macros in VBA to automate our work in excel to save our time. Macro in VBA contains a series of tasks written in strings.

Who can join for VBA Macros training?

      • MIS Executives
      • Data Analytics
      • Data Scientists
      • Data Miners
      • Work Automation organisation employees
      • Who wants to master in Excel.

VBA Macros training course highlights


      • 18 hours course duration
      • Weekdays & weekend (sat/sun) classes.
      • Corporate Trainers
      • Worldwide valid certificate
      • Lifetime support after course completion
      • 100% job assistance
      • Free demo classes.
      • Regular & fast-track batches available

VBA Macros Course Duration & Mode


 

Course Mode Course Duration
Regular Classes 1 Months
  Weekend Classes 4 Weeks

VBA Macros Automation Full Course Curriculum


  • About VBA Macros (Intro)
  • Intro of Developer Tab
  • Recording & Assigning a Macro
  • Understanding Difference Between (.xlsx) and (.xlsm)
  • Understanding Macros Security Types
  • Using Trusted Location
  • Private Vs. Public Macros

  • Use of Command Button
  • Use of Combo Box
  • Use of Spin Button
  • Use of List
  • Use of Option
  • Use of Scrollbar
  • Project 1 -Dashboards Using Above Features (Project ID: XLVBP001)

  • Introduction of VBE Editor
  • VB language Structure
  • Difference Between Method & Property
  • Selection Methods & Differences
  • Basic Programs Using Value, End, Offset, Font, Border, Interior, Align Properties
  • Use of with Statement
  • Project 2 –Simple Data Entry (Project ID: XLVBP002)

  • Using Workbooks & Worksheets Property
  • Working with MsgBox & Inputbox
  • If + And + Or Logical Statements
  • Validation Using If + and + Or statements
  • Project 3 –Data Entry with Diff Sheet (Project ID: XLVBP003)
  • Project 4 –Data Entry with Diff workbook & Validations (Project ID: XLVBP004)

  • Variable Concept
  • Declared vs Non Declared Variables
  • Use of DIM (Dimension)
  • Different Data Types (Integer, Long, String, Double, Date, Boolean, Variant) Etc.
  • Object Variables Uses & Benefits
  • OV with Sheets, Workbooks & Ranges
  • Project 5– Data Entry with Variables (Project ID: XLTVBP005)

  • For Loops Structure & Concept
  • Basic Programs Using for Loop
  • Data Separation Static
  • What are Steps in For Loop
  • Use of Steps with for Loop
  • Project 6– Data Separation Dynamic with Loop (Project ID: XLTVBP006)
  • Project 7– Invoice Generate PDF (Project ID: XLTVBP007)

  • Do Loops in VBA
  • Do White Loop in VBA
  • Do Until Loop in VBA
  • For Each Loops in VBA
  • Project 8 –Using All Above Loops (Project ID : XLTVBP008)

  • Use of Excel Functions in VBA
  • Vlookup in VBA
  • Index in VBA
  • Match in VBA
  • Sumif + Countif in VBA
  • Project 9 –Using All Above Formulas (Project ID: XLTVBP009)

  • Intro to Event in VBA
  • Worksheets Events like (Activate, Selection Change, Clicks etc.)
  • Workbooks event like (Open, Activate, Deactivate, Close, After Save, Pivot Update etc.)
  • Project 11 –Using Sheet Events(Project ID: XLVBP010)
  • Project 12 –Using Workbook Events(Project ID: XLVBP012)

  • Intro of User Forms
  • Use of Textbox, Combo Box, List Box, Option & Spin Buttons etc.
  • Advance Data Entry & Data Updating Using User Forms.
  • Advance Data Validation on User Forms
  • User Forms with Event Macros
  • Dynamic List Box and Combo Box in User Forms
  • Project 13 –User From Project (Project ID: XLVBP013)
  • Project 14 –Dynamic List Box Project with Loop (Project ID: XLVBP004)

  • Create Pivot Using VBA
  • Making Pivot Range Dynamic
  • Use of Pivot Autonomations in Dashboard.
  • Project 15 –Pivot Table Project (Project ID: XLTVBP015)

  • Different Methods of Adding Chart
  • Working with Chart Elements
  • Data Separation Static
  • What are Steps in For Loop
  • Use of Steps with for Loop
  • Project 16 –Making Dashboard Using VBA Charts (Project ID: XLTVBP016)

  • Creating A folder with VBA
  • Deleting A file with VBA
  • Accessing Folder with VBA
  • Project 17 –Using All Above Loops (Project ID : XLTVBP017)

  • Outlook Object Librasry
  • Outlook Object Variable
  • Sending Automatic Emails Using VBA
  • Project 18–Email Automation Projects (Project ID: XLTVBP018)

  • Intro to Event in VBA
  • Worksheets Events like (Activate, Selection Change, Clicks etc.)
  • Workbooks event like (Open, Activate, Deactivate, Close, After Save, Pivot Update etc.)
  • Project 19 –Using Sheet Events(Project ID: XLVBP019)
  • Project 20 –Using Workbook Events(Project ID: XLVBP020)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Course Curriculum

No curriculum found !

Course Reviews

N.A

ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

TAKE THIS COURSE
  • 6,000.00
  • 0 Hours

Instructors

STUDENTS ENROLLED

    Top Rated Course

    Course Reviews

    Copyright© XL Technologies-2020
    X