Title Details

Isaac D. Gottlieb, Ph.D. is the Director of the International Executive MBA at Rutgers University Business School. He has been part of the teaching faculty for over 10 years, and is the recipient of a number of teaching excellence awards.
Over the last decade, he has taught how to use Excel—and how to apply it effectively to various business disciplines—to thousands of MBA and Executive MBA students at Rutgers, NYU and Columbia University.
He has also instructed Excel application in business settings to over 10,000 participants in corporate seminars, conferences and workshops. The participants are professionals from leading multinational companies as well as small private business corporations.
Dr. Gottlieb has an Excel-Tip-Of-The-Month newsletter which goes to over 50,000 recipients.

A Word from the Author xi

Acknowledgments xiii

Introduction and Overview xv

PART ONEUsing Excel Efficiently 1

CHAPTER 1 AutoFill 3

CHAPTER 2 Selecting Efficiently In Excel 14

CHAPTER 3 Formulas, Functions, Relative and Absolute Addressing 19

CHAPTER 4 Naming Cells and Ranges 28

CHAPTER 5 Excel Charts 38

PART TWOIF Functions and Text Manipulations 63

CHAPTER 6 IF Functions 65

CHAPTER 7 Text Manipulation 72

PART THREEStatistical Tools 83

CHAPTER 8 Descriptive Statistics 85

CHAPTER 9 Frequency Distributions 90

CHAPTER 10 Statistical Regression 100

CHAPTER 11 Data Analysis—The Excel Easy to Use Statistics Add-in 109

PART FOURWhat-if Analysis 119

CHAPTER 12 Naming Cells—for Meaningful Decision Making and Modeling 121

CHAPTER 13 What-if Analysis and Goal Seek 129

CHAPTER 14 Sensitivity Analysis—One- and Two-way Data Tables 136

CHAPTER 15 Using Scroll Bars for Sensitivity Analysis 149

PART FIVEMulti-Page Systems and Lookups 159

CHAPTER 16 Multi-Page Budgets—Going to the Third Dimension 161

CHAPTER 17 Lookup Tables 170

PART SIXThe Data Menu and Ribbon 179

CHAPTER 18 Sorting Data 181

CHAPTER 19 AutoFilter 190

CHAPTER 20 Data Forms and Features Eliminated in Excel 2007 198

CHAPTER 21 Group and Outline Data 204

CHAPTER 22 Subtotals 209

CHAPTER 23 Pivot Tables 219

CHAPTER 24 Data Mining Using Pivot Tables 229

PART SEVENExcel Financial Tools 241

CHAPTER 25 NPV and IRR—Evaluating Capital Investments 243

CHAPTER 26 Unconventional Financial Functions: XNPV and XIRR 249

CHAPTER 27 Frequently Used Financial Functions 253

CHAPTER 28 Amortization Tables 258

CHAPTER 29 Accounting Depreciation Functions 268

PART EIGHTUsing the Solver Add-In 271

CHAPTER 30 Beyond the Goal Seek—More than One Changing Cell? Use the Solver 273

CHAPTER 31 The Solver Add-In—Optimizer 282

Index 291