Microsoft Excel 2013: Data Analysis and Business Modeling

Valutazione media 4,3
( su 23 valutazioni fornite da GoodReads )
 
9780735669130: Microsoft Excel 2013: Data Analysis and Business Modeling

Master the business modeling and analytic techniques with Microsoft Excel 2013, and help transform your data into bottom-line results. With this hands-on, scenario-focused guide from Excel expert and bestselling author Wayne Winston, you’ll learn how to use the new Data Model and Relationships features for integrating data from multiple tables, effectively building a relational data source inside an Excel workbook.

Gain the skills to solve real-world business problems with Excel 2013

  • 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

Le informazioni nella sezione "Riassunto" possono far riferimento a edizioni diverse di questo titolo.

L'autore:

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.

Contenuti:

Introduction; What’s new in this edition; What you should know before reading this book; How to use this book; Using the companion content; Acknowledgments; Support & feedback; Chapter 1: Range names; 1.1 How can I create named ranges?; 1.2 Answers to this chapter’s questions; 1.3 Remarks; 1.4 Problems; Chapter 2: Lookup functions; 2.1 Syntax of the lookup functions; 2.2 Answers to this chapter’s questions; 2.3 Problems; Chapter 3: INDEX function; 3.1 Syntax of the INDEX function; 3.2 Answers to this chapter’s questions; 3.3 Problems; Chapter 4: MATCH function; 4.1 Answers to this chapter’s questions; 4.2 Problems; Chapter 5: Text functions; 5.1 Text function syntax; 5.2 Answers to this chapter’s questions; 5.3 Problems; Chapter 6: Dates and date functions; 6.1 Answers to this chapter’s questions; 6.2 Problems; Chapter 7: Evaluating investments by using net present value criteria; 7.1 Answers to this chapter’s questions; 7.2 Problems; Chapter 8: Internal rate of return; 8.1 Answers to this chapter’s questions; 8.2 Problems; Chapter 9: More Excel financial functions; 9.1 Answers to this chapter’s questions; 9.2 CUMPRINC and CUMIPMT functions; 9.3 Problems; Chapter 10: Circular references; 10.1 Answers to this chapter’s questions; 10.2 Problems; Chapter 11: IF statements; 11.1 Answers to this chapter’s questions; 11.2 Problems; Chapter 12: Time and time functions; 12.1 Answers to this chapter’s questions; 12.2 Problems; Chapter 13: The Paste Special command; 13.1 Answers to this chapter’s questions; 13.2 Problems; Chapter 14: Three-dimensional formulas; 14.1 Answer to this chapter’s question; 14.2 Problem; Chapter 15: The Auditing tool and Inquire add-in; 15.1 Answers to this chapter’s questions; 15.2 Problems; Chapter 16: Sensitivity analysis with data tables; 16.1 Answers to this chapter’s questions; 16.2 Problems; Chapter 17: The Goal Seek command; 17.1 Answers to this chapter’s questions; 17.2 Problems; Chapter 18: Using the Scenario Manager for sensitivity analysis; 18.1 Answer to this chapter’s question; 18.2 Remarks; 18.3 Problems; Chapter 19: The COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK functions; 19.1 Answers to this chapter’s questions; 19.2 Remarks; 19.3 Problems; Chapter 20: The SUMIF, AVERAGEIF, SUMIFS, and AVERAGEIFS functions; 20.1 Answers to this chapter’s questions; 20.2 Problems; Chapter 21: The OFFSET function; 21.1 Answers to this chapter’s questions; 21.2 Remarks; 21.3 Problems; Chapter 22: The INDIRECT function; 22.1 Answers to this chapter’s questions; 22.2 Problems; Chapter 23: Conditional formatting; 23.1 Answers to this chapter’s questions; 23.2 Problems; Chapter 24: Sorting in Excel; 24.1 Answers to this chapter’s questions; 24.2 Problems; Chapter 25: Tables; 25.1 Answers to this chapter’s questions; 25.2 Problems; Chapter 26: Spinner buttons, scroll bars, option buttons, check boxes, combo boxes, and group list boxes; 26.1 Answers to this chapter’s questions; 26.2 Problems; Chapter 27: The analytics revolution; 27.1 Answers to this chapter’s questions; Chapter 28: Introducing optimization with Excel Solver; 28.1 Problems; Chapter 29: Using Solver to determine the optimal product mix; 29.1 Answers to this chapter’s questions; 29.2 Problems; Chapter 30: Using Solver to schedule your workforce; 30.1 Answer to this chapter’s question; 30.2 Problems; Chapter 31: Using Solver to solve transportation or distribution problems; 31.1 Answer to this chapter’s question; 31.2 Problems; Chapter 32: Using Solver for capital budgeting; 32.1 Answer to this chapter’s question; 32.2 Problems; Chapter 33: Using Solver for financial planning; 33.1 Answers to this chapter’s questions; 33.2 Problems; Chapter 34: Using Solver to rate sports teams; 34.1 Answer to this chapter’s question; 34.2 Problems; Chapter 35: Warehouse location and the GRG Multistart and Evolutionary Solver engines; 35.1 Understanding the GRG Multistart and Evolutionary Solver engines; 35.2 Answers to this chapter’s questions; 35.3 Problems; Chapter 36: Penalties and the Evolutionary Solver; 36.1 Answers to this chapter’s questions; 36.2 Using conditional formatting to highlight each employee’s ratings; 36.3 Problems; Chapter 37: The traveling salesperson problem; 37.1 Answers to this chapter’s questions; 37.2 Problems; Chapter 38: Importing data from a text file or document; 38.1 Answer to this chapter’s question; 38.2 Problems; Chapter 39: Importing data from the Internet; 39.1 Answer to this chapter’s question; 39.2 Problems; Chapter 40: Validating data; 40.1 Answers to this chapter’s questions; 40.2 Remarks; 40.3 Problems; Chapter 41: Summarizing data by using histograms; 41.1 Answers to this chapter’s questions; 41.2 Problems; Chapter 42: Summarizing data by using descriptive statistics; 42.1 Answers to this chapter’s questions; 42.2 Problems; Chapter 43: Using PivotTables and slicers to describe data; 43.1 Answers to this chapter’s questions; 43.2 Problems; Chapter 44: The Data Model; 44.1 Answers to this chapter’s questions; 44.2 Problems; Chapter 45: PowerPivot; 45.1 Answers to this chapter’s questions; 45.2 Problems; Chapter 46: Power View; 46.1 Answers to this chapter’s questions; 46.2 Problems; Chapter 47: Sparklines; 47.1 Answers to this chapter’s questions; 47.2 Problems; Chapter 48: Summarizing data with database statistical functions; 48.1 Answers to this chapter’s questions; 48.2 Problems; Chapter 49: Filtering data and removing duplicates; 49.1 Answers to this chapter’s questions; 49.2 Problems; Chapter 50: Consolidating data; 50.1 Answer to this chapter’s question; 50.2 Problems; Chapter 51: Creating subtotals; 51.1 Answers to this chapter’s questions; 51.2 Problems; Chapter 52: Charting tricks; 52.1 Answers to this chapter’s questions; 52.2 Problems; Chapter 53: Estimating straight-line relationships; 53.1 Answers to this chapter’s questions; 53.2 Problems; Chapter 54: Modeling exponential growth; 54.1 Answer to this chapter’s question; 54.2 Problems; Chapter 55: The power curve; 55.1 Answer to this chapter’s question; 55.2 Problems; Chapter 56: Using correlations to summarize relationships; 56.1 Answer to this chapter’s question; 56.2 Problems; Chapter 57: Introduction to multiple regression; 57.1 Answers to this chapter’s questions; Chapter 58: Incorporating qualitative factors into multiple regression; 58.1 Answers to this chapter’s questions; Chapter 59: Modeling nonlinearities and interactions; 59.1 Answers to this chapter’s questions; 59.2 Problems for Chapters 57 and 58; Chapter 60: Analysis of variance: one-way ANOVA; 60.1 Answers to this chapter’s questions; 60.2 Problems; Chapter 61: Randomized blocks and two-way ANOVA; 61.1 Answers to this chapter’s questions; 61.2 Problems; Chapter 62: Using moving averages to understand time series; 62.1 Answer to this chapter’s question; 62.2 Problem; Chapter 63: Winters’s method; 63.1 Time series characteristics; 63.2 Parameter definitions; 63.3 Initializing Winters’s method; 63.4 Estimating the smoothing constants; 63.5 Remarks; 63.6 Problems; Chapter 64: Ratio-to-moving-average forecast method; 64.1 Answers to this chapter’s questions; 64.2 Problem; Chapter 65: Forecasting in the presence of special events; 65.1 Answers to this chapter’s questions; 65.2 Problems; Chapter 66: An introduction to random variables; 66.1 Answers to this chapter’s questions; 66.2 Problems; Chapter 67: The binomial, hypergeometric, and negative binomial random variables; 67.1 Answers to this chapter’s questions; 67.2 Problems; Chapter 68: The Poisson and exponential random variable; 68.1 Answers to this chapter’s questions; 68.2 Problems; Chapter 69: The normal random variable; 69.1 Answers to this chapter’s questions; 69.2 Problems; Chapter 70: Weibull and beta distributions: modeling machine life and duration of a project; 70.1 Answers to this chapter’s questions; 70.2 Problems; Chapter 71: Making probability statements from forecasts; 71.1 Answers to this chapter’s questions; 71.2 Problems; Chapter 72: Using the lognormal random variable to model stock prices; 72.1 Answers to this chapter’s questions; 72.2 Remarks; 72.3 Problems; Chapter 73: Introduction to Monte Carlo simulation; 73.1 Answers to this chapter’s questions; 73.2 Problems; Chapter 74: Calculating an optimal bid; 74.1 Answers to this chapter’s questions; 74.2 Problems; Chapter 75: Simulating stock prices and asset allocation modeling; 75.1 Answers to this chapter’s questions; 75.2 Problems; Chapter 76: Fun and games: simulating gambling and sporting event probabilities; 76.1 Answers to this chapter’s questions; 76.2 Problems; Chapter 77: Using resampling to analyze data; 77.1 Answer to this chapter’s question; 77.2 Problems; Chapter 78: Pricing stock options; 78.1 Answers to this chapter’s questions; 78.2 Problems; Chapter 79: Determining customer value; 79.1 Answers to this chapter’s questions; 79.2 Problems; Chapter 80: The economic order quantity inventory model; 80.1 Answers to this chapter’s questions; 80.2 Problems; Chapter 81: Inventory modeling with uncertain demand; 81.1 Answers to this chapter’s questions; 81.2 Problems; Chapter 82: Queuing theory: the mathematics of waiting in line; 82.1 Answers to this chapter’s questions; 82.2 Problems; Chapter 83: Estimating a demand curve; 83.1 Answers to this chapter’s questions; 83.2 Problems; Chapter 84: Pricing products by using tie-ins; 84.1 Answer to this chapter’s question; 84.2 Problems; Chapter 85: Pricing products by using subjectively determined demand; 85.1 Answers to this chapter’s questions; 85.2 Problems; Chapter 86: Nonlinear pricing; 86.1 Answers to this chapter’s questions; 86.2 Problems; Chapter 87: Array formulas and functions; 87.1 Ans...

