Filter interviews by
MIS stands for Management Information System. It is a computer-based system that provides information to support decision-making.
MIS collects, processes, and stores data from various sources.
It generates reports and provides analysis to support decision-making.
MIS helps in planning, controlling, and organizing business operations.
Examples of MIS include ERP systems, CRM systems, and financial management systems.
MIS stands for Management Information System. There are mainly four types of MIS: Strategic, Tactical, Operational, and Decision Support System.
Strategic MIS: Helps in long-term planning and decision-making.
Tactical MIS: Helps in short-term planning and decision-making.
Operational MIS: Helps in day-to-day operations and monitoring.
Decision Support System: Helps in complex decision-making by providing analytical tools a...
Protect sheet from editing by setting password and restricting access.
Set a password to protect the sheet
Restrict access to the sheet by only allowing authorized users to edit
Use Excel's Protect Sheet feature to prevent editing
Use VBA code to protect the sheet and prevent unauthorized access
The constraint of a VLOOKUP function is that it can only look up values in the leftmost column of a table.
VLOOKUP can only search for values in the first column of a table
The lookup value must be in the leftmost column of the table
If you need to search for values in other columns, you need to use INDEX/MATCH instead
There are several report formats available in MS Excel.
Excel offers various report formats such as tables, charts, pivot tables, and pivot charts.
Tables are used to organize data in rows and columns.
Charts are used to visually represent data in different formats such as bar, line, and pie charts.
Pivot tables are used to summarize and analyze large amounts of data.
Pivot charts are used to visually represent data from pi...
To prepare an MIS report in Excel, follow these steps:
Identify the data to be included in the report
Organize the data in a structured format
Use Excel functions and formulas to calculate metrics
Create charts and graphs to visualize the data
Format the report for readability and clarity
Include a summary or conclusion section
Save the report and share with relevant stakeholders
Top trending discussions
posted on 5 Sep 2024
My current CTC is INR 12 lakhs per annum.
My current CTC is INR 12 lakhs per annum
I am currently earning INR 1,00,000 per month
My current salary package is INR 12,00,000 per year
I have 5 years of experience in my current company.
5 years of experience in current company
Experience gained through various projects and roles
Demonstrated growth and expertise in the field
Received promotions and increased responsibilities
Contributed to the success of the company
I applied via Approached by Company and was interviewed in Dec 2023. There were 2 interview rounds.
Qualifications and work experience
I applied via Recruitment Consulltant and was interviewed in Apr 2024. There were 2 interview rounds.
posted on 9 Apr 2024
I applied via LinkedIn and was interviewed in Mar 2024. There were 2 interview rounds.
Finacial modeling , Finacial Budegeting , Cash flow statement , Projection Report
I applied via Referral and was interviewed before Oct 2021. There were 4 interview rounds.
I applied via LinkedIn and was interviewed before May 2023. There was 1 interview round.
posted on 10 Apr 2023
I applied via Campus Placement
based on 1 review
Rating in categories
MIS Executive
59
salaries
| ₹2 L/yr - ₹3.7 L/yr |
Assistant Manager
33
salaries
| ₹3.6 L/yr - ₹8.4 L/yr |
Project Manager
28
salaries
| ₹3 L/yr - ₹13.3 L/yr |
Operations Manager
26
salaries
| ₹4.4 L/yr - ₹11 L/yr |
Executive Accountant
20
salaries
| ₹3 L/yr - ₹4.8 L/yr |
TCS
Infosys
Wipro
HCLTech