Have any Questions ? Call +91 9384011665

VBA Macro Training

  • Home -
  • VBA Macro Training
Discover How You Can Increase Each Employee’s Productivity Every Month For Less Than A Price Of A Cup Of Coffee

VBA Macro Training Training

VBA Macro is one of the powerful automation tools which inbuild in Microsoft Excel.VBA Macro enables you to automate various activities in Excel like generating reports, preparing charts & graphs, doing calculations, eliminate repetitive task etc. You can also automate report using Microsoft Excel, but it will not give much time savings. But using VBA Macro you can easily save huge number of hours. This way it helps users to save their time spent behind running the repetitive steps.Learning VBA is relatively easy compared to other programming languages also it can be learnt without prior coding experience. Especially so, if you’re already familiar with Excel. You should have minimum of Excel Basic and Intermediate knowledge to take VBA Macro course, otherwise it’s almost equivalent to wasting your money.


Description

VBA Macro session cover following topics:-

  • VBA Macro Overview
  • VBA Cell Objects
  • VBA Worksheet Objects
  • VBA Worksheet Objects
  • VBA Excel Options
  • VBA Excel PivotTable & Dashboard
  • VBA Workbook and Worksheet specific Macro
  • VBA Formulas – Create your Own Formulas/Functions using Macro
  • Mini Automation Project in all the above topics

Our course contents developed after so many researches and studies with various user like Students, Working Professionals, Finance, HR, Engineering etc.

Our courses not only cover the features of VBA Macro,we also teach how and when to use with real time examples and Mini projects. Also, we provide material with complete VBA Macro coding for practicing.

VBA Macro helps to boost your productivity, improve your speed, save time, eliminate manual, repetitive and non-value added activities in your day to day process.

Why should we learn VBA?

  • VBA will make you better at your job
  • Create Dashboard for better decision making
  • Makes calculations of complex formulas easy
  • Eliminate manual work through Automating reports
  • Easily save 1000+ hours through Automating reports
  • Finish huge task with the click of a button
  • Within minutes can finish huge task
  • Improve your Company productivity
  • It will increase your Salary
  • Sell yourself in the competitive Industries
  • Improve your analytical thinking
  • Organize data in an easy-to-navigate way
  • Gain practical experience with large spreadsheets

Syllabus- VBA Macro Training (Basic, Intermediate and Advanced Level)


1. Basic Overview
  • What is VBA?
  • Quick Review of Macros
  • Using the Visual Basic Editor
  • Uses of Record Macro
  • Understanding and creating Modules
  • How to create a Message Box
  • Conditions (IF, AND, OR etc.)
  • Understanding and using Select Case statement
  • How do I define a Variables and Rules for defining a Variable Name and Type
  • Creating and Using Variables
  • Working with For …. Next procedure
  • Working with Do While …. Loop procedure
  • Calling Procedures from one procedure to another
2. VBA Cell Objects
  • Select Cell, Multiple Cells, All Cells
  • Select Range, Select CurrentRegion
  • Update value in Active Cell and Range
  • Get Activecell Address, Selection Address
  • Select Row, Rows and Multiple Rows
  • Select Column, Columns and Multiple Columns
  • Select Activecell Row and Column
  • Curser Navigation Up, Down, Right and Left
  • Range Selection Navigation Up, Down, Right and Left
  • Navigate Cells using OFFSET method
  • Range Selection with Offset
  • Select Entire Data
  • Selection from Down to Header
  • Fill Down
  • Move to end of the report
  • Insert Cell Down, Up, Right and Left
  • Insert Rows
  • Insert Row, Rows, Column, Columns, Rows & Column in Active Cell
  • Delete cell down and Left
  • Delete Row, Rows, Column, Columns, Rows & Column in Active Cell
  • Copy Active cell and Selection, Range, Rows and Columns
  • Move Columns
  • Paste and All PasteSpecial Options
  • Mini Project using All Cell Objects – Create and Update Table with Formulas
