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
Also provide session on powerpoint word. 23 Aug
I am advance excel user and VBA developer and working from last 18 years and developed many real life problem solving macros. Giving Excel Training to My Colleagues in my Office from basic to advance including VBA. Customized Training as per your requirement. price negotiable . will also provide learning material in soft free of cost.
In Basic/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)
----------------------