Le informazioni nella sezione "Su questo libro" possono far riferimento a edizioni diverse di questo titolo.

I migliori risultati di ricerca su AbeBooks

Edizione Internazionale
Edizione Internazionale

1.

Winston,W.L.
ISBN 10: 0735669139 ISBN 13: 9780735669130
Nuovi PAPERBACK Quantità: 15
Edizione Internazionale
Da
Stock Tiger
(New Delhi, DELHI, India)
Valutazione libreria
[?]

Descrizione libro PAPERBACK. Condizione libro: New. PAPERBACK INTERNATIONAL EDITION Brand New Book. We ship from India. The ISBN-13 or Cover might be different but content is extactly same. We deliver in 5 - 9days and respond quickly to customer queries. Codice libro della libreria Abe-E-0735669139

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 25,44
Convertire valuta

Aggiungere al carrello

Spese di spedizione: GRATIS
Da: India a: U.S.A.
Destinazione, tempi e costi

2.

Winston, Wayne
Editore: Prentice Hall
ISBN 10: 0735669139 ISBN 13: 9780735669130
Nuovi Quantità: > 20
Da
INDOO
(Avenel, NJ, U.S.A.)
Valutazione libreria
[?]

Descrizione libro Prentice Hall. Condizione libro: New. Brand New. Codice libro della libreria 0735669139

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 29,69
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 3,23
In U.S.A.
Destinazione, tempi e costi

