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


Related Posts:

  • Interactive INDEX Example Excel Index and Match Functions Use the INDEX and MATCH functions to pull data from a list. These functions can be used together, to create a power… Read More
  • Excel INDIRECT Function The INDIRECT function returns a reference to a range. You can use this function to create a reference that won't change if row or columns are insert… Read More
  • Excel Average Functions Examples show how to average Excel cells with numbers, text, blanks, or cells based on specific criteria. Use the AVERAGE, AVERAGEA, AVERAGEIF or AV… Read More
  • Excel Count Functions Excel Count Functions See 7 ways to count in Excel. Examples and video tutorials show how to count Excel cells with numbers, text, blanks, or cells… Read More
  • Excel HLOOKUP Function The HLOOKUP function looks for a value in the first row of a table, and returns another value from the same column in that table. It is very similar… Read More