书籍详情
Excel 数据分析：Visual Blueprint 数据分析、图表与数据透视表（第2版）
作者：Jinjer Simon 著
出版社：John Wiley & Sons
出版时间：2005-12-01
ISBN：9780764597800
定价：¥243.63
购买这本书可以去
内容简介
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
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
猜您喜欢
