Data analysis using Microsoft Excel

Microsoft excel is an Electronic spreadsheet Program. These spreadsheet programs have evolved dramatically over the past decade, and now comprise one of the most widely used categories of software products. Among these Excel is versatile as it has more user interface features in common with other Microsoft Office applications such as MS Word, MS Power point MS Access etc.

Spreadsheet is software, which is a substitute to all types of applications using paper worksheets. Spreadsheet displays data in the form of rows and columns. An intersection of wows and columns is known as cell. Data and formulae are entered in the cell. Spreadsheet allows to perform the following.

• All types of arithmetic calculations
• Allows to perform many types of Statistical Analysis from simple to advanced.
• Allows to represents data in various graphical forms and hold graphical objects like pictures and images

Some Important features of Excel Excel like all other applications has tool bars, short cut Menus, templates, Wizards and online help.

• Windows Environment: Excel like all other all other applications has tools bars, Shortcut Menus, Templates, Wizards and online help.
• Workbooks: An Excel document is referred to as workbook. There are 256 worksheets in each workbook. Each worksheet contains 65,536 (256X256) rows and 256 (AA, BB,..BA,BB, ….IV) columns. Each single cell in and worksheet can accommodate about 32,000 characters.
• Formula bar: Below the tool bar (i.e. Standard and Formatting), there is a Formula Bar.
• Cell Address: On the left hand side of Formula Bar is the address Box. The address of the cell which is active is shown in the box. Ex. A1 refers the cell in first column and first row.