MARC details
| 000 -LEADER |
|---|
| fixed length control field |
07068nam a22002297a 4500 |
| 005 - DATE AND TIME OF LATEST TRANSACTION |
|---|
| control field |
20230608103144.0 |
| 008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION |
|---|
| fixed length control field |
220208b ||||| |||| 00| 0 eng d |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER |
|---|
| International Standard Book Number |
9789389347180 |
| 082 ## - DEWEY DECIMAL CLASSIFICATION NUMBER |
|---|
| Classification number |
005.54 |
| Item number |
WAY |
| 100 ## - MAIN ENTRY--PERSONAL NAME |
|---|
| Personal name |
Wayne, L. Winston |
| 245 ## - TITLE STATEMENT |
|---|
| Title |
Microsoft excel 2019: data analysis and business model |
| 250 ## - EDITION STATEMENT |
|---|
| Edition statement |
6th |
| 260 ## - PUBLICATION, DISTRIBUTION, ETC. (IMPRINT) |
|---|
| Name of publisher, distributor, etc. |
PHI Learning Pvt. Ltd. |
| Place of publication, distribution, etc. |
New Delhi |
| Date of publication, distribution, etc. |
2021 |
| 300 ## - PHYSICAL DESCRIPTION |
|---|
| Extent |
xxvii, 850 p. |
| 365 ## - TRADE PRICE |
|---|
| Price type code |
INR |
| Price amount |
795.00 |
| 504 ## - BIBLIOGRAPHY, ETC. NOTE |
|---|
| Bibliography, etc. note |
Introduction<br/>CHAPTER 1 Basic worksheet modeling<br/>CHAPTER 2 Range names<br/>CHAPTER 3 Lookup functions<br/>CHAPTER 4 The INDEX function<br/>CHAPTER 5 The MATCH function<br/>CHAPTER 6 Text functions and Flash Fill<br/>CHAPTER 7 Dates and date functions<br/>CHAPTER 8 NPV and XNPV functions<br/>CHAPTER 9 IRR, XIRR, and MIRR functions<br/>CHAPTER 10 More Excel financial functions<br/>CHAPTER 11 Circular references<br/>CHAPTER 12 IF, IFERROR, IFS, CHOOSE, and SWITCH functions<br/>CHAPTER 13 Time and time functions<br/>CHAPTER 14 The Paste Special command<br/>CHAPTER 15 Three-dimensional formulas and hyperlinks<br/>CHAPTER 16 The auditing tool and the Inquire add-in<br/>CHAPTER 17 Sensitivity analysis with data tables<br/>CHAPTER 18 The Goal Seek command<br/>CHAPTER 19 Using the Scenario Manager for sensitivity analysis<br/>CHAPTER 20 The COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK functions<br/>CHAPTER 21 The SUMIF, AVERAGEIF, SUMIFS, AVERAGEIFS, MAXIFS, and MINIFS functions<br/>CHAPTER 22 The OFFSET function<br/>CHAPTER 23 The INDIRECT function<br/>CHAPTER 24 Conditional formatting<br/>CHAPTER 25 Sorting in Excel<br/>CHAPTER 26 Excel tables and table slicers<br/>CHAPTER 27 Spin buttons, scrollbars, option buttons, check boxes, combo boxes, and group list boxes<br/>CHAPTER 28 The analytics revolution<br/>CHAPTER 29 An introduction to optimization with Excel Solver<br/>CHAPTER 30 Using Solver to determine the optimal product mix<br/>CHAPTER 31 Using Solver to schedule your workforce<br/>CHAPTER 32 Using Solver to solve transportation or distribution problems<br/>CHAPTER 33 Using Solver for capital budgeting<br/>CHAPTER 34 Using Solver for financial planning<br/>CHAPTER 35 Using Solver to rate sports teams<br/>CHAPTER 36 Warehouse location and the GRG Multistart and Evolutionary Solver engines<br/>CHAPTER 37 Penalties and the Evolutionary Solver<br/>CHAPTER 38 The traveling salesperson problem<br/>CHAPTER 39 Importing data from a text file or document<br/>CHAPTER 40 Get & Transform<br/>CHAPTER 41 Geography and Stock data types<br/>CHAPTER 42 Validating data<br/>CHAPTER 43 Summarizing data by using histograms and Pareto charts<br/>CHAPTER 44 Summarizing data by using descriptive statistics<br/>CHAPTER 45 Using pivot tables and slicers to describe data<br/>CHAPTER 46 The Data Model<br/>CHAPTER 47 Power Pivot<br/>CHAPTER 48 Filled and 3D Power Maps<br/>CHAPTER 49 Sparklines<br/>CHAPTER 50 Summarizing data with database statistical functions<br/>CHAPTER 51 Filtering data and removing duplicates<br/>CHAPTER 52 Consolidating data<br/>CHAPTER 53 Creating subtotals<br/>CHAPTER 54 Charting tricks<br/>CHAPTER 55 Estimating straight-line relationships<br/>CHAPTER 56 Modeling exponential growth<br/>CHAPTER 57 The power curve<br/>CHAPTER 58 Using correlations to summarize relationships<br/>CHAPTER 59 Introduction to multiple regression<br/>CHAPTER 60 Incorporating qualitative factors into multiple regression<br/>CHAPTER 61 Modeling nonlinearities and interactions<br/>CHAPTER 62 Analysis of variance: One-way ANOVA<br/>CHAPTER 63 Randomized blocks and two-way ANOVA<br/>CHAPTER 64 Using moving averages to understand time series<br/>CHAPTER 65 Winters method and the Forecast Sheet<br/>CHAPTER 66 Ratio-to-moving-average forecast method<br/>CHAPTER 67 Forecasting in the presence of special events<br/>CHAPTER 68 An introduction to probability<br/>CHAPTER 69 An introduction to random variables<br/>CHAPTER 70 The binomial, hypergeometric, and negative binomial random variables<br/>CHAPTER 71 The Poisson and exponential random variable<br/>CHAPTER 72 The normal random variable and Z-scores<br/>CHAPTER 73 Weibull and beta distributions: Modeling machine life and duration of a project<br/>CHAPTER 74 Making probability statements from forecasts<br/>CHAPTER 75 Using the lognormal random variable to model stock prices<br/>CHAPTER 76 Importing historical stock data into Excel<br/>CHAPTER 77 Introduction to Monte Carlo simulation<br/>CHAPTER 78 Calculating an optimal bid<br/>CHAPTER 79 Simulating stock prices and asset-allocation modeling<br/>CHAPTER 80 Fun and games: Simulating gambling and sporting event probabilities<br/>CHAPTER 81 Using resampling to analyze data<br/>CHAPTER 82 Pricing stock options<br/>CHAPTER 83 Determining customer value<br/>CHAPTER 84 The economic order quantity inventory model<br/>CHAPTER 85 Inventory modeling with uncertain demand<br/>CHAPTER 86 Queuing theory: The mathematics of waiting in line<br/>CHAPTER 87 Estimating a demand curve<br/>CHAPTER 88 Pricing products by using tie-ins<br/>CHAPTER 89 Pricing products by using subjectively determined demand<br/>CHAPTER 90 Nonlinear pricing<br/>CHAPTER 91 Array formulas and functions<br/>CHAPTER 92 Recording macros<br/>CHAPTER 93 Advanced sensitivity analysis<br/>Index<br/><br/> |
| 520 ## - SUMMARY, ETC. |
|---|
| Summary, etc. |
Description:<br/><br/>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.<br/><br/>• Solve real business problems with Excel—and build your competitive advantage<br/><br/>• Quickly transition from Excel basics to sophisticated analytics<br/><br/>• Use PowerQuery or Get & Transform to connect, combine, and refine data sources<br/><br/>• Leverage Office 365's new Geography and Stock data types and six new functions<br/><br/>• Illuminate insights from geographic and temporal data with 3D Maps<br/><br/>• Summarize data with pivot tables, descriptive statistics, histograms, and Pareto charts<br/><br/>• Use Excel trend curves, multiple regression, and exponential smoothing<br/><br/>• Delve into key financial, statistical, and time functions<br/><br/>• Master all of Excel's great charts<br/><br/>• Quickly create forecasts from historical time-based data<br/><br/>• Use Solver to optimize product mix, logistics, work schedules, and investments—and even rate sports teams<br/><br/>• Run Monte Carlo simulations on stock prices and bidding models<br/><br/>• Learn about basic probability and Bayes' Theorem<br/><br/>• Use the Data Model and Power Pivot to effectively build and use relational data sources inside an Excel workbook<br/><br/>• Automate repetitive analytics tasks by using macros<br/><br/>www.phindia.com/MicrosoftPressBooks/mspmain<br/><br/>Your digital content includes: All the book’s practise and solution files— ready to download at<br/><br/>MicrosoftPressStore.com/Excel2019DataAnalysis/downloads |
| 650 ## - SUBJECT ADDED ENTRY--TOPICAL TERM |
|---|
| Topical term or geographic name as entry element |
Electronic spreadsheets |
| 650 ## - SUBJECT ADDED ENTRY--TOPICAL TERM |
|---|
| Topical term or geographic name as entry element |
Microsoft Excel (Computer file) |
| 650 ## - SUBJECT ADDED ENTRY--TOPICAL TERM |
|---|
| Topical term or geographic name as entry element |
Business--Computer programs |
| 942 ## - ADDED ENTRY ELEMENTS (KOHA) |
|---|
| Source of classification or shelving scheme |
Dewey Decimal Classification |
| Koha item type |
Book |