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
Eventually we want to get to commands that we use.
From the Ribbon the sequence is
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 |