Start With VBA Macro Programming

Microsoft-VBA-Large

 

 

Macros

Introduction To Macro

What is Macro?
Declartions/Data Types
What are references?
Options Explicit Recording a Macro?
Introduction to Windows
Viewing and editing VBA code
Understanding How it Works?
Finding the Last row or Last Col
How to define range
Playing with Ranges
Msgbox
Inputbox
Writing Formulas in Macro
Using Formula defined in Macro
Evaluate Method
IF/ENDIF
Case
With
Instr
Dateadd
Datepart
Datedif
Mod Operator
Date & Time Functions
Understanding Loops
For Loop  
Do Loop
Introduction to Form X and Active X Controls
Working with Errors
Resume Statements
Introduction to Userforms
Change Events
How to work with Them?
Open Dialog,Save As
Introduction to Customised Functions
Sending Email from Excel
Consolidating Multiple Workbooks in One
Rename & Moving Files
Opening Internet & IQY Method
Send Keys
SQL & Access

Working with SQL & Access
Understanding of the Queries
Various Kind of Joins
SQL & Access Continue
How to work with Excel  

Macros

Working with Pivot Tables`
Working with Charts
Split
Understanding Arrays

MS Access.

Start with SQL:

SQL Statements
Create DB
DDL ( Data Definition Language) – CREATE, ALTER, DROP statements
DML (Data Manipulation Language) – SELECT, UPDATE, INSERT statements
DCL (Data Control Language) – GRANT, REVOKE statements
TCL (Transaction Control Language) – COMMIT, ROLLBACK statements

Data manipulation and extraction
Select statement– select, select distinct
Column and Table Aliases
Sorting Data – order by
Filtering Data – WHERE Clause
Grouping data – Using the GROUP BY Clause , Filtering Groups with HAVING
Aggregate Functions – count() ,sum() ,avg() ,min() , max() , first(), last()
Not null, unique, foreign key.

SQL with Joins and Functions:

Joins and Functions
Joins – Inner Joins ,Outer Joins , Left joins, Right joins, Cross Joins and Self Joins .
Set Operators – UNION,EXCEPT, INTERSECT ,APPLY
Functions – String Functions, Math Functions, Date Functions, Conversion Functions

Interacting with Other Office Applications Like MSAccess andOutlook (Mail Merge):

Establishing the Connection, Late Binding, Early Binding .
Interacting with Outlook:Drafting and sending mails via Outlook, Adding the recipients’ mail address and subject lines, Adding ranges, charts, tables, text in the mail body, Adding attachments.
Data Access with ADO Connectivity with Access and SQL: An Overview of ADO, The Connection Object, The Recordset Object, The Command Object, Using ADO in Microsoft Excel Applications, Using ADO with Microsoft Access, Using ADO with Microsoft SQL Server, Using ADO with Non-Standard Data Sources.

Our Faculty:

  • Experience in Data Anaylitics
  • More than 5 years of industry experience.
  • Analytical Skills
  • Expert in Macros Development