Wayne Winston
Microsoft Excel 2019 Data Analysis and Business Modeling
Wayne Winston
Microsoft Excel 2019 Data Analysis and Business Modeling
- Broschiertes Buch
- Merkliste
- Auf die Merkliste
- Bewerten Bewerten
- Teilen
- Produkt teilen
- Produkterinnerung
- Produkterinnerung
Master business modeling and analysis techniques with Microsoft Excel 2019, 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 tablesGÇôand how to effectively build a relational data source inside an Excel workbook.
Andere Kunden interessierten sich auch für
- Joan LambertMOS 2016 Study Guide for Microsoft Excel26,99 €
- Lois PattersonTeach Yourself Microsoft Excel 97 in 24 Hours18,99 €
- McGraw HillIcheck Series, Microsoft Office Excel 2007, Real World Applications, Student Edition164,99 €
- Joe KraynakAbsolute Beginner's Guide to Microsoft Excel 200222,99 €
- Wayne WinstonMicrosoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365)38,99 €
- Excel 200242,99 €
- Paul CornellBeginning Excel What-If Data Analysis Tools51,99 €
-
-
-
Master business modeling and analysis techniques with Microsoft Excel 2019, 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 tablesGÇôand how to effectively build a relational data source inside an Excel workbook.
Hinweis: Dieser Artikel kann nur an eine deutsche Lieferadresse ausgeliefert werden.
Hinweis: Dieser Artikel kann nur an eine deutsche Lieferadresse ausgeliefert werden.
Produktdetails
- Produktdetails
- Verlag: Pearson Education / Pearson Education Limited
- 6th edition
- Seitenzahl: 880
- Erscheinungstermin: 15. April 2019
- Englisch
- Abmessung: 188mm x 233mm x 46mm
- Gewicht: 1602g
- ISBN-13: 9781509305889
- ISBN-10: 1509305882
- Artikelnr.: 54544223
- Herstellerkennzeichnung
- Libri GmbH
- Europaallee 1
- 36244 Bad Hersfeld
- 06621 890
- Verlag: Pearson Education / Pearson Education Limited
- 6th edition
- Seitenzahl: 880
- Erscheinungstermin: 15. April 2019
- Englisch
- Abmessung: 188mm x 233mm x 46mm
- Gewicht: 1602g
- ISBN-13: 9781509305889
- ISBN-10: 1509305882
- Artikelnr.: 54544223
- Herstellerkennzeichnung
- Libri GmbH
- Europaallee 1
- 36244 Bad Hersfeld
- 06621 890
Wayne L. Winston is Professor Emeritus of Decision Sciences at Indiana University’s Kelley School of Business, where he won 40+ teaching awards. He developed spreadsheet modeling coursework for Harvard Business School Publishing, and has taught or consulted on using Excel to improve decision-making at Microsoft, Cisco, Morgan Stanley, Pfizer, Verizon, the U.S. Navy, U.S. Army, and many other organizations. A two-time Jeopardy! Champion, he co-developed the Dallas Mavericks’ player tracking and rating system.
* Chapter 1 Basic spreadsheet modeling
* Chapter 2 Range names
* Chapter 3 Lookup functions
* Chapter 4 The INDEX function
* Chapter 5 The MATCH function
* Chapter 6 Text functions
* Chapter 7 Dates and date functions
* Chapter 8 Evaluating investment by using net present value criteria
* Chapter 9 Internal rate of return
* Chapter 10 More Excel financial functions
* Chapter 11 Circular references
* Chapter 12 IF statements
* Chapter 13 Time and time functions
* Chapter 14 The Paste Special command
* Chapter 15 Three-dimensional formulas and hyperlinks
* Chapter 16 The auditing tool
* Chapter 17 Sensitivity analysis with data tables
* Chapter 18 The Goal Seek command
* Chapter 19 Using the Scenario Manager for sensitivity analysis
* Chapter 20 The COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK
functions
* Chapter 21 The SUMIF, AVERAGEIF, SUMIFS, and AVERAGEIFS functions
* Chapter 22 The OFFSET function
* Chapter 23 The INDIRECT function
* Chapter 24 Conditional formatting
* Chapter 25 Sorting in Excel
* Chapter 26 Tables
* Chapter 27 Spin buttons, scroll bars, option buttons, check boxes,
combo boxes, and group list boxes
* Chapter 28 The analytics revolution
* Chapter 29 An introduction to optimization with Excel Solver
* Chapter 30 Using Solver to determine the optimal product mix
* Chapter 31 Using Solver to schedule your workforce
* Chapter 32 Using Solver to solve transportation or distribution
problems
* Chapter 33 Using Solver for capital budgeting
* Chapter 34 Using Solver for financial planning
* Chapter 35 Using Solver to rate sports teams
* Chapter 36 Warehouse location and the GRG Multistart and Evolutionary
Solver engines
* Chapter 37 Penalties and the Evolutionary Solver
* Chapter 38 The traveling salesperson problem
* Chapter 39 Importing data from a text file or document
* Chapter 40 Validating data
* Chapter 41 Summarizing data by using histograms and Pareto charts
* Chapter 42 Summarizing data by using descriptive statistics
* Chapter 43 Using PivotTables and slicers to describe data
* Chapter 44 The Data Model
* Chapter 45 Power Pivot
* Chapter 46 Power View and 3D Maps
* Chapter 47 Sparklines
* Chapter 48 Summarizing data with database statistical functions
* Chapter 49 Filtering data and removing duplicates
* Chapter 50 Consolidating data
* Chapter 51 Creating subtotals
* Chapter 52 Charting tricks
* Chapter 53 Estimating straight-line relationships
* Chapter 54 Modeling exponential growth
* Chapter 55 The power curve
* Chapter 56 Using correlations to summarize relationships
* Chapter 57 Introduction to multiple regression
* Chapter 58 Incorporating qualitative factors into multiple regression
* Chapter 59 Modeling nonlinearities and interactions
* Chapter 60 Analysis of variance: One-way ANOVA
* Chapter 61 Randomized blocks and two-way ANOVA
* Chapter 62 Using moving averages to understand time series
* Chapter 63 Winters method
* Chapter 64 Ratio-to-moving-average forecast method
* Chapter 65 Forecasting in the presence of special events
* Chapter 66 An introduction to probability
* Chapter 67 An introduction to random variables
* Chap
* Chapter 2 Range names
* Chapter 3 Lookup functions
* Chapter 4 The INDEX function
* Chapter 5 The MATCH function
* Chapter 6 Text functions
* Chapter 7 Dates and date functions
* Chapter 8 Evaluating investment by using net present value criteria
* Chapter 9 Internal rate of return
* Chapter 10 More Excel financial functions
* Chapter 11 Circular references
* Chapter 12 IF statements
* Chapter 13 Time and time functions
* Chapter 14 The Paste Special command
* Chapter 15 Three-dimensional formulas and hyperlinks
* Chapter 16 The auditing tool
* Chapter 17 Sensitivity analysis with data tables
* Chapter 18 The Goal Seek command
* Chapter 19 Using the Scenario Manager for sensitivity analysis
* Chapter 20 The COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK
functions
* Chapter 21 The SUMIF, AVERAGEIF, SUMIFS, and AVERAGEIFS functions
* Chapter 22 The OFFSET function
* Chapter 23 The INDIRECT function
* Chapter 24 Conditional formatting
* Chapter 25 Sorting in Excel
* Chapter 26 Tables
* Chapter 27 Spin buttons, scroll bars, option buttons, check boxes,
combo boxes, and group list boxes
* Chapter 28 The analytics revolution
* Chapter 29 An introduction to optimization with Excel Solver
* Chapter 30 Using Solver to determine the optimal product mix
* Chapter 31 Using Solver to schedule your workforce
* Chapter 32 Using Solver to solve transportation or distribution
problems
* Chapter 33 Using Solver for capital budgeting
* Chapter 34 Using Solver for financial planning
* Chapter 35 Using Solver to rate sports teams
* Chapter 36 Warehouse location and the GRG Multistart and Evolutionary
Solver engines
* Chapter 37 Penalties and the Evolutionary Solver
* Chapter 38 The traveling salesperson problem
* Chapter 39 Importing data from a text file or document
* Chapter 40 Validating data
* Chapter 41 Summarizing data by using histograms and Pareto charts
* Chapter 42 Summarizing data by using descriptive statistics
* Chapter 43 Using PivotTables and slicers to describe data
* Chapter 44 The Data Model
* Chapter 45 Power Pivot
* Chapter 46 Power View and 3D Maps
* Chapter 47 Sparklines
* Chapter 48 Summarizing data with database statistical functions
* Chapter 49 Filtering data and removing duplicates
* Chapter 50 Consolidating data
* Chapter 51 Creating subtotals
* Chapter 52 Charting tricks
* Chapter 53 Estimating straight-line relationships
* Chapter 54 Modeling exponential growth
* Chapter 55 The power curve
* Chapter 56 Using correlations to summarize relationships
* Chapter 57 Introduction to multiple regression
* Chapter 58 Incorporating qualitative factors into multiple regression
* Chapter 59 Modeling nonlinearities and interactions
* Chapter 60 Analysis of variance: One-way ANOVA
* Chapter 61 Randomized blocks and two-way ANOVA
* Chapter 62 Using moving averages to understand time series
* Chapter 63 Winters method
* Chapter 64 Ratio-to-moving-average forecast method
* Chapter 65 Forecasting in the presence of special events
* Chapter 66 An introduction to probability
* Chapter 67 An introduction to random variables
* Chap
* Chapter 1 Basic spreadsheet modeling
* Chapter 2 Range names
* Chapter 3 Lookup functions
* Chapter 4 The INDEX function
* Chapter 5 The MATCH function
* Chapter 6 Text functions
* Chapter 7 Dates and date functions
* Chapter 8 Evaluating investment by using net present value criteria
* Chapter 9 Internal rate of return
* Chapter 10 More Excel financial functions
* Chapter 11 Circular references
* Chapter 12 IF statements
* Chapter 13 Time and time functions
* Chapter 14 The Paste Special command
* Chapter 15 Three-dimensional formulas and hyperlinks
* Chapter 16 The auditing tool
* Chapter 17 Sensitivity analysis with data tables
* Chapter 18 The Goal Seek command
* Chapter 19 Using the Scenario Manager for sensitivity analysis
* Chapter 20 The COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK
functions
* Chapter 21 The SUMIF, AVERAGEIF, SUMIFS, and AVERAGEIFS functions
* Chapter 22 The OFFSET function
* Chapter 23 The INDIRECT function
* Chapter 24 Conditional formatting
* Chapter 25 Sorting in Excel
* Chapter 26 Tables
* Chapter 27 Spin buttons, scroll bars, option buttons, check boxes,
combo boxes, and group list boxes
* Chapter 28 The analytics revolution
* Chapter 29 An introduction to optimization with Excel Solver
* Chapter 30 Using Solver to determine the optimal product mix
* Chapter 31 Using Solver to schedule your workforce
* Chapter 32 Using Solver to solve transportation or distribution
problems
* Chapter 33 Using Solver for capital budgeting
* Chapter 34 Using Solver for financial planning
* Chapter 35 Using Solver to rate sports teams
* Chapter 36 Warehouse location and the GRG Multistart and Evolutionary
Solver engines
* Chapter 37 Penalties and the Evolutionary Solver
* Chapter 38 The traveling salesperson problem
* Chapter 39 Importing data from a text file or document
* Chapter 40 Validating data
* Chapter 41 Summarizing data by using histograms and Pareto charts
* Chapter 42 Summarizing data by using descriptive statistics
* Chapter 43 Using PivotTables and slicers to describe data
* Chapter 44 The Data Model
* Chapter 45 Power Pivot
* Chapter 46 Power View and 3D Maps
* Chapter 47 Sparklines
* Chapter 48 Summarizing data with database statistical functions
* Chapter 49 Filtering data and removing duplicates
* Chapter 50 Consolidating data
* Chapter 51 Creating subtotals
* Chapter 52 Charting tricks
* Chapter 53 Estimating straight-line relationships
* Chapter 54 Modeling exponential growth
* Chapter 55 The power curve
* Chapter 56 Using correlations to summarize relationships
* Chapter 57 Introduction to multiple regression
* Chapter 58 Incorporating qualitative factors into multiple regression
* Chapter 59 Modeling nonlinearities and interactions
* Chapter 60 Analysis of variance: One-way ANOVA
* Chapter 61 Randomized blocks and two-way ANOVA
* Chapter 62 Using moving averages to understand time series
* Chapter 63 Winters method
* Chapter 64 Ratio-to-moving-average forecast method
* Chapter 65 Forecasting in the presence of special events
* Chapter 66 An introduction to probability
* Chapter 67 An introduction to random variables
* Chap
* Chapter 2 Range names
* Chapter 3 Lookup functions
* Chapter 4 The INDEX function
* Chapter 5 The MATCH function
* Chapter 6 Text functions
* Chapter 7 Dates and date functions
* Chapter 8 Evaluating investment by using net present value criteria
* Chapter 9 Internal rate of return
* Chapter 10 More Excel financial functions
* Chapter 11 Circular references
* Chapter 12 IF statements
* Chapter 13 Time and time functions
* Chapter 14 The Paste Special command
* Chapter 15 Three-dimensional formulas and hyperlinks
* Chapter 16 The auditing tool
* Chapter 17 Sensitivity analysis with data tables
* Chapter 18 The Goal Seek command
* Chapter 19 Using the Scenario Manager for sensitivity analysis
* Chapter 20 The COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK
functions
* Chapter 21 The SUMIF, AVERAGEIF, SUMIFS, and AVERAGEIFS functions
* Chapter 22 The OFFSET function
* Chapter 23 The INDIRECT function
* Chapter 24 Conditional formatting
* Chapter 25 Sorting in Excel
* Chapter 26 Tables
* Chapter 27 Spin buttons, scroll bars, option buttons, check boxes,
combo boxes, and group list boxes
* Chapter 28 The analytics revolution
* Chapter 29 An introduction to optimization with Excel Solver
* Chapter 30 Using Solver to determine the optimal product mix
* Chapter 31 Using Solver to schedule your workforce
* Chapter 32 Using Solver to solve transportation or distribution
problems
* Chapter 33 Using Solver for capital budgeting
* Chapter 34 Using Solver for financial planning
* Chapter 35 Using Solver to rate sports teams
* Chapter 36 Warehouse location and the GRG Multistart and Evolutionary
Solver engines
* Chapter 37 Penalties and the Evolutionary Solver
* Chapter 38 The traveling salesperson problem
* Chapter 39 Importing data from a text file or document
* Chapter 40 Validating data
* Chapter 41 Summarizing data by using histograms and Pareto charts
* Chapter 42 Summarizing data by using descriptive statistics
* Chapter 43 Using PivotTables and slicers to describe data
* Chapter 44 The Data Model
* Chapter 45 Power Pivot
* Chapter 46 Power View and 3D Maps
* Chapter 47 Sparklines
* Chapter 48 Summarizing data with database statistical functions
* Chapter 49 Filtering data and removing duplicates
* Chapter 50 Consolidating data
* Chapter 51 Creating subtotals
* Chapter 52 Charting tricks
* Chapter 53 Estimating straight-line relationships
* Chapter 54 Modeling exponential growth
* Chapter 55 The power curve
* Chapter 56 Using correlations to summarize relationships
* Chapter 57 Introduction to multiple regression
* Chapter 58 Incorporating qualitative factors into multiple regression
* Chapter 59 Modeling nonlinearities and interactions
* Chapter 60 Analysis of variance: One-way ANOVA
* Chapter 61 Randomized blocks and two-way ANOVA
* Chapter 62 Using moving averages to understand time series
* Chapter 63 Winters method
* Chapter 64 Ratio-to-moving-average forecast method
* Chapter 65 Forecasting in the presence of special events
* Chapter 66 An introduction to probability
* Chapter 67 An introduction to random variables
* Chap