1Hands on Training on Advance Excel, VBA and MIS
Starting On: 20th January, 2013.
Starting On: 20th January, 2013.
330 Professionals from different companies got trained in 2012. 4 Days Customized Training (Weekends Classes Only).
Course Contents:
Day 1 & 2 : (Main Focus EXCEL)
Focus on real scenarios of Reporting / Data Management / Automation
- Difference between basic and advance Excel
- Advance Formulas
- Data Management and Analysis
- Reporting Techniques
- Pivot Table, Macros
- Concepts of VBA
- Excel Data Handling with VBA
- Use of SQL Queries
- User Form, List Box, Combo Box, Buttons etc.
- Application Design
Day 3 & 4: (MAIN Focus ACCESS)
- Database, Tables, Fields and Properties
- SQL Queries, Reports and Data Management
- VBA Programming and Data Management
- Forms, Reports & Application Design
Target Audience:
MS Office Specialist, Technical/ Test Leads, Program Managers, Project Managers, Research Workers, Freelancers, Data analysts, MIS Personals, VBA Programmer, Accounts Personal, Project Managers, Developers.
At the end of training, participants have:
>> Mini Project using VBA
>> Macro Generation Techniques
>> Reporting Capabilities
>> Handling Different kinds of data
Venue: ACLM Institute of Professional Studies
Plot No. 169, Gyan Khand-IV, Indirapuram, Ghaziabad-201014
For registration kindly contact us at 9971554606 or drop a mail at:
From India, Ghaziabad
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
Advance Excel.xls
Healthy Office Ergonomics Workshop.doc
Advanced Excel 2003.pdf