Introduction
1 Getting the Most Out of Ranges
2 Using Range Names
3 Building Basic Formulas
4 Creating Advanced Formulas
5 Troubleshooting Formulas
II Harnessing the Power of Functions
6 Understanding Functions
7 Working with Text Functions
8 Working with Logical and Information Functions
9 Working with Lookup Functions
10 Working with Date and Time Functions
11 Working with Math Functions
12 Working with Statistical Functions
III Building Business Models
13 Analyzing Data with Tables
14 Analyzing Data with PivotTables
15 Using Excel’s Business-Modeling Tools
16 Using Regression to Track Trends and Make Forecasts
17 Solving Complex Problems with Solver
IV Building Financial Formulas
18 Building Loan Formulas
19 Building Investment Formulas
20 Building Discount Formulas