Introduction to Spreadsheet Concepts

Introduzione alla nozione di foglio elettronico

Introdução à noção de planilha de cálculo

Einführung in den Begriff der
Tabellenkalkulation

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.

Next Excel Interface

Spreadsheets - Worksheets The Concept of a Worksheet 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... en.kioskea.net/contents/tableur/tabfeuille.php3

Spreadsheet - Expressions The Concept of an Expression Expressions allow the spreadsheets to perform simple calculations using values from many cells. There are generally many types of expressions: Arithmetic expressions Conditional expressions Text expressions en.kioskea.net/contents/tableur/tabexpr.php3

Spreadsheet - Formulas Introduction to 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... en.kioskea.net/contents/tableur/tabformules.php3

Results for Introduction to Spreadsheet Concepts

[Excel]Storage 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)... en.kioskea.net/faq/sujet-1152-excel-storage-name-and-path-of-a-spreadsheet

Network conceptNetwork concept Intro Computer Network Intro A network is a general term referring to a set of related elements or entities linked to each other. The coexistence of these elements is defined by the communication or exchange processes... en.kioskea.net/faq/sujet-2664-network-concept

Inserting an animated gif in ExcelInserting an animated gif in Excel To insert an animated gif image in an Excel spreadsheet, you must insert the image into a control. To insert the control, go to the View menu/Toolbars/Control Toolbox Activate the first button Design... en.kioskea.net/faq/sujet-1402-inserting-an-animated-gif-in-excel

Results for Introduction to Spreadsheet Concepts

Index and matching 2 different spreadsheetsHello, i am trying to index and match two diffrent excel spreadsheets. one has the same info on it as the other except for one column. i'm trying to add that data over on the other spreadhseet becaue not all the names are on the spreadsheet i'm trying... en.kioskea.net/forum/affich-92629-index-and-matching-2-different-spreadsheets

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

Import webpage data into Excel spreadsheetHello, I am attempting to import the web page data from "http://bet1.hkjc.com/..." through EXCEL - new web query function but unsuccessful, the 'odds' data cannot be captured. Any idea? Thanks. en.kioskea.net/forum/affich-31834-import-webpage-data-into-excel-spreadsheet

Results for Introduction to Spreadsheet Concepts

Download ConceptDraw MINDMAPConceptDraw MINDMAP Professional is a professional software of idea and information presentation. It is designed for: teachers, psychologists, managers, jurist. The presentation is bases on the process of human reflection and uses the Mind Mapping... en.kioskea.net/telecharger/telecharger-2393-conceptdraw-mindmap

Download Excel ViewerWith Excel Viewer, you can open, view, and print Excel workbooks, even if you don't have Excel installed. You can also copy data from Excel Viewer to another program. en.kioskea.net/telecharger/telecharger-52-excel-viewer

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

Results for Introduction to Spreadsheet Concepts

New software makes iPhones spreadsheet-friendlyUS software developer MeLLmo has released a free application that turns iPhones into powerful tools for analyzing spreadsheets and reports, enhancing the appeal of Apple mobile devices to businesses. The application, named RoamBi, intuitively... en.kioskea.net/actualites/new-software-makes-iphones-spreadsheet-friendly-12823-actualite.php3

Results for Introduction to Spreadsheet Concepts

Spreadsheets - Cell SelectionCell 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. Line Selection An entire line can be chosen by clicking directly on the line... en.kioskea.net/contents/tableur/tabcellselect-1.php3

Spreadsheets - Conditional expressionsWhat is a Conditional Structure? Conditional structures are instructions that allow to test if a condition is true or not. Conditional structures may be associated together. To successfully execute these tests using logical functions, spreadsheets... en.kioskea.net/contents/tableur/tabcond.php3

Spreadsheets - The Excel InterfaceExcel Introduction 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... en.kioskea.net/contents/tableur/tabinterface.php3

Results for Introduction to Spreadsheet Concepts