loading......

coming soon

Coming Soon

We are in process of building the inventory of good professionals in this category

Got it!

Where do you need ?

location

Please select a Location.

Enquire

Submit your enquiry for Industry Level MIS Training

Please enter valid question or comment

Please enter your name.

Please enter valid email

Please enter valid Phone Number

Please enter the Pin Code.

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

Connect With Vivekananda

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

Industry Level MIS Training

Industry Level MIS Training

Ghaziabad, Delhi

8,000

21 Reviews
0 Interested

About the Course


The training will covere all the aspects of core MIS at corporate level. It includes the two modules:

1 - Expertising Microsoft Excel
2 - Excel Macro Programming using VBA

Topics Covered

MODULE 1 - Expertising Microsoft Excel



Overview of basic Excel skills
Basic Short Keys
Basic Functions
Worksheet Operations
Format Cells
Cell Operation
Freeze Panes
Techniques of Paste Special
Protect Worksheets & Workbooks

Time Saving Utilities
Format Painter
Text to Columns with fixed and delimited parameters
Data Sorting using custom list
Summarizing data using Group and Outline

Concept of Cell Referencing
Relative Referencing
Absolute Referencing
Mixed Referencing


Important Functions in Excel
AND
OR
NOT
COUNT
COUNTA
COUNTBLANK
COUNTIF
MAX
MIN
UPPER
LOWER
PROPER
RIGHT
LEFT
MID
POWER
SUM
SUMIF
AVERAGE
EXACT
CONCATENATE
LEN
NETWORKDAYS
IS FUNCTIONS
MATCH
INDEX
IF
VLOOKUP – 1D
VLOOKUP – 2D
Reverse VLOOKUP
HLOOKUP
LARGE
SMALL
SUBTOTAL
SUMPRODUCT
OFFSET
NESTED FUNCTIONS


Name Manager
Defining Static and Dynamic List using names
Use of Names in Advance Reports

Conditional Formatting
Conditional Formatting using Formulas & cell values
Highlighting Duplicates
Calculation based Conditional Formatting

Data Validation
Different Data validation in Excel
Using Dynamic list in validation

Charts in Excel
Elements of Charts
Major charts used in Excel
Creating Dynamic Charts

Pivot Table
Pivot Table creating Methods
Rearranging a Pivot Table
Filtering Pivot Table Data
Performing Custom Calculation
Creating Dynamic Dashboards using pivot charts and Slicer
Consolidating Data from external source or multiple files in less than a minute
Creating Pivot Tables through Database Connections

Array Functions for quick conditional calculations

Data Filter
Normal Data Filter
Advance Filter
Calculation based filter
Filter using wild cards

Summarizing data using Subtotal

Data Consolidation
Consolidation by categories
Consolidation using 3D Formulas

Analyzing data with What-If Analysis
Determine unknown with Goal Seek
Analyze data with Data Table
Enable decision making using Solver
View results with Scenario Manager

Sparklines for Data trends

Use of Form controls for creating Dynamic Reports and Dashboards

Discussion on 7 Quality Control (QC) Tools
Ishikawa or Fishbone chart
Check Sheet
Control Charts
Histogram
Pareto Analysis
Scatter Diagram
Stratification

Error handling Tips and Tricks




MODULE 2 - Excel Macro Programming using VBA


Introduction to Visual Basic

Object Orient Programming concepts and Illustration

Excel Object Model

VBA Data Types

Operators
Arithmetic Operators
Comparison Operators
Logical Operators
Concatenation Operator

Basic Excel Operations

Dialogs in VBA screen

Defining Constants

Defining Variables
Defining Global Variables
Defining Static Variables

Working with Functions
Creating Functions using Optional Arguments
Creating Private Functions
Creating Public Functions

Working with Subroutines
Creating Functions using Arguments
Creating Functions using optional Arguments
Creating Private Subroutines
Creating Public Subroutines

Handling errors

Working with Message Box

Decision Statements

Looping Statements

Working with User Forms

Developing different Consolidation Tools using VBA programming

Working with system Registry

Database Connectivity using VBA
Introduction to SQL Server
Making connections in SQL Server through VBA
Concept of Recordset
Retrieving records from database
Updating records to database
Adding records to database
Deleting records from database

Creating Excel based application

Creating Time saving tools

Creating Plug-Ins

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, HR Managers, Students

Pre-requisites

Basic understanding of Microsoft Excel

What you need to bring

Notebook
Pen

Key Takeaways

Understanding importance of Management Information System at corporate environment.

Perform Data Analysis on key performance indicators to drive performance and operational excellence to exceed the goals.

