Op werkdagen voor 23:00 besteld, morgen in huis Gratis verzending vanaf €20

Microsoft Excel 2019 Data Analysis and Business Modeling

Paperback Engels 2019 9781509305889
Verkooppositie 2552
Verwachte levertijd ongeveer 7 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

ISBN13:9781509305889
Taal:Engels
Bindwijze:paperback
Aantal pagina's:852
Druk:6
Verschijningsdatum:20-6-2019
Hoofdrubriek:IT-management / ICT

Lezersrecensies

Wees de eerste die een lezersrecensie schrijft!

Geef uw waardering

Zeer goed Goed Voldoende Matig Slecht

Over Wayne Winston

Wayne L. Winston is Professor Emeritus of Decision Sciences at Indiana University’s Kelley School of Business, and Visiting Professor of Decision and Information Sciences at University of Houston Bauer College of Business. He has earned numerous MBA teaching awards. For more than 20 years, he has taught clients at Fortune 500 companies, various accounting groups, the U.S. Navy, and the U.S. Army how to use Excel to make smarter business decisions. Wayne and his business partner Jeff Sagarin developed the player-statistics tracking and rating system used by the Dallas Mavericks professional basketball team. He is also a two time Jeopardy! champion.

Andere boeken door Wayne Winston

Inhoudsopgave

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

Alle 100 bestsellers

Rubrieken

Populaire producten

    Personen

      Trefwoorden

        Microsoft Excel 2019 Data Analysis and Business Modeling