Flux rss

Spreadsheets - The Excel Interface

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.
Returning contents of last cell in row Hello, I am trying to write a macro that returns the data contents of the last cell in a row of data. I then need to declare the cell's data as a variable. So far, my code is this (from another online tutorial): Public Sub LastColumnInOneRow()... en.kioskea.net/forum/affich-27391-returning-contents-of-last-cell-in-row
[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
Pretty Basic Excel Macro Help Hello, I am writing a macro (which will be used to create a VB6 program) in Excel 2003. The spreadsheet Update_Log is a database with 9 user input columns and 7 columns which are calculated by formulas based on user input. I need to create a macro... en.kioskea.net/forum/affich-15106-pretty-basic-excel-macro-help
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
How to convert Excel into PDF?How to convert Excel into PDF? Here is a small tips about how to convert your excel files into PDF for your presentation. PDF995 is software that gets installed on your computer which enables you to print any sources of document to PDF.... en.kioskea.net/faq/sujet-552-how-to-convert-excel-into-pdf
Graphical interfaces for SQLiteGraphical interfaces for SQLite SQLite is a powerful database management engine found in a relatively small C programming library; it requires no monitoring and can be used with most programming languages (C, C++, Java, Python). Unlike... en.kioskea.net/faq/sujet-629-graphical-interfaces-for-sqlite
Excel wont open on MACHello, MAC doesn't support excel. Is there any way that i can open my excel attachment on MAC. This excel spreadsheet has various tab and i want to work on them in MAC environment. Please help. Thanks, -Dinesh en.kioskea.net/forum/affich-20155-excel-wont-open-on-mac
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... en.kioskea.net/forum/affich-19906-macro-help-search-for-text-in-excel
Excel Macro HelpHello, I am trying to create a macro within Excel 2003, which will extract data from a Text document into an Excel spreadsheet and sort the data as required. This is made slightly more difficult by the inconsistency in the data which is explained... en.kioskea.net/forum/affich-30377-excel-macro-help
Download FfmpegXEncoding will not be any more a mystery for whoever. FfmpegX is the horrible tool of encoding par excellence. It is a graphic interface indicated for Mac. Encoding becomes with more than 20 tools Open Source different including the ffmpeg... en.kioskea.net/telecharger/telecharger-204-ffmpegx
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 ConnectCode Free Excel TrainingService Excel is an inevitable when they use Windows as Word is him. However her use is not of the most intuitive for the laymen. ConnectCode Free Excel Training is a program of study for introduction with Excel. It understands ten different... en.kioskea.net/telecharger/telecharger-568-connectcode-free-excel-training
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
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
Spreadsheets - Introduction 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... en.kioskea.net/tableur/tablintro.php3