Proactively monitor Performance Dashboards to determine key areas of focus and to identify root causes and potential corrective Actions.

Develop and provide Trend Data and Analysis on key performance indicators as required.

Track, monitor and report out on all Service Delivery and Quality Improvement Plans.

Develop Automated Dashboard.

Prepare Annual Reports in less than a minute.

Analyze data and enhance Decision Making to generate new business opportunities.

Analyze Trends and increase the accuracy of forecasting.

Develops simple-to-complex models for measuring performance using VBA Automation.

Designing and set up new Automated Reporting Systems to monitor the productivity, quality of the employees.

Develop Excel based high quality Applications.

Develop Time saving Utilities.
Gallery
Reviews

Prashant Verma

"It’s a pleasure in writing and sharing my success story as there has been many hiccups in my career starting from the day I stepped into this corporate world and later on some great learning experience with a supportive hand from my Mentor Vivek Sir who has guided me into a right direction. It all started when I wanted a spark in my career as I switched my job profile from Call Centre Executive to a MIS Executive. Initially I took help from Google and YouTube and learnt certain basic fundamentals of Excel and its uses. However I knew that things were not going the way I wanted as I joined my current company Virtual Employee as Administrative Assistant which required a great knowledge of Microsoft Excel, Microsoft Word and other corporate learning. Then I came to know about Future in Hands and the best trainer (Vivekananda Sinha) in NCR from Ankit Saxena, one of the alumni of FIH who himself has a great success story and that influenced me to join FIH and Vivek Sir. Thus, after a successful training sessions on Advance Excel, I enrolled and completed Productivity Enhancement session, Dashboards, Excel Power Tools (best in class), VBA and SQL training. All this resulted in direct positive impact on my career and get promoted as Business Analyst and now as Sr. Business Analyst II within three years of completion. I’ll always be thankful to Vivek Sir for being a great mentor, soft spoken, disciplined and passing the zeal of never stop learning new things in life. "

attended Industry Level MIS Training


Rakesh Sharma

"The training i attended was the best training of my life. So much of practical exposure I never had. I gain confident on Analytical skills. The best part of the training is the Brainstorming Microsoft Excel Tool that covers 100+ very very complex interview question which is not provided by any training institutes. The recommend Mr. Vivekananda the best Mentor for Reporting & Analysis and the Future in Hands the best center for future growth. Thanks for everything, I learnt from here. "

attended Industry Level MIS Training


Lokesh Sharma

"It was a great experience with FIH. Vivekananda Sir is one of the best faculty in Delhi for VBA, Excel, SQL and SAS. I learnt VBA and EXCEL from this institution and got a higher position in Accenture. Thanks to Vivek Sir for his unique way of teaching that helped in building my career. "

attended Industry Level MIS Training


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


Recommendations & reviews from previous Customers:

Prashant Verma

"It’s a pleasure in writing and sharing my success story as there has been many hiccups in my career starting from the day I stepped into this corporate world and later on some great learning experience with a supportive hand from my Mentor Vivek Sir who has guided me into a right direction. It all started when I wanted a spark in my career as I switched my job profile from Call Centre Executive to a MIS Executive. Initially I took help from Google and YouTube and learnt certain basic fundamentals of Excel and its uses. However I knew that things were not going the way I wanted as I joined my current company Virtual Employee as Administrative Assistant which required a great knowledge of Microsoft Excel, Microsoft Word and other corporate learning. Then I came to know about Future in Hands and the best trainer (Vivekananda Sinha) in NCR from Ankit Saxena, one of the alumni of FIH who himself has a great success story and that influenced me to join FIH and Vivek Sir. Thus, after a successful training sessions on Advance Excel, I enrolled and completed Productivity Enhancement session, Dashboards, Excel Power Tools (best in class), VBA and SQL training. All this resulted in direct positive impact on my career and get promoted as Business Analyst and now as Sr. Business Analyst II within three years of completion. I’ll always be thankful to Vivek Sir for being a great mentor, soft spoken, disciplined and passing the zeal of never stop learning new things in life. "

attended Industry Level MIS Training


Rakesh Sharma

"The training i attended was the best training of my life. So much of practical exposure I never had. I gain confident on Analytical skills. The best part of the training is the Brainstorming Microsoft Excel Tool that covers 100+ very very complex interview question which is not provided by any training institutes. The recommend Mr. Vivekananda the best Mentor for Reporting & Analysis and the Future in Hands the best center for future growth. Thanks for everything, I learnt from here. "

attended Industry Level MIS Training


