SPECIAL OFFERS
Keep up with new releases and promotions.Sign up to hear from us.
This eBook includes the following formats, accessible from yourAccountpage after purchase:
EPUBThe open industry format known for its reflowable content and usability on supported mobile devices.
PDFThe popular standard, used most often with the freeAdobe® Reader®software.
This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.
Also available inother formats.
Register your productto gain access to bonus material or receive a coupon.
Master business modeling and analysis techniques with Microsoft Excel and transform data into bottom-line results. Award-winning educator Wayne Winstons hands-on, scenario-focused guide helps you use todays Excel to ask the right questions and get accurate, actionable answers. More extensively updated than any previous edition, new coverage ranges from one-click data analysis to STOCKHISTORY, dynamic arrays to Power Query, and includes six new chapters. Practice with over 900 problems, many based on real challenges faced by working analysts.
Solve real problems with Microsoft Exceland build your competitive advantage
Follow the instructions to download this book's lesson files.
Download the sample pages(includes Chapter 4)
土地干裂ER 1 Basic worksheet modeling
第二章范围名称
土地干裂ER 3 Lookup functions
土地干裂ER 4 The INDEX function
土地干裂ER 5 The MATCH function
土地干裂ER 6 Text functions and Flash Fill
土地干裂ER 7 Dates and date functions
土地干裂ER 8 The net present value functions: NPV and XNPV
土地干裂ER 9 The internal rate of return: IRR, XIRR, and MIRR functions
土地干裂ER 10 More Excel financial functions
土地干裂ER 11 Circular references
土地干裂ER 12 IF, IFERROR, IFS, CHOOSE, SWITCH, and the IS functions
土地干裂ER 13 Time and time functions
土地干裂ER 14 The Paste Special command
土地干裂ER 15 Three-dimensional formulas and hyperlinks
土地干裂ER 16 The auditing tool and the Inquire add-in
土地干裂ER 17 Sensitivity analysis with data tables
土地干裂ER 18 The Goal Seek command
土地干裂ER 19 Using the Scenario Manager for sensitivity analysis
土地干裂ER 20 The COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK functions
土地干裂ER 21 The SUMIF, AVERAGEIF, SUMIFS, AVERAGEIFS, MAXIFS, and MINIFS functions
土地干裂ER 22 The OFFSET function
土地干裂ER 23 The INDIRECT function
土地干裂ER 24 Conditional formatting
土地干裂ER 25 Excel tables and table slicers
土地干裂ER 26 Spin buttons, scrollbars, option buttons, check boxes, combo boxes, and group list boxes
土地干裂ER 27 Importing data from a text file or document
土地干裂ER 28 The Power Query Editor
土地干裂ER 29 Excels new data types
土地干裂ER 30 Summarizing data with histograms and Pareto charts
土地干裂ER 31 Summarizing data with descriptive statistics
土地干裂ER 32 Sorting in Excel
土地干裂ER 33 Filtering data and removing duplicates
土地干裂ER 34 Summarizing data with database statistical functions
土地干裂ER 35 Array formulas and functions
土地干裂ER 36 Excels new dynamic array functions
土地干裂ER 37 Validating data
土地干裂ER 38 Using PivotTables and slicers to describe data
土地干裂ER 39 The Data Model
土地干裂ER 40 Power Pivot
土地干裂ER 41 Consolidating data
土地干裂ER 42 Creating subtotals
土地干裂ER 43 Basic charting
土地干裂ER 44 Advanced charting
土地干裂ER 45 Filled and 3D Maps
土地干裂ER 46 Sparklines
土地干裂ER 47 Estimating straight-line relationships
土地干裂ER 48 Modeling exponential growth
土地干裂ER 49 The power curve
土地干裂ER 50 Using correlations to summarize relationships
土地干裂ER 51 Introduction to multiple regression
土地干裂ER 52 Incorporating qualitative factors into multiple regression
土地干裂ER 53 Modeling nonlinearities and interactions
土地干裂ER 54 Analysis of variance: One-way ANOVA
土地干裂ER 55 Randomized blocks and two-way ANOVA
土地干裂ER 56 Using moving averages to understand time series
土地干裂ER 57 Ratio-to-moving-average forecast method
土地干裂ER 58 An introduction to probability
土地干裂ER 59 An introduction to random variables
土地干裂ER 60 The binomial, hypergeometric, and negative binomial random variables
土地干裂ER 61 The Poisson and exponential random variable
土地干裂ER 62 The normal random variable and Z-scores
土地干裂ER 63 Making probability statements from forecasts
土地干裂ER 64 Using the lognormal random variable to model stock prices
土地干裂ER 65 Importing past stock prices, exchange rates, and cryptocurrency prices with the STOCKHISTORY function
土地干裂ER 66 An introduction to optimization with Excel Solver
土地干裂ER 67 Using Solver to determine the optimal product mix
土地干裂ER 68 Using Solver to schedule your workforce
土地干裂ER 69 Using Solver to solve transportation or distribution problems
土地干裂ER 70 Using Solver for capital budgeting
土地干裂ER 71 Using Solver for financial planning
土地干裂ER 72 Using Solver to rate sports teams
73年冬天法和预测Sh章eet tool
土地干裂ER 74 Forecasting in the presence of special events
土地干裂ER 75 Warehouse location and the GRG Multistart and Evolutionary Solver engines
土地干裂ER 76 Penalties and the Evolutionary Solver
土地干裂ER 77 The traveling salesperson problem
土地干裂ER 78 Weibull and beta distributions: Modeling machine life and duration of a project
土地干裂ER 79 Introduction to Monte Carlo simulation
土地干裂ER 80 Calculating an optimal bid
土地干裂ER 81 Simulating stock prices and asset-allocation modeling
土地干裂ER 82 Fun and games: Simulating gambling and sporting-event probabilities
土地干裂ER 83 Using resampling to analyze data
土地干裂ER 84 Pricing stock options
土地干裂ER 85 Determining customer value
土地干裂ER 86 The economic order quantity inventory model
土地干裂ER 87 Inventory modeling with uncertain demand
土地干裂ER 88 Queuing theory: The mathematics of waiting in line
土地干裂ER 89 Estimating a demand curve
土地干裂ER 90 Pricing products by using tie-ins
土地干裂ER 91 Pricing products by using subjectively determined demand
土地干裂ER 92 Nonlinear pricing
土地干裂ER 93 Use Analyze Data to find patterns in your data
土地干裂ER 94 Recording macros
土地干裂ER 95 The LET and LAMBDA functions and the LAMBDA helper functions
土地干裂ER 96 Advanced sensitivity analysis