1. ADVANCEL EXCEL TRAINING topics includes: A. Advanced data analysis using Excel: Goal Seek, Solver function, Pivot tables & reports, Data tables & scenarios. B. Data Management using Excel: Sorting, Data sub totaling, Filtering data, Grouping & outlining data, Data validation, Data consolidation, Formatting & Conditional formatting. C. Advance functions in Excel: Mathematical functions, Look up functions, Text functions & Data base functions, General Functions. Duration: 20 Hours (Weekdays & Weekends classes conducted) 2. VBA & MACROS Training topics includes: Primer in Excel VBA, Work book & Work sheets, Using Names, Pivot table, Data lists, Charts, User form, Ribbon X, Data access with ADO & Programming the VBE. Duration: 30 Hours (Weekdays & Weekends classes conducted) 3. SQL SERVER topics include: Introduction, Working with tables, joins, dealing with nulls, Triggers & Cursors. Duration: 30 Hours (Weekdays & Weekends classes conducted)

Topics Covered

1. ADVANCEL EXCEL TRAINING topics includes: A. Advanced data analysis using Excel: Goal Seek, Solver function, Pivot tables & reports, Data tables & scenarios. B. Data Management using Excel: Sorting, Data sub totaling, Filtering data, Grouping & outlining data, Data validation, Data consolidation, Formatting & Conditional formatting. C. Advance functions in Excel: Mathematical functions, Look up functions, Text functions & Data base functions, General Functions. Duration: 20 Hours (Weekdays & Weekends classes conducted) 2. VBA & MACROS Training topics includes: Primer in Excel VBA, Work book & Work sheets, Using Names, Pivot table, Data lists, Charts, User form, Ribbon X, Data access with ADO & Programming the VBE. Duration: 30 Hours (Weekdays & Weekends classes conducted) 3. SQL SERVER topics include: Introduction, Working with tables, joins, dealing with nulls, Triggers & Cursors. Duration: 30 Hours (Weekdays & Weekends classes conducted)