Microsoft Excel Data Analysis and Business Modeling

WAYNE L. WINSTON is Professor Emeritus of Decision Sciences at Indiana University’s Kelley School of Business and Visiting Professor of Decision and Information Sciences at University of Houston Bauer College of Business. He has earned numerous MBA teaching awards. For more than 20 years, he has taught clients at Fortune 500 companies, various accounting groups, the US Navy, and the US Army how to use Excel to make smarter business decisions. Wayne and his business partner Jeff Sagarin developed the player-statistics tracking and rating system used by the Dallas Mavericks professional basketball team. He is also a two time  Jeopardy! champion.

Chapter 1 Basic spreadsheet modeling                                   
Chapter 2 Range names                                                       
Chapter 3 Lookup functions                                                  
Chapter 4 The INDEX function
Chapter 5 The MATCH function                                            
Chapter 6 Text functions                                                     
Chapter 7 Dates and date functions
Chapter 8 Evaluating investment by using net present value criteria      
Chapter 9 Internal rate of return                                          
Chapter 10 More Excel financial functions                              
Chapter 11 Circular references                                            
Chapter 12 IF statements                                                    
Chapter 13 Time and time functions                                     
Chapter 14 The Paste Special command