PrefaceIntroduction to Excel 2007: Whats New?Chapter 1: Range NamesChapter 2: Lookup FunctionsChapter 3: The INDEX FunctionChapter 4: The MATCH FunctionChapter 5: Text FunctionsChapter 6: Dates and Date FunctionsChapter 7: Evaluating Investments by Using Net Present Value CriteriaChapter 8: Internal Rate of ReturnChapter 9: More Excel Financial FunctionsChapter 10: Circular ReferencesChapter 11: IF StatementsChapter 12: Time and Time FunctionsChapter 13: The Paste Special CommandChapter 14: The Auditing ToolChapter 15: Sensitivity Analysis with Data TablesChapter 16: The Goal Seek CommandChapter 17: Using the Scenario Manager for Sensitivity AnalysisChapter 18: The COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK FunctionsChapter 19: The SUMIF, AVERAGEIF, SUMIFS, and AVERAGEIFS FunctionsChapter 20: The OFFSET FunctionChapter 21: The INDIRECT FunctionChapter 22: Conditional FormattingChapter 23: Sorting in ExcelChapter 24: TablesChapter 25: Spin Buttons, Scroll Bars, Option Buttons, Check Boxes, Combo Boxes, and Group List BoxesChapter 26: An Introduction to Optimization with Excel SolverChapter 27: Using Solver to Determine the Optimal Product MixChapter 28: Using Solver to Schedule Your WorkforceChapter 29: Using Solver to Solve Transportation or Distribution ProblemsChapter 30: Using Solver for Capital BudgetingChapter 31: Using Solver for Financial PlanningChapter 32: Using Solver to Rate Sports TeamsChapter 33: Importing Data from a Text File or DocumentChapter 34: Importing Data from the InternetChapter 35: Validating DataChapter 36: Summarizing Data by Using HistogramsChapter 37: Summarizing Data by Using Descriptive StatisticsChapter 38: Using PivotTables to Describe DataChapter 39: Summarizing Data with Database Statistical FunctionsChapter 40: Filtering Data and Removing DuplicatesChapter 41: Consolidating DataChapter 42: Creating SubtotalsChapter 43: Estimating Straight Line RelationshipsChapter 44: Modeling Exponential GrowthChapter 45: The Power CurveChapter 46: Using Correlations to Summarize RelationshipsChapter 47: Introduction to Multiple RegressionChapter 48: Incorporating Qualitative Factors into Multiple RegressionChapter 49: Modeling Nonlinearities and InteractionsChapter 50: Analysis of Variance: One-Way ANOVAChapter 51: Randomized Blocks and Two-Way ANOVAChapter 52: Using Moving Averages to Understand Time SeriesChapter 53: Winters MethodChapter 54: Forecasting in the Presence of Special EventsChapter 55: An Introduction to Random VariablesChapter 56: The Binomial, Hypergeometric, and Negative Binomial Random VariablesChapter 57: The Poisson and Exponential Random VariableChapter 58: The Normal Random VariableChapter 59: Weibull and Beta Distributions: Modeling Machine Life and Duration of a ProjectChapter 60: Introduction to Monte Carlo SimulationChapter 61: Calculating an Optimal BidChapter 62: Simulating Stock Prices and Asset Allocation ModelingChapter 63: Fun and Games: Simulating Gambling and Sporting Event Prob...