Microsoft Excel 2007 Overview

2012-09-03T01:31:00.004-07:00

Microsoft Excel is a spreadsheet program that allows users to create worksheets that store information in workbook files. It uses grids to arranged in numbered rows and letter-named columns to organize data. Excel offers many features like store, manipulate, analyze, and visualize data etc. It has built-in functions which allow users to create and edit formulas, copy and move data, format worksheets, and set up worksheets for printing. Excel has been a great application for formating of data, providing you the features like Format Cells option, Sort, Filter, Remove Duplicate. The default file extension of Microsoft Excel 2007 is xlsx unlike xls of previous version.

Microsoft Excel 2007 interface looks like as below:

Components in Microsoft Excel 2007

Office Button
Quick Access Toolbar
Title Bar
Excel Menu
Ribbon
Name Box
Formula Bar
Worksheet
Status Bar

OFFICE BUTTON

The above image is the Microsoft Office Button, which is located at the upper left corner of Microsoft Office 2007 Interface. This button has the basic features as previous version of Microsoft Office but in the newer version commands such as Publish for distributing the documents with other peoples.

When you click the button or press (Alt + F) it will showed up like the image below:

The above image comprises of commands:

New	(Ctrl + N)	-	to create a new workbook.
Open	(Ctrl + O)	-	to open an existing file.
Save	(Ctrl + S)	-	to save a workbook.
Save As	(F12)	-	to save a copy of the document.
Print	(Ctrl + P)	-	to print the document.
Prepare		-	to prepare the document for distribution like setting properties, encryption etc.
Send		-	to send a copy of the document to other people through E-mail or Internet Fax.
Publish		-	to distribute the document using Excel Services or by sharing through server.
Close	(Alt + F4)	-	to close the document.

QUICK ACCESS TOOLBAR

The Quick Access Toolbar is located just next to Microsoft Office Button. The toolbar includes the commands which uses frequently so that it could be access very quickly without touring through the menus and their sub-menus. By default the bar includes the Save, Undo, Redo commands and a Customize button respectively.

User can also click on thetag to jump to an undo or redo point listed if you have undo or redo points.

To add additional commands click on the Customize button which is at the right side and click to add

the commands.

TITLE BAR

The Title bar shows the name of the file at the center which is in used followed by Microsoft Excel. By default Microsoft Excel open new workbook as Book1.

EXCEL MENU

The Excel 2007 Menu is a list of the basic options available. By default Excel 2007 listed out the menus as seen in the above image and each menu has logically related group of commands shown as below.

RIBBON

With each Excel Menu Tab a group of command and their related activities are shown as Ribbon making it more easy to find and meaningful.

NAME BOX

A Name Box is located at the left side just below Ribbon. It is used as reference to a cell which is active or clicked. The Name Box will reference a cell according to the column name and row number, in the above image the active will is at first column i.e., A and first row i.e., 1.

FORMULA BAR

Whenever we edit a cell the content of that cell is reflected on the Formula Bar which is next to the Name Box. To the left most side of the bar, as in the above image, is the Cancel button for reverting to the previous state or hit the Esc key from keyboard. Next to the Cancel button is the accept button to insert the input value or hit the Enter key to accept. And the Insert Function button is to insert inbuilt function of Excel into the selected cell. When click a dialog box will be shown as below and you can choose required function to insert.

WORKSHEET

Worksheet is the editable area in the Excel Interface and it is organised in tabular format having each block as editable cell. Each cell is indexed through the row number and column name. User can also apply formatting to the cells to make it more convenient to use and meaningful to display.

The Excel 2007 supports up to 1048576 rows as compared to 65536 of previous version.
And it can insert multiple sheets by clicking on the right most tag of the image which is shown below and is located at the lower left side of the worksheet. User can switch between the sheets by clicking on the navigation tags at the left side of Sheet Name.

User can also delete or rename the sheets by right clicking on the sheet name and for other options as seen below:

STATUS BAR

Status Bar will define summaries related to the workings on the worksheet whenever it is applicable. According to the above image the status bar shows the Average, Count, Min, Max and Sum of the selected cells. User can also customized the status bar by right clicking on the Status Bar and choose the options given listed as in the image below.

Learn To Excel

Microsoft Excel 2007 Overview

Components in Microsoft Excel 2007