Microsoft® Excel Data Analysis and Business Modeling (Business Skills) (英語) ペーパーバック – 2004/2/25
Kindle 端末は必要ありません。無料 Kindle アプリのいずれかをダウンロードすると、スマートフォン、タブレットPCで Kindle 本をお読みいただけます。
Master the techniques that business analysts at leading companies use to transform data into bottom-line results. For more than a decade, well-known consultant and business professor Wayne Winston has been teaching corporate clients and MBA students the most effective ways to use Microsoft Excel for data analysis, modeling, and decision making. Now this award-winning educator shares the best of his classroom experience in this practical, business-focused guide. Each chapter advances your data analysis and modeling expertise using real-world examples and learn-by-doing exercises. You also get all the book’s problem-and-solution files on CD—for all the practice you need to solve complex problems and work smarter with Excel.
Learn how to solve real business problems with Excel!
- Create best, worst, and most-likely scenarios for sales
- Calculate how long it would take to recoup a project’s startup costs
- Plan personal finances, such as computing loan terms or saving for retirement
- Estimate a product’s demand curve
- Simulate stock performance over a year
- Determine which product mix will yield the greatest profits
- Interpret the effects of price and advertising on sales
- Assign a dollar value to customer loyalty
- Manage inventory and order quantities with precision
- Create customer service queues with short wait times
- Estimate the probabilities of equipment failure
- Model business uncertainties
- Get new perspectives on data with PivotTable dynamic views
- Help predict quarterly revenue, outcomes of sporting events, presidential elections, and more!
On the CD:
- Practice files for all the book’s exercises
- Solutions for problem sets
- Fully searchable eBook
For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.
Wayne L. Winston is a professor of Decision Sciences at Indiana University's Kelley School of Business and has earned numerous MBA teaching awards. For 20+ years, he has taught clients at Fortune 500 companies 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.
About two years ago (before I started the MBA program) I felt like I could work my way around a spreadsheet. After purchasing the other popular excel books and working through them, they helped a lot. Then I took Dr. Winston's course(s) and realized that I only took away from the previous books what was applicable to my daily excel needs for my job. Now that I am finishing up the MBA program (final semester), I have started a consulting company using the exact methods out of this book that I learned in Dr. Winston's class.
After reading the other reviews about how this book is challenging to get through, I completely agree. This is an advanced excel book. The big difference between this book and every other excel book (I have purchased several) is that the other ones teach you HOW to use excel. They walk you through the different formulas and teach you how to do them.
This book teaches you the WHY while also teaching you the HOW. In other words, if you wanted to build a model to help a company maximize profit by determining which limited resources to put into play (labor, materials, $$) based on the revenue of each product, this book teaches you. This is the WHY (and was our week 1 homework problem in his class). In doing this you will learn how to use excel's solver model (constraints, changing cells, linear models, non linear...etc) , vlookups, nested if statements, and several other functions in excel. This is the HOW. So you get to learn a ton of the really cool functions in excel, how they work together in nested formulas, and how they could directly benefit a company/organization (just from one chapter).
I am biased as I have learned quite a bit from Dr. Winston. There is a reason why he has won all of the awards that he has (google his name and Indiana University). He is very good at explaining these concepts to somebody like me that doesn't come from a heavy quantitative background.
I have recently spoken with Dr. Winston and he mentioned that he was in the process of putting his courses up online. He said that currently there are around 200 videos explaining lots of the topics in his books. I am not sure of the website, but once he tells me I will update this review again.
Spoke with Dr. Winston yesterday and he said that his site is up! Just checked it out and there is a lot of free content showing how to work some of the examples in his book. You can find it by googling excelwithwayne (fitting name). I'm jealous because I just paid a ton of money to take his classes when I could have just watched his videos.I am only posting this here because some of the reviews said that they would like to see the videos if possible. Not trying to sell anything as this is Dr. Winston's website and I am just an alum of his.
1.) Mike Smart's Excel 2013 Essential and Expert Skills
2.) This book, Microsoft Excel 2013 Data Analysis and Business Modeling
3.) John Foreman's Data Smart
What I truly love about this book is not only the shear breadth of information, with topics ranging from shipping optimization to generating your own football team rankings, but also the depth! There are numerous examples of problems at the end of each chapter that help to solidify your knowledge and practice of the given topic. Winston also does something rare that I wish more authors would do: offer plenty of examples and solutions in Excel format! I'm someone who learns by doing and practicing and this book is like taking a college semester in data analysis condensed into 1 book. Winston also does an excellent job of building up your skills in a logical fashion throughout the book, in addition to making chapters small enough to be indexed properly so you can jump to your topic of choice for review or reference. Incredible book that I cannot recommend enough!