Introduction To Macro
What is Macro?
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
Writing Formulas in Macro
Using Formula defined in Macro
Date & Time Functions
Introduction to Form X and Active X Controls
Working with Errors
Introduction to Userforms
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
SQL & Access
Working with SQL & Access
Understanding of the Queries
Various Kind of Joins
SQL & Access Continue
How to work with Excel
Working with Pivot Tables`
Working with Charts
Start with SQL:
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.
- Experience in Data Anaylitics
- More than 5 years of industry experience.
- Analytical Skills
- Expert in Macros Development