- Tapa blanda: 888 páginas
- Editor: Microsoft Press; Edición: 1 (19 de enero de 2014)
- Idioma: Inglés
- ISBN-10: 0735669139
- ISBN-13: 978-0735669130
- Valoración media de los clientes: Sé el primero en opinar sobre este producto
Clasificación en los más vendidos de Amazon:
nº116.228 en Libros en idiomas extranjeros (Ver el Top 100 en Libros en idiomas extranjeros)
- n.° 278 en Libros en idiomas extranjeros > Informática, internet y medios digitales > Sistemas operativos
- n.° 554 en Libros en idiomas extranjeros > Informática, internet y medios digitales > Software y aplicaciones de negocio
- n.° 1412 en Libros en idiomas extranjeros > Informática, internet y medios digitales > Ciencias informáticas
- Ver el Índice completo
Compara Precios en Amazon
+ Envío GRATIS
Microsoft Excel 2013: Data Analysis and Business Modeling (Inglés) Tapa blanda – 19 ene 2014
|Nuevo desde||Usado desde|
Hay una nueva edición de este producto:
Los clientes que compraron este producto también compraron
¿Qué otros productos compran los clientes tras ver este producto?
Descripción del producto
Reseña del editor
Master business modeling and analysis techniques with Microsoft Excel 2013, and transform data into bottom-line results. Written by award-winning educator Wayne Winston, this hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables—and how to effectively build a relational data source inside an Excel workbook.
Solve real business problems with Excel—and sharpen your edge
- Summarize data with PivotTables and Descriptive Statistics
- Explore new trends in predictive and prescriptive analytics
- Use Excel Trend Curves, multiple regression, and exponential smoothing
- Master advanced Excel functions such as OFFSET and INDIRECT
- Delve into key financial, statistical, and time functions
- Make your charts more effective with the Power View tool
- Tame complex optimization problems with Excel Solver
- Run Monte Carlo simulations on stock prices and bidding models
- Apply important modeling tools such as the Inquire add-in
Biografía del autor
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.
No es necesario ningún dispositivo Kindle. Descárgate una de las apps de Kindle gratuitas para comenzar a leer libros Kindle en tu smartphone, tablet u ordenador.
Obtén la app gratuita:
Detalles del producto
Si eres el vendedor de este producto, ¿te gustaría sugerir ciertos cambios a través del servicio de atención al vendedor?
Opiniones de clientes
|5 estrellas (0%)|
|4 estrellas (0%)|
|3 estrellas (0%)|
|2 estrellas (0%)|
|1 estrella (0%)|
Opiniones de clientes más útiles en Amazon.com
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!
SOME EXAMPLES: Here are some examples of what you can accomplish with this book. Use it as a checklist to see if you will find the book helpful.
> Write A formula to calculate the distance between two cities
> You have a paid event with multiple fee levels and several expenses. How many people need to attend to break even ?
> Create a Pivot Table that gives average salary broken down by department?
> How are monthly stock returns of Microsoft , GE, and Cisco Related?
> How to forecast one quarter ahead revenues of Apple?
> Based on the past on how long it takes to clean your house, If you start cleaning at noon, what are the chances that you will be finished in time to leave at 7:00 PM for a movie?
> Suppose it costs $20 per hour to have a teller working, and you value a customer's time at $15 per hour. How many tellers should you have working?
TIME COMMITMENT REQUIRED :
Since this is "exercise driven" book, expect to spend few hours to few days ( yes, in a real world, you will be pulled into other things) every chapter and move to the next.I will not strictly call this book as a "reference" book since you need to know which formula or tool to use at which time without looking at a book.
The editor who was responsible for accuracy was probably drunk or someone who has never used Excel for his day to day work making the reader's life difficult. As an example, go to page 47 Question Number. After the initial question, the question number 4 is appended to it.Similarly some of the questions do not have a spreadsheet reference and so on and on. The editorial team should be shown the door for such a shoddy work.
If you work in an office, you need to know Excel .. Period and this book takes you to next level that 95% of your colleagues would not know. A masterpiece