<p>目录</p><p>CHAPTER 1: GETTING STARTED . . . . . . . . . . . . . . . . . . . . .2<br/>Introduction to Data Analysis with Excel ..............................................................2<br/>Understanding the Excel Window..........................................................................3<br/>Enter Data ............................................................................................................4<br/>Format Numbers....................................................................................................6<br/>Format Cells ........................................................................................................10<br/>Select Data ..........................................................................................................14<br/>Copy, Cut, and Paste Cells....................................................................................16<br/>Copy with the Office Clipboard ............................................................................18<br/>Insert and Delete Cells ........................................................................................20<br/>Find and Replace ................................................................................................22<br/>Find and Replace Formats ..................................................................................24<br/>CHAPTER 2: CREATING FORMULAS . . . . . . . . . . . . . . . . .26<br/>Understanding Formulas ....................................................................................26<br/>Create Formulas ..................................................................................................28<br/>Edit Formulas ......................................................................................................30<br/>Name Cells and Ranges ......................................................................................32<br/>Define and Display Constants ..............................................................................34<br/>Create Formulas that Include Names....................................................................36<br/>Check Formulas for Errors ..................................................................................38<br/>Trace Precedents and Dependents ........................................................................40<br/>CHAPTER 3: CREATING AND USING FUNCTIONS . . . . . .42<br/>Understanding the Function Wizard ....................................................................42<br/>Round a Number ................................................................................................44<br/>Determine the Nth Largest Value ........................................................................46<br/>Create a Conditional Formula ..............................................................................48<br/>Calculate a Conditional Sum ................................................................................50<br/>Calculate Products and Square Roots ..................................................................52<br/>Look Up Information ..........................................................................................54<br/>Determine the Location of a Value ......................................................................56<br/>Perform Time Calculations ..................................................................................58<br/>Perform Date Calculations....................................................................................60</p><p>CHAPTER 4: USING FINANCIAL FUNCTIONS . . . . . . . . . .62<br/>Calculate Future Value ........................................................................................62<br/>Calculate Present Value........................................................................................64<br/>Calculate Loan Payments ....................................................................................66<br/>Calculate Principal or Interest ..............................................................................68<br/>Calculate the Interest Rate ..................................................................................70<br/>Calculate the Internal Rate of Return ..................................................................72<br/>Calculate Straight-Line Depreciation ....................................................................74<br/>Calculate Declining Balance Depreciation ............................................................76<br/>Calculate Double-Declining Balance Depreciation ................................................78<br/>Calculate Sum-of-the-Years-Digits Depreciation ..................................................80<br/>CHAPTER 5: USING STATISTICAL FUNCTIONS<br/>AND TOOLS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .82<br/>Calculate an Average ..........................................................................................82<br/>Calculate the Median or the Mode........................................................................84<br/>Calculate Rank ....................................................................................................86<br/>Calculate Frequency ............................................................................................88<br/>Calculate Variance and Standard Deviation..........................................................90<br/>Find the Correlation ............................................................................................92<br/>Install Excel Add-Ins ..........................................................................................94<br/>Calculate a Moving Average ................................................................................96<br/>Compare Variances ..............................................................................................98<br/>Using the Data Analysis Toolpak to Determine Rank and Percentile ................100<br/>Calculate Descriptive Statistics ..........................................................................102<br/>CHAPTER 6: ORGANIZING WORKSHEET DATA . . . . . . .104<br/>Enter Data with a Form ....................................................................................104<br/>Filter Duplicate Records ....................................................................................106<br/>Perform Simple Sorts and Filters ......................................................................108<br/>Perform Complex Sorts ......................................................................................110<br/>Sort by Cell Color, Font Color, or Icon ................................................................112<br/>Perform Complex Filters ....................................................................................114<br/>Enter Criteria to Find Records............................................................................116</p><br/><br/><br/><br/>