Fill Handle or Auto Handle not Showing or Working

How to enable fill handle or auto handle

The fill handle is a small black dot or square in the bottom right corner of the active cell. The fill handle has a number of uses including copying a cell’s contents to adjacent cells or to create a series.

How to Enable -:

A) Go To File

1) Go to Excel options

2) Go to Advance tab

3) Check Enable handle

CHARACTERISTICS OF COMPUTERIZED MIS

Characteristics of Computerized MIS :

• Ability to process data into information with accuracy and high speed. It involves complex computation, analysis, comparisons and summarization.
• Organizing and updating of huge amount of raw data of related and unrelated nature, derived from internal and external sources at different periods of time.
• The information processing and computer technology have been so advanced that managers are able to obtain real time information about ongoing activities and events without any waiting period.
•  The input data in computer can be converted into different output formats for a variety of purpose.
• The system is so organized that managers at different levels and in different activity units are in a position to obtain information in whatever form they want , provided that relevant “programmes” or instructions have been designed for the purpose.
•  Super-human memory, tremendous volume of data and information and the set of instructions can be stored in the computer and can be retrieved as and when needed. Management can get bit of stored information from the computer in seconds.

Advantages of Computer  The usage of computer gives following advantages in comparison to manual MIS :

a) Speed : The speed of carrying out the given instructions logically and numerically is incomparable
    between computers and human beings. A computer can perform and give instructions in less than a
    millionth of second.
b) Accuracy : Computer can calculate very accurately without any errors.
c) Reliability : The information stored in the computer is in digital format. The information can be stored for
    a long time and have long life. A user may feel comfortable and be rely on, while using information stored
    in computer.
d) Storage : Computer can store huge data for a long time in comparison to human brain.
e) Automatic : Computers perform automatically in user friendly and menu driven program.
f) Repetitiveness : Computer can be used repetitively to process information without any mental fatigue as
    in case of human brain.
g) Diligence : A computer is an electronic device. It does not suffer from the human traits of lack of
    concentration.
h) No Feeling : Computers are devoid of any emotions. They have no feelings and no instincts because they
    are machines.

Limitations of Computer :
a) Lack of Common Sense : Computer is only an electronic device. It can not think. If we provide an
    incorrect data, it does not have a common sense to question the correctness of the data.

b) Memory Without Brain : Computer can store data in its memory,however, if a wrong instruction is given
    to computer it does not have a brain to correct the wrong instruction.

CHARACTERISTICS OF MANAGEMENT INFORMATION SYSTEM (MIS)

CHARACTERISTICS OF MANAGEMENT INFORMATION SYSTEM

Systems Approach : The information system follows a systems approach. Systems approach means taking a comprehensive view or a complete look at the interlocking sub-systems that operate within an organization.

Management Oriented : Management oriented characteristic of MIS implies thatthe management actively directs the system development efforts. For planning of MIS, top-down approach should be followed. Top down approach suggests that the system development starts from the determination of management’s needs
and overall business objective. To ensure that the implementation of system’s polices meet the specification of the system, continued review and participation of the manager is necessary.

Need Based : MIS design should be as per the information needs of managers at different levels.

Exception Based : MIS should be developed on the exception based also, which means that in an abnormal situation, there should be immediate reporting about the exceptional situation to the decision –makers at the required level.

Future Oriented : MIS should not merely provide past of historical information; rather it should provide information, on the basis of future projections on the actions to be initiated.

Integrated : Integration is significant because of its ability to produce more meaningful information. Integration means taking a comprehensive view or looking at the complete picture of the interlocking subsystems that operate within the company.

Common Data Flow : Common data flow includes avoiding duplication, combining similar functions and simplifying operations wherever possible. The development of common data flow is an economically sound and logical concept, but it must be viewed from a practical angle.

Long Term Planning : MIS is developed over relatively long periods. A heavy element of planning should be involved.

Sub System Concept : The MIS should be viewed as a single entity, but it must be broken down into digestible sub-systems which are more meaningful.

Central database : In the MIS there should be common data base for whole system

MANAGEMENT INFORMATION SYSTEM IN DETAIL

