Excel Data Analysis

Name: Excel Data Analysis | Your visual blueprint for creating and analyzing data, charts and PivotTables
Brand: Visual
Price: 20.99 EUR
Availability: OnlineOnly

Your visual blueprint for creating and analyzing data, charts and PivotTables

Denise Etheridge(Autor*in)

Visual (Verlag)

3. Auflage

Erschienen am 1. Juni 2010

368 Seiten

E-Book

PDF mit Adobe-DRM

Systemvoraussetzungen

978-0-470-90172-4 (ISBN)

20,99 €inkl. 7% MwSt.

Systemvoraussetzungen

für PDF mit Adobe-DRM

E-Book Einzellizenz

Als Download verfügbar

Beschreibung

Weitere Details

Weitere Ausgaben

Person

Inhalt

Excel® Data Analysis: Your visual blueprintT for creating and analyzing data, charts, and PivotTables, 3rd Edition
TABLE OF CONTENTS
Chapter 1: Getting Started
Introducing Data Analysis with Excel
Tour the Excel Window
Explore the Ribbon
Using the Mini Toolbar and Context Menu
Select Options on the Status Bar
Take a Look at Backstage View
Upload a File to Excel's Web-based Application
Create a File Using Excel's Web-based Application
Enter Data
Select Cells
Chapter 2: Formatting a Worksheet
Using the Ribbon to Format Numbers
Using the Format Cells Dialog Box
Understanding Dates and Times
Format Percentages
Format Fractions
Format in Scientific Notation
Format as Text
Add a Border
Change the Font or Font Size
Add a Background Color
Change the Font Color
Bold, Underline, or Italicize
Align Data
Rotate Data
Wrap Text
Merge and Center
Apply a Style
Using Format Painter
Clear Formats
Chapter 3: Structuring Your Workbook
Cut, Copy, and Paste Cells
Using Live Preview with Paste
Paste from the Office Clipboard
Insert or Delete
Find and Replace Information
Change the Name of a Worksheet
Change Column Widths or Row Heights
Hide Columns or Rows
Hide a Worksheet
Move or Copy a Worksheet
Freeze Worksheet Titles
Hide Gridlines, Headings, or the Formula Bar
Chapter 4: Creating Formulas
Understanding Formulas
Calculate with an Operator
Calculate Using a Function and Cell Addresses
Create an Array Formula
Using the Sum, Average, Count, Min, and Max Functions
Create a Formula that Refers to Another Worksheet
Understanding Relative and Absolute Cell Addresses
Edit Formulas
Name Cells and Ranges
Define and Display Constants
Create Formulas That Include Names
Check Formulas for Errors
Trace Precedents and Dependents
Chapter 5: Using Functions
Understanding the Function Wizard
Round a Number
Create a Conditional Formula
Calculate a Conditional Sum
Calculate a Conditional Count
Find the Square Root
Retrieve Column or Row Numbers
Using VLOOKUP
Determine the Location of a Value
Using INDEX
Perform Date and Time Calculations
Chapter 6: Using Financial Functions
Calculate Future Value
Calculate Present Value
Calculate Loan Payments
Calculate Principal or Interest
Calculate the Interest Rate
Calculate the Internal Rate of Return
Calculate Straight-Line Depreciation
Calculate Declining Balance Depreciation
Calculate Double-Declining Balance Depreciation
Calculate Sum-of-the-Years-Digits Depreciation
Chapter 7: Using Statistical Functions and Tools
Calculate an Average
Calculate a Conditional Average
Calculate the Median or the Mode
Calculate Rank
Determine the Nth Largest Value
Calculate Frequency
Calculate Variance and Standard Deviation
Find the Correlation
Install Excel Add-Ins
Calculate a Moving Average
Compare Variances
Using the Data Analysis Toolpak to Determine Rank and Percentile
Calculate Descriptive Statistics
Chapter 8: Organizing Worksheet Data
Enter Data with a Form
Perform Simple Sorts and Filters
Perform Multilevel Sorts
Perform a Custom Sort
Sort by Cell Color, Font Color, or Cell Icon
Perform Complex Filters
Enter Criteria to Find Records
Using Advanced Filtering Techniques
Filter Duplicate Records
Count Filtered Records
Subtotal Records
Using Auto Outline
Define Data as a Table
Modify a Table Style
Using Database Functions with a Table
Chapter 9: Working with PivotTables
Create a PivotTable
Modify a PivotTable Layout
Summarize PivotTable Values
Create a PivotTable Calculated Field
Group the Rows or Columns in a PivotTable
Apply a Style to a PivotTable
Filter a PivotTable
Sort a PivotTable
Retrieve Values from a PivotTable
Using Slicer
Chapter 10: Charting Data
Create a Chart
Add Chart Details
Create a Combination Chart
Change the Chart Type
Add or Remove Chart Data
Add Sparklines
Create a Trendline
Add Error Bars
Create a Histogram
Chart Filtered Data
Create a PivotChart
Filter a PivotChart
Chapter 11: Working with External Data
Paste Link into Word
Embed a Worksheet
Hyperlink a Worksheet
Query a Web Site
Import a Text File
Import an Access Database
Query an Access Database
Chapter 12: Using Data Analysis Tools and Techniques
Perform What-If Analysis
Optimize a Result with Goal Seek
Using Solver
Solve a Formula with a Data Table
Extend a Series with Auto Fill
Join Text
Add a Calculator
Consolidate Worksheets
Highlight Cells that Meet Your Criteria
Find the Highest or Lowest Ranked Values
Add Data Bars to Your Worksheet
Add Icon Sets to Your Worksheet
Remove Conditional Formatting
Change Conditional Formatting Rules
Paste with Paste Special
Chapter 13: Sharing Your Workbook with Others
Validate with a Validation List
Validate with Data Entry Rules
Add Comments to Your Worksheet
Track Changes
Protect Your Worksheet
Save Your Workbook as a Template
Choose a Format When Saving a Workbook
Print Your Workbook
Print Multiple Areas of Your Worksheet
Chapter 14: Automating with Macros
Introducing Macros
Set Macro Security
Create a Digital Signature
Record a Macro
Assign a Digital Signature to a Macro
Run a Macro
Create and Launch a Keyboard Shortcut
Assign a Macro to the Quick Access Toolbar
Delete a Macro
Chapter 15: Illustrating Your Worksheets
Place a Screenshot in Your Worksheet
Insert Clip Art into Your Worksheet
Crop a Clip Art Illustration or a Photograph
Insert a Picture into Your Worksheet
Recolor a Picture
Adjust the Sharpness, Brightness, and Contrast
Compress a Picture
Add a Border
Add a Picture Effect
Apply a Picture Style
Add an Artistic Effect
Remove a Background
Chapter 16: Illustrating Your Ideas
Insert a Text Box
Format a Text Box
Insert a Shape
Add Text to a Shape
Change the Size of an Object
Rotate an Object
Change the Stacking Order
Group Objects
Align Objects
Insert a Symbol
Using SmartArt Graphics
Modify a SmartArt Graphic
Apply a SmartArt Style
Apply a SmartArt Layout
Chapter 17: Customizing Excel
Add a Form Control to a Worksheet
Assign Values to a Form Control
Add a Macro to a Form Control
Customize the Quick Access Toolbar
Customize the Ribbon
Appendix A: Using Excel Keyboard Shortcuts
Using Excel Keyboard Shortcuts
INDEX

Systemvoraussetzungen

Als PDF speichern Als Link merken