Lokesh Sharma

"It was a great experience with FIH. Vivekananda Sir is one of the best faculty in Delhi for VBA, Excel, SQL and SAS. I learnt VBA and EXCEL from this institution and got a higher position in Accenture. Thanks to Vivek Sir for his unique way of teaching that helped in building my career. "

attended Industry Level MIS Training


Satendra Kumar

"Words cannot express Enormity of Mr. Vivek. He is one of the best Teacher/instructor or career path maker with his well-informed Teaching about excel/VBA & All I ever had. I would recommend FIH for best Learning Centre in Delhi-NCR. Today whatever I have got because of him, which I never thought in my Dreams as well. From bottom to top. "

attended Industry Level MIS Training


Satya Prakash Pandey

"Here I am speechless to say about my best teacher of my life. I studied many institutions like NIIT and other institutions for technical knowledge, but the knowledge, the path, the guidance I obtained by Vivek Sir; I do not say “Future in Hands” is an Institution. Actually FIH is an NGO where peoples do not need to worry about their future. I was nothing when I joined FIH. But now I am something. And if I am something, the complete credit goes to Vivek Sir. Only due to Vivek Sir I am in Airtel. Thanks Sir. Thanks FIH. Will be grateful to you. "

attended Industry Level MIS Training


Satya Prakssh Pandey

"Here I am speechless to say about my best teacher of my life. I studied many institutions like NIIT and other institutions for technical knowledge, but the knowledge, the path, the guidance I obtained by Vivek Sir; I do not say “Future in Hands” is an Institution. Actually FIH is an NGO where peoples do not need to worry about their future. I was nothing when I joined FIH. But now I am something. And if I am something, the complete credit goes to Vivek Sir. Only due to Vivek Sir I am in Airtel. Thanks Sir. Thanks FIH. Will be grateful to you. "

attended Industry Level MIS Training


Uday Thakur

"I am surprised, having seen Mr. Vivekananda Sinha because his art of teaching can not be defined. I am so satisfied by joining him. Before join him, I went in several institute but I could not find out such an art of teaching. I want to say something about Mr. Vivekananda Sinha, "He not only delivers the best quality but also he helps all the students for making the best career" So, I am really very grateful of Mr. Vivekananda Sinha for giving the best quality as well as the best career. Thanks a lot to Mr. Vivekananda Sinha. "

attended Industry Level MIS Training


Ragini Singh Chauhan

"Mr. Vivekananda Sinha is an awesome trainer in Delhi NCR. The pedagogy of Mr. Vivekananda Sinha is outstanding and he caters the best career. His motive is not provided a job, his motive is provided a career. I am really very thankful of Mr. Vivekananda Sinha for giving me the best career. Thanks a lot to Mr. Vivekananda Sinha from core of my heart. "

attended Industry Level MIS Training


Bivay Kumar

"I have no word to explain to Mr. Vivekananda Sinha. He is an outstanding trainer in Delhe NCR. "Just as a drop of water helps to live at the time of thirst, in the same way Mr. Vivekananda Sinha helps us in making of wonderful career at the time of spread career." His motive is not provided a job, his motive is provided a career. I am really very thankful of Mr. Vivekananda Sinha for giving me the best career. Thanks a lot to Mr. Vivekananda Sinha from core of my heart. "

attended Industry Level MIS Training


Bivay Kumar

"I have no word to explain to Mr. Vivekananda Sinha. He is an outstanding trainer in Delhe NCR. "Just as a drop of water helps to live at the time of thirst, in the same way Mr. Vivekananda Sinha helps us in making of wonderful career at the time of spread career." His motive is not provided a job, his motive is provided a career. I am really very thankful of Mr. Vivekananda Sinha for giving me the best career. Thanks a lot to Mr. Vivekananda Sinha from core of my heart. "

attended Industry Level MIS Training


Bivay Kumar

"I have no word to explain Mr. Vivekananda Sinha. He is Outstanding Trainer in Delhi NCR. "Just as a drop of water is necessary to live at the time of thirst, in the same way he always helps his students at the time of their tough hours" His motive is not provided a good job, his motive is provided a good career. Thanks a lot to Mr. Vivekananda Sinha from core of my heart to light the career of my spread life. "

attended Industry Level MIS Training


Alok Kumar Srivastava

"Vivek Sir is one of the best trainer in NCR. "

attended Industry Level MIS Training


Amit Makhija

"Sir is so helpful, always try to motivate you and always ready to help you in any condition. thank u sir that i gain so much from future in hands. "

attended Industry Level MIS Training


Sujeet Singh

