| 000 | 02367nam a22001937a 4500 | ||
|---|---|---|---|
| 999 |
_c26710 _d26710 |
||
| 005 | 20200229113714.0 | ||
| 008 | 190824b ||||| |||| 00| 0 eng d | ||
| 020 | _a9788120353350 | ||
| 040 | _cVITAP | ||
| 082 |
_223rd _a005.54 WIN |
||
| 100 |
_98709 _aWinston, Wayne L. |
||
| 245 |
_aMicrosoft Excel 2016 Data Analysis and Business Modeling _c/ Wayne L. Winston |
||
| 260 |
_aNew Delhi _bPHI Learning Pvt. Ltd. _c2019 |
||
| 300 |
_axxvi, 837p. : ill. ; _c24cm |
||
| 500 | _aIt includes index 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 Key Features: Excel, Statistics, Data, Analysis, Modelling, Business models, Descriptive, Predictive, Spreadsheet, | ||
| 650 | 0 |
_98710 _aMicrosoft Excel (Computer file); Decision making--Computer programs; Industrial management--Statistical methods--Computer programs; Business--Computer programs; Electronic spreadsheets--Computer programs; Business;Electronic spreadsheets |
|
| 856 | _uhttps://www.phindia.com/Books/BookDetail/OTc4ODEyMDM1MzM1MA | ||
| 942 |
_2ddc _cREF _e005.54 WIN |
||