Advance Training On Excel, Access And Mis - CiteHR
Cite.Co is a repository of information created by your industry peers and experienced seniors sharing their experience and insights.
Join Us and help by adding your inputs. Contributions From Other Members Follow Below...
ADVANCE TRAINING ON EXCEL, ACCESS AND MIS

Turning Motivated Individuals into Office Superstars



4 days training for working professionals - Training will be on Sunday Only.

Date of Start: 2nd December, 2012, End Date: 23rd December, 2012

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

>> 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

Venue:

169, Gyan Khand-IV, Indirapuram, Ghaziabad-201014

Timing: 10:30 AM to 05:30 PM

Certificate of Participation will be provided at the end of the training.

Dear Sir / Madam, Is it possible to arrange such kind of training at Ahmedabad Location. Warm Regards Jignesh Patel. +91-9909027365
Dear Mr. Jignesh, Greetings! If it is a corporate training then it is possible at your location. Please confirm me at 09971554606. Regards, Amit.
This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network.
Add the url of this thread if you want to cite this discussion.






About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2020 Cite.Co™