000 | 02289nam a22002297a 4500 | ||
---|---|---|---|
003 | JGU | ||
005 | 20240813020031.0 | ||
008 | 220929b |||||||| |||| 00| 0 eng d | ||
020 |
_a9789389347180 _qpbk. |
||
040 |
_beng _cJGU |
||
041 | _aeng | ||
100 |
_aWinston, Wayne L., _91635076 _eauthor |
||
245 |
_aMicrosoft Excel 2019 : _bdata analysis and business modeling / _cWayne L. Winston. |
||
250 | _a6th ed. | ||
260 |
_aDelhi : _bPHI learning, _c2019. |
||
520 | _a"Master business modeling and analysis techniques with Microsoft Excel 2019 and Office 365 and transform data into bottom-line results. Written by award-winning educator Wayne Winston, this hands-on, scenario-focused guide helps you use Excel to ask the right questions and get accurate, actionable answers. New coverage ranges from Power Query/Get & Transform to Office 365 Geography and Stock data types. Practice with more than 800 problems, many based on actual challenges faced by working analysts. • Solve real business problems with Excel—and build your competitive advantage • Quickly transition from Excel basics to sophisticated analytics • Use Power Query or Get &Transform to connect, combine, and refine data sources • Leverage Office 365's new Geography and Stock data types and six new functions • Illuminate insights from geographic and temporal data with 3D Maps • Summarize data with pivot tables, descriptive statistics, histograms, and Pareto charts • Use Excel trend curves, multiple regression, and exponential smoothing • Delve into key financial, statistical, and time functions • Master all of Excel's great charts • Quickly create forecasts from historical time-based data • Use Solver to optimize product mix, logistics, work schedules, and investments—and even rate sports teams • Run Monte Carlo simulations on stock prices and bidding models • Learn about basic probability and Bayes' Theorem • Use the Data Model and Power Pivot to effectively build and use relational data sources inside an Excel workbook • Automate repetitive analytics tasks by using macros."-- | ||
650 |
_aMicrosoft Excel (Computer file) _9396513 |
||
650 |
_aElectronic spreadsheets _933777 |
||
999 |
_c3052465 _d3052465 |