Flux rss
They need your help
Excel

Spreadsheets - The Excel Interface

Worksheets
Bookmark Bookmark & Share
Foglio elettronico - L'interfaccia di Excel Folha de cálculo - A conversão de Excel Tabellenkalkulationsprogramm - Die Excel-Benutzeroberfläche Tableur - L'interface d'Excel

Excel 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 document is called a file and it contains one or more worksheets shown by tabs at the bottom of the page.

Interface Introduction

The Microsoft Excel interface is presented below:

Microsoft Excel Interface

It is made up of various elements:

  1. A title bar that shows the application name and the name of the open file
  2. A menu bar that provides access to the various functions of the spreadsheet
  3. A tool bar in icon form that offers direct access to the main functions. It is interesting to note that this bar can be personalised to allow shortcuts to the most used functions
  4. A formula bar showing the coordinates of the selected cell and its contents. The formula bar allows data to be entered in cells
  5. The worksheet is the key to the spreadsheet; it is the table that contains all the cells. Tabs that allow the user to switch between worksheets are located at the bottom of the worksheet.
  6. The status bar provides information about required actions. By default, the message ready is shown in the status bar


Last update on Thursday October 16, 2008 02:43:17 PM.This document entitled « Spreadsheets - The Excel Interface » 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.
Excel interface with the real world Hello, I want to interface an Excel spreadsheet with the real world. For instance, in it's simplest form, I would like to enter a number in a cell in a spreadsheet and have this sent to another application running on my PC, and to read a number from... en.kioskea.net/forum/affich-52541-excel-interface-with-the-real-world
Import webpage data into Excel spreadsheet Hello, 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
Index and matching 2 different spreadsheets Hello, 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 tips : How to insert date In an Excel cellExcel tips : How to insert date In an Excel cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press “CTRL”+ “;” in the chosen cell. To insert current... en.kioskea.net/faq/sujet-313-excel-tips-how-to-insert-date-in-an-excel-cell
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
[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
Results for Spreadsheets The Excel Interface
Compare 2 excel sheet and combine uniq dataHello, I have 2 excel sheets , A and B. There are redundant data in both sheets as well as uniq. All i want is to combine both with no redundant records. (A+B-Redundant= Uniq complete data) Thanks, Rina en.kioskea.net/forum/affich-106825-compare-2-excel-sheet-and-combine-uniq-data
Macro help - search for text in ExcelHello, I've been trying to wrap my head around how to do this but haven't had any luck -- I want to search for text in excel in a spreadsheet of 4000 entries...so it'll save a ton of time. Here's the situation I want solved. I have an array of 22... en.kioskea.net/forum/affich-19906-macro-help-search-for-text-in-excel
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
Results for Spreadsheets The Excel Interface
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 Excel Password Recovery MasterExcel Password Recovery Master is used to delete the passwords for documents created in MS Excel 97/2000/XP/2003 files (. Xls,. Xlt,. Xla). The program allows you to reset the password for reading ( "open" password), but also to recover passwords for... en.kioskea.net/telecharger/telecharger-2903-excel-password-recovery-master
Download Ms Word Excel CrackerMs Word Excel Craker allows recover lost or forgotten passwords for .xls and .doc reated with Microsoft Office 97, 2000, 2003, XP or other word and excel compatible programs. This application will be necessary in case you should have received an... en.kioskea.net/telecharger/telecharger-2222-ms-word-excel-cracker
Results for Spreadsheets The Excel Interface
Spreadsheet - FormulasIntroduction 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
Introduction to Spreadsheet ConceptsWhat 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... en.kioskea.net/contents/tableur/tablintro.php3
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
Results for Spreadsheets The Excel Interface