3.

Winston, Wayne L.
ISBN 10: 0735669139 ISBN 13: 9780735669130
Nuovi Softcover Quantità: 15
Da
VNHM SHOP
(Pompano Beach, FL, U.S.A.)
Valutazione libreria
[?]

Descrizione libro Softcover. Condizione libro: New. 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. Codice libro della libreria 9583625

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 34,77
Convertire valuta

Aggiungere al carrello

Spese di spedizione: GRATIS
In U.S.A.
Destinazione, tempi e costi

4.

Winston, Wayne
Editore: Microsoft Press
ISBN 10: 0735669139 ISBN 13: 9780735669130
Nuovi PAPERBACK Quantità: > 20
Da
Movie Mars
(Indian Trail, NC, U.S.A.)
Valutazione libreria
[?]

Descrizione libro Microsoft Press. PAPERBACK. Condizione libro: New. 0735669139 Brand New Book. Ships from the United States. 30 Day Satisfaction Guarantee!. Codice libro della libreria 16907582

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 33,32
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 3,68
In U.S.A.
Destinazione, tempi e costi

5.

Winston, Wayne
Editore: Microsoft Press (2014)
ISBN 10: 0735669139 ISBN 13: 9780735669130
Nuovi PAPERBACK Quantità: 2
Da
PetesCheapBooks
(Long Beach, CA, U.S.A.)
Valutazione libreria
[?]

