Flux rss
 

Introduction to Spreadsheet Concepts

What is a Spreadsheet?

A spreadsheet (or spreadsheet program) is software that permits numerical data to be used and to perform automatic calculations on numbers contained in a table. It is also possible to automate complex calculations by using a large number of parameters and by creating tables called worksheets.

In addition, spreadsheets can also easily produce graphic representations of the data entered:

  • histograms
  • curves
  • sector charts
  • ...
Therefore, the spreadsheet is a multi-use tool that works as well for secretarial activities that involve organising large quantities of data, as at the strategic and decisional level by creating graphical representation of synthesised information.

The Main Spreadsheets

Numerous spreadsheets have been produced by the main software companies. The main spreadsheets are:

  • Microsoft Excel, in the Microsoft Office office suite
  • Sun StarOffice Calc, in the StarOffice suite
  • OpenCalc, in the OpenOffice suite
  • IBM/Lotus 1-2-3 in the SmartSuite suite
  • Corel Quattro Pro in the WordPerfect suite
  • KSpread in the KOffice free suite from Linux

Examples in the following articles are based on the Microsoft Excel spreadsheet, but the other spreadsheets contain the same functionalities.



Last update on Thursday October 16, 2008 02:43:17 PM.
This document entitled « Introduction to Spreadsheet Concepts » from Kioskea (en.kioskea.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the licence, as this note appears clearly.
Spreadsheets - Cell Selection Spreadsheets are powerful tools for working with data. However, to work with data, it is necessary to have tools to rapidly choose the required cells. An entire line can be chosen by clicking directly on the line header: It is also possible to choose... en.kioskea.net/tableur/tabcellselect-1.php3
Spreadsheets - The Excel Interface Microsoft Excel is the spreadsheet in the Microsoft Office office suite. To start it, simply click on the appropriate icon in the Start menu (in Windows) or click on an Excel file (that has an .xls file extension). A Excel document is called a file... en.kioskea.net/tableur/tabinterface.php3
Spreadsheets - Worksheets Spreadsheets display data and formulas in a table form (lines and columns) called a worksheet. A worksheet is made of lines (numbered with numbers) and of columns (numbered with letters). The intersection of a line and a column is called a cell. A... en.kioskea.net/tableur/tabfeuille.php3
[ExcelStorage name and path of a spreadsheet[ExcelStorage name and path of a spreadsheet The tip below will show you how to automatically show the storage path and the name of any spreadsheet Enter in a cell (E.g cellA1) the following formula: =cell("filename", A1) Upon... en.kioskea.net/faq/sujet-1152-excelstorage-name-and-path-of-a-spreadsheet
What is DOM player ?What is DOM player ? DOM player a is a malware affecting mainly P2P software users. The hidden concept is quite simple, you download what you think is the last episode of your favorite TV series or movie, which in this case is a fake (aXXo... en.kioskea.net/faq/sujet-495-what-is-dom-player
What is Google Earth ?What is Google Earth ? Major Features of the Google Earth Google Earth is a program that was created by Keyhole inc . The project was initially known as Earth Viewer before being acquired by Google. The concept is to display a merge... en.kioskea.net/faq/sujet-497-what-is-google-earth
Excel spreadsheetHello, I am trying to create a spreadsheet for employees schedule. I want it to be able to give me the total hours at the end of each week. It is a montly schedule with their names. Also, I want to be able to put a code in representing the shift they... en.kioskea.net/forum/affich-29731-excel-spreadsheet
O/s concepts with real time exampleHello, please sent web address or documents for o/s [operating system]concepts with real time example. en.kioskea.net/forum/affich-20003-o-s-concepts-with-real-time-example
EXCEL CVS data to a custom spreadsheetHello, I download a CVS file from an investment site and transfer the variables to a custom spreadsheet. The problem is that the variables will not always be in the same place on th CVS file. This corrupts the custom spreadsheet. How can I track the... en.kioskea.net/forum/affich-38065-excel-cvs-data-to-a-custom-spreadsheet
Download Icy TowerIcy Tower is a game with a very simple concept, it is a question of making climb a tower as high as possible by skipping one of platform in platform good-natured baby and of earning points.There is possibility of accumulating max of points by making "... en.kioskea.net/telecharger/telecharger-917-icy-tower
Download OpenOfficeOpenOffice is a free office application suite, including a word processor, spreadsheet, presentation tool, drawing package and database, compatible with all other major office suites like Microsoft Office (97-2007... en.kioskea.net/telecharger/telecharger-56-openoffice
Download IETesterIf you are integral filter web or simple conceptor of web, big one worries which you would owe to overcome are the compatibility of your site with all available navigators. The black animal of all is IE6. IETester is a free navigator allowing to... en.kioskea.net/telecharger/telecharger-320-ietester
Nissan to make lithium-ion batteries with NEC: reportA model of Nissan Motor 's concept electric vehicle "Pivo". Nissan and NEC Corp will join forces in the world's first mass production of lithium-ion batteries for hybrid and electric vehicles, a newspaper said Nissan Motor Co and NEC Corp... en.kioskea.net/actualites/nissan-to-make-lithium-ion-batteries-with-nec-report-10361-actualite.php3
Spreadsheet - Text Operators Spreadsheets generally use an oeprator, called a concatenation operator , that allows two text values to be added together. The concatenation operator, written as &, is used as follows: In the above example, the cell value B15 ("Total TTC") is... en.kioskea.net/tableur/tabtexte.php3
Spreadsheet - Functions Spreadsheets generally have a large number of integrated functions for processing data. There are hundreds, categorised as follows: Arithmetic functions that offer basic tools to process numerical data Statistical functions that have analysis tools,... en.kioskea.net/tableur/tabfonc.php3
Spreadsheet - Formulas The main use of a spreadsheet is to automate calculations, which means using cells to perform operations based on values in other cells. The spreadsheet recalculates all the values each time a change is made to the value of a cell. A formula is used... en.kioskea.net/tableur/tabformules.php3