Microsoft Excel 2007: Ribbons And Tabs
by: AndrewWhiteman |
Total views: 3 |
Word Count: 465 |
View PDF | Print View
Share This Article
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 frequently used commands. Here you'll find the commands that are used all the time; commands related to the clipboard such as Cut Copy and Paste; commands for formatting the data within your cells; changing the font; changing the alignment and the appearance of numbers; commands for modifying cells such as inserting rows and columns; and finally commands for sorting and editing data.
The Insert Tab, as the name suggests, is used to add or insert elements into your worksheets. Some of these elements are part and parcel of Excel such as charts; other elements need to be inserted from outside the program like images, for example, adding a company logo to an Excel form.
The Page Layout Tab contains commands to control the appearance of your worksheets as a whole. Here, you'll find settings like the margins, orientation, the size of paper and the area of the worksheet to be printed. You will normally visit the page layout Tab before printing your worksheets.
The Formulas Tab contains commands for dealing with the most powerful aspect of Excel: formulas and functions. Here you can insert functions, track down errors in formulas and control the way in which Excel deals with formulas and carries out its 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 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.
Share This Article
Rating: Not yet rated Next Article - WOW - Free Video Lessons on PowerPoint and Previous Article - The Threat of Spyware: Devouring Your System and Your Privacy
About the Author
The writer of this article is a developer and trainer with Macresource Computer Solutions, a UK IT training company offering Microsoft Excel 2007 Classes at their central London training centre.
Comments
No comments posted.Add Comment
Popular Articles about: Software
1: Viagra2: Adobe Illustrator: Getting Past The Blank Canvas
3: Enhance Your Web Pages With Dreamweaver's Javascript Behaviors
4: How to use a poker software
5: MyCafeCup.com launched new AIO Internet Cafe Software + WiFi HotSpot Gateway Billing.
6: The Easy Way To Write An E-book
7: How to convert swf to Avi, iPod, iPhone, PSP, Zune
8: Optimize Your PC With Registry Cleaner
9: A new version of contextual German-English and English-German dictionary TranslateIt! for Windows
10: Pre-packaged vs. Custom Software
11: Getting Rid Of The This Nasty Philippine Made Virus
12: DOCUMENT SCANNING STORAGE of RECORDS DIGITIZING ARCHIVING PAPERLESS OFFICE NYC.
13: Your Reaction to the Idea of Paying Students
14: Using Personal Computers to Solve Humanitarian Problems
15: Find Home Renovation Software
16: The Story of Finding Longitude: It Was All a Question of Timing
17: Choosing the Turnkey Software for your Business
18: Tokenless Two Factor Authentication Ensures Secure Remote Access
19: The Way People Communicate Has Changed Over Time
20: Management Software To Drive Your Bottom Line
21: Windows Vista Ultimate OEM Software
22: How To Safely Clean Windows Registry
23: Commercial Driver’s License CDL Manual
24: Does iBuzzPro Automatic Recruiter Software Actually Work?
25: How To Use Article Marketing For Free Unlimited Traffic
26: Big Ticket to Wealth Retail Store-- Is It Worth A Visit?
27: Don't Buy a Myspace Friend Adder: Compare Consumer Ratings First
28: Multiple Streams of Income...Surefire Way to Success
29: How to find an email address easily
30: Cleaning Your Windows Registry Effectively