Next Generation Excel (eBook)

Dr. Isaac D. Gottlieb, PhD, is a professor of Management and Statistics at the Fox Business School of Temple University and Director of the China and Singapore programs. Also, he is a former director of the International Executive MBA at Rutgers University Business School. The recipient of numerous excellence-in-teaching awards, Dr. Gottlieb has taught how to use Excel and apply it effectively to various business disciplines to thousands of MBA and Executive MBA students at Rutgers, Temple, New York University, Columbia, and other universities. Also, he has instructed Excel for business professionals to over 20,000 participants in corporate seminars, conferences and workshops, including staff from Johnson & Johnson, Merck, Pfizer, Procter & Gamble, Microsoft, Intel, Boeing, Chrysler, JP Morgan, Morgan Stanley, 3M and Hewlett-Packard. Dr Gottlieb has an "Excel Tip Of The Month" newsletter that goes to over 50,000 recipients.

Preface

Acknowledgments

Part One
Using Excel Efficiently
Chapter 1
AutoFill

Chapter 2
Selecting Efficiently In Excel

Chapter 3
Formulas, Functions, and Relative and Absolute Addressing

Chapter 4
Naming Cells and Ranges

Chapter 5
Conditional and Advanced Conditional Formatting in Excel

Chapter 6
Excel Charts

Chapter 7
Sparklines and Advanced Topics in Excel Charts

Part Two
IF Functions and Text Manipulations
Chapter 8
IF Functions

Chapter 9
Text Manipulation

Part Three
Statistical Tools
Chapter 10
Descriptive Statistics

Chapter 11
Frequency Distributions

Chapter 12
Statistical Regression

Chapter 13
Data Analysis--The Excel Easy to Use Statistics Add-in

Chapter 14
Data Analysis - Multi-Regression

Part Four
What-if Analysis
Chapter 15
Naming Cells--for Meaningful Decision Making and Modeling

Chapter 16
What-if Analysis and Goal Seek

Chapter 17
Sensitivity Analysis--One- and Two-way Data Tables

Chapter 18
Using Scroll Bars for Sensitivity Analysis

Part Five
Multi-Page Systems and Lookups
Chapter 19
Multi-Page Budgets--Going to the Third Dimension

Chapter 20
Lookup Tables

Part Six
The Data Menu and Ribbon
Chapter 21
Sorting Data

Chapter 22
Auto Filter

Chapter 23
Data Forms and Features Eliminated in Excel 2007 and 2010

Chapter 24
Group and Outline Data

Chapter 25
Excel Subtotals

Chapter 26
Pivot Tables

Chapter 27
Data Mining Using Pivot Tables

Chapter 28
Using Slicers to Filter Pivot Tables

Part Seven
Excel Financial Tools
Chapter 29
NPV and IRR--Evaluating Capital Investments

Chapter 30
Unconventional Financial Functions: XNPV and XIRR

Chapter 31
Frequently Used Financial Functions

Chapter 32
Amortization Tables

Chapter 33
Accounting Depreciation Functions

Part Eight
Using the Solver Add-In
Chapter 34
Beyond the Goal Seek--More Than One Changing Cell? Use the Solver

Chapter 35
The Solver Add-In--Optimizer

Appendix A
Summary Case Study - Supply Chain Management Example

About the Author

Index