Wayne Winston
Pearson Education
e druk, 2019
9781509306077
Microsoft Excel 2019 Data Analysis and Business Modeling
Specificaties
E-book, blz.
|
Engels
Pearson Education |
e druk, 2019
ISBN13: 9781509306077
Rubricering
Verwachte levertijd ongeveer 9 werkdagen
Samenvatting
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
Specificaties
Inhoudsopgave
<p style="margin:0px;">1 Basic worksheet modeling </p> <p style="margin:0px;">2 Range names</p> <p style="margin:0px;">3 Lookup functions</p> <p style="margin:0px;">4 The INDEX function</p> <p style="margin:0px;">5 The MATCH function</p> <p style="margin:0px;">6 Text functions and Flash Fill</p> <p style="margin:0px;">7 Dates and date functions</p> <p style="margin:0px;">8 Evaluating investments by using net present value criteria </p> <p style="margin:0px;">9 IRR, XIRR, and MIRR functions</p> <p style="margin:0px;">10 More Excel financial functions</p> <p style="margin:0px;">11 Circular references</p> <p style="margin:0px;">12 IF, IFERROR, IFS, CHOOSE, and SWITCH functions</p> <p style="margin:0px;">13 Time and time functions</p> <p style="margin:0px;">14 The Paste Special command</p> <p style="margin:0px;">15 Three-dimensional formulas and hyperlinks</p> <p style="margin:0px;">16 The auditing tool and the Inquire add-in</p> <p style="margin:0px;">17 Sensitivity analysis with data tables</p> <p style="margin:0px;">18 The Goal Seek command</p> <p style="margin:0px;">19 Using the Scenario Manager for sensitivity analysis</p> <p style="margin:0px;">20 The COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK functions</p> <p style="margin:0px;">21 The SUMIF, AVERAGEIF, SUMIFS, AVERAGEIFS, MAXIFS, and MINIFS functions</p> <p style="margin:0px;">22 The OFFSET function</p> <p style="margin:0px;">23 The INDIRECT function</p> <p style="margin:0px;">24 Conditional formatting</p> <p style="margin:0px;">25 Sorting in Excel</p> <p style="margin:0px;">26 Excel tables and table slicers</p> <p style="margin:0px;">27 Spin buttons, scrollbars, option buttons, check boxes, combo boxes, and group list boxes</p> <p style="margin:0px;">28 The analytics revolution</p> <p style="margin:0px;">29 An introduction to optimization with Excel Solver</p> <p style="margin:0px;">30 Using Solver to determine the optimal product mix</p> <p style="margin:0px;">31 Using Solver to schedule your workforce</p> <p style="margin:0px;">32 Using Solver to solve transportation or distribution problems</p> <p style="margin:0px;">33 Using Solver for capital budgeting</p> <p style="margin:0px;">34 Using Solver for financial planning</p> <p style="margin:0px;">35 Using Solver to rate sports teams</p> <p style="margin:0px;">36 Warehouse location and the GRG Multistart and Evolutionary Solver engines</p> <p style="margin:0px;">37 Penalties and the Evolutionary Solver</p> <p style="margin:0px;">38 The traveling salesperson problem</p> <p style="margin:0px;">39 Importing data from a text file or document</p> <p style="margin:0px;">40 Get & Transform (or s/b Get & Transform?)</p> <p style="margin:0px;">41 Geography and Stock data types</p> <p style="margin:0px;">42 Validating data</p> <p style="margin:0px;">43 Summarizing data by using histograms and Pareto charts</p> <p style="margin:0px;">44 Summarizing data by using descriptive statistics</p> <p style="margin:0px;">45 Using pivot tables and slicers to describe data</p> <p style="margin:0px;">46 The Data Model</p> <p style="margin:0px;">47 Power Pivot</p> <p style="margin:0px;">48 Filled and 3D Power Maps</p> <p style="margin:0px;">49 Sparklines</p> <p style="margin:0px;">50 Summarizing data with database statistical functions</p> <p style="margin:0px;">51 Filtering data and removing duplicates</p> <p style="margin:0px;">52 Consolidating data</p> <p style="margin:0px;">53 Creating subtotals</p> <p style="margin:0px;">54 Charting tricks</p> <p style="margin:0px;">55 Estimating straight-line relationships</p> <p style="margin:0px;">56 Modeling exponential growth</p> <p style="margin:0px;">57 The power curve</p> <p style="margin:0px;">58 Using correlations to summarize relationships</p> <p style="margin:0px;">59 Introduction to multiple regression</p> <p style="margin:0px;">60 Incorporating qualitative factors into multiple regression</p> <p style="margin:0px;">61 Modeling nonlinearities and interactions</p> <p style="margin:0px;">62 Analysis of variance: One-way ANOVA </p> <p style="margin:0px;">63 Randomized blocks and two-way ANOVA</p> <p style="margin:0px;">64 Using moving averages to understand time series</p> <p style="margin:0px;">65 Winters method and the Forecast Sheet</p> <p style="margin:0px;">66 Ratio-to-moving-average forecast method</p> <p style="margin:0px;">67 Forecasting in the presence of special events</p> <p style="margin:0px;">68 Introduction to Probability</p> <p style="margin:0px;">69 An introduction to random variables</p> <p style="margin:0px;">70 The binomial, hypergeometric, and negative binomial random variables</p> <p style="margin:0px;">71 The Poisson and exponential random variables</p> <p style="margin:0px;">72 The normal random variable and Z-scores</p> <p style="margin:0px;">73 Weibull and beta distributions: Modeling machine life and project duration</p> <p style="margin:0px;">74 Making probability statements from forecasts</p> <p style="margin:0px;">75 Using the lognormal random variable to model stock prices</p> <p style="margin:0px;">76 Importing Historical stock data into Excel</p> <p style="margin:0px;">77 Introduction to Monte Carlo simulation</p> <p style="margin:0px;">78 Calculating an optimal bid</p> <p style="margin:0px;">79 Simulating stock prices and asset-allocation modeling</p> <p style="margin:0px;">80 Fun and games: Simulating gambling and sporting event probabilities</p> <p style="margin:0px;">81 Using resampling to analyze data </p> <p style="margin:0px;"> 82 Pricing stock options</p> <p style="margin:0px;">83 Determining customer value</p> <p style="margin:0px;">84 The economic order quantity inventory model</p> <p style="margin:0px;">85 Inventory modeling with uncertain demand</p> <p style="margin:0px;">86 Queueing theory: The mathematics of waiting in line</p> <p style="margin:0px;">87 Estimating a demand curve</p> <p style="margin:0px;">88 Pricing products by using tie-ins</p> <p style="margin:0px;">89 Pricing products by using subjectively determined demand</p> <p style="margin:0px;">90 Nonlinear pricing</p> <p style="margin:0px;">91 Array formulas and functions</p> <p style="margin:0px;">92 Recording macros </p> <p style="margin:0px;"> </p> <p style="margin:0px;">93 Advanced Sensitivity Analysis</p>
