Excel 数据分析：Visual Blueprint 数据分析、图表与数据透视表 第2版EXCEL DATA ANALYSIS
点此进入淘宝搜索页搜索分类: 图书,计算机/网络,家庭与办公室用书,微软Office ,
作者： Jinjer Simon 著
出 版 社： John Wiley & Sons
出版时间： 2005-12-1字数：版次： 1页数： 291印刷时间： 2005/12/01开本：印次：纸张： 胶版纸I S B N ： 9780764597800包装： 平装内容简介
Excel Data Analysis 2nd Edition
Welcome to the only guidebook series that takes a visual approach to professional-level computer topics. Open the book and you'll discover step-by-step screen shots that demonstrate over 100 key Excel data analysis techniques, including:
Creating PivotTables and PivotCharts
Importing and linking data
Compiling data from various sources
Filtering a list
Creating an amortization table
Manipulating data within a chart
Editing external database tables
Using an Excel function in a macro
Building PivotTable formulas
Using Analysis Toolpak add-ins
High-resolution screen shots demonstrate each task
Succinct explanations walk you through step by step
Two-page lessons break big topics into bite-sized modules
"Apply It" and "Extra" sidebars highlight useful tips
目录
HOW TO USE THIS BOOK
1 GETTING STARTED WITH EXCEL
Excel Data Analysis Options
Excel Data Types
Locate a Value in a Worksheet
Select a Range of Cells
Name a Range
Create Label Ranges
Modify Named Ranges
Copy and Paste a Range of Cells
Create a Custom Number Format
Apply AutoFormat to a Worksheet
Create a Named Style
Create a Custom Template
Protect Worksheets
2 ORGANIZE WORKSHEET DATA
Create a List
Add a Series to a List
Sort a List
Create a Custom Sort
Consolidate Data
Outline Your Data
3 EVALUATE WORKSHEET DATA
Apply Conditional Formatting
Summarize Data with Subtotals
Filter a List
Create a Custom Filter
Create an Advanced Filter
Create Scenarios
Validate Data
4 CREATING FORMULAS
Sum Cells with the AutoSum Button
Add a Function via the Insert Function Dialog Box
Edit Formulas
Evaluate a Formula
Using Solver to Produce Specific Values
Create a Conditional Formula
Solve a Formula with a Data Table
Trace a Formula Error
Lookup a Value in a Specific Row and Column
Determine the Location of a Value
Return a Value at a Specific Location in a Data List
Rank a Value within a Data List
Create an Amortization Table for a Loan
5 WORKING WITH EXTERNAL DATA
Link Data to Other Windows Programs
Import a Delimited Text File
Divide a Column into Multiple Columns
Create a Web Query
Import a Database Table
Using Queries to Screen External Databases
Find the Average of a Database Range
Save for Web
6 CHART DATA
Chart Basics
Modify a Chart Type
Explode Slices of a Pie Chart
Create a Custom Chart Type
Add a Trendline to a Chart
Add or Change New Data to a Chart
Create a Chart with Multiple Chart Types
7 WORKING WITH PIVOTTABLE REPORTS
PivotTable Basics
A View of the PivotTable Report Fields
Create a PivotTable Report from an Excel List
Change the Layout of a PivotTable
Filter a Field
Change the Calculation of a Data Field
Group PivotTable Data Items
Add Another Data Area Calculation
Add a Calculated Field
Add a Calculated Item
Retrieve a Value from a PivotTable Report
8 CREATING PIVOTCHARTS
9 AUTOMATING ACTIONS WITH MACROS
10 USING FORMS AND DIALOG BOXES
11 USING THE ANALYSIS TOOLPACK ADD-INS
APPENDIX A: EXCEL KEYBOARD SHORTCUTS
APPENDIX B: EXCEL FUNCTION QUICK REFERENCE
APPENDIX C: VBA AND EXCEL EVENTS QUICK REFERENCE
APPENDIX D: FORMULA BASICS IN EXCEL
APPENDIX E: WHAT'S ON THE CD-ROM
INDEX
