书籍详情

Excel 数据分析:Visual Blueprint 数据分析、图表与数据透视表(第2版)

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
猜您喜欢

读书导航