What is MIS? Discuss in detail?

OR

Describe the three words of MIS: Management, Information, System.

OR

 Management Information Systems (MIS), referred to as Information Management and Systems, is the discipline covering the application of people, technologies, and procedures collectively called information systems, to solving business problems.

“'MIS' is a planned system of collecting, storing and disseminating data in the form of information needed to carry out the functions of management.” Academically, the term is commonly used to refer to the group of information management methods tied to the automation or support of human decision making, e.g. Decision Support Systems, Expert Systems, and Executive Information Systems.

Management : Management is art of getting things done through and with the people in formally organized groups. The basic functions performed by a manager in an organization are: Planning, controlling, staffing, organizing, and directing.

Information : Information is considered as valuable component of an organization. Information is data that is processed and is presented in a form which assists decision maker. Information Generation

System : A system is defined as a set of elements which are joined together to achieve a common objective. The elements are interrelated and interdependent. Thus every system is said to be composed of subsystems. A system has one or multiple inputs, these inputs are processed

Duties & Responsibilities of Management Information System ( MIS ) Officer or Executive

The major duties include assisting the MIS Manager in various tasks that include, but

are not limited to:

• Perform duties in the absence of the MIS Manager
• Assist the MIS Manager with administrative and technical functions.
• Responsible for maintaining servers and workstations as requested by the MIS Manager
• Perform system diagnosis, repair and updates to ensure data integrity
  and reliability of automated tasks.
• Assist with diagnosing and resolving problems with printers, copiers,
   fax machines and networks.
• Provide help-desk and on-site technical support of hardware and software.
• Interface with users to identify computer related needs and provide
  appropriate software/hardware support applicable to those needs.
• Ensure the anti-virus software is always up to date and share necessary
  information with users regarding potential risks.
• Monitor, order and distribute computer supplies.
• Provide instruction to staff on the use of computer applications and systems.
• Generate reports as requested by the MIS Manager.
• Ensure routine backups are performed as outlined by the Backup & Restore Manual.
• Assist in maintaining and updating of web site and intranet.
• Any other duties as requested by the MIS

Qualifications/Requirements

• Bachelors Degree in Computer Science or its equivalent any other professional experience
• Strong communications skills both oral & written and ability to practice
• both downward and upward communication.
• Experience in interacting with senior management.
• A demonstrated ability to implement management directives with little direct supervision.
• A demonstrated ability to co-ordinate hardware and software maintenance contracts.
• Minimum of 1 - 2 years experience in MIS or performing similar duties.

What is Management Information System or MIS ?

Management Information System

A management information system (MIS) provides information that organizations need to manage themselves efficiently and effectively. Management information systems are typically computer systems used for managing five primary components: hardware, software,data (information for decision making), procedures (design,development and documentation), people (individuals, groups, or organizations). Management information systems are distinct from other information systems, in that they are used to analyze and facilitate strategic and operational activities. Academically, the term is commonly used to refer to the study of how individuals, groups, and organizations evaluate, design, implement, manage, and utilize systems to generate information to improve efficiency and effectiveness of decision making, including systems termed decision support systems, expert systems, and executive information systems.

Overview

A management information system gives the business managers the information that they need to make decisions. Early business computers were used for simple operations such as tracking inventory, billing, sales, or payroll data, with little detail or structure. Over time, these computer applications became more complex, hardware storage capacities grew, and technologies improved for connecting previously isolated applications. As more data was stored and linked, managers sought greater abstraction as well as greater detail with the aim of creating significant management reports from the raw, stored data. Originally, the term "MIS" described applications providing managers with information about sales, inventories, and other data that would help in managing the enterprise. Over time, the term broadened to include: decision support systems, resource management and human resource management, enterprise resource planning (ERP),enterprise performance management (EPM), supply chain management (SCM), customer relationship management (CRM), project management and database retrieval applications.

Recommended Tools


Applicatioon Tools - MS EXCEL, MS WORD, MS POWERPOINT
Database Tools     - SQL, ORACLE , MSACCESS

you will also find here the best methods and tutorials to operate these tools  becouse you can't be perfect without excellent knowledge of these tools.