theguidance

2days workshop.

Learn the best from the city's best.

We teach from experience.Is not just to teach, our objective is to have knowledge

implemented.

To help you work faster and smarter.It is excellent opportunity for professionals from all fields to get trained in all specialized tools of Excel.



Who should attend?

BPO Employee

Business person

Management Professional dealing with Data

MIS personnel

Commerce field, Would be C.A.

Sales/HR.





Workshop Topics:



Day 1



> 1. Introduction on usage of Advance Excel Techniques

> 2. Formulas Basic and Advance (40+ formulas)

> 3. Formula Auditing/Type of Errors

> 4. Data Validation

> 5. Data Import

> 6. Text to Columns

> 7. Conditional Formatting

> 8. Advance Filter

> 9. Subtotal

> 10. Name Manager

> 11. Pivot Table

> 12. Pivot Charts

> 13. Charts

> 14. Table



Day 2



> 1. Introduction to VB

> 2. Introduction to VBA

> 3. Introduction to Macro

> 4. Introduction to VBA Editor

> 5. Introduction to Routines

> 6. User Defined Functions

> 7. Data Types, Variables and Constants

> 8. Control Structures

> 9. Object Model

> 10. Excel Objects and Collections

> 11. Logic Development (Algorithms and Flowcharts)

> 12. Exercises



Hurry to enroll as you may miss the oppourtunity.