3. VBA Worksheet Objects
  • Select Worksheet
  • Select Worksheet with InputBox
  • Count Worksheets
  • Create Worksheets
  • Create Worksheets After Activesheet
  • Create Worksheets After, Before and End of the Sheets
  • Create more Worksheets Using For…Next
  • Change Worksheet Name
  • Select All Worksheets
  • Create more worksheets with Name
  • Get all and Visible Worksheet Name
  • Delete Sheet, Sheets, Active sheet and all Sheets
  • Hide and Unhide Sheet, Sheets and all Sheets except active Sheet
  • Create Hyperlink for Sheet and Multiple Sheets
  • Mini Projects using Worksheets Objects
    • Consolidate Data from All Sheets
    • Consolidate Data from Visible Sheets
    • Consolidate Data with Blank Cells & Sheet
    • Consolidate Data with Sheet Name
    • Consolidate Only Specific Field Data
4. VBA Workbook Objects
  • Create Workbook, Workbooks and Multiple Workbooks
  • Select Workbooks
  • Open and Close Workbooks
  • Open Workbooks with Password and ReadOnly
  • Close Workbooks and Activeworkbook without Alert
  • Select ThisWorkbook
  • Select next workbook
  • Save ActiveWorkbook
  • SaveAs Workbooks
  • SaveAs Workbooks with Format (.xlsx, .xlsm, .xlsb)
  • Count Workbooks
  • Select All Workbook
  • ActiveFilePath, Name and Path & Name
  • Get Name for All Files
  • Create more workbooks with Name
  • Consolidate Data from multiple Workbook from folder
  • Mini Project using Workbook Object
    • Consolidate Data from multiple workbook with multiple Worksheets from folder
5. VBA Excel PivotTable & Dashboard
  • Create new pivot table
  • Add Row Field First & Second Position
  • Add Column Field Position
  • Add Value Field
  • Remove Row Field
  • Remove Value Field
  • Refresh a Table
  • Update Pivot with Additional Rows
  • Filter a field
  • Clear All Filters
  • Refresh All Workbooks
  • TabularForm
  • Mini Project using PivotTable – Create Dashboard which update all information just click of a button
6. VBA - Workbook and Worksheet specific Macro
  • Run Macro before Workbook close
  • Run Macro before WorkbookSave
  • Run Macro when WorkbookDeactivate
  • Run Macro when add new Sheet in Workbook
  • Run Macro when WorkbookOpen
  • Run Macro whenWorkbook Activate
  • Run Macro whenWorksheet_Activate
  • Run Macro whenWorksheet_BeforeDoubleClick
  • Run Macro whenWorksheet_BeforeRightClick
  • Run Macro whenWorksheet_Calculate
  • Run Macro whenWorksheet_Change
  • Run Macro whenWorksheet_Deactivate
  • Run Macro whenWorksheet_FollowHyperlink
  • Run Macro whenWorksheet_SelectionChange
  • Mini Project using Workbook & Worksheet Macro
7. VBA - Create your Own Formulas and Functions using Macro
  • Basic and Advanced IF conditions
  • Advanced Conditional formula using Select Case
  • Create Formulas/Function (COUNTALL, COUNTNUMBERS, COUNTTEXT, COUNTBLANKS, SUM, SUMIF)
  • Mini Projects using VBA Functions - Create Formula to calculate Tax with Various rules
8. VBA Excel Options
  • Filter
  • Remove Filter
  • Filter Single Criteria in Single Field
  • Filter Double Criteria in Single Field - Or
  • Filter Double Criteria in Single Field - And
  • Filter Multiple Criteria in Single Field
  • Filter Single Criteria in Multiple Field
  • Filter Multiple Criteria in Multiple Field
  • Filter Multiple Criteria in Multiple Field and Copy Paste
  • Filter Multiple Criteria in Multiple Field and Delete
  • Advance Filter
  • Sort
  • Data Projection
  • Define Name
  • Data Formatting (Color, Border, Font, Full Screen etc.)
  • Mini Projects using Excel Options - Filter Multiple Criteria Data and Paste it in New sheets

 

Our session will not just stop with teaching you the above options, we go beyond to make you an expert in using the various options in real time scenario

Below are our VBA Macro Training Batches across India:

  • VBA Macro Online Training
  • VBA Macro Training in India
  • VBA Macro Training in Chennai
  • VBA Macro Training in Bangalore
  • VBA Macro Training in Hyderabad
  • VBA Macro Training in Delhi
  • VBA Macro Training in Mumbai