Excel
Microsoft Excel 2013 Data Analysis and Business Modeling
 |
| Microsoft Excel 2013 Data Analysis and Business Modeling |
Main Contents of Microsoft Excel 2013 Data Analysis and Business Modeling
- Range names
- Lookup functions
- INDEX function
- MATCH function
- Text functions
- Dates and date functions
- Time and time functions
- Sorting in Excel
- The analytics revolution
- Using Solver for capital budgeting
- Importing data from a text file or document
- Validating data
- Summarizing data by using descriptive statistics
- The Data Model
- Sparklines
- Consolidating data
- Estimating straight-line relationships
- The power curve
- Modeling nonlinearities and interactions
- Using moving averages to understand time series
- Forecasting in the presence of special events
- The normal random variable
- Calculating an optimal bid
- Using resampling to analyze data
- Pricing products by using tie-ins
- Array formulas and functions
Foreword to Microsoft Excel 2013 Data Analysis and Business Modeling
Whether you work for a Fortune 500 corporation, a small company, a government agency, or a not-for-profit organization, if you’re reading this introduction the chances are you use Microsoft Excel in your daily work.
Your job probably involves summarizing, reporting, and analyzing data. It might also involve building analytic models to help your employer increase profits, reduce costs, or manage operations more efficiently.
Since 1999, I’ve taught thousands of analysts at organizations such as 3M, Booz Allen Hamilton consulting, Bristol-Myers Squibb, Broadcom Cisco Systems, Deloitte Consulting.
Drugstore.com, eBay, Eli Lilly, Ford, General Electric, General Motors, Intel, Microsoft, Morgan Stanley, NCR, Owens Corning, Pfizer, Proctor & Gamble, PWC, Schlumberger, Tellabs, the U.S. Army, the U.S.
Department of Defense, and Verizon how to use Excel more efficiently and productively in their jobs.
Students have often told me that the tools and methods I teach in my classes have saved them hours of time each week and provided them with new and improved approaches for analyzing important business problems.
I’ve used the techniques described in this book in my own consulting practice to solve many business problems. For example, I have used Excel to help the Dallas Mavericks and New York Knickers NBA basketball teams evaluate referees, players, and lineups.
During the last 15 years, I have also taught Excel business modeling and data analysis classes to MBA students at Indiana University’s Kelley School of Business.
(As proof of my teaching excellence, I have won over 45 teaching awards, and have won the school’s overall MBA teaching award six times.) I would like to also note that 95 percent of MBA students at Indiana University take my spreadsheet modeling class even though it is an elective.
