2 
IdentityWant to learn VBA with Excel including advance excel solutions with your own business problems?
I can make you VBA programmer using your own day today business problems.
Can also help in developing access database solutions using access VBA with forms, linked tables , reports etc.
I am excel VBA developer and working from last 18 yes and developed many real life problem solving macros. I can be useful in giving training to working professionals as my examples will be more related to their actual work/business.
In Advance Excel Following Topics will be covered,
Absolute Referencing & Relative Referencing
Formatting Cells & Numbers
Using Cell / Range Names , constants
Referencing from Other Sheets / Workbooks
Using IF functions and nested IF functions to evaluate Logical Expressions
Working with Lists in Excel (PivotTable, datavalidation, forms, Vlookup, Countifs, sumifs, match, index.....
Connecting to MS Access Database Tables
Data Lookup Functions
Inserting Drawing Shapes
Use charts to visually represent your data
Conditional Formatting
Format your data for viewing and printing,
Header & Footers, etc.
Logical Functions
ISNA, AND, OR, ISERROR, ISNUMERIC, etc.
Text Functions
MID, SUBSTITUTE, FIND, LEN, STR, CONCATENATE
CAMERA TOOL
PROTECTING YOUR DATA / WORKBOOK
MACROS (OVERVIEW / BASIC)
In VBA/MACO Training following will be covered
Working with Visual Basic Editor
What is VBA (Terminologies)
Working with Cells & Ranges Worksheets & Workbooks in VBA
Working with Worksheet Functions from VBA
Variables
Introduction to Programming Constructs (Decision/Loop)
Creating & Using User Defined Functions
Interacting using Forms
More Form Controls on Excel User Forms
Debugging your Code
Macro Security
