Having trouble finding the Excel features you're used to in the new Microsoft Office Excel 2007 "Ribbon" interface? If you are, maybe this can help. The following index is a fairly complete list (we hope!) of the tabs and the main sections grouped below each tab in the Excel 2007 Ribbon.

Note that where a "flyout" icon is shown in the bottom-right corner of a sub-section, clicking it will popup a small window with more options/features. I put an asterisk (*) next to those sections which have one of these "more options" buttons.

• Office Button (round button on top-left corner)
  New, Open, Save, Save As (incl. 97-2003 format), Print (incl. print preview), Prepare, Send (email, fax), Publish, Close, Excel Options.
• Home
  • Clipboard *
    Cut/Copy/Paste and Format Painter.
  • Font *
    Font family, Size, Bold, Italic, Underline, Cell Borders, Fill Color, Font Color.
  • Alignment *
    Vertical alignment, Justification (left/right/center/full), Text Orientation, Wrap Text, Merge & Center cells.
  • Number *
    Cell formatting (drop-down for most common types), Accounting format ($), Percent style (%), Comma style, increase/decrease Decimal.
  • Styles
    Conditional formatting, Format as Table, Cell Styles.
  • Cells
    Insert, Delete, Format.
  • Editing
    Sort & filter, Find & select, Sum, Fill, Clear.
• Insert
  • Tables
    PivotTable (& PivotChart), Table.
  • Illustrations
    Insert Picture, Clip Art, Shapes, SmartArt.
  • Charts *
    Chart types: Column, Line, Pie, Bar, Area, Scatter, Other Charts.
  • Links
    Hyperlink.
  • Text
    Test Box, Header & Footer, WordArt, Signature Line, Object, Symbol.
• Page Layout
  • Themes
    Themes, Colors, Fonts, Effects.
  • Page Setup *
    Margins, Orientation, Size, Print Area, Breaks, Background, Print Titles.
  • Scale to Fit *
    Width (pages), Height (pages), Scale (%).
  • Sheet Options *
    Gridlines (view/print), Headings (view/print).
  • Arrange
    Bring to front, Send to back, Selection Pane, Align, Group, Rotate.
• Formulas
  • Function Library
    Incert Function, AutoSum, Recently Used, Financial, Logical, Text, Date & Time, Lookup & reference, Math & Trigonometry, More Functions.
  • Defined Names
    Name Manager, Define a Name, Use in Formula, Create from Selection.
  • Formula Auditing
    Trace Precedents, Trace Dependents, Remove Arrows, Show Formulas, Error Checking, Evaluate Formula, Watch Window.
  • Calculation
    Calculation Options, Calculate Now, Calculate Sheet.
• Data
  • Get External Data
    From Access, From Web, From Text, From Other Sources, Existing Connections.
  • Connections
    Refresh All, Connections, Properties, Edit Links.
  • Sort & Filter
    A-Z, Z-A, Sort, Filter, Clear, Reapply, Advanced.
  • Data Tools
    Text to Columns, Remove Duplicates, Data validation, Consolidate, What-If Analysis
  • Outline *
    Group, Ungroup, Subtotal, Show Detail, Hide Detail.
• Review
  • Proofing
    Spelling, Research, Thesaurus, Translate.
  • Comments
    New Comment, Delete/Previous/Next, Show/Hide Comment, Show All Comments, Show Ink.
  • Changes
    Protect Sheet, Protect Workbook, Share Workbook, Protect & Share Workbook, Allow Users to Edit Ranges, Track Changes.
• View
  • Workbook Views
    Normal, Page Layout, Page Break Preview, Custom Views, Full Screen.
    (Page Layout shortcuts are always visible at bottom-right corner, next to Zoom slider.)
  • Show/Hide
    Ruler, Gridlines, Message Bar, Formula Bar, Headings.
  • Zoom
    Zoom, 100%, Zoom to Selection.
    (Zoom slider always visible at bottom-right corner, next to page layout)
  • Window
    New window, Arrage All, Freeze Paanes, Split, Hide, Unhide, View Side-by-Side, Synchronous Scrolling, Reset Window Position, Save Workspace, Switch Windows.
  • Macros
    (View, Record, Use Relative References)
• Developer (optional tab - activate from Office Button -> "Excel Options")
  • Code
    Visual Basic, Macros, Record Macro, Use Relative References, Macro Security.
  • Controls
    Insert (Form Controls, ActiveX Controls), Design Mode, Properties, View Code, Run Dialog.
  • XML
    Source, Map Properties, Expansion Packs, Refresh Data, Import, Export.
  
  
• There are also Context Sensitive Tabs which will vary depending on what you're doing
  (ie. click on a Chart object, and Design, Layout, and Format tabs will appear to customize the selected Chart).

More resources:

Interactive Excel 2003 to Excel 2007 command reference guide
(a flash demo which shows the Excel 2003 UI, clicking a function brings up an overlay with the 2007 UI (aka "Ribbon") and shows where the feature you clicked is located:
http://office.microsoft.com/en-ca/help/HA101491511033.aspx

From this page, similar guides exist for the other Office 2007 applications:
http://office.microsoft.com/en-ca/training/HA102295841033.aspx

A Flash tour of the Excel 2007 interface:
http://h30187.www3.hp.com/tutorials/viewHowTo/p/courseId/14760

Hope that helps!

Questions? Suggestions? Contact Us.