EXCEL 2007 versus EXCEL 2003 and
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, the user interface for Excel 2007 is much different from
that in earlier versions. In particular
The office button is at the
top left-hand corner of the Ribbon.
It replaces the File Menu of earlier versions of Office and Excel.
It is used to Open, Save, Print and Close files.
The commands are organized by Tab and Group.
At the highest level is the Ribbon for each Tab.
Here this is is shown for the Home Tab.
Eventually we want to get to commands that we use.
From the Ribbon the sequence is
For a two-page document showing the Office Button and the Ribbons
for the seven Tabs click here.
WITHIN THE TAB (and Selected Commands within Group)
||1Home.gif||Clipboard (cut, paste, ....)
|Font (font type, font size,
|Number ($, %, decimal places,
|Styles (for tables, cells)
|Cells (insert and delete cell(s)
or rows or columns)
|Editing (find, replace, ....)
|Illustration (picture, clip art,
(column, line, pie, scatter, ....)
|Text (insert text box, object,
symbol, word art, ....)
Page Layout Tab
||3Pagelayout.gif||Themes (select colors, fonts, ... for the entire document)|
|Page Setup (margins,
orientation, background, ....)
|Scale to Fit (scale or number of
|Sheet options (gridlines,
||Function library (sum, financial, math, statistical (in more), ....)|
External Data (from text, web, ....)
|Sort and Filter (sort worksheet
|Data tools (text to columns)
(Data Analysis Add-in for histogram, descriptive statistics,
||6Review.gif||Proofing (spellcheck, ....)
|Changes (track worksheet
||7View.gif||Workbook Views (normal, page
|Show / Hide (gridlines, ....)
|Zoom (zoom level for screen
display of worksheet cells)
|Windows (arrangements for