INTRODUCTION TO ELECTRONIC SPREADSHEET


Electronic Spreadsheet is a financial management system use in calculating and analyzing numerical data. It is a windows application program or software that provides users with a powerful spreadsheet features and environment. It is referred to as an electronic spreadsheet because it produces the facilities that you have in a document on an electronic system (i.e the computer).

MICROSOFT EXCEL

Microsoft Excel is a grid of numbered rows and columns intersection in cells. It can be defined as any documentation area that consists of series of rows and columns, which is suitable for any form of data analysis. Example of a spreadsheet is the account ledger book.

Microsoft Excel can be referred to as a peace of electronic spreadsheet. Meaning it’s a package, software or an application under electronic spreadsheet but electronic spreadsheet is generally used for all the Financial Management Packages. Another typical example of an electronic spreadsheet package is Lotus 1-2-3.

 

ADVANTAGES OF ELECTRONIC SPREADSHEET OVER ITS MANUAL TYPE

  1. Computerized ledger has some advantages over its manual type, which includes the following:
  2. Easy insertion of formulas into the spreadsheet for automatic calculations
  3.  Easy editing of entries
  4. Instant creating and printing of graphs for pictorial representation of data
  5. Organization of numerical data into rows and columns
  6.   Provision of financial, statistical and mathematical functions
  7.  Recalculation ability
  8.  Financial Record Keeping
  9.  Budget Preparation
  10.   Forecasting