VBA Macro Programming & Automation

• Macro Recording and Running
• Programming Concept
• Developer Tab and Menu
• Recording a Macro
• Saving Macro in Different Workbooks
• Various Methods of Running a Macro
• Command Button
• Design Mode
• Running Mode & Break Mode
• Modules and Procedures
• Absolute and Relative Reference

Introduction to Visual:-

• Basic Editor
• Project Explorer and Code Window
• Modules
• Functions and Subroutines
• Worksheet Properties in Property Window

Programming Basic

• Public and Private Subroutines
• Object
• Methods and Properties
• Object Hierarchy & Collection
• Creating a Folder/Subfolder
• Opening , Saving, Closing New Workbook
• Opening a saved Workbook
• Selecting/Activating/Renaming/Adding Sheets
• Range, Cells, Columns & Row Properties
• Writing a Simple Code in VBA

Variables and Data Types

• VBA Data Types
• Variables and Constants
• Numeric and String Types
• String and Date
• Boolean, Long, Integer, Byte, Double, Single, Currency
• Working with Arrays
• Working with Arrays
• Single line Decision
• Nested Line Decisions
• Single Line Case
• Nested Line Case
• IIF, If and Then Statements
• IIF, If and Then Statements
• Looping -
• DoLoop, For Next Loop , For Each Loop
• Data Compilation
• Conditional Data Compilation
• Conditional Sheet Add
• Looping through Object
• Looping Sheet
• Looping Workbook
• Looping file & Folders
• While Wend Loop
• Do Until Loop
• Some Useful Formula Using Loop

Dialog Boxes and User Form

• Massage Box
• Input Box
• Using Loop in Input Box 
• Selecting User defined range in Input box

• Creating a User Form
• Label, Text Box, Combo Box, List Box
• Check Box  Option Button
• Spin Button, Command Button
• Frame

Using Excel Application and Function

• Sorting and Filtering Data Using VBA
• Creating Pivot Table Using VBA
• Text to Column
• Remove Duplicate
• Formatting
• Protecting/Unprotecting a Sheet Using VBA
• Using Excel Formulas like V-lookup
• H-lookup and other functions in VBA
• Import Text/CSV files using VBA 

Outlook & PPT Automation

• Connecting with Microsoft Outlook
• Creating Outlook New Session
• Early Binding and Late Binding
• Formatting HTML and Plain/Rich Text Body
• To, CC, BCC, Subject ,Body Text & Signature
• Attach a file in Email using VBA
• A Simple Programme of Email
• Automate Multiple Mails