EXCEL 2007: The Microsoft Office 2007 Interface

A. Colin Cameron, Dept. of Economics, Univ. of Calif. - Davis

This January 2009 help sheet gives a very brief overview of the MS Office 2007 Interface for Excel 2007.

EXCEL 2007 versus EXCEL 2003 and earlier

For basic data analysis using the Data Analysis Toolpack, such as descriptive statistics and regression, versions of Microsoft Excel from 1997 on are adequate.

However

However, the user interface for Excel 2007 is much different from that in earlier versions. In particular

EXCEL 2007 INTERFACE

The following website
Microsoft Office Online Training: Up to speed with Excel 2007
is quite helpful and is the basis for the summary given below.

At the highest level is the Ribbon

Microsoft Office Excel 2007 ribbon

Eventually we want to get to commands that we use.
From the Ribbon the sequence is

  1. Tabs:
    -
    The seven tabs are Home, Insert, Page Layout, Formulas, Data, Review, View.
    - The above example uses the Home tab.
  2. Groups:
    -
    These show related items together.
    - For example, there is the Font group (within the Home tab).
  3. Commands
    - A command is a button, a box to enter information, or a menu.
    - For example, there is the B button (in the Font group in the  Home tab) to make text bold.
    - The Dialog Box launcher is a small arrow that gives additional commands (e.g. at bottom right of the Font group).
THE RIBBON FOR EACH OF THE SEVEN TABS

For each of the seven tabs the Ribbon looks as follows on my computer
(the look of the ribbon varies with screen resolution and with the active Excel document).

   TAB
RIBBON
COMMANDS AND METHODS INCLUDE
1. Home
1Home.pdf Formatting, Cut and Paste, Find
2. Insert
2Insert.pdf Tables and Charts and Text
3. Page Layout
3Pagelayout.pdf Page Setup
4. Formulas
4Formulas.pdf
Functions such as AVERAGE and SUM
5. Data
5Data.pdf
Get External Data and Data Analysis
6. Review
6Review.pdf Proofing
7. View
7View.pdf

The Insert, Formulas and Data tabs are especially useful for data analysis.

For further information on how to use Excel go to
   http://cameron.econ.ucdavis.edu/excel/