article marketing
Cerca:

Home | English Articles


Microsoft Excel 2007: Ribbons And Tabs

By: Andrew Whiteman

The Microsoft Excel Ribbon is the most important part of the Microsoft Excel interface and contains the majority of the program's commands. The Ribbon is arranged into a series of Tabs, each of which contains groups of related commands. Tabs are accessed simply by clicking on the name of each Tab. Within each Tab, commands are arranged in sections: the name of each section is displayed at the bottom of the section.

The Home Tab contains the most often used commands. Here you'll find the commands which one uses all the time; clipboard such as Cut Copy and Paste; commands for formatting the data within your cells; choosing the font; changing the alignment and the format of numbers; commands for chopping and changing cells such as inserting rows and columns; and finally you will also find commands for sorting and editing your data.

As the name suggests, the Insert Tab is used to insert or add items into your worksheets. Some of these items are built into Excel such as charts; other items are inserted from outside the program such as pictures; for example, inserting a company logo.

The Page Layout Tab contains options for controlling the appearance of your worksheets as a whole. Here, you'll find settings relating to margins, orientation, size of paper and the area of the worksheet to be printed. You will usually go to the page layout Tab before printing worksheets.

The Formulas Tab contains controls for dealing with the most powerful aspect of Excel: formulas and functions. Here you can insert functions, search for errors in formulas and control the way in which Excel works with formulas and carries out calculations.

In the Data Tab you will find commands for importing information into Excel from sources such as databases; sorting information and also filtering (in other words returning data which matches certain criteria).

Here you'll also find advanced tools for consolidation, validating data and performing "What if?" analysis. Also, in the outline section, there are commands for assigning different levels to the different columns and rows of the worksheet. Excel's powerful outlining commands make large worksheet easier to manage and to navigate.

The general theme of the Review Tab is checking and protection. It is here that you will find the spell-checker, facilities for users to add comments to a worksheet and commands for protecting worksheets and workbooks.

The View Tab houses controls relating to the way in which your workbooks and worksheets are viewed on screen. It contains commands for zooming in and out on your work and for displaying several worksheets and workbooks simultaneously.

The Developer Tab relates to automation. It is here that you'll find commands for creating macros. Macros enable you to write Visual Basic code which can automate just about every aspect of Microsoft Excel.

Italian Article Marketing Directory: http://www.articolando.com

Author is a developer and trainer with Macresource Computer Solutions, an independent computer training company offering Microsoft Excel 2007 Classes at their central London training centre.





social bookmarking

Vota l'articolo

 

Not yet Rated

Clicca sulla icona XML per ricevere English Articles Via RSS!

realizzazione siti cagliari| creazione siti sardegna

Powered by Article Dashboard