Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Spreadsheet Definition

Table of data arranged in columns and rows often used in business and financial applications.

Spreadsheet software programs are widely used computer applications that allow the user to organize large amounts of data.  

and it can be a type of application program which manipulates numerical and string data in rows and columns of cells. The value in a cell can be calculated from a formula which can involve other cells. A value is recalculated automatically whenever a value on which it depends changes. Different cells may be displayed with different formats.
Some spreadsheet support three-dimensional matrices and cyclic references which lead to iterative calculation.
An essential feature of a spreadsheet is the copy function (often using drag-and-drop). A rectangular area may be copied to another which is a multiple of its size. References between cells may be either absolute or relative in either their horizontal or vertical index. All copies of an absolute reference will refer to the same row, column or cell whereas a relative reference refers to a cell with a given offset from the current cell.
Many spreadsheets have a "What-if" feature. The user gives desired end conditions and assigns several input cells to be automatically varied. An area of the spreadsheet is assigned to show the result of various combinations of input values.
Spreadsheets usually incorporate a macro language, which enables third-party writing of worksheet applications for commercial purposes.
Today, Microsoft, Lotus, Borland and many other companies offer Windows-based spreadsheet programs.
The main end-users of spreadsheets are business and science.
Spreadsheets are an example of a non-algorithmic programming language.
 

Market Place

Primavera P6 and Microsoft Project books, on-line video training courses and training material available from an internationally recognised publisher. Teach yourself using on-line or book based learning or run your own in-house or public courses.