Pages

Wednesday, February 2, 2011

Excel 2010's Features | Home Ribbon |






The Home Ribbon has many buttons with magnitudes of features and functions.  In this post, I'm going to label the individual buttons in the Home
Ribbon and give a short description of their uses.

Clipboard and Font Explained | Excel 2010
<<<<<<<<<<CLIPBOARD>>>>>>>>

Paste: Its a feature that every computer user likes to use; paste is used in conjunction with the copy function to add similar data to another part of a spreadsheet.

The Scissors Icon: The CUT button.  This is basically used to move data from one cell to another.  The data is not copied but it is basically removed and added to another portion of the spreadsheet.

The Paint Brush: This icon is responsible for copying the formatting of a cell or a group of cells to another portion of the spreadsheet.

<<<<<<<<<<<Font>>>>>>>>>>>>

B: Anytime text is highlighted and bold (B) is pressed the text basically becomes Darker or "FATTER". Eg.  BOLD TEXT, NOT BOLD TEXT

I: Italics basically gives the text a slant to the right. Eg. Italised Text, Non Italised Text

U: The 'U' stands for Underline.  Anytime text is highlighted and the underline tool is clicked it automatically underlines the text ( Pretty self explanatory)

Many Tools are located in the FONT section.  Simply highlighting any text and clicking on an icon can provide many formatting options.  Options include changing the font size, color, font style and even cell borders.

Monday, January 31, 2011

Excel 2007 user interface and features

Excel 2010 user interface introduces us to the all new ribbon feature.  The ribbon is basically a "ribbon like" user interface design that makes excel functions and  workflows easier.  The ribbon feature  debuted in Microsoft Excel 2007 and it has since been very helpful in improving workflow and the general ease of use of Excel.


The ribbon is basically a conglomeration of 'ribbons'.  From the image above, it is easy to locate the ribbons in the excel interface. 
  • Home : Basically the main ribbon button






  • Insert : The name explains it ( This ribbon basically opens up a new set of options for inserting various media and formatting

  • Page Layout : Options for restructuring your excel worksheet . eg. landscape vs. portrait page design.

  • Formulas : A preview of Excel's formulas.  You can automatically add formulas and functions directly to your worksheet with little or no code.

  • Data: Organize sort and edit your spreadsheet data

  • Review: Options in this tab include protecting your workbook, spelling and grammar check and also commenting.

  • View: The name says it all, view,zoom, rearrange and simply play around with your excel spreadsheet.

  • Add-ins: You can add custom applications and options to this tab; in order to extend Excel 2010's functionality.

 An indepth look of the ribbons and their buttons would be included in the next posts