Microsoft Excel Data Analysis and Business Modeling

Heftet / 2016 / Engelsk
584,-
Levering 3-20 dager

Produktbeskrivelse

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 advantageQuickly transition from Excel basics to sophisticated analyticsSummarize data by using PivotTables and Descriptive StatisticsUse Excel trend curves, multiple regression, and exponential smoothingMaster advanced functions such as OFFSET and INDIRECTDelve into key financial, statistical, and time functionsLeverage the new charts in Excel 2016 (including box and whisker and waterfall charts)Make charts more effective by using Power ViewTame complex optimizations by using Excel SolverRun Monte Carlo simulations on stock prices and bidding modelsWork with the AGGREGATE function and table slicersCreate PivotTables from data in different worksheets or workbooksLearn about basic probability and Bayes' TheoremAutomate repetitive tasks by using macros
Les mer »

Detaljer

ISBN13
9781509304219
Format
Product format
Heftet
Utgiver
Vendor
Microsoft Press
Språk
Product language
Engelsk
Publisert
2016