The Home Ribbon, the very first of the standard ribbons, consist mainly of functions that are available to you when you select Format or Edit in the Menu bar.
Here is a detailed coverage of the ribbon:
It is used primarily for formating cells similar to the functions you find when you click on Menu -> Format, Menu -> edit in the previous version or when you click on the right mouse button within the worksheet, in Excel 2007 and previous version of Excel. See below for get a better picture of how the Home Ribbon is organised:/P>
The style group contains 3 elements which are usually neglected by the average users.
Conditional formating - to automatically format the cell(s) to a different color when certain conditions are met.
Format Table - to format the data in your worksheet into a table
Style - to capture and store cell format settings so that it could be re-used by other cells or ranges. This function is similar to MS Word style formating (e.g. HEADING 1, normal, etc).
Summation button to generate a simple sum, average, count, max or min formula.
Activate the fill series function.
Clear the cell contents
Sort and filter the list
Find, select, goto and goto special functionsLesson 01: Why learn Excel 2007?