Microsoft Excel Data Analysis and Business Modeling

Business & Finance, Economics, Statistics, Nonfiction, Computers, Application Software, Spreadsheets, Financial Applications
Cover of the book Microsoft Excel Data Analysis and Business Modeling by Wayne Winston, Pearson Education
View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart
Author: Wayne Winston ISBN: 9781509304226
Publisher: Pearson Education Publication: November 29, 2016
Imprint: Microsoft Press Language: English
Author: Wayne Winston
ISBN: 9781509304226
Publisher: Pearson Education
Publication: November 29, 2016
Imprint: Microsoft Press
Language: English

This is the eBook of the printed book and may not include any media, website access codes, or print supplements that may come packaged with the bound book.

*** ***

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
View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart

This is the eBook of the printed book and may not include any media, website access codes, or print supplements that may come packaged with the bound book.

*** ***

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

More books from Pearson Education

Cover of the book The iPhone Book (Covers iPhone 3G, Original iPhone, and iPod Touch) by Wayne Winston
Cover of the book Enhancing a Dreamweaver CS3 Web Site with Flash Video by Wayne Winston
Cover of the book My iMac (Yosemite Edition) by Wayne Winston
Cover of the book Unix and Linux by Wayne Winston
Cover of the book Level 1: Marcel and the Shakespeare Letters by Wayne Winston
Cover of the book Spin Sucks by Wayne Winston
Cover of the book The Photographer's Quick Guide to Photoshop CS6 by Wayne Winston
Cover of the book Microsoft Office Access 2007 Step by Step by Wayne Winston
Cover of the book Office 2016 In Depth (includes Content Update Program) by Wayne Winston
Cover of the book Deploying and Managing Active Directory with Windows PowerShell by Wayne Winston
Cover of the book Digital Lighting and Rendering by Wayne Winston
Cover of the book XPages Extension Library by Wayne Winston
Cover of the book My Amazon Fire Phone by Wayne Winston
Cover of the book Recruiting with Social Media by Wayne Winston
Cover of the book It's Not About the F-Stop by Wayne Winston
We use our own "cookies" and third party cookies to improve services and to see statistical information. By using this website, you agree to our Privacy Policy