Picture 1 of 1
Picture 1 of 1
Microsoft Excel 2019 Data Analysis and Business Modeling (6th Edition) (B - GOOD
US $14.97
Condition:
6 available14 sold
Shipping:
Located in: Montgomery, Illinois, United States
Delivery:
Estimated between Fri, Jun 28 and Wed, Jul 3 to 43230
Returns:
Payments:
Special financing available. See terms and apply now- for PayPal Credit, opens in a new window or tab
Earn up to 5x points when you use your eBay Mastercard®. Learn moreabout earning points with eBay Mastercard
Shop with confidence
Seller assumes all responsibility for this listing.
eBay item number:264968340186
Item specifics
- Condition
- Brand
- Unbranded
- MPN
- Does not apply
- ISBN
- 1509305882
- Subject Area
- Computers, Business & Economics
- Publication Name
- Microsoft Excel 2019 Data Analysis and Business Modeling
- Publisher
- Pearson Education
- Item Length
- 9.1 in
- Subject
- Desktop Applications / General, Economics / General, Desktop Applications / Spreadsheets
- Publication Year
- 2019
- Series
- Business Skills Ser.
- Type
- Textbook
- Format
- Trade Paperback
- Language
- English
- Item Height
- 1.9 in
- Item Weight
- 51.2 Oz
- Item Width
- 7.4 in
- Number of Pages
- 880 Pages
About this product
Product Identifiers
Publisher
Pearson Education
ISBN-10
1509305882
ISBN-13
9781509305889
eBay Product ID (ePID)
9038370030
Product Key Features
Number of Pages
880 Pages
Language
English
Publication Name
Microsoft Excel 2019 Data Analysis and Business Modeling
Subject
Desktop Applications / General, Economics / General, Desktop Applications / Spreadsheets
Publication Year
2019
Type
Textbook
Subject Area
Computers, Business & Economics
Series
Business Skills Ser.
Format
Trade Paperback
Dimensions
Item Height
1.9 in
Item Weight
51.2 Oz
Item Length
9.1 in
Item Width
7.4 in
Additional Product Features
Edition Number
6
Intended Audience
Scholarly & Professional
LCCN
2019-933467
Dewey Edition
23
Illustrated
Yes
Dewey Decimal
658.40300285554
Table Of Content
Chapter 1 Basic spreadsheet modeling Chapter 2 Range names Chapter 3 Lookup functions Chapter 4 The INDEX function Chapter 5 The MATCH function Chapter 6 Text functions Chapter 7 Dates and date functions Chapter 8 Evaluating investment by using net present value criteria Chapter 9 Internal rate of return Chapter 10 More Excel financial functions Chapter 11 Circular references Chapter 12 IF statements Chapter 13 Time and time functions Chapter 14 The Paste Special command Chapter 15 Three-dimensional formulas and hyperlinks Chapter 16 The auditing tool Chapter 17 Sensitivity analysis with data tables Chapter 18 The Goal Seek command Chapter 19 Using the Scenario Manager for sensitivity analysis Chapter 20 The COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK functions Chapter 21 The SUMIF, AVERAGEIF, SUMIFS, and AVERAGEIFS functions Chapter 22 The OFFSET function Chapter 23 The INDIRECT function Chapter 24 Conditional formatting Chapter 25 Sorting in Excel Chapter 26 Tables Chapter 27 Spin buttons, scroll bars, option buttons, check boxes, combo boxes, and group list boxes Chapter 28 The analytics revolution Chapter 29 An introduction to optimization with Excel Solver Chapter 30 Using Solver to determine the optimal product mix Chapter 31 Using Solver to schedule your workforce Chapter 32 Using Solver to solve transportation or distribution problems Chapter 33 Using Solver for capital budgeting Chapter 34 Using Solver for financial planning Chapter 35 Using Solver to rate sports teams Chapter 36 Warehouse location and the GRG Multistart and Evolutionary Solver engines Chapter 37 Penalties and the Evolutionary Solver Chapter 38 The traveling salesperson problem Chapter 39 Importing data from a text file or document Chapter 40 Validating data Chapter 41 Summarizing data by using histograms and Pareto charts Chapter 42 Summarizing data by using descriptive statistics Chapter 43 Using PivotTables and slicers to describe data Chapter 44 The Data Model Chapter 45 Power Pivot Chapter 46 Power View and 3D Maps Chapter 47 Sparklines Chapter 48 Summarizing data with database statistical functions Chapter 49 Filtering data and removing duplicates Chapter 50 Consolidating data Chapter 51 Creating subtotals Chapter 52 Charting tricks Chapter 53 Estimating straight-line relationships Chapter 54 Modeling exponential growth Chapter 55 The power curve Chapter 56 Using correlations to summarize relationships Chapter 57 Introduction to multiple regression Chapter 58 Incorporating qualitative factors into multiple regression Chapter 59 Modeling nonlinearities and interactions Chapter 60 Analysis of variance: One-way ANOVA Chapter 61 Randomized blocks and two-way ANOVA Chapter 62 Using moving averages to understand time series Chapter 63 Winters method Chapter 64 Ratio-to-moving-average forecast method Chapter 65 Forecasting in the presence of special events Chapter 66 An introduction to probability Chapter 67 An introduction to random variables Chap
Synopsis
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, Master business modeling and analysis techniques with Microsoft Excel 2019, and transform data into bottom-line results. Written by award-winning educator Wayne Winston, this hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables-and how to effectively build a relational data source inside an Excel workbook., 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 Excel; Office 2016; Windows 10; data analysis; business modeling; PivotTables; Descriptive Statistics; predictive analytics
LC Classification Number
HD30.215.W5635 2019
Copyright Date
2019
ebay_catalog_id
4
Item description from the seller
Seller assumes all responsibility for this listing.
eBay item number:264968340186
Shipping and handling
Item location:
Montgomery, Illinois, United States
Ships to:
Canada, Mexico, United States
Excludes:
Africa, Asia, Barbados, Bermuda, Central America and Caribbean, Europe, French Guiana, French Polynesia, Greenland, Guadeloupe, Libya, Martinique, Middle East, New Caledonia, Oceania, Reunion, Russian Federation, Saint Pierre and Miquelon, South America, Southeast Asia, Ukraine, Venezuela
| Shipping and handling | Each additional item | To | Service | Delivery*See Delivery notes |
|---|---|---|---|---|
| Free shipping | Free | United States | Economy Shipping (USPS Media MailTM) | Estimated between Fri, Jun 28 and Wed, Jul 3 to 43230 |
| US $4.95 | US $4.95 | United States | Standard Shipping (DGM SmartMail Expedited) | Estimated between Wed, Jun 26 and Mon, Jul 1 to 43230 |
| US $10.95 | US $10.95 | United States | Expedited Shipping (FedEx 2Day®) | Estimated between Tue, Jun 25 and Wed, Jun 26 to 43230 |
| Handling time |
|---|
| Will usually ship within 1 business day of receiving cleared payment. |
| Taxes |
|---|
| Taxes may be applicable at checkout. Learn moreLearn more about paying tax on eBay purchases. |
Sales Tax for an item #264968340186
Sales Tax for an item #264968340186
Seller collects sales tax for items shipped to the following states:
| State | Sales Tax Rate |
|---|
Return policy
| After receiving the item, contact seller within | Refund will be given as | Return shipping |
|---|---|---|
| 30 days | Money Back | Seller pays for return shipping |
Refer to eBay Return policyopens in a new tab or window for more details. You are covered by the eBay Money Back Guaranteeopens in a new tab or window if you receive an item that is not as described in the listing.
Payment details
Payment methods
Popular categories from this store
Seller feedback (6,007,576)
This item (1)
All items (6,007,576)
i***p (1843)- Feedback left by buyer.
More than a year ago
Verified purchase
As described and fast ship. Thank you
a***a (171)- Feedback left by buyer.
Past month
Verified purchase
This is an outstanding seller to deal with. Fair prices that are more than reasonable in this economy. The product is in better condition than described, a true value for my money. Packaged and shipped well shows seller has concern for the products he sells to arrive in excellent condition. The seller is friendly and communicates timely with his customers. I highly recommend this seller and would do business again anytime. Thank you.
5***u (3413)- Feedback left by buyer.
Past 6 months
Verified purchase
🏆 SUPER STAR 🤩 AMAZING PHOTOS 🎯 ACCURATE DESCRIPTION ✏️ GENUINE PRODUCTS 💎 HIGH QUALITY 🍯 SUPER PRICES 💰 EASY TO WORK WITH 🍰 ECONOMY HANDLING ⏱️ FAST SHIPPING 🚀 BUBBLE PACKAGE 📦 ARRIVED WITHIN DAYS 🌎 EXCEPTIONAL COMMUNICATION 🎙️ OUTSTANDING CUSTOMER SERVICE 🛎️ GREAT SENSE OF HUMOR 🍿 TOTAL ASSET TO THE EBAY-ECO SYSTEM 🥇 SAVED SELLER 🎱 PROMT REPLY FOR RETURNS 🎯 WOULD BUY FROM AGAIN 🧲 UNDER PROMISES OVER DELIVERS ⛳️ MADE ME VERY HAPPY 🌈 LEFT POSITIVE FEEDBACK 🌼 THANK YOU! 😇 A+++
z***z (603)- Feedback left by buyer.
Past 6 months
Verified purchase
🏆 SUPER STAR 🤩 AMAZING PHOTOS 🎯 ACCURATE DESCRIPTION ✏️ GENUINE PRODUCTS 💎 HIGH QUALITY 🍯 SUPER PRICES 💰 EASY TO WORK WITH 🍰 ECONOMY HANDLING ⏱️ FAST SHIPPING 🚀 BUBBLE PACKAGE 📦 ARRIVED WITHIN DAYS 🌎 EXCEPTIONAL COMMUNICATION 🎙️ OUTSTANDING CUSTOMER SERVICE 🛎️ GREAT SENSE OF HUMOR 🍿 TOTAL ASSET TO THE EBAY-ECO SYSTEM 🥇 SAVED SELLER 🎱 PROMT REPLY FOR RETURNS 🎯 WOULD BUY FROM AGAIN 🧲 UNDER PROMISES OVER DELIVERS ⛳️ MADE ME VERY HAPPY 🌈 LEFT POSITIVE FEEDBACK 🌼 THANK YOU! 😇 A+++
Product ratings and reviews
More to explore :
- Business & Economy Business Week 1st Edition Magazines,
- Business Studies Revised Edition Textbooks,
- 1st Edition Business Week Magazines,
- Business Studies 1st Edition Textbooks,
- 1st Edition Good Housekeeping Magazines,
- 1st Edition Business Antiquarian & Collectible Books,
- Business & Economy Fortune 1st Edition Magazines,
- Business & Economy Limited Edition Magazines in English,
- 1st Edition Business Leather Antiquarian & Collectible Books,
- Business & Economy Pre - 1850 Limited Edition Magazines