Descrizione libro Microsoft Press, 2014. PAPERBACK. Condizione libro: New. 0735669139 *NEW!* RETURNS ARE NO PROBLEM! We LOVE happy customers. All of our orders are sent with tracking information when possible. Abebooks-. Codice libro della libreria NCLN13016975

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 33,33
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 3,68
In U.S.A.
Destinazione, tempi e costi

6.

Wayne Winston
Editore: Microsoft Press,U.S., United States (2014)
ISBN 10: 0735669139 ISBN 13: 9780735669130
Nuovi Paperback Prima edizione Quantità: 10
Da
The Book Depository US
(London, Regno Unito)
Valutazione libreria
[?]

Descrizione libro Microsoft Press,U.S., United States, 2014. Paperback. Condizione libro: New. 1st ed.. 230 x 188 mm. Language: English . Brand New Book. 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. Codice libro della libreria AAS9780735669130

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 40,80
Convertire valuta

Aggiungere al carrello

Spese di spedizione: GRATIS
Da: Regno Unito a: U.S.A.
Destinazione, tempi e costi

7.

Wayne Winston
Editore: Microsoft Press,U.S., United States (2014)
ISBN 10: 0735669139 ISBN 13: 9780735669130
Nuovi Paperback Prima edizione Quantità: 10
Da
The Book Depository
(London, Regno Unito)
Valutazione libreria
[?]

Descrizione libro Microsoft Press,U.S., United States, 2014. Paperback. Condizione libro: New. 1st ed.. 230 x 188 mm. Language: English . Brand New Book. 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. Codice libro della libreria AAS9780735669130

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 40,82
Convertire valuta

Aggiungere al carrello

Spese di spedizione: GRATIS
Da: Regno Unito a: U.S.A.
Destinazione, tempi e costi

8.

Winston, Wayne
Editore: Microsoft Press (2014)
ISBN 10: 0735669139 ISBN 13: 9780735669130
Nuovi Paperback Quantità: 3
Da
Ergodebooks
(RICHMOND, TX, U.S.A.)
Valutazione libreria
[?]

Descrizione libro Microsoft Press, 2014. Paperback. Condizione libro: New. Codice libro della libreria INGM9780735669130

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 39,70
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 3,68
In U.S.A.
Destinazione, tempi e costi

9.

Wayne Winston
Editore: Microsoft Press,U.S. 2014-01-15, Redmond (2014)
ISBN 10: 0735669139 ISBN 13: 9780735669130
Nuovi paperback Quantità: 5
Da
Blackwell's
(Oxford, OX, Regno Unito)
Valutazione libreria
[?]

Descrizione libro Microsoft Press,U.S. 2014-01-15, Redmond, 2014. paperback. Condizione libro: New. Codice libro della libreria 9780735669130

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 38,43
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 5,19
Da: Regno Unito a: U.S.A.
Destinazione, tempi e costi

10.

Wayne Winston
Editore: Microsoft Press,U.S.
ISBN 10: 0735669139 ISBN 13: 9780735669130
Nuovi Paperback Quantità: 18
Da
THE SAINT BOOKSTORE
(Southport, Regno Unito)
Valutazione libreria
[?]

Descrizione libro Microsoft Press,U.S. Paperback. Condizione libro: new. BRAND NEW, Data Analysis and Business Modeling: Microsoft Excel 2013, Wayne Winston, 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. Codice libro della libreria B9780735669130

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 38,03
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 6,85
Da: Regno Unito a: U.S.A.
Destinazione, tempi e costi

Vedi altre copie di questo libro

Vedi tutti i risultati per questo libro