MS-Excel
Microsoft Excel is Application software which is developed by Microsoft Corporation of USA. Microsoft Excel is a spreadsheet program included in the Microsoft Office suite of applications. Such spreadsheets provide users with the values arranged in rows and columns that can be changed mathematically using both basic and complex arithmetic operations. It is mostly used for accounting and auditing and it is also useful for making reports using information and chart. In short, MS-Excel is a software program that allows users to organize, format and calculate data by suing several formulas. Spreadsheet applications such as MSExcel use collection of cells arranged into rows and columns to organize and manipulate data. It displays data in chart, histograms and line graphs.
Features of MS-Excel
Add Header and Footer
Find and Replace Command
Password Protection
Data Sorting
Data Filtering
Built-in formulae
Create different charts (Pivot Table Report)
Automatically edits the result
Formula Auditing
Functions of MS-Excel
It analyzes and store data safely for the current and future use.
It provides various tools that make users’ work easier.
It keeps data combined at one location.
It helps business men in developing future strategies.
It prints the documents.
It adjusted pictures and graphics in documents.
It helps in recording the financial transactions of BFIs.
It extracts the statements prepared by the CBS software of the Banks.
It also keeps record of employees to provide the services and facilities.
It keeps the complete record of the customers to disburse loans and advances.
It generates memos, track trends, and other business data
MS-Excel is commonly used for financially related activities as it define custom formulas for calculating and measuring that data easily and produces accurate and reliable data for making appropriate decision in order to avoid possible risks.