"This is an amazing class. I def was not expecting the instructor, Sir, to be so awesome. He is super well versed with Excel, a fantastic teacher. we learned awesome tips and techniques about how to most efficiently use Excel. It's amazing how much time many of us waste doing things manually. I never realized how simple it is to use the methods/shortcuts that vivek sir teaches.Vivek sir's style of teaching is to keep drilling a concept over and over until it sticks. He is a very good teacher and technical mentor for excel and vba programming,his class tutorial is well organised to understand basics as well as advance excel and vba programming.Every class we are getting the video of tutorial which helps later to understand the missing things.The most important thing is that we can clear our doubts any time at cell phone or chatting. I am very happy to took this class. Compared to what else is out there..... "

attended Industry Level MIS Training


Ankit Saxena

"The way he teach is best amongst all and he have all the good qualities and skills needed in a trainer. He focus on every individual student and clear every doubts. So far I can say he is master on excel and vba. I highly recommend him as trainer for all the courses he is providing and can guarantee that after course you will post same things as I did for him. "

attended Industry Level MIS Training


Devendra Nautiyal

"really feeling honoured while giving recommendation , as vivek sir....the way u teach and approach every student queries quiet majestic and brilliant.The main highlight of the session are tricky assignments that you used to give after every class and believe me it takes a toll to do those brain storming assignments. "

attended Industry Level MIS Training


Manjeet

"He is awesome in Excel & VBA with a simple and the best teaching method. He is the only person who made me to believe MIS is an awesome profile to choose. "

attended Industry Level MIS Training


Rohit Diwakar

"thanks to you sir......for so much of learning. guys if you are looking for specialized training and expertising excels and VBA skills then this would be the end of your search. vivek sir , provides all study materials with tricky assignments. the best part of his sessions are personalised attention to each and every student as the batch size is very small with reasonable fees structure that too in installments."

attended Industry Level MIS Training


DevInder Tewatia

"According to me, this is right place to get the knowledge about excel/ VBA /others. And as concerned about Teacher," explain each & every point very clear". Thanks to Vivekanand !!"

attended Industry Level MIS Training


Avinash Rai

"Hello Sir, It was pleaasure being your student and having your guidance on MIS. This was really beneficial training for me, now i have been able to analyze data from various angle and can make dashboards. It has saved my effort at large by scrapping manual effort by using formulaes. I would also request you to please start classes for complete MS-Office package."

attended Industry Level MIS Training


Vibhor Rawat

"Consummate skills of trainer make tough things very easy. Trainer covers all part of excel from root level to complex level like macros and decision enabling data analysis tools. Fee is affordable too.I must recommend everyone to go and learn excel in a way you never knew before."

attended Industry Level MIS Training


Date and Time

Not decided yet.

About the Trainer

Vivekananda Sinha picture

Vivekananda Sinha

Certified Microsoft Office Specialist


8 Years industrial experience in core MIS.

Trained Executives, Engineers, Managers, Students.

Received MICROSOFT OFFICE SPECIALIST title from Microsoft Corporation.

Awarded several times as Best Trainer at corporate level for receiving excellent feedback for trainings on Advance Excel, Statistical Analysis using Excel, VBA Macros and Microsoft Productivity Tools.

Developed Global Content Repository System, a 20,000 USD project developed in VBA for an IT company in South America. Received excellent customer feedback for the application.

Been as a Project Guide on Construction Site Layout Planning System, a VBA project initiated by group of Civil Engineers of Indian Institute of Technology, New Delhi. This project emphasizes on the planning of different facilities of a site in an optimized way. This is a generic-algorithm based model for site layout planning.

Developed and Implemented Utilities for Excel, a multi functionality tool that helped in saving lots of time for the Excel users. It covers the functionalities such as Sending Mails, Format Cells, Workbook Management, Workbook Library, Text Operations, Arithmetic Operations, Color Themes and Printing.

Developed various Consolidation Tools using VBA that helped in the reduction of 99% of the time taken in manual consolidation of Reports. It proved great at the time of Yearly Baseline Analysis.

Developed and Implemented Awareness Evaluation System, a VBA project to check the skills of the internal employees in different domains. This project includes SQL Server 2005 for storing questions, scores, user information and other details of the application. Login is based on windows Authentication.

Developed a Solution for Human Resource to taken user inputs in email. The data received are automatically saved to central database.

Developed Document Management System Plug-In for Microsoft Excel. This is a VBA Application that facilitates the users, to have documents easily available without wasting their time and efforts in searching them in the drive.
Seats Left-

Students Interested 0

Course Id: 7267