loading......

Where do you need ?

location

Please select a Location.

Enquire

Submit your enquiry for Advance Excel, VBA and MIS Training

Please enter valid question or comment

Please select a category

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With AISECT STUDIES

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer

Share

Advance Excel, VBA and MIS Training

Advance Excel, VBA and MIS Training

Okhla, Delhi

5,000

No Reviews Yet
0 Interested

About the Course


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.

Topics Covered

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

Who should attend

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

Pre-requisites

Knowledge of basic excel is mandatory.

What you need to bring

notepad, pens, pencils

Key Takeaways

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.
Reviews
There are no Reviews yet. Be the First to Review
Questions and Comments

Thousands of experts Tutors, Trainers & other Professionals are available to answer your questions

Comment ?

Questions Guidelines

  • Start your question with simple statements like "what", "when", "where", or "how".
  • Ensure your question or answer is not offensive or insensitive - it may be voted down or banned.
  • Please provide as much detail as possible as this will allow our members to better understand and respond to your question.
  • Take some time to categorize your question. This will greatly help other users find the question.


You can add upto 6 Images

Ask


There are no Reviews yet. Be the First to Review

Date and Time

Not decided yet.

About the Trainer

Shadab Akhtar picture

Shadab Akhtar

MCA, Oracle Certified Programmer, VBA Programmer, MIS Team Leader


Working with renowned MNC as a Senior Data Analyst having 8+ Years of experience in data analysis and MIS handling.
Seats Left-

Students Interested 0

Course Id: 5255