Excel 数据分析：Visual Blueprint 数据分析、图表与数据透视表（第2版）

定　价：¥243.63

作　者：	Jinjer Simon 著
出版社：	John Wiley & Sons
丛编项：
标　签：	暂缺

购买这本书可以去

当当网 (¥192.50)

ISBN：	9780764597800	出版时间：	2005-12-01	包装：	平装
开本：		页数：		字数：

内容简介

　　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

作者简介

暂缺《Excel 数据分析：Visual Blueprint 数据分析、图表与数据透视表（第2版）》作者简介

图书目录

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