AISECT
1

Hands on Training on Advance Excel, VBA and MIS



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.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.