Microsoft Press - Microsoft Excel Data Analysis And Business Modeling, 5th Edition (2016 EN)

Discussion in 'Information Technologies' started by Kanka, Dec 16, 2018.

  1. Kanka

    Kanka Well-Known Member Loyal User

    Likes Received:
    Trophy Points:

    Author: Wayne Winston
    Full Title: Microsoft Excel Data Analysis And Business Modeling, 5th Edition
    Publisher: Microsoft Press; 5 edition (December 19, 2016)
    Year: 2016
    ISBN-13: 9781509304219 (978-1-5093-0421-9), 9781509304257 (978-1-5093-0425-7)
    ISBN-10: 1509304215, 1509304258
    Pages: 864
    Language: English
    Genre: Software: Microsoft Excel
    File type: EPUB, PDF (True) + Contents (Files)
    Quality: 10/10
    Price: $49.99

    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

    Last edited by a moderator: Dec 16, 2018

Share This Page