Free Articles at Neutron Marketing Article Publishing and Distribution » Computers-and-technology » Software » Microsoft Excel 2007: Ribbons And Tabs
Previous Article - Spyware: Destroying Your Computer System and Your Privacy At Once
Next Article - MS SQL Server Versions

View PDF | Print View | Html Version
by: AndrewWhiteman
Total views: 2
Word Count: 458

The Microsoft Excel 2007 Ribbon is the most vital part of the Microsoft Excel interface and contains the majority of the program's features. 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 divided in groups: the name of each group is shown at the bottom of that group.

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 has commands for controlling the appearance of your worksheets as a whole. Here you'll find margins, orientation, paper size and the area of the worksheet to be printed. You will normally use the page layout Tab before you print your 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 data validation tools, tools for consolidation and for performing "What if?" analysis. Also, in the outline group, you will find commands for assigning different levels to different rows and columns of the worksheet. These outline commands make large worksheet easier to navigate and to manage.

The principal theme of the Review Tab is checking and protection. It is here that you will find Excel's spell-checker, commands enabling users to add comments to a worksheet and options for protecting both worksheets and workbooks.

The View Tab contains controls relating to the way in which your workbooks and worksheets are viewed. Here you'll find commands for zooming in and out on your work and for working with multiple worksheets and workbooks simultaneously.

The Developer Tab is all about automation. It is here that you'll find commands for creating macros. Macros are Visual Basic code which can be written to automate just about any aspect of Microsoft Excel.

About the Author

The The writer of this article is a training consultant with Macresource Computer Solutions, a UK IT training company offering Microsoft Excel 2007 training courses at their central London training centre.

---

Rating: Not yet rated

--Choose-- 0 1 2 3 4 5

No comments posted.

Add Comment

Enter the code shown