Winston, Wayne L.
Microsoft Excel 2019 : data analysis and business modeling / Wayne L. Winston - 6th ed. - New Delhi ; Pearson Education India, 2019. - xxvii, 850 pages : illustrations ; 23 cm
"Microsoft Press"--Back cover
Includes index
Basic worksheet modeling
Range names
Lookup functions
The INDEX function
The MATCH function
Text functions and Flash Fill
Dates and date functions
NPV and XNPV functions
IRR, XIRR, and MIRR functions
More Excel financial functions
Circular references
IF, IFERROR, IFS, CHOOSE, and SWITCH functions
Time and time functions
The Paste Special command
Three-dimensional formulas and hyperlinks
The auding tool and the Inquire add-in
Sensitivity analysis with data tables
The Goal Seek command
Using the Scenario Manager for sensitivity analysis
The COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK functions
The SUMIF, AVERAGEIF, SUMIFS, AVERAGEIFS, MAXIFS, and MINIFS functions
The OFFSET function
The INDIRECT function
Conditional formatting
Sorting in Excel
Excel Tables and table slicers
Spin buttons, scrollbars, option buttons, check boxes, combo boxes, and group list boxes
The analytics revolution
An introduction to optimization with Excel Solver
Using Solver to determine the optimal product mix
Using Solver to schedule your workforce
Using Solver to solve transportation or distribution problems
Using Solver for capital budgeting
Using Solver for financial planning
Using Solver to rate sports teams
Warehouse location and the GRG Multistart and Evolutionary Solver engines
Penalties and the Evolutionary Solver
The traveling salesperson problem
Importing data from a text file or document
Get & Transform
Geography and Stock data types
Validating data
Summarizing data by using histograms and Pareto charts
Summarizing data by using descriptive statistics
Using pivot tables and slicers to describe data
The Data Model
Power Pivot
Filled and 3D Power Maps
Sparklines
Summarizing data with database statistical functions
Filtering data and removing duplicates
Consolidating data
Creating subtotals
Charting tricks
Estimating straight-line relationships
Modeling exponential growth
The power curve using correlations to summarize relationships
Introduction to multiple regression
Incorprating qualitative factors into multiple regression
Modeling nonlinearities and interactions
Analysis of variance: One-way ANOVA
Randomized blocks and two-way ANOVA
Using moving averages to understand time series
Winters method and the Forecast Sheet
Ratio-to-moving-average forecast method
Forecasting in the presence of special events
An introduction to probability
An introduction to random variables
The binomial, hypergeometric, and negative binomial random variables
The Poisson and exponential random variable
The normal random variable and Z-scores
Weibull and beta distributions: Modeling machine life and duration of a project
Making probability statements from forecasts
Using the lognormal random variaable to model stock prices
Importing historical stock data into Excel
Introduction to Monte Carlo simulation
Calculating an optimal bid
Simulating stock prices and asset-allocation modeling
Fun and games: Simulating gambling and sporting event probabilities
Using resampling to analyze data
Pricing stock options
Determining customer value
The economic order quantity inventory model
Inventory modeling with uncertain demand
Queuing theory: The mathematics of waiting in line
Estimating a demand curve
Pricing products by using tie-ins
Pricing products by using subjectively determinded demand
Nonlinear pricing
Array formulas and functions
Recording macros
Advanced sensitivity analysis
9789389347180
Business --Computer programs
Decision making --Computer programs
Microsoft excel (Computer file)
005.54 / WIN
Microsoft Excel 2019 : data analysis and business modeling / Wayne L. Winston - 6th ed. - New Delhi ; Pearson Education India, 2019. - xxvii, 850 pages : illustrations ; 23 cm
"Microsoft Press"--Back cover
Includes index
Basic worksheet modeling
Range names
Lookup functions
The INDEX function
The MATCH function
Text functions and Flash Fill
Dates and date functions
NPV and XNPV functions
IRR, XIRR, and MIRR functions
More Excel financial functions
Circular references
IF, IFERROR, IFS, CHOOSE, and SWITCH functions
Time and time functions
The Paste Special command
Three-dimensional formulas and hyperlinks
The auding tool and the Inquire add-in
Sensitivity analysis with data tables
The Goal Seek command
Using the Scenario Manager for sensitivity analysis
The COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK functions
The SUMIF, AVERAGEIF, SUMIFS, AVERAGEIFS, MAXIFS, and MINIFS functions
The OFFSET function
The INDIRECT function
Conditional formatting
Sorting in Excel
Excel Tables and table slicers
Spin buttons, scrollbars, option buttons, check boxes, combo boxes, and group list boxes
The analytics revolution
An introduction to optimization with Excel Solver
Using Solver to determine the optimal product mix
Using Solver to schedule your workforce
Using Solver to solve transportation or distribution problems
Using Solver for capital budgeting
Using Solver for financial planning
Using Solver to rate sports teams
Warehouse location and the GRG Multistart and Evolutionary Solver engines
Penalties and the Evolutionary Solver
The traveling salesperson problem
Importing data from a text file or document
Get & Transform
Geography and Stock data types
Validating data
Summarizing data by using histograms and Pareto charts
Summarizing data by using descriptive statistics
Using pivot tables and slicers to describe data
The Data Model
Power Pivot
Filled and 3D Power Maps
Sparklines
Summarizing data with database statistical functions
Filtering data and removing duplicates
Consolidating data
Creating subtotals
Charting tricks
Estimating straight-line relationships
Modeling exponential growth
The power curve using correlations to summarize relationships
Introduction to multiple regression
Incorprating qualitative factors into multiple regression
Modeling nonlinearities and interactions
Analysis of variance: One-way ANOVA
Randomized blocks and two-way ANOVA
Using moving averages to understand time series
Winters method and the Forecast Sheet
Ratio-to-moving-average forecast method
Forecasting in the presence of special events
An introduction to probability
An introduction to random variables
The binomial, hypergeometric, and negative binomial random variables
The Poisson and exponential random variable
The normal random variable and Z-scores
Weibull and beta distributions: Modeling machine life and duration of a project
Making probability statements from forecasts
Using the lognormal random variaable to model stock prices
Importing historical stock data into Excel
Introduction to Monte Carlo simulation
Calculating an optimal bid
Simulating stock prices and asset-allocation modeling
Fun and games: Simulating gambling and sporting event probabilities
Using resampling to analyze data
Pricing stock options
Determining customer value
The economic order quantity inventory model
Inventory modeling with uncertain demand
Queuing theory: The mathematics of waiting in line
Estimating a demand curve
Pricing products by using tie-ins
Pricing products by using subjectively determinded demand
Nonlinear pricing
Array formulas and functions
Recording macros
Advanced sensitivity analysis
9789389347180
Business --Computer programs
Decision making --Computer programs
Microsoft excel (Computer file)
005.54 / WIN