Advance Excel and MIS Training

17/04/2013 Professional & Short Term Course

Price: Free

Description

Advance Excel and MIS Training


 


ADVANCE TRAINING ON EXCEL, ACCESS AND MIS


 Turning Motivated Individuals into Office Superstars


 4 days training for working professionals


 Management information systems involve three primary resources: people, technology, and information or decision making. Management information systems are distinct from other information systems in that they are used to analyze operational activities in the organization. This seminar is designed in such a way that the people from the relevant field can have insight about the tools and techniques to develop a customizable MIS system. 



Target Audience:  


MS Office Specialist, MIS Personals, VBA Programmer, Accounts Personal, Project Managers, Developers, Technical/ Test Leads, Program Managers, Project Managers, Research Workers, Freelancers, Data analysis departments



 At the end of training, participants will be able to know:


 



  • Various MIS technique with the help of Excel VBA Programming

  • Get an overview of different Analytical Process

  • Data handling with the help of Access

  • Reporting and Formatting by different angles

  • VBA Programming (Concepts and Techniques) 


    • Macro generation and application design 


  • Writing customize queries as per the need

  • Fundamentals of data handling, MIS, EXCEL and Access.


 


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

 



Time: 10:30 AM to 05:30 PM


Venue :



ACLM Institute of Professional Studies


169, Gyan Khand-IV, IndirapuramGhaziabad-201014


Fee Details:



Rs. 5,000=00 + 12.36% Service Tax per participants (includes Lunch, Tea / Coffee)



 



  • Registration is first come first serve basis.

  • Sponsorship Option Available


 


Payment Options:


Through Cheque / Demand Draft to the name of "ACLM Institute of Professional Studies " payable at New Delhi only.


 


 


 


 



Contact details:


 


 

ACLM 


9971554606, 01206512820


169, Gyan Khand-IV, Indirapuram, Ghaziabad


 

More Details

Total Views:10
Reference Id:#207619
Phone Number:9971554606, 01206512820
Current Rating: /5 0 Vote
Copyright © 2019 |   All Rights Reserved |   tuffclassified.com |   24x7 support |   Email us : info[at]tuffclassified.com