It's Raining Books Sale
 
 

Recently Viewed clear list


Interviews | September 2, 2014

Jill Owens: IMG David Mitchell: The Powells.com Interview



David MitchellDavid Mitchell's newest mind-bending, time-skipping novel may be his most accomplished work yet. Written in six sections, one per decade, The Bone... Continue »
  1. $21.00 Sale Hardcover add to wish list

    The Bone Clocks

    David Mitchell 9781400065677

spacer
Qualifying orders ship free.
$49.99
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Qty Store Section
1 Beaverton Microsoft Windows- Windows 95 General
3 Burnside - Bldg. 2 Microsoft Windows- Applications
18 Remote Warehouse Personal Computers- Desktop Applications- Spreadsheets
25 Remote Warehouse Personal Computers- Desktop Applications- Spreadsheets

Microsoft Excel 2013: Data Analysis and Business Modeling

by

Microsoft Excel 2013: Data Analysis and Business Modeling Cover

 

Synopses & Reviews

Publisher Comments:

Master business modeling and analysis techniques with Microsoft Excel 2013, 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.

Solve real business problems with Excel—and sharpen your edge

  • Summarize data with PivotTables and Descriptive Statistics
  • Explore new trends in predictive and prescriptive analytics
  • Use Excel Trend Curves, multiple regression, and exponential smoothing
  • Master advanced Excel functions such as OFFSET and INDIRECT
  • Delve into key financial, statistical, and time functions
  • Make your charts more effective with the Power View tool
  • Tame complex optimization problems with Excel Solver
  • Run Monte Carlo simulations on stock prices and bidding models
  • Apply important modeling tools such as the Inquire add-in

Synopsis:

Master the business modeling and analytic techniques with Microsoft Excel 2013, and help transform your data into bottom-line results. With this hands-on, scenario-focused guide from Excel expert and bestselling author Wayne Winston, youll learn how to use the new Data Model and Relationships features for integrating data from multiple tables, effectively building a relational data source inside an Excel workbook.

Gain the skills to solve real-world business problems with Excel 2013

  • Model investment risks and returns
  • Analyze your sales teams effectiveness
  • Create best, worst, and most-likely case scenarios
  • Compare lease vs. buy, and calculate loan terms
  • See how price, advertising, and seasonality affect sales
  • Manage inventory with precision
  • Quantify the value of customer loyalty
  • Calculate your break-even number and ROI
  • Maximize scheduling efficiency

About the Author

Wayne L. Winston is a professor of Decision Sciences at Indiana University's Kelley School of Business and has earned numerous MBA teaching awards. For 20+ years, he has taught clients at Fortune 500 companies 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.

Table of Contents

