Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.


Industry Level MIS Training

37 Reviews

Ghaziabad, Delhi

Course ID: 7267

Ghaziabad, Delhi

Students Interested 0 (Seats Left 0)

₹ 8,000

The Educationalist

37 Reviews

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

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
Pareto Analysis
Scatter Diagram

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

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


Basic understanding of Microsoft Excel

What you need to bring


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.

Date and Time

Not decided yet.

Gallery (5)

About the Trainer

Vivekananda Sinha picture

5 Avg Rating

56 Reviews

68 Students

9 Courses

Vivekananda Sinha

Certified Microsoft Office Specialist

10 Years of Experience

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.

Student Feedback


Average Rating




Manish Kumar

I recently cracked my IJP after upgrading myself to VBA Programming. I joined Vivek sir 5 months back. The in-depth course content with the expertise of Vivek sir was a great combination. He has a great variety of industry examples. He is really a great mentor. His students are star performer. I am lucky to attached with him. He is truly the best trainer around. I enrolled for the next level.


Sachin Kant

Vivekananda Sir is a person with whom you can achieve yours big dreams and got depth knowledge" I had known about Mr. Vivek Sir from year-2014 by my friend Depak. We both are working in same company "Data Flow" and searching MIS training Institute but they had joined to Vivekananda Sir, but that time i was making my career in Web Designing but till now i am also part of crowd with low salary but my friend is now working with good company on high salary, Then will decided to change my career career path. I have decided to join Sir. Sir enrolled me in MIS batch on February-2017. I had joined as I had trust on Vivek Sir that he will be supporting me in any way. I did not know about Excel. I feared but he gave me friendly environment. I really appreciate that you are always so friendly and supportive in all way. I feel free and comfortable to talk to you. I really appreciate your teaching ways. Learning from you are very enjoyable. Your explanation way is very unique. I have also enrolled for other sessions conducted by him.


Vijay Kumar

Vivek sir you are the only one who made me crack that interview. You are our hero. You are the only one who is behind my success. Like me there are a lot more students who really can't express how much thankful we are that our paths cross with future in Hands. I never ever expected that I can also get success in my career. I started my career with calling profile and yet I was tele caller. Now I just can't express my happiness. I am Thankful to you. Advice or suggestion for everyone also keep improving your skills. That's what I did followed Vivek sir guidelines. With Excel and VBA Programming, I learnt Advance Dashboard, Power Point. And now already enrolled for the upcoming Brainstorming Microsoft Excel session. Some of you think that all of these courses are not possible but it is. Instead of watching television, I watched those videos. And now more exited to get my self enrolled for more courses. I will always be thankful to Future in Hands Institute. \


Sanjeev Pant

This was one of the best training of my life. The mentor Mr. Vivekananda left no place for any doubts in this. The entire training was great with very useful and practical examples that relate to our day to day Reporting activities. I have taken VBA Training from this Institution and learned the subject very well. Sir cleared all our doubts without thinking of any time limitations during our sessions. He has a great knowledge on Excel Analytics. His expertize on the subject made us more confident. I have applied the leanings in my office and its WOW. Thanks to sir for your guidance. I recommend his Institution Future in Hands as one of the best learning place in Delhi.


Anil Kumar Pal

I would rate the institute by five stars, because the excel and VBA training was damn amazing. He makes us everything understand. I would specially thanks vivekananda sir for his valuable guidance and support. I would highly recommend him.


Siddharth Singh

I attended the VBA Training under the guidance of Vivekananda sir and his training changed my life. I got a better position in Amex and lots of appreciation in my office. Earlier I though that VBA could be impossible for me as I dont have any tech background but the way he guided me was awesome and very easy to understand. His examples are very practical and related to our work. Surely, He is a GEM and the best of the best trainer and a wonderful person. I was referred by one of my Friend to join his session and believe me this decision was one of the best decisions of my life. Most of his students are outstanding performer in their company. Thank you Vivek Sir for your exceptional guidance.

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.


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.


Daljeet Singh Rana

Good, Excellent June 2014

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.

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.

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.

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.

Sunil Kumar

Because teaching method of educating is very simple and he has very good experiences in Excel & VBA programming. Any doubt of queries solved in seconds. He is a very good teacher in this world.


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.


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.

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.

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.


Vandana Chauhan

The Teaching method of Vivekanda Sir is so progressive in a very simple and understanding language. I want to say "thank you to Vivek Sir as I got a lot of improvement in my official task by join the MIS classes from UrbanPro.


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.



He is a awesome teacher for all course. I have done Excel & VBA. Good notes, appreciate the way of teaching.


Alok Kumar Srivastava

Vivek Sir is one of the best trainer in NCR.



I would like to share my experience with vivek sir, As a teacher, his concept about course is very much immpresive. Assignment are very much helpful to learn the course in easy way. tough question has resolved with in a minute. he knows how to manages 10 -50 peoples in a group in classroom. his video programmes were very much impresive and help ful for each student. and i think most of the students has got a new jobs after attending his classes. thats not enough about vivek sir, i just want to say thank you vivek sir, for those times which i have spent with u in classes. regards vasu saini


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.

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


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.


Mohit Sharma

Vivekanand Sir, Who always helps Students to get the knowledge and always stands beside the students when they have problems. He's not only teacher he's a good friend, philosopher and guide. he's made a good platform to our bright future


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.



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.


Gaurav Tyagi

Mr. Vivekananda has been tutoring me from last two months. I was scared by the name of VBA before I met him but in last couple of months under his guidence and my hardwork I have been making very complex VBA programming applications. He is a very good teacher and a better human being. He is an optimistic person not just for himself but for the students too. He motivates and drives trainees to excel in whatever training he is providing. He is surely a master at what he does. I'm really glad that I joined his initiative "Future in Hands" and now I'm enjoying my fruitful career, all thanks to him. Thank You Sir


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.


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


Anant Jain

The method of teaching is excellent. Very supportive and helpful in teaching. Its a great experience to learn from Vivekananda S.

Shivkant Pathak

Vivekananda is an excellent knowledge of MS Office tools. His way of teaching is excellent as he have the experience of IT industry.

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.


Vibhor Rawat

One day Training session on Expertising Excel is a great learning experience. This training is beneficial for all those who are working in corporates. I attended this training and learnt many things that can be used in our routine tasks. Waiting for VBA Session to commnece.


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.


Vivekananda Sinha picture

Vivekananda Sinha

The Educationalist

37 Reviews

Students Interested 0 (Seats Left 0)

₹ 8,000

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


Submit your enquiry for Industry Level 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.

Please check the fields again.

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 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 the OTP sent to your registered mobile number.

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 is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on, to fulfill their learning requirements across 1,000+ categories. Using, 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 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