Wiley 978-0-470-59160-4 Datenblatt

Stöbern Sie online oder laden Sie Datenblatt nach Software-Handbücher Wiley 978-0-470-59160-4 herunter. Wiley Excel Data Analysis Benutzerhandbuch

  • Herunterladen
  • Zu meinen Handbüchern hinzufügen
  • Drucken
  • Seite
    / 14
  • Inhaltsverzeichnis
  • LESEZEICHEN
  • Bewertet. / 5. Basierend auf Kundenbewertungen
Seitenansicht 0
2
2
3
1
Introducing Data
Analysis with Excel
T
his book is about using Microsoft Excel to
analyze your data. Microsoft Excel is an electronic
worksheet you can use to perform mathematical,
financial, and statistical calculations; create charts;
analyze your data with a PivotTable; maintain lists; 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 can use to enter information.
The most powerful feature in Excel is its 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 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.
Introducing Data Analysis with Excel
Open a New Workbook
1 Click the File tab.
A menu appears.
2 Click New.
3 Double-click Blank workbook.
Excel opens a new workbook.
03_591604-ch01.indd 203_591604-ch01.indd 2 5/25/10 12:34 PM5/25/10 12:34 PM
COPYRIGHTED MATERIAL
Seitenansicht 0
1 2 3 4 5 6 ... 13 14

Inhaltsverzeichnis

Seite 1 - COPYRIGHTED MATERIAL

2231Introducing Data Analysis with ExcelThis book is about using Microsoft Excel to analyze your data. Microsoft Excel is an electronic worksheet you

Seite 2 - Excel Window

11Chapter 1: Getting Started5768 The Microsoft Excel Web App opens.7 Create your document.8 Click a path location. Exit the file. You do not need

Seite 3 - Explore

121221Enter Numbers1 Click in a cell.2 Type the number.3 Press Enter. Excel enters the number and then moves down to the next cell. Alternatively

Seite 4 - Using the Mini Toolbar

13Chapter 1: Getting Started13212Enter Dates1 Click in a cell.2 Type the date.3 Click on the formula bar. Excel enters the date. Alternatively,

Seite 5 - Select Options on

14112Select Contiguous Cells1 Click the first cell.2 Drag to the last cell. Alternatively, click the first cell, hold down the Shift key, and then

Seite 6 - Backstage View

15Chapter 1: Getting Started12342You can easily select all cells with formulas, comments, conditional formatting, constants, or data validation. Click

Seite 7 - Web-based Application

3Chapter 1: Getting StartedB QUICK ACCESS TOOLBARPlace commands you use often on the Quick Access Toolbar.A FILE TABClick the File tab to open, save,

Seite 8

4A TabsTabs appear across the top of the Ribbon and contain groups of related commands. The File tab provides access to the Backstage view in all Offi

Seite 9 - Create a File Using Excel’s

5Chapter 1: Getting Started12 Excel executes the command.• In this example, Excel applies a fill.1 Right-click. The Mini toolbar and context menu

Seite 10

621• Selected options appear on the status bar. Some options only appear when appropriate.1 Right-click the status bar. A list of options appears.

Seite 11 - Enter Text

7Chapter 1: Getting Started21 The Backstage view options appear.2 Click an option to select it.• Excel opens the option’s pane.1 Click the File ta

Seite 12 - Enter Numbers as Text

895846327 The Connecting to docs.live.net dialog box appears.7 Type your e-mail address.8 Type your password.9 Click OK.1 Sign-up for a SkyDrive

Seite 13 - 2 Drag to the last cell

9Chapter 1: Getting Started$0!#@%You can sign in to SkyDrive from Excel. Click the File tab. A menu appears. Click Share. The Share Pane appears. In t

Seite 14 - Select Noncontiguous Cells

10243 You move to the folder.3 Click New. A menu appears.4 Click Microsoft Excel workbook.1 Sign in to SkyDrive.2 Click the folder where you wan

Kommentare zu diesen Handbüchern

Keine Kommentare