Excel 数据分析：Visual Blueprint 数据分析、图表与数据透视表 第2版EXCEL DATA ANALYSIS

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