Wiley Microsoft Office Excel 2007 Data Analysis 978-0-470-13229-6 Manuale Utente

his book is about using Microsoft Excel to
analyze your data. Microsoft Excel is an electronic
worksheet you can use to maintain lists; perform

mathematical, financial, and statistical calculations; create
charts; analyze your data with a PivotTable; and much
more. Excel can help you locate data, find trends in your
data, and present your data to others.
Each Excel file is a workbook. Each workbook can have
multiple worksheets. Worksheets are made up of rows
and columns of cells you use to enter information. One
of the many useful features of Excel is the ability to
calculate. When you enter a formula into Excel, Excel can
automatically calculate the result, and when you make
changes to your worksheet, Excel can automatically
recalculate.
You can also use Excel to create charts. A chart is a
graphical representation of your data. When using Excel,

you can choose from several types of charts, including
Column, Line, Pie, Bar, Area, and Scatter. Charts can
make your data easier to read, easier to understand, and
easier to compare.
A PivotTable is an interactive worksheet table you can
use to analyze data. A PivotTable gives you an easy way
to summarize and view large amounts of data. Using a
PivotTable, you can rotate rows and columns of data so
you can see different views of your data easily. You can
use Excel to create PivotTables.
Excel provides a way for you to create and maintain lists.
A list is a series of rows and columns. Each column has a
label — for example, name, address, telephone number.
Each row under a column has information pertaining to
the column label. You can sort, filter, and analyze your
lists in Excel.

1

Click the Office button.

A menu appears.

2

Click New.

2

1

3

The New Workbook dialog box appears.

3

Double-click Blank Workbook.

Excel opens a new workbook.

04_132296 ch01.qxp  5/24/07  12:53 PM  Page 2