Module 1: Introduction to Microsoft Excel

What is Microsoft Excel?
Microsoft Excel is a spread sheet program that is used to record and analyse
numerical data.
Spreadsheet programme is a software application capable of organizing, storing
and analyzing data in tabular form. The application can provide digital
simulation of paper accounting worksheets. They can also have multiple
interacting sheets with data represented in text, numeric or in graphic form.

With these capabilities, spreadsheet software has replaced many paper-based
systems, especially in the business world. Originally developed as an aid for
accounting and bookkeeping tasks, spreadsheets are now widely used in other
contexts where tabular lists can be used, modified and collaborated.
Spreadsheet software provides a distinct advantage when working with
numbers. Calculation and functionalities are easier to represent in
spreadsheets than in word processors, and thus effective data handling is
possible. Spreadsheet software also provides flexible presentation of data. This
software is capable of interacting with databases, can populate fields and can
also help in automation of data creation and modification. Spreadsheet software
can be shared both online and offline and allows for easy collaboration. There
are many spread sheet applications available in the market or in open source
(free), for the purpose of this training Microsoft Excel is used.

Data in spread sheet is represented by cells, organized as rows and columns
that form a table and can be text or numeric. Alphabetical letters are assigned
to columns and numbers are assigned to rows. The point where a column and a
row meet is called a cell. The address of a cell is given by the letter representing
the column and the number representing a row.