## With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

No credit card required

## Book Description

2. Praise for Visual Books
3. Credits
5. 1. Boosting Efficiency
1. 1.1. Quick Tips
2. 1.2. Name Cells and Ranges
3. 1.3. Validate with a Validation List
4. 1.4. Validate with Data Entry Rules
5. 1.5. Extend a Series with AutoFill
6. 1.6. Insert Symbols and Special Characters
7. 1.7. Hide Rows by Grouping and Outlining
9. 1.9. Let Excel Read Back Data
6. 2. Working with Formulas and Functions
1. 2.1. Quick Tips
2. 2.2. Calculate with the Function Wizard
3. 2.3. Define a Constant
4. 2.4. Create Formulas That Include Names
5. 2.5. Figure Out Loan Terms
6. 2.6. Determine the Internal Rate of Return
7. 2.7. Determine the Nth Largest Value
8. 2.8. Create a Conditional Formula
9. 2.9. Calculate a Conditional Sum
11. 2.11. Find Products and Square Roots
12. 2.12. Perform Time Calculations
13. 2.13. Perform Date Calculations
7. 3. Copying, Formatting, and More
1. 3.1. Quick Tips
2. 3.2. Check Formulas for Errors
3. 3.3. Change Text to Numbers and Then Calculate
4. 3.4. Convert a Row to a Column
5. 3.5. Copy with the Office Clipboard
6. 3.6. Specify How to Paste with Paste Special
7. 3.7. Create Your Own Style
8. 3.8. Copy Styles to Another Workbook
9. 3.9. Conditionally Format a Worksheet
10. 3.10. Track Changes While Editing
11. 3.11. Consolidate Worksheets
8. 4. Manipulating Records
9. 5. Explore Patterns in Data
1. 5.1. Quick Tips
2. 5.2. Create a PivotTable
3. 5.3. Modify PivotTable Data and Layout
4. 5.4. Compute Sub- and Grand Totals
5. 5.5. Create a Calculated Field
6. 5.6. Hide Columns or Rows in a PivotTable
7. 5.7. Sort a PivotTable
8. 5.8. Create a PivotChart
9. 5.9. Describe Data with Statistics
10. 5.10. Find the Correlation Between Variables
11. 5.11. Explore Outcomes with What-If Analysis
12. 5.12. Optimize a Result with Goal Seek
10. 6. Creating Charts
1. 6.1. Quick Tips
2. 6.2. Create a Chart That Has Visual Appeal