| |
| |
| |
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 | |