About this product

Product Identifiers

PublisherPearson Education

ISBN-101509304215

ISBN-139781509304219

eBay Product ID (ePID)227669164

Product Key Features

Number of Pages864 Pages

Publication NameMicrosoft Excel Data Analysis and Business Modeling

LanguageEnglish

SubjectIndustrial Management, Decision-Making & Problem Solving, Desktop Applications / Spreadsheets, Databases / Data Mining, Statistics

Publication Year2016

TypeTextbook

Subject AreaComputers, Education, Business & Economics

AuthorWayne Winston

SeriesBusiness Skills Ser.

FormatTrade Paperback

Dimensions

Item Height1.7 in

Item Weight50.7 Oz

Item Length9 in

Item Width7.5 in

Additional Product Features

Edition Number5

Intended AudienceScholarly & Professional

LCCN2016-943109

Dewey Edition23

IllustratedYes

Dewey Decimal658.4033

Table Of ContentChapter 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

SynopsisStudents will master business modeling and analysis techniques with Microsoft Excel 2016, and transform data into bottom-line results. Written by award-winning educator Wayne Winston, this hands on, scenario-focused guide helps readers use Excel's newest tools to ask the right questions and get accurate, actionable answers. This edition adds 150+ new problems with solutions, plus a chapter of basic spreadsheet models to make sure readers are fully up to speed., Master business modeling and analysis techniques with Microsoft Excel 2016, and transform data into bottom-line results. Written by award-winning educator Wayne Winston, this hands on, scenario-focused guide helps you use Excel's newest tools to ask the right questions and get accurate, actionable answers. This edition adds 150+ new problems with solutions, plus a chapter of basic spreadsheet models to make sure you're fully up to speed. Solve real business problems with Excel--and build your competitive advantage Quickly transition from Excel basics to sophisticated analytics Summarize data by using PivotTables and Descriptive Statistics Use Excel trend curves, multiple regression, and exponential smoothing Master advanced functions such as OFFSET and INDIRECT Delve into key financial, statistical, and time functions Leverage the new charts in Excel 2016 (including box and whisker and waterfall charts) Make charts more effective by using Power View Tame complex optimizations by using Excel Solver Run Monte Carlo simulations on stock prices and bidding models Work with the AGGREGATE function and table slicers Create PivotTables from data in different worksheets or workbooks Learn about basic probability and Bayes' Theorem Automate repetitive tasks by using macros

LC Classification NumberHD30.215