Free PDF Microsoft Excel 2010 Data Analysis and Business Modeling (Business Skills), by Wayne Winston
When getting guide Microsoft Excel 2010 Data Analysis And Business Modeling (Business Skills), By Wayne Winston by on-line, you can read them wherever you are. Yeah, also you are in the train, bus, hesitating list, or other areas, on-line e-book Microsoft Excel 2010 Data Analysis And Business Modeling (Business Skills), By Wayne Winston can be your buddy. Whenever is a great time to check out. It will boost your expertise, enjoyable, enjoyable, session, and experience without investing even more money. This is why on-line e-book Microsoft Excel 2010 Data Analysis And Business Modeling (Business Skills), By Wayne Winston becomes most desired.
Microsoft Excel 2010 Data Analysis and Business Modeling (Business Skills), by Wayne Winston
Free PDF Microsoft Excel 2010 Data Analysis and Business Modeling (Business Skills), by Wayne Winston
Microsoft Excel 2010 Data Analysis And Business Modeling (Business Skills), By Wayne Winston. In undergoing this life, many individuals constantly attempt to do as well as obtain the most effective. New knowledge, experience, driving lesson, as well as everything that could enhance the life will certainly be done. Nonetheless, numerous people occasionally feel perplexed to obtain those points. Feeling the limited of experience and sources to be far better is among the lacks to own. However, there is a really basic point that could be done. This is just what your teacher always manoeuvres you to do this. Yeah, reading is the answer. Reading a publication as this Microsoft Excel 2010 Data Analysis And Business Modeling (Business Skills), By Wayne Winston as well as other referrals could enhance your life high quality. How can it be?
To conquer the problem, we now give you the technology to download guide Microsoft Excel 2010 Data Analysis And Business Modeling (Business Skills), By Wayne Winston not in a thick printed documents. Yeah, reading Microsoft Excel 2010 Data Analysis And Business Modeling (Business Skills), By Wayne Winston by on-line or obtaining the soft-file just to read could be one of the ways to do. You might not feel that reviewing a publication Microsoft Excel 2010 Data Analysis And Business Modeling (Business Skills), By Wayne Winston will certainly work for you. However, in some terms, May individuals successful are those which have reading habit, included this sort of this Microsoft Excel 2010 Data Analysis And Business Modeling (Business Skills), By Wayne Winston
By soft file of the publication Microsoft Excel 2010 Data Analysis And Business Modeling (Business Skills), By Wayne Winston to check out, you could not need to bring the thick prints all over you go. Any type of time you have willing to read Microsoft Excel 2010 Data Analysis And Business Modeling (Business Skills), By Wayne Winston, you can open your gadget to read this book Microsoft Excel 2010 Data Analysis And Business Modeling (Business Skills), By Wayne Winston in soft documents system. So easy as well as fast! Reviewing the soft documents e-book Microsoft Excel 2010 Data Analysis And Business Modeling (Business Skills), By Wayne Winston will certainly offer you easy method to read. It can additionally be much faster since you can read your book Microsoft Excel 2010 Data Analysis And Business Modeling (Business Skills), By Wayne Winston almost everywhere you really want. This online Microsoft Excel 2010 Data Analysis And Business Modeling (Business Skills), By Wayne Winston can be a referred book that you can take pleasure in the remedy of life.
Considering that book Microsoft Excel 2010 Data Analysis And Business Modeling (Business Skills), By Wayne Winston has fantastic perks to check out, numerous people now expand to have reading practice. Assisted by the established modern technology, nowadays, it is easy to obtain the book Microsoft Excel 2010 Data Analysis And Business Modeling (Business Skills), By Wayne Winston Even guide is not alreadied existing yet on the market, you to look for in this internet site. As just what you could locate of this Microsoft Excel 2010 Data Analysis And Business Modeling (Business Skills), By Wayne Winston It will really alleviate you to be the very first one reading this book Microsoft Excel 2010 Data Analysis And Business Modeling (Business Skills), By Wayne Winston as well as obtain the perks.
Master the business modeling and analysis techniques that help you transform data into bottom-line results. For more than a decade, Wayne Winston has been teaching corporate clients and MBA students the most effective ways to use Excel to solve business problems and make better decisions. Now this award-winning educator shares the best of his expertise in this hands-on, scenario-focused guide—fully updated for Excel 2010!
Use Excel to solve real business problems—and sharpen your edge!
- Model investment risks and returns
- Analyze your sales team’s effectiveness
- Create best, worst, and most-likely case scenarios
- Compare lease vs. buy, and calculate loan terms
- See how price, advertising, and seasonality affect sales
- Manage inventory with precision
- Quantify the value of customer loyalty
- Calculate your break-even number and ROI
- Maximize scheduling efficiency
- Express “home-field advantage” in real numbers
- Project company growth, predict election results, and more!
- Plus—introduce yourself to PowerPivot for Excel
- Downloadable eBook
- Hundreds of scenario-based practice problems
- All the book’s sample files—plus customizable templates
- Sales Rank: #347302 in Books
- Published on: 2011-01-17
- Original language: English
- Number of items: 1
- Dimensions: 8.60" h x 1.60" w x 7.30" l, 2.29 pounds
- Binding: Paperback
- 720 pages
About the Author
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.
Most helpful customer reviews
71 of 72 people found the following review helpful.
Worth buying?
By Kawakami
If someone asked me that question, I would have to say no. It's not that the book is very bad per se; it's just that the book is not very good either, and you can pretty much get the same info for free off of the internet.
I'll qualify that by saying: I think that if you are an MBA student, then this book may be worth the money just for the convenience of having all of the information in one package. BUT if you are a professional looking for solutions to business problems, then you'll probably only use the small portions of the book that are related to your field... and it would be better to just look on the internet for templates on a piecemeal basis as the needs arise. The templates you find on the 'net will probably be more sophisticated and more polished as well.
Here's the detail:
THE GOOD
The best thing about this book is that it covers a wide range of topics from stats to queuing to finance and more. In that way, the book can be valuable as a versatile reference book that you can turn to first.
Each chapter begins with problem statements, and then it shows how to use formulas and functions in Excel to come up with an answer. Some of the solutions are specific to functions and features found in Excel, while others are simply math equations that could be used in any spreadsheet software such as Lotus or Google Docs (or even just written out on a piece of paper for that matter). So you may consider the solutions to be good because they're flexible.
The scope of the book pretty much covers the first year of MBA coursework which is nice for the students out there. Also, everything is supported by sample Excel files, so it gives you plenty of templates to cut and paste from.
THE BAD
As much as the book offers in breadth, it more than lacks in terms of depth and realism. For example, the chapter on NPV modeling really doesn't tell you much more than the equation for present value:
[present value] = [the future cash flow] / [1 + the discount rate] ^ [the year you receive the future cash flow]
Enter one of those formulas for each year in your analysis, and add them together. The result is the NPV. This same information, along with a more detailed template, could have been found using Google. Moreover, he could have just used the present value function in Excel rather than calculating it manually.
Another example is the chapter where he uses solver to maximize the effect of observed price elasticity. You are given:
1. A low price leads to higher demand and sales of $90
2. A medium price has slightly less demand but sales of $102
3. A high price has the least demand and sales of $50
I realize that the problem statement is scaled down in order to teach solver... but if you find yourself in this unlikely situation, then you don't need solver. The answer is choose medium. That is a supportable solution with the highest value. If you were in the more realistic situation where you have more data points... then the answer is still "you don't need solver". Again, choose the highest observed value.
The goals of each of the chapters I mentioned was clearly to teach a formula or a tool and not how to design a model with a structure that most effectively uses that tool... which leads me to...
THE UGLY
The templates provided are in no way close to being turn key solutions; not only because of the lack of detail, flexibility, and sophistication... but by the fact that the models themselves are actually, physically ugly. The inputs, calculations, and outputs are all mashed together in a single clump. Worse yet, sometimes they are actually intermixed in the same block of cells. The worksheets are not formatted; making it even more difficult to identify what is what. There are spelling errors and superfluous worksheets in the workbooks. If you were to use the files as templates, you could run the risk of passing through some of these problems. Additionally, the files have no comments or other documentation contained within the workbook, so the files don't function particularly well as stand-alone resources.
Also, the production quality of the book itself is mediocre. The book is entirely in black and white (which hurts his chapters on charts and coloring), and it is just simple text without call outs, side bars, or other things that could help to summarize, highlight, and reiterate key items. The effect is that it reads something like a textbook where all items, both large and small, are given the same level of importance in a weird, academic way.
I work as a consultant, and my clients expect me to deliver work that is understandable, easy to use, efficient, versatile, and accurate. As a consumer, I expect the same from my vendors. This book falls short on at least the first 4 of the 5.
I think this book would have worked far better if it was written as a series of case studies that taught multiple elements together in a realistic combination. E.g.:
The NPV model could have been a lesson in designing a model with distinct input, calculation, and output sections. It could have taught the reader how to expand the model by year and line item while preserving formatting. It could have explained that virtually every single NPV model the reader will ever make must be split by cash and non-cash expenses because tax, accounting, and finance each handle those items differently.
The price elasticity model could have shown us how to build in sections for more than 2 variables since price problems always involve economies of scale/ diminishing returns as well as manufacturing/ operational impacts, and knock on effects to the brand. (If Gucci lowered prices to stimulate demand, there could be a short term profit increase, but...... slimmer margins, downward pressure on quality to avoid a long-term increase in COGS, and a long-term knock on effect to overall brand perception which in turn would impact demand... and drive the brand into the bargain bin at TJ Maxx like Tommy Hillfiger).
17 of 18 people found the following review helpful.
become familiar with Excel built in functions
By mko
Microsoft Excel 2010 is typical FAQ/lecture like book. What you get is a list of issues that you probably encounter, sooner or later, during Excel programming. Each chapter is organized the same way. At first, you get the list of questions that are related to topics covered within chapter. Then, you get answers to questions explained by examples. This way you can easily find solutions for problems that you have recently encountered and want to have them solved by the Excel. What is a benefit here is that knowledge is not just a plain theory. Contrary, what you get is a purely pragmatic approach - problem/solution. In order to check your knowledge, each chapter contains brain teasers that will force you to think a little bit. You are asked to solve a problem that can be solved using knowledge you have acquired while reading the chapter.
I have mixed feelings when it comes to this book. At one point you should have it in your own library as a reference. On the other hand, I don't like editorial side of the book at all. It's too simple and too plain. I know you can say that lecture script is not required to look fancy and nice, but I simply like well edited books. I know that judging book by it's cover might be very unfair by in case of this one, editorial side of the book took advantage over the content. However, if you don't pay that much attention to look over the content you should consider buying this one. You will find quite a loot of examples that will guide you through the mysteries of the Excel. And you don't have to know Visual Basic at all.
12 of 13 people found the following review helpful.
A real good book on Excel 2010
By Tran DUC
This is a proper book written by a professor from a top business school and this is indeed a very deep one covering a lot of grounds.
It covers almost everything in Excel starting from the most basic thing such as putting together a arithmetic expression and end with some advanced modelling examples.
Written by a professor, the book format is like a university course starting with a bit of of theory, some examples and then followed by many exercises to refine your skills. By having many exercises and scenarios you actually have to think about the problem you face, works out your solutions before actually using excel to implement your solutions. This is to me great because so many books taught people only which buttons to press.
As a business analyst this is a very helpful book covering a lot of grounds teaching you a lot of business knowledge and business analysis skills, the excel bit of it is just the implementation which is the right way to go about it.
The downside is the poor editing, while the content and organisation is top class, the presenting bit is simple pathetic and it makes you think of a boring lecture with white chalks on a black board. And yes, the course did not cover as much on themes and design features of Excel 2010.
I have read many books on excel and this is the one with the most brain so I give it 5-star
Microsoft Excel 2010 Data Analysis and Business Modeling (Business Skills), by Wayne Winston PDF
Microsoft Excel 2010 Data Analysis and Business Modeling (Business Skills), by Wayne Winston EPub
Microsoft Excel 2010 Data Analysis and Business Modeling (Business Skills), by Wayne Winston Doc
Microsoft Excel 2010 Data Analysis and Business Modeling (Business Skills), by Wayne Winston iBooks
Microsoft Excel 2010 Data Analysis and Business Modeling (Business Skills), by Wayne Winston rtf
Microsoft Excel 2010 Data Analysis and Business Modeling (Business Skills), by Wayne Winston Mobipocket
Microsoft Excel 2010 Data Analysis and Business Modeling (Business Skills), by Wayne Winston Kindle
Tidak ada komentar:
Posting Komentar