| |
| |
| |
| Getting Started | |
| |
| |
| Introduction to Data Analysis with Excel | |
| |
| |
| Understanding the Excel Window | |
| |
| |
| Enter Data | |
| |
| |
| Format Numbers | |
| |
| |
| Format Cells | |
| |
| |
| Select Data | |
| |
| |
| Copy, Cut, and Paste Cells | |
| |
| |
| Copy with the Office Clipboard | |
| |
| |
| Insert and Delete Cells | |
| |
| |
| Find and Replace | |
| |
| |
| Find and Replace Formats | |
| |
| |
| |
| Creating Formulas | |
| |
| |
| Understanding Formulas | |
| |
| |
| Create Formulas | |
| |
| |
| Edit Formulas | |
| |
| |
| Name Cells and Ranges | |
| |
| |
| Define and Display Constants | |
| |
| |
| Create Formulas that Include Names | |
| |
| |
| Check Formulas for Errors | |
| |
| |
| Trace Precedents and Dependents | |
| |
| |
| |
| Creating and Using Functions | |
| |
| |
| Understanding the Function Wizard | |
| |
| |
| Round a Number | |
| |
| |
| Determine the Nth Largest Value | |
| |
| |
| Create a Conditional Formula | |
| |
| |
| Calculate a Conditional Sum | |
| |
| |
| Calculate Products and Square Roots | |
| |
| |
| Look Up Information | |
| |
| |
| Determine the Location of a value | |
| |
| |
| Perform Time Calculations | |
| |
| |
| Perform Date Calculations | |
| |
| |
| |
| Using Financial Functions | |
| |
| |
| Calculate Future Value | |
| |
| |
| Calculate Present Value | |
| |
| |
| Calculate Loan Payments | |
| |
| |
| Calculate Principal or Interest | |
| |
| |
| Calculate the Interest Rate | |
| |
| |
| Calculate the Internal Rate of Return | |
| |
| |
| Calculate Straight-Line Depreciation | |
| |
| |
| Calculate Declining Balance Depreciation | |
| |
| |
| Calculate Double-Declining Balance Depreciation | |
| |
| |
| Calculate Sum-of-the-Years-Digits Depreciation | |
| |
| |
| |
| Using Statistical Functions and Tools | |
| |
| |
| Calculate an Average | |
| |
| |
| Calculate the Median or the Mode | |
| |
| |
| Calculate Rank | |
| |
| |
| Calculate Frequency | |
| |
| |
| Calculate Variance and Standard Deviation | |
| |
| |
| Find the Correlation | |
| |
| |
| Install Excel Add-Ins | |
| |
| |
| Calculate a Moving Average | |
| |
| |
| Compare Variances | |
| |
| |
| Using the Data Analysis Toolpak to Determine Rank and Percentile | |
| |
| |
| Calculate Descriptive Statistics | |
| |
| |
| |
| Organizing Worksheet Data | |
| |
| |
| Enter Data with a Form | |
| |
| |
| Filter Duplicate Records | |
| |
| |
| Perform Simple Sorts and Filters | |
| |
| |
| Perform Complex Sorts | |
| |
| |
| Sort by Cell Color, Font Color, or Icon | |
| |
| |
| Perform Complex Filters | |
| |
| |
| Enter Criteria to Find Records | |
| |
| |
| Filter by Multiple Criteria | |
| |
| |
| Subtotal Sorted Data | |
| |
| |
| Count Filtered Records | |
| |
| |
| Define Data as a Table | |
| |
| |
| Modify a Table Style | |
| |
| |
| |
| Working with Pivottables | |
| |
| |
| Create a PivotTable | |
| |
| |
| Modify PivotTable Data and Layout | |
| |
| |
| Compute Subtotals and Grand Totals | |
| |
| |
| Create a PivotTable Calculated Field | |
| |
| |
| Hide Rows or Columns in a PivotTable | |
| |
| |
| Sort a PivotTable | |
| |
| |
| Retrieve Values from a PivotTable | |
| |
| |
| |
| Charting Data | |
| |
| |
| Create a Chart | |
| |
| |
| Add Chart Details | |
| |
| |
| Change the Chart Type | |
| |
| |
| Add a Trendline | |
| |
| |
| Add and Remove Chart Data | |
| |
| |
| Add Error Bars | |
| |
| |
| Create a Histogram | |
| |
| |
| Chart Filtered Data | |
| |
| |
| Create a PivotChart | |
| |
| |
| Create a Combination Chart | |
| |
| |
| |
| Working with External Data | |
| |
| |
| Paste Link into Word | |
| |
| |
| Embed a Worksheet | |
| |
| |
| Hyperlink a Worksheet | |
| |
| |
| Query a Web Site | |
| |
| |
| Import a Text File | |
| |
| |
| Import an Access Database | |
| |
| |
| Query an Access Database | |
| |
| |
| |
| Useful Data Analysis Tools and Techniques | |
| |
| |
| Perform What-If Analysis | |
| |
| |
| Optimize a Result with Goal Seek | |
| |
| |
| Solve a Formula with a Data Table | |
| |
| |
| Extend a Series with AutoFill | |
| |
| |
| Work with Multiple Windows | |
| |
| |
| Let Excel Read Back Your Data | |
| |
| |
| Add a Calculator | |
| |
| |
| Change Text to Numbers | |
| |
| |
| Convert a Row to a Column | |
| |
| |
| Consolidate Worksheets | |
| |
| |
| Conditionally Format Your Worksheet | |
| |
| |
| Change Conditional Formatting Rules | |
| |
| |
| Paste with Paste Special | |
| |
| |
| Insert Photographs into Your Worksheet | |
| |
| |
| |
| Sharing Your Workbook with Others | |
| |
| |
| Validate with a Validation List | |
| |
| |
| Validate with Data Entry Rules | |
| |
| |
| Add Comments to Your Worksheet | |
| |
| |
| Track Changes | |
| |
| |
| Protect Your Worksheet | |
| |
| |
| Save Your Workbook as a Template | |
| |
| |
| Choose a Format When Saving a Workbook | |
| |
| |
| Print Your Workbook | |
| |
| |
| Print Multiple Areas of Your Worksheet | |
| |
| |
| Add a Form Control to a Worksheet | |
| |
| |
| Assign Values to a Form Control | |
| |
| |
| Add a Macro to a Form Control | |
| |
| |
| |
| Automating with Macros | |
| |
| |
| Introducing Macros | |
| |
| |
| Set Macro Security | |
| |
| |
| Create a Digital Signature | |
| |
| |
| Record a Macro | |
| |
| |
| Assign a Digital Signature to a Macro | |
| |
| |
| Run a Macro | |
| |
| |
| Create and Launch a Keyboard Shortcut | |
| |
| |
| Assign a Macro to the Quick Access Toolbar | |
| |
| |
| Delete a Macro | |
| |
| |
| |
| Excel Keyboard Shortcuts | |
| |
| |
| |
| Excel Function Quick Reference | |
| |
| |
| |
| Formula Basics | |
| |
| |
| Index | |