One of the greatest changes to Office 2007 is the introduction of ribbons rather than drop-down menus (really, you'll grow to love them). Click on an item in the ribbon bar (where it shows Home, Insert, Page Layout, etc.) to view the ribbon choices available under that item.
If you want to quickly learn where a menu item has been replaced to, visit the Where'd It Go article. This article contains clickable clicks from Excel 2007 to the equivalent features in Excel 2007.
The following shows the various ribbons available:
The Home ribbon is also the primary formatting ribbon. Select this item to apply most text formatting choices.
Use the Insert ribbon to.. insert things, such as pictures, tables, hyperlinks, text boxes, and other special items.
Use the Page Layout ribbon to specify page details such as orientation, size etc. as well as other paragraph options.
Use the Formulas ribbon to insert formulas, manage named ranges, audit formulas and access calculation options (a great new addition to Excel 2007!).
Use the Data ribbon to access data controls such as links, sorting, filtering, validation, grouping, subtotaling and more.
Use the Review ribbon to access proofing options, comments and worksheet/workbook protection options.
Use the View ribbon to select your document views, control window options and access Macro choices.
Use the Developer ribbon to access more macro and code controls..
If you like keyboard access to ribbons and ribbon choices but do not want to memorize a million combinations, press the Alt key. You can then use the arrow keys to move through the ribbon displays. In the following illustration, the Alt key was pressed at the Insert ribbon. Note the letter access to each ribbon: