Microsoft Excel Data Analysis and Business Modeling (5th Edition)

By | February 9, 2020
Microsoft Excel Data Analysis and Business Modeling (5th Edition) Author Wayne Winston
ISBN-10 1509304215
ISBN-13 9781509304219
Year 2016-12-19
Pages 864
Language English
Publisher Microsoft Press
Download Link Click Here

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 Excels 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 youre fully up to speed Solve real business problems with Exceland 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

Leave a Reply

Your email address will not be published. Required fields are marked *