Microsoft Excel 2016 Data Analysis and Business Modeling / Wayne L. Winston
Material type:
TextPublication details: New Delhi PHI Learning Pvt. Ltd. 2019Description: xxvi, 837p. : ill. ; 24cmISBN: - 9788120353350
- 23rd 005.54 WIN
| Item type | Current library | Call number | Status | Notes | Date due | Barcode | |
|---|---|---|---|---|---|---|---|
| Text Book | VIT-AP General Stacks | 005.54 WIN (Browse shelf(Opens below)) | Checked out to GUNGUN SHARMA (21BCE8547) | CSE | 2023-06-07 | 018216 | |
| Reference Book | VIT-AP General Stacks | 005.54 WIN (Browse shelf(Opens below)) | Not for loan | CSE | 018217 |
Browsing School of Computer Science Section shelves, Shelving location: General Stacks Close shelf browser (Hides shelf browser)
|
|
|
|
|
|
|
||
| 005.54 PAR Microsoft Office 365 Excel 2016 Comprehensive / | 005.54 PRI Excel 2010 in Easy Steps | 005.54 WIN Microsoft Excel 2016 Data Analysis and Business Modeling | 005.54 WIN Microsoft Excel 2016 Data Analysis and Business Modeling | 005.54 WIN Microsoft Excel 2019 : Data Analysis and Business Modeling | 005.55 McCO SPSS Statistics for Data Analysis and Visualization | 005.7 MAH Big Data |
It 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,
There are no comments on this title.