Part 1: General Spreadsheet Techniques Chapter 2: The Fill Handle Chapter 3: Relative vs. Absolute Cell References Chapter 4: Range Names Chapter 5: Nested Functions Part 1 Exercises Part 2: Data Analysis Chapter 7: Subtotals Chapter 8: Summary Functions Chapter 9: Unique Lists Chapter 10: Data Validation Chapter 11: Conditional Formatting Chapter 12: Filtering Tools Chapter 13: Lookups Chapter 14: Working with Trends Chapter 15: Fixing Numbers Chapter 16: Copying Formulas Chapter 17: Multi-cell Arrays Chapter 18: Single-cell Arrays Chapter 19: Date Manipulation Chapter 20: Time Manipulation Part 2 Exercises Part 3: Plotting Data Chapter 22: A Chart’s or Graph’s Data Source Chapter 23: Combining Chart Types Chapter 24: Changing Graph Locations Chapter 25: Templates and Defaults Chapter 26: Axis Scales Chapter 27: More Axes Chapter 28: Error Bars Chapter 29: More Bars Chapter 30: Line Markers Chapter 31: Interpolation Chapter 32: Graph Formulas Part 3 Exercises Part 4: Regression and Curve Fitting Chapter 34: Nonlinear Regression Chapter 35: Curve Fitting Chapter 36: Sigmoid Curves Chapter 37: Predictability Chapter 38: Correlation Chapter 39: Multiple Regression: Linear Estimates Chapter 40: Reiterations and Matrixes Chapter 41: Solving Equations Chapter 42: What-If Controls Chapter 43: Syntax of Functions Chapter 44: Worksheet Functions Part 4 Exercises Part 5: Statistical Analysis Chapter 46: Types of Distributions Chapter 47: Simulating Distributions Chapter 48: Sampling Techniques Chapter 49: Test Conditions and Outliers Chapter 50: Estimating Means Chapter 51: Estimating Proportions Chapter 52: Significant Means Chapter 53: Significant Proportions Chapter 54: Significant Frequencies Chapter 55: More on Chi-Squared Testing and Box-Cox Power Chapter 56: Analysis of Variance Part 5 Exercises