Data Analysis with Microsoft Excel: Updated for Office 2007

Chapter 1 Getting Started with Excel 9

1 Press CTRL+n to create a new blank document.

I Click the Copy button from the Clipboard group on the Home tab

to copy the contents of the active cell.

If you are asked to run a command using a keyboard shortcut, the keyboard

combination will be shown in boldface with the keys joined by a plus sign to

indicate that you should press these keys simultaneously. For example,

In addition to the Excel ribbon, you may occasionally see context-

sensitive ribbons. These ribbons only appear when certain items are selected

in the Excel document. For example, when you select an Excel chart, Excel

will display a Chart ribbon containing a collection of tabs and tab groups

designed for use with charts.

Formulas Used to insert formulas into a worksheet
and to audit the effects of your formulas
on cells values

Function Library, Defi ned
Names, Formula Auditing,
Calculation
Data Used to import data from different data
sources and to group data values and
perform what-if analysis on data

Get External Data,
Connections, Sort & Filter,
Data Tools, Outline
Review Used to proof the contents of a workbook
and to manage the document in a workgroup
environment involving several users

Proofi ng, Comments, Changes

View Controls the display of the Excel
worksheet window including the ability
to hide or display Excel elements

Workbook Views, Show/

Hide, Zoom, Window, Macros

Develop Contains tools used to add macros and other
features to extend the capabilities of Excel

Code, Controls, XML

Add-Ins Contains user-defi ne menus and tab
groups created from add-ins (note that this
tab will only appear when an add-in has
been installed and activated.)

various groups depending

upon the add-ins being used.

Each tab is broken up into different topical groups. For example the Home

tab is broken into the following groups: Clipboard, Font, Alignment, Number,

Styles, Cells, and Editing. When you are asked to run a command, you will

be told which button to click from which tab group. For example, to copy the

contents of a worksheet cell you would be given the following command: