"Advance Excel, VBA and MIS Training" is no longer available

No Reviews Yet

Okhla, Delhi

Course ID: 5255

Okhla, Delhi

No Reviews Yet

Date and Time

Not decided yet.

Shadab Akhtar picture
Shadab Akhtar

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

About Shadab Akhtar

Working with renowned MNC as a Senior Data Analyst having 8+ Years of experience in data analysis and MIS handling.
No reviews currently Be the First to Review

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

No reviews currently Be the First to Review

Discussions

Post your requirement and let us connect you with best possible matches for Computer Software Classes Post your requirement now

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more