IntroductionChapter 1: Range namesChapter 2: Lookup functionsChapter 3: INDEX functionChapter 4: MATCH functionChapter 5: Text functionsChapter 6: Dates and date functionsChapter 7: Evaluating investments by using net present value criteriaChapter 8: Internal rate of returnChapter 9: More Excel financial functionsChapter 10: Circular referencesChapter 11: IF statementsChapter 12: Time and time functionsChapter 13: The Paste Special commandChapter 14: Three-dimensional formulasChapter 15: The Auditing tool and Inquire add-inChapter 16: Sensitivity analysis with data tablesChapter 17: The Goal Seek commandChapter 18: Using the Scenario Manager for sensitivity analysisChapter 19: The COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK functionsChapter 20: The SUMIF, AVERAGEIF, SUMIFS, and AVERAGEIFS functionsChapter 21: The OFFSET functionChapter 22: The INDIRECT functionChapter 23: Conditional formattingChapter 24: Sorting in ExcelChapter 25: TablesChapter 26: Spinner buttons, scroll bars, option buttons, check boxes, combo boxes, and group list boxesChapter 27: The analytics revolutionChapter 28: Introducing optimization with Excel SolverChapter 29: Using Solver to determine the optimal product mixChapter 30: Using Solver to schedule your workforceChapter 31: Using Solver to solve transportation or distribution problemsChapter 32: Using Solver for capital budgetingChapter 33: Using Solver for financial planningChapter 34: Using Solver to rate sports teamsChapter 35: Warehouse location and the GRG Multistart and Evolutionary Solver enginesChapter 36: Penalties and the Evolutionary SolverChapter 37: The traveling salesperson problemChapter 38: Importing data from a text file or documentChapter 39: Importing data from the InternetChapter 40: Validating dataChapter 41: Summarizing data by using histogramsChapter 42: Summarizing data by using descriptive statisticsChapter 43: Using PivotTables and slicers to describe dataChapter 44: The Data ModelChapter 45: PowerPivotChapter 46: Power ViewChapter 47: SparklinesChapter 48: Summarizing data with database statistical functionsChapter 49: Filtering data and removing duplicatesChapter 50: Consolidating dataChapter 51: Creating subtotalsChapter 52: Charting tricksChapter 53: Estimating straight-line relationshipsChapter 54: Modeling exponential growthChapter 55: The power curveChapter 56: Using correlations to summarize relationshipsChapter 57: Introduction to multiple regressionChapter 58: Incorporating qualitative factors into multiple regressionChapter 59: Modeling nonlinearities and interactionsChapter 60: Analysis of variance: one-way ANOVAChapter 61: Randomized blocks and two-way ANOVAChapter 62: Using moving averages to understand time seriesChapter 63: Winterss methodChapter 64: Ratio-to-moving-average forecast methodChapter 65: Forecasting in the presence of special eventsChapter 66: An introduction to random variablesChapter 67: The binomial, hypergeometric, and negative binomial random variablesChapter 68: The Poisson and exponential random variableChapter 69: The normal random variableChapter 70: Weibull and beta distributions: modeling machine life and duration of a projectChapter 71: Making probability statements from forecastsChapter 72: Using the lognormal random variable to model stock pricesChapter 73: Introduction to Monte Carlo simulationChapter 74: Calculating an optimal bidChapter 75: Simulating stock prices and asset allocation modelingChapter 76: Fun and games: simulating gambling and sporting event probabilitiesChapter 77: Using resampling to analyze dataChapter 78: Pricing stock optionsChapter 79: Determining customer valueChapter 80: The economic order quantity inventory modelChapter 81: Inventory modeling with uncertain demandChapter 82: Queuing theory: the mathematics of waiting in lineChapter 83: Estimating a demand curveChapter 84: Pricing products by using tie-insChapter 85: Pricing products by using subjectively determined demandChapter 86: Nonlinear pricingChapter 87: Array formulas and functionsAbout the Author

Product Details

ISBN:
9780735669130
Author:
Winston, Wayne L
Publisher:
Microsoft Press
Author:
on
Author:
Wayne L. Winst
Author:
Winston, Wayne
Author:
Winston, Wayne L.
Subject:
Spreadsheets - General
Subject:
Personal Computers-Desktop Applications-Spreadsheets
Subject:
Excel;Microsoft;Office;Windows;analysis;analytics;business;data;expenses;finances;financial;goals;modeling;objectives;trends;visualization
Subject:
Microsoft excel; excel; excel 2013; data analysis; business modeling; business analyst; data analytics; statistical software; Microsoft excel 2013; it business analyst; statistical data; analyzing data
Copyright:
Edition Description:
Trade Paper
Publication Date:
20140131
Binding:
TRADE PAPER
Language:
English
Pages:
888
Dimensions:
9 x 7.38 in

Related Subjects

Computers and Internet » Computers Reference » General
Computers and Internet » Internet » Information
Computers and Internet » Operating Systems » Microsoft Windows » Applications
Computers and Internet » Operating Systems » Microsoft Windows » Windows 95 » General
Computers and Internet » Personal Computers » Desktop Applications » Spreadsheets
Health and Self-Help » Health and Medicine » General
Health and Self-Help » Health and Medicine » General Medicine
History and Social Science » Politics » General

Microsoft Excel 2013: Data Analysis and Business Modeling New Trade Paper
0 stars - 0 reviews
$49.99 In Stock
Product details 888 pages Microsoft Press - English 9780735669130 Reviews:
"Synopsis" by ,

Master the business modeling and analytic techniques with Microsoft Excel 2013, and help transform your data into bottom-line results. With this hands-on, scenario-focused guide from Excel expert and bestselling author Wayne Winston, youll learn how to use the new Data Model and Relationships features for integrating data from multiple tables, effectively building a relational data source inside an Excel workbook.

Gain the skills to solve real-world business problems with Excel 2013

  • Model investment risks and returns
  • Analyze your sales teams effectiveness
  • Create best, worst, and most-likely case scenarios
  • Compare lease vs. buy, and calculate loan terms
  • See how price, advertising, and seasonality affect sales
  • Manage inventory with precision
  • Quantify the value of customer loyalty
  • Calculate your break-even number and ROI
  • Maximize scheduling efficiency

spacer
spacer
  • back to top
Follow us on...




Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.