Microsoft Excel 2019 Data Analysis and Business Modeling
6th Edition
Published on 28. March 2019
864 pages
978-1-5093-0607-7 (ISBN)
Description
Master business modeling and analysis techniques with Microsoft Excel 2019 and Office 365 and transform data into bottom-line results. Written by award-winning educator Wayne Winston, this hands-on, scenario-focused guide helps you use Excel to ask the right questions and get accurate, actionable answers. New coverage ranges from Power Query/Get & Transform to Office 365 Geography and Stock data types. Practice with more than 800 problems, many based on actual challenges faced by working analysts.
Solve real business problems with Excel-and build your competitive advantage:
Quickly transition from Excel basics to sophisticated analytics
Use PowerQuery or Get & Transform to connect, combine, and refine data sources
Leverage Office 365's new Geography and Stock data types and six new functions
Illuminate insights from geographic and temporal data with 3D Maps
Summarize data with pivot tables, descriptive statistics, histograms, and Pareto charts
Use Excel trend curves, multiple regression, and exponential smoothing
Delve into key financial, statistical, and time functions
Master all of Excel's great charts
Quickly create forecasts from historical time-based data
Use Solver to optimize product mix, logistics, work schedules, and investments-and even rate sports teams
Run Monte Carlo simulations on stock prices and bidding models
Learn about basic probability and Bayes' Theorem
Use the Data Model and Power Pivot to effectively build and use relational data sources inside an Excel workbook
Automate repetitive analytics tasks by using macros
Solve real business problems with Excel-and build your competitive advantage:
Quickly transition from Excel basics to sophisticated analytics
Use PowerQuery or Get & Transform to connect, combine, and refine data sources
Leverage Office 365's new Geography and Stock data types and six new functions
Illuminate insights from geographic and temporal data with 3D Maps
Summarize data with pivot tables, descriptive statistics, histograms, and Pareto charts
Use Excel trend curves, multiple regression, and exponential smoothing
Delve into key financial, statistical, and time functions
Master all of Excel's great charts
Quickly create forecasts from historical time-based data
Use Solver to optimize product mix, logistics, work schedules, and investments-and even rate sports teams
Run Monte Carlo simulations on stock prices and bidding models
Learn about basic probability and Bayes' Theorem
Use the Data Model and Power Pivot to effectively build and use relational data sources inside an Excel workbook
Automate repetitive analytics tasks by using macros
All prices
More details
Edition
6th edition
Language
English
Place of publication
Boston
United States
Publishing group
Microsoft Press,U.S.
Target group
Professional and scholarly
File size
51,37 MB
ISBN-13
978-1-5093-0607-7 (9781509306077)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Other editions
Additional editions
Wayne Winston
Microsoft Excel 2019 Data Analysis and Business Modeling
Book
04/2019
6th Edition
Microsoft Press
€47.00
Shipment within 3-4 weeks
Person
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.
Content
1 Basic worksheet modeling
2 Range names
3 Lookup functions
4 The INDEX function
5 The MATCH function
6 Text functions and Flash Fill
7 Dates and date functions
8 Evaluating investments by using net present value criteria
9 IRR, XIRR, and MIRR functions
10 More Excel financial functions
11 Circular references
12 IF, IFERROR, IFS, CHOOSE, and SWITCH functions
13 Time and time functions
14 The Paste Special command
15 Three-dimensional formulas and hyperlinks
16 The auditing tool and the Inquire add-in
17 Sensitivity analysis with data tables
18 The Goal Seek command
19 Using the Scenario Manager for sensitivity analysis
20 The COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK functions
21 The SUMIF, AVERAGEIF, SUMIFS, AVERAGEIFS, MAXIFS, and MINIFS functions
22 The OFFSET function
23 The INDIRECT function
24 Conditional formatting
25 Sorting in Excel
26 Excel tables and table slicers
27 Spin buttons, scrollbars, option buttons, check boxes, combo boxes, and group list boxes
28 The analytics revolution
29 An introduction to optimization with Excel Solver
30 Using Solver to determine the optimal product mix
31 Using Solver to schedule your workforce
32 Using Solver to solve transportation or distribution problems
33 Using Solver for capital budgeting
34 Using Solver for financial planning
35 Using Solver to rate sports teams
36 Warehouse location and the GRG Multistart and Evolutionary Solver engines
37 Penalties and the Evolutionary Solver
38 The traveling salesperson problem
39 Importing data from a text file or document
40 Get & Transform (or s/b Get & Transform?)
41 Geography and Stock data types
42 Validating data
43 Summarizing data by using histograms and Pareto charts
44 Summarizing data by using descriptive statistics
45 Using pivot tables and slicers to describe data
46 The Data Model
47 Power Pivot
48 Filled and 3D Power Maps
49 Sparklines
50 Summarizing data with database statistical functions
51 Filtering data and removing duplicates
52 Consolidating data
53 Creating subtotals
54 Charting tricks
55 Estimating straight-line relationships
56 Modeling exponential growth
57 The power curve
58 Using correlations to summarize relationships
59 Introduction to multiple regression
60 Incorporating qualitative factors into multiple regression
61 Modeling nonlinearities and interactions
62 Analysis of variance: One-way ANOVA
63 Randomized blocks and two-way ANOVA
64 Using moving averages to understand time series
65 Winters method and the Forecast Sheet
66 Ratio-to-moving-average forecast method
67 Forecasting in the presence of special events
68 Introduction to Probability
69 An introduction to random variables
70 The binomial, hypergeometric, and negative binomial random variables
71 The Poisson and exponential random variables
72 The normal random variable and Z-scores
73 Weibull and beta distributions: Modeling machine life and project duration
74 Making probability statements from forecasts
75 Using the lognormal random variable to model stock prices
76 Importing Historical stock data into Excel
77 Introduction to Monte Carlo simulation
78 Calculating an optimal bid
79 Simulating stock prices and asset-allocation modeling
80 Fun and games: Simulating gambling and sporting event probabilities
81 Using resampling to analyze data
82 Pricing stock options
83 Determining customer value
84 The economic order quantity inventory model
85 Inventory modeling with uncertain demand
86 Queueing theory: The mathematics of waiting in line
87 Estimating a demand curve
88 Pricing products by using tie-ins
89 Pricing products by using subjectively determined demand
90 Nonlinear pricing
91 Array formulas and functions
92 Recording macros
93 Advanced Sensitivity Analysis
2 Range names
3 Lookup functions
4 The INDEX function
5 The MATCH function
6 Text functions and Flash Fill
7 Dates and date functions
8 Evaluating investments by using net present value criteria
9 IRR, XIRR, and MIRR functions
10 More Excel financial functions
11 Circular references
12 IF, IFERROR, IFS, CHOOSE, and SWITCH functions
13 Time and time functions
14 The Paste Special command
15 Three-dimensional formulas and hyperlinks
16 The auditing tool and the Inquire add-in
17 Sensitivity analysis with data tables
18 The Goal Seek command
19 Using the Scenario Manager for sensitivity analysis
20 The COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK functions
21 The SUMIF, AVERAGEIF, SUMIFS, AVERAGEIFS, MAXIFS, and MINIFS functions
22 The OFFSET function
23 The INDIRECT function
24 Conditional formatting
25 Sorting in Excel
26 Excel tables and table slicers
27 Spin buttons, scrollbars, option buttons, check boxes, combo boxes, and group list boxes
28 The analytics revolution
29 An introduction to optimization with Excel Solver
30 Using Solver to determine the optimal product mix
31 Using Solver to schedule your workforce
32 Using Solver to solve transportation or distribution problems
33 Using Solver for capital budgeting
34 Using Solver for financial planning
35 Using Solver to rate sports teams
36 Warehouse location and the GRG Multistart and Evolutionary Solver engines
37 Penalties and the Evolutionary Solver
38 The traveling salesperson problem
39 Importing data from a text file or document
40 Get & Transform (or s/b Get & Transform?)
41 Geography and Stock data types
42 Validating data
43 Summarizing data by using histograms and Pareto charts
44 Summarizing data by using descriptive statistics
45 Using pivot tables and slicers to describe data
46 The Data Model
47 Power Pivot
48 Filled and 3D Power Maps
49 Sparklines
50 Summarizing data with database statistical functions
51 Filtering data and removing duplicates
52 Consolidating data
53 Creating subtotals
54 Charting tricks
55 Estimating straight-line relationships
56 Modeling exponential growth
57 The power curve
58 Using correlations to summarize relationships
59 Introduction to multiple regression
60 Incorporating qualitative factors into multiple regression
61 Modeling nonlinearities and interactions
62 Analysis of variance: One-way ANOVA
63 Randomized blocks and two-way ANOVA
64 Using moving averages to understand time series
65 Winters method and the Forecast Sheet
66 Ratio-to-moving-average forecast method
67 Forecasting in the presence of special events
68 Introduction to Probability
69 An introduction to random variables
70 The binomial, hypergeometric, and negative binomial random variables
71 The Poisson and exponential random variables
72 The normal random variable and Z-scores
73 Weibull and beta distributions: Modeling machine life and project duration
74 Making probability statements from forecasts
75 Using the lognormal random variable to model stock prices
76 Importing Historical stock data into Excel
77 Introduction to Monte Carlo simulation
78 Calculating an optimal bid
79 Simulating stock prices and asset-allocation modeling
80 Fun and games: Simulating gambling and sporting event probabilities
81 Using resampling to analyze data
82 Pricing stock options
83 Determining customer value
84 The economic order quantity inventory model
85 Inventory modeling with uncertain demand
86 Queueing theory: The mathematics of waiting in line
87 Estimating a demand curve
88 Pricing products by using tie-ins
89 Pricing products by using subjectively determined demand
90 Nonlinear pricing
91 Array formulas and functions
92 Recording macros
93 Advanced Sensitivity Analysis
