Microsoft Excel 2019 Data Analysis and Business Modeling, 6th Edition
- By Wayne Winston
- Published Mar 28, 2019 by Microsoft Press.
eBook
- Your Price: $38.39
- List Price: $47.99
- Includes EPUB and PDF
- About eBook Formats
This eBook includes the following formats, accessible from your Account page after purchase:
EPUB
The open industry format known for its reflowable content and usability on supported mobile devices.
PDF
The popular standard, used most often with the free Acrobat® 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 in other formats.
Register your product to gain access to bonus material or receive a coupon.
Description
- Copyright 2019
- Pages: 864
- Edition: 6th
- eBook
- ISBN-10: 1-5093-0613-7
- ISBN-13: 978-1-5093-0613-8
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
Downloads
Downloads
Follow the instructions to download this book's lesson files.
- Click the Download button below to start the download.
- If prompted, click Save.
- Locate the .zip file on your computer. Right-click the file, click Extract All, and then follow the instructions.
Sample Content
Sample Pages
Download the sample pages (includes Chapter 4).
Table of Contents
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