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
鄂公網(wǎng)安備 42010302